Categories
View Replies (2)

Resolved Virtuemart Orders export creates enormous csv

  1. New
  1. Picannick
    Picannick
  2. RO CSVI
  3. Friday, 17 January 2025
  4.  Subscribe via email
Hi there,

We have strange differences in our Matomo statistics that do not agree with the information in the backend of VM, so I wanted to export the orders to find out where the differences come from.

I ran into multiple errors concerning the execution time and memory limit so I raised the limits and only exportet the orders from the last two months and only the order number to see if I have a misconfiguration in the template. With the execution time set to 10 minutes it finally worked but in the CSV there were over 65.000 lines (for appr. 150 orders). Every order has 232 lines.

Do you have an idea what went wrong.

Kind regards,
Tanja Vogt
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Tanja,
CSV there were over 65.000 lines (for appr. 150 orders). Every order has 232 lines.

Your export file is getting duplicate orders and so you see those lines. Read the document Use of Group by and Sort by fields on how to avoid duplicate rows in export. In your VirtueMart Orders export template set virtuemart_order_item_id in Group by field and run the export. See if that solves your issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Picannick
Picannick
Accepted Answer Pending Moderation
Hi Tharuna,

thanks for your help, that worked perfectly!

Kind regards,
Tanja
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!