Resolved Duplicite in order export virtuemart

Hello,
Thank you for sending the requested details. The FTP details you had sent dont seem to work. It says "Error:Connection timed out after 20 seconds of inactivity
Error:Could not connect to server". Have sent this on Private Message too. Can you please take a look?

log453 is with duplicities
log 454 is with only some orders

website logins via PM

export-order_de.csv export-order_de (1).csv com_csvi.log.454.zip com_csvi.log.453.zip

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.

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

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.

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?

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

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.

hi i need to fix my problem with duplicities, can you give me info about my problem?

ok problem with duplicities are in order 4115, 4113, 4090, 4091
com_csvi.log.441.zip export-order_de (2).csv

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?

virtuemart has function parent and child (product variant), child is standalone product direct under another one (clone of it)

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

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?

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

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?

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)...

yes now it works

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.

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,

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.