1. vlada83
  2. RO CSVI
  3. Saturday, 07 July 2018
  4.  Subscribe via email
Hi, i found small problem. On our site we use in virtuemart products system of parents and child. When we try to export orders with items, we found problem that orders with product child are doubled. As you can see order 4060 and 4067 there are same lines in export files, but in order there is only one item

export-order_de (1).csv

other orders with more items are ok, only problem is with system child and parent
we are using VM 3.2.14 and csv 7.6.2
Accepted Answer Pending Moderation
Hello,
Have a look at Group by and Sort by fields document to check to avoid duplicates in your export. In your case try adding virtuemart_order_item_id field to group by fields and run the export.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
sorry, same result... duplicite order items are still in the file
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

You should tell us what you are doing because you are probably using the wrong field to group on. Post the debug log and we can have a look.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
com_csvi.log.433.zip my log
i want to export my order with data about ordered products, amount, price, customer

i add in group fieds as defaut field virtuemart order product id, but in my file there is some lines doubled,
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Remove the group by fields virtuemart_order_item_id and virtuemart_product_id which are added and try adding only virtuemart_order_id to group by field and run the export.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
yes now it works
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
i am sorry, we just found that after last change in file there are only first item (one line) from order but there should be more products (more lines)...
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
Adding virtuemart_order_id to group by field would group all the orders ids in VirtueMart Order items table and so you are seeing only one record on export. Instead of virtuemart_order_id you should be grouping by virtuemart_product_id field. Can you check adding this field works for you?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
your advice is useless, i start to solve my problem because of duplicite orders in my csv file when group by virtuemart_product_id
when changed to virtuemart_order_id i have only first item from order with more products...

This is only because using virtuemart child products, orders with more products are not duplicated!
please test it and you will see
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
your advice is useless, i start to solve my problem because of duplicite orders in my csv file when group by virtuemart_product_id
when changed to virtuemart_order_id i have only first item from order with more products...

The suggestions given are only based on your export file and debug log. We don't know how your records are in database. Let me explain with an example why i said virtuemart_product_id. Consider you have an order with virtuemart_order_id as 1 and it has two products in virtuemart_order_items table with virtuemart_product_id as 1 and 2 then the records in virtuemart_order_items will be stored as

virtuemart_order_id;virtuemart_product_id
1;1
1;2

Grouping by virtuemart_order_id would have got one record as the virtuemart_order_id are same but you should be seeing both the records with virtuemart_product_id as the ids are different. Not sure why it did not work for you.

This is only because using virtuemart child products, orders with more products are not duplicated!
please test it and you will see

Can you explain more on this? what do you mean by VirtueMart child products? aren't these normal products? Can you post a screenshot on this?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
virtuemart has function parent and child (product variant), child is standalone product direct under another one (clone of it)
screen.JPG
can the problem be in using product sku like 150-1 for master and 150 for child?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
virtuemart has function parent and child (product variant), child is standalone product direct under another one (clone of it)

I understand this.

can the problem be in using product sku like 150-1 for master and 150 for child?

No, that should not be a problem. Can you post your last export file along with the export debug log?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
ok problem with duplicities are in order 4115, 4113, 4090, 4091
com_csvi.log.441.zip export-order_de (2).csv
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
hi i need to fix my problem with duplicities, can you give me info about my problem?
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Sorry for the delayed reply, notification on your last post got missed.

Looking into the debug log you have added virtuemart_product_id to Group by fields but the field is missing in your export template fields. You would need to add this field to export fields and you can set the status as unpublished. This way the field will not be included in your export file but used in query for grouping the records. Let me know if that solves your problem.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
well it starts to be a nighmare, your tip does not work, it removes some orders from export so there are missing couple of lines with order info, see export file and log com_csvi.log.450.zip export-order_de (4).csv

orders are in one contious line so no number should miss
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,

The logic is pretty simple I think. If you have duplicate orders, find the uniqueness in your orders and group on that. Unfortunately I can't see what is missing in your order export file but I checked the file you posted originally.

The problem you are trying to solve is the duplicate products when you have child/parent items, correct?
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
Comparing the debug logs you posted with thread #58833 and #58852, the order export filters set in your template are completely different. That would be a reason you are missing records or more are included in export file. In the debug log with post #58833 you have set order created on date filter to be greater than 02-07-2018 16:38:02 and in the debug log related to #58852, you have set filter for order number to be greater than 4057. Different filters will run different conditions in queries which would get different records. You need to use the same filters in both the templates and see if your group by is working.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
no this is not reason, first export was from some time period (i think 30 days back from now)
second was from order id till now
so this is not reason why i am missing third of orders in the csv file!
Yes, i have duplicite only in orders when in there is child items
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello,
Ok, can you set your filters as in post #58833 and send me the latest export file along with latest debug log?

Also can you send me a private message of your site's administrator login details and FTP access details? I will take a look at your records and see what is happening.
Kind regards,

Tharuna

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


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