Support is offline. We are back Monday 23 November, 09:00.

J2Store orders export to J2Commerce #86880

Open Webcompagnons opened this topic Monday, 19 October 2026 · 7 replies
Author

Can I export J2Store orders in Joomla 3 to J2Commerce in Joomla 6?
Or are these tables too different? Do you know?
If so, wich plugin and template do I have to use in the target site?

TIA and kind regards,
Joris

Support

Hi Joris,

Can I export J2Store orders in Joomla 3 to J2Commerce in Joomla 6?

Yes you can export J2Store orders from Joomla 3 using J2Store Order export template and import them to J2Commerce using J2Commerce Order import template.

Or are these tables too different? Do you know?

Yes there has been changes to Orders table from J2Store to J2Commerce. One basic change is the primary key field j2store_order_id is now j2commerce_order_id. You can refer to the document https://docs.j2commerce.com/developer/getting-started/database-schema-reference/ for changes with these tables.

If so, wich plugin and template do I have to use in the target site?

In target site you need to install RO CSVI core package along with RO CSVI - J2Commerce addon. You can then use J2Commerce Order import template to import orders. You can also install J2Commerce example templates and use J2Commerce order import template to start with.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thanks.
It appears that a link to Joomla users is being sought; however, no such link exists, as they are all guests. Consequently, the import—using the "Example J2Commerce Order Import" template—seems to be failing. Is it possible to bypass this check?

Thanks again and greetings,
Joris

Support

Hi Joris,
With attached patch file you can import J2Commerce orders for guest users with fields order_id or j2commerce_order_id fields in import file. Load the attached patch file and check the import. Try and let me know on how that goes.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thank you, but:

Status error: 500

Explanation: This error means that something has gone wrong but the server does not want to tell you what exactly happened. The only way to find out is to ask your hosting provider for the error message in the error log. For further information you can check the 500 Internal Server Error document on our site. Without the real error we will not be able to help you.

Status message: error
Sorry, there was a problem we could not recover from.

The server returned a "500 - Whoops, looks like something went wrong."

In log I see: "GET /administrator/components/com_csvi/rantai/rantai.php?task=import&runId=70&_=1792671392006 HTTP/2" 500 7899 "https://domain.ext/administrator/index.php?option=com_csvi&view=import"

Support

Hi Joris,
May I know the version of RO CSVI you are using? Also please post sample of import file to check along with template XML file. To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. Post the downloaded XML file.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Export from Joomla 3.10.12 with RO CSVI 8.22.1.
Import to Joomla 6.2.0 with RO CSVI 9.13.0.

It should be noted that I changed the field name "j2store_order_id" to j2commerce_order_id" in the import file.
Field names:
"billing_address_1","billing_address_2","billing_city","billing_company","billing_country_name","billing_first_name","billing_last_name","billing_zone_name","customer_group","invoice_number","order_subtotal","order_tax","order_tota l","shipping_address_1","shipping_address_2","shipping_city","shipping_country_name","shipping_first_name","shipping_last_name","shipping_phone_1","shipping_phone_2","shipping_zone_name","user_email","j2commerce_order_id","order_id"
Template attached.

Support

Hi Joris,
I asked for sample of import file and template XML file so I can run import here and see if I can reproduce 500 error. Template XML is fine but having only fields will not help me to check 500 error. Please post import file with few records so I can run import and check. Also post import debug log. To get debug log read How to get debug information? document. Will see on which record import breaks in debug log.

Also 500 error is not the actual error. Something else is broken in import and that triggers 500 error. To get actual error check server error log. See if there are any details on actual error in server error log. Post that as well. Also read 500 internal server error document.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.