1. gibilogic
  2. RO CSVI
  3. Wednesday, 24 June 2020
  4.  Subscribe via email
I'm trying to export orders from VirtueMart in CSV format.
It happens that more lines appear in the export than necessary.
I enclose:
- example exported csv file
- backup of the template
- stamp video of the order in VirtueMart

Reference order 73SW0225
The lines (items) should be only one.

Important note:
The products are configured as father and son.
Child products have the same order_item_sku.
Attachments (3)
Accepted Answer Pending Moderation
Hello,
Please take a look at Group by and Sort by fields document to avoid duplicates in export. For your export, try adding virtuemart_order_item_id in the Groupby field and see if it solves the duplicate orders.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Ok, the "virtuemart_order_item_id" field highlights the uniqueness of the elements.
I set up grouping but it doesn't seem to group.
I enclose:
- template
- export csv
- stamp video of the grouping
Attachments (3)
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Can you also add virtuemart_order_id field to Group by fields? You can add this field as second field in Group by section (See attached image). If you are still have a problem then post the debug log of the export. To get the debug log check How to get debug information? document.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
If I also group for virtuemart_order_id, there are only 2 lines.
In the first case (order 73SW0225) it is fine because the product is unique, but in the second case (order U7C70224) the products are 12
Attachments (2)
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
If the products are unique then try adding group by field virtuemart_product_id as second field instead of virtuemart_order_id. Check the export after that.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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