Categories
View Replies (5)

Resolved Product lines duplicated in the order

  1. gibilogic
    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)
csvi_templates_www.iricamidelcuore.it_20200624.xml
ordini_20200624162650.csv
I_Ricami_del_Cuore_Articoli_da_ricamo_fine_serie_per_bimbi_e_per_la_casa_Amministrazione_.png I_Ricami_del_Cuore_Articoli_da_ricamo_fine_serie_per_bimbi_e_per_la_casa_Amministrazione_.png
0
Responses (5)
tharuna
tharuna
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 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
gibilogic
gibilogic
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)
csvi_templates_www.iricamidelcuore.it_20200625.xml
Schermata 2020-06-25 alle 09.22.25.png Schermata 2020-06-25 alle 09.22.25.png
ordini_20200625091955.csv
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
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)
Screenshot 2020-06-25 at 1.06.52 PM.png Screenshot 2020-06-25 at 1.06.52 PM.png
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. # 3
gibilogic
gibilogic
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)
ordini_20200625095323.csv
ordini_20200625091955.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month 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!