Dashboards widgets and exports, editable or not?

-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.8.11
-- PHP version -- : 7.1.20
-- Browser(s) name and version -- : Firefox, Chrome

Hi,

The documentation for Orders / Reports says: "This screen enables you to manage all your reports and therefore your dashboard's widgets."
But the Dashbord widgets seem to come from somewhere else. When I edit, depublish or even delete all reports, the dashboard still looks the same!
How does this work?

Also, it would be great to be able to select which columns end up in exports, as the current info is quite overwhelming for my clients.
Is this possible somehow?

Regards,
Eric

Furthermore, in the reports, it's only possible to set a date in the filter, while time defaults to current time.
The result is that the reports contain partial, not full days!

And, in the exported report, the field "order_full_price" does not have decimal separators, € 511,20 shows up as "51120000" (global decimal separator set to comma, report coding UTF8).

Hi Jerome,

The built-in Help still says:

"You can also find additional display options for widgets in the Display tab of the configuration of HikaShop.
To display a report on your dashboard, simply publish it through the listing or the report edition screen. Reports will automatically be display on the dashboard according to the options your set in the global configuration of Hikashop and following the defined ordering."

But as the new dashboard cannot (yet) be configured, I suggest to make that clear in the Help text. It will save people like me some time trying to find out why it does not work!

Concerning the reports and exports (including those from the Orders listing):
Always export some basics like order number, order date, order status, customer number and name, currency, invoice total, tax total.
Then have options to add delivery address, payment details, product details, shipping details, customer details, etc.

And please make sure the data are in a useful format!
I cannot imagine that many clients have a clue what's in the field: order_shipping_params for example:
O:8:"stdClass":1:{s:6:"prices";a:1:{s:3:"1@1";O:8:"stdClass":2:{s:14:"price_with_tax";s:7:"9.50000";s:3:"tax";d:0;}}}

And please fix the missing decimal separator, and set the time of the date selectors to 00:00:00.
Another good option for "Period" would be "Past quarter", as many companies have to make tax reports by quarter.

That would be great!

Best regards,

Eric

Hi,

1) Thanks

2) Through mass actions indeed it's already possible and I have used it, but it's a bit difficult to explain to a client not to use the regular reports but go to mass actions instead. So customizable dashboard reports would be great.

3) I think it's better not to show a client confusing data, or show those only in a kind of debug mode

4) separately, I will mail you some reports:
- hikashop_export_from_mass.csv where all zero values show up as "0.00000" while in the same column fields that are not zero, show up as 9,50000. Please note the double quotes as field encapsulation, they are missing for fields that have a numeric value >0!
This occurs in all exports.

- hikashopexport_from_orders_reports.csv where all decimal separators are points, while I set comma in the global configuration (Xxcel interpreted them as thousands separator, that's why I thought there were no separators).

In another discussion about another customer, we also saw that PHP "gets to much freedom" to format the export cells which leads to some unexpected results.

And finally, I think we would help our clients a lot if there was in the reports not only an order total, but also a tax total. As said before, most of our clients have to report sales and tax (VAT) on a quarterly basis. Now it's only in the details per product, and not so easy to add up.

Thanks again, I'm looking forward to your reaction!

Best regards
Eric

Hi,

4. Thanks! I'm looking forward to it.

5. The column "order_full_tax" is indeed in the exports from the order listing screen. But you cannot select it to be included in the Mass Action report.

6. A completely different issue came up:
For the Quantity input method I have to use Select as it is the only option that limits the quantity to be added to multiples of the Minimum Order Quantity (we sell boxes of 2, 3, or 6 bottles of wine).
The dropdown list goes up to 15 x the minimum order quantity.
When a professional customer want to order more, they can click the Add button twice.
But then, when they proceed to the cart, the quantity is reset to zero!
Can this be fixed?

Best regards,
Eric

Hi Nicolas,

5) I see. In the meantime, waiting for the new Mass Action, would it be difficult for you to add this one item to the selection list?

6) Thanks a lot, works perfectly!

Best regards,
Eric

Hi,

5. And again, thanks a lot in advance.

Getting better all the time!