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
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
I'm using Joomla! 3.8.2 and VirtueMart 3.2.6
I've attached a sample of export file that I'm using and debug log
exportar-pedidos2.csv
com_csvi.log.34.zip
Thanks in advance
- Bcall
- RO CSVI
- Wednesday, 10 January 2018
- Subscribe via email
0
Accepted Answer
Pending Moderation
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.
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, 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
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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?
Accepted Answer
Pending Moderation
Hello,
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.
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.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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
Import fields Unsupported
Everything else seems to work fine
com_csvi.log.48.zip productos-pedido.csv
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
That's right! My bad, sorry, it's working now! thank you so much for being so helpful, tharuna : )
Accepted Answer
Pending Moderation
Hello,
Happy to hear that your issues are solved. Would appreciate if you can give us a review on Joomla Extension Directory
Happy to hear that your issues are solved. Would appreciate if you can give us a review on Joomla Extension Directory
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »