Resolved Import orders and order items

Hello,

Hello, I need ti import Virtuemart orders and order items from a website using VM2 -- CSVI Free to a website using VM3 CSVI Pro 7.3.0.

Import is successful but I don't know how to import status change, shipment and payment data

For shipment data you can use shipment_element field, for payment use payment_element field and for order status you can use order_status_name field in your import file. Have a look at the example in VirtueMart order import document.

Also, I don't know how to import order items -- how do I map items to orders? I see no order number in order items export

Yes, there is no support for order_number in order item export as of now. You can load the attached patch file to get the order_number field in order item export. Remember that the code has been modified for latest CSVI version 7.3.0 version and will not work in CSVI free version.

patch_vm_orderitems_2018_01_10.zip

Hello,
For shipment data you can use shipment_element field, for payment use payment_element field and for order status you can use order_status_name field in your import file. Have a look at the example in VirtueMart order import document.

Thank you so much. Order status is working ok, but shipment and payment information is still missing

exportar-pedidos.csv com_csvi.log.39.zip

Yes, there is no support for order_number in order item export as of now. You can load the attached patch file to get the order_number field in order item export. Remember that the code has been modified for latest CSVI version 7.3.0 version and will not work in CSVI free version.

[attachment]patch_vm_orderitems_2018_01_10.zip[/attachment]

Thanks for the patch but the website I'm exporting from is using Joomla 2.5 and CSVI free. Target website is using CVSI 7.3.0. How can I do this then?

Hello,

Thank you so much. Order status is working ok, but shipment and payment information is still missing

You don't need virtuemart_paymentmethod_id and virtuemart_shipmentmethod_id in your import file. Just import payment_element and shipment_element and CSVI will automatically update the equivalent ids of these payment_element and shipment_element.

Thanks for the patch but the website I'm exporting from is using Joomla 2.5 and CSVI free. Target website is using CVSI 7.3.0. How can I do this then?

We don't support CSVI free version. What you can do is when you are creating orders you can retain the same order id as in your VM 2 database. Add virtuemart_order_id to your order export in VM 2 site and in your new site where you are doing order import, in your import template on Option tab set Keep Order ID to Yes. CSVI will create orders with same id as in your import file. Now in your order items export you can add field virtuemart_order_id instead of order_number and import it in your new site. Since the order id is same as your old database linking your order items will be done to the same order id. Hope it is clear.

Nice, thanks! One last this (hopefully) I'm having trouble importing order product items. I'm getting this

Import fields Unsupported

Everything else seems to work fine

com_csvi.log.48.zip productos-pedido.csv

Hello,
It looks like you are trying to do a product import using Order item export file. Except product_sku and product_tax other fields in your import file are not supported in product import and so you are seeing the Unsupported error. Have a look at VirtueMart product import document for the fields supported by product import operation.

That's right! My bad, sorry, it's working now! thank you so much for being so helpful, tharuna : )

Hello,
Happy to hear that your issues are solved. Would appreciate if you can give us a review on Joomla Extension Directory