News:

Support the VirtueMart project and become a member

Main Menu

Orders migration skipping records

Started by rayge, May 04, 2013, 19:02:35 PM

Previous topic - Next topic

rayge

Ive tried a few times and where it skips orders seems random.
when i am migrating I am using
orders only
Rewrite order numbers UNCHECKED
Use the vm1 order id as vm2 order number CHECKED

in this case i see order 3936 then it skipped to order 4088
and looking at the VM1 orders table, all order records between 3936 and 4088 DO EXIST
so why did it skip them?

I have made sure to truncate all related tables before testing multiple times.
virtuemart_orders, virtuemart_order_histories, virtuemart_order_items, virtuemart_order_userinfos
AND NULL out the order items inside the virtuemart_migration_oldtonew_ids

has anyone else had this issue and how do you solve it?
I have a live site that i need to migrate the orders over to ultimately and i will have to take the new order data and place it in after this import.
HELP!

***UPDATE***
I wrote my own orders migration script that does the orders import properly because I don't have time to figure out why the code in /administrator/components/com_virtuemart/views/updatesmigration/default_migrator.php for order migration is failing.

someone should look into this bug though and solve it.
I Use: Joomla 3.4.1 & VM 3.0.9

grog24

Same problem here! can you post/upload your script please.

Thank you!

rayge

Unfortunately i coded a special script JUST for the client so i dont have anything that will work in a general sense. :(
I Use: Joomla 3.4.1 & VM 3.0.9

grog24

Thank you anyway, I've resolved increasing max_execution_time from 30 to 60.