1. roderic
  2. RO CSVI
  3. Tuesday, 05 April 2022
  4.  Subscribe via email
Hello,

Sometimes when exporting orders (advanced order export), one of the products in the order is exported twice, although it's only ordered once. I have checked in the database to see if it's double there, but no. As far as I know, it has happened about 4 times now out of 900 orders. Twice yesterday.

As you can see below, the product with EAN 5037835205367 is there twice.
duplicate-product-export.jpg

Now when I check the table order_items, search for the order number 1381, I get the 5 products that should be in there:
double-product-database.jpg

All looks normal to me. So not sure why it does what it does. I've exported the same order 10 times now and the result is consistent.

I've attached the logfile and exported XML, although this logfile doesn't really mention much about the products being exported.


Cheers
Attachments (4)
Accepted Answer
Accepted Answer Pending Moderation
Hello Roderic,
Please check Group by and Sort by document to avoid duplicates in export. Try grouping by virtuemart_order_item_id and virtuemart_product_id in your export.
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. # Permalink
Accepted Answer Pending Moderation
Hi Tharuna,

That did not help, setting the grouping by product_gtin however did the trick. Thanks!
  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!