Export not matching data on screen

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
7 months 2 days ago #302739

-- url of the page with the problem -- : crestridgefarms.com
-- HikaShop version -- : 4.0.1 Business
-- Joomla version -- : 3.9.2
-- PHP version -- : 7.1.26
-- Browser(s) name and version -- : Chrome 71.0
-- Error-message(debug-mod must be tuned on) -- : none

Greetings,
The exported report is dropping some data.

Here is the correct data on the screen shot: prnt.sc/m8wd6v

I have attached what gets exported. As you can see, the data on lines 3,5,8,10 and 11, column one is missing which is the product name. We use this report to know how many of each product is needed for the week. I can use a screen print temporarily

File Attachment:

File Name: hikashopexport2.csv
File Size:1 KB


Also, is there a way to add a custom field to the report. I have a "comments" field where users can make one off changes to their order and it would be nice if that could show on this report.

Thanks in advance,
Bill


Regards,
Bill
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 66586
  • Thank you received: 9792
  • MODERATOR
7 months 2 days ago #302745

Hi,

From your screenshot it seems that you're using the Orders>Reports menu to export that data from a report.
(it would be great to specify clearly what you do when you report a problem)
Also, in such case, it's a good idea to provide a screenshot of the settings of the report, so that we can reproduce the issue without having to try different things.
Luckily, I was able to reproduce the problem and made a patch for it. You can download again the install package of HikaShop on our website and install it on yours to get the patch.

Regarding your second point that's not possible because it's not logical. This report is an aggregate of the sales of the products. You have one row per product (or variant), even if the product is bought by 10 different people in different orders. Then, even without that logic issue, adding an extra column there is not easy as you'll have to modify the core file of HikaShop generating these reports to load the corresponding data and it will be problematic since the query which loads the data only loads one element for all the orders of a product and so it's not a simple modification.
If you want an export of your orders, you're not using the correct tool. Instead, you want an export of the order data with a mass action via the menu System>Mass actions. There, you'll get one row per order and some you can easily get the comment of each order. The drawback is that you would have to calculate the sum of the quantities of the products. Unless you use actually both CSV exports one next to the other.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
7 months 1 day ago #302775

Thanks Nicolas, sorry next time I will be more specific with my questions. The patch works.

Bill


Regards,
Bill

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum