Categories
View Replies (1)

Resolved Exporting Virtuemart orders to CSV results in entries doubling

  1. Anonymous User
  2. RO CSVI
  3. Wednesday, 25 August 2021
  4.  Subscribe via email
Hello,

Exporting Virtuemart orders to CSV results in entries doubling/cloning themselves. The relevant settings in the export template are: Operation: Order; CSV; Order Status: Confirmed, Order Payment Method: Paypal.

The problem apeared with just a few orders. Some multiplied 13 times, some came up twice. Manually changing the order status after purchases resulted in doubling the starting number of entries (13-26-39 entries....)

We tried all template options, but couldn't find the source of the problem.

Any solutions or ideas are much apprechiated, our customer needs this to work properly to minimize manual workload for them.
Attachments (1)
virtuemart_export_test.csv
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

This can happen if an order has multiple products. So the rows may look double but they are actually not double, the difference may not be clear in the export file because that specific field is not used in the export file. To handle such situations we have documented the use of group and sort by fields and you can use this to remove any "duplicates". You can start by grouping on the virtuemart_order_id field and see if that is enough or too much. You can tweak by grouping on other fields depending on your requirements.
Kind regards,

RolandD

=========================
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
  • Page :
  • 1


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