Categories

Resolved Orders Duplicated in a Virtuemart Export

  1. sohopros
    sohopros
  2. RO CSVI
  3. Friday, 19 July 2024
  4.  Subscribe via email
Joomla 4.4.6 | plugin current version 8.8.0, indicated new version 8.11.2 | PHP 8.1.29 | Database Version:10.2.44-MariaDB

We used the Export order Item Template and changed the Operation to Order, instead of Order Item, but are getting some orders that show up twice, even though the order contains just a single line item. In the attached file, you can see that 4 of the single-line-item listed orders are duplicated.

Any clues on why this is happening? I believe this is a default template.
Attachments (1)
CSVI_Export order items_19-07-2024_15.47.xlsx
0
Accepted Answer
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dale,

But when I group be order_number, it even eliminates duplicate lines that are separate line-items.
Which makes sense because if you have multiple line items the order number will be the same for all of them.

You are looking for a unique value of the line item. That will be the field virtuemart_order_item_id, if you group by that you get unique line items and that is what you are looking for I think.

Give that a try and let us know how it goes.
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. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.