I am testing the OpenCart 4.0.1.1. How can I migrate customers data including purchase history record from OC v2.2.0.0.? So customers can use the same login credentials.
Please advise. Thanks in advance!
https://www.opencart.com/index.php?rout ... sion_id=17
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
And possible some small changes in the exported file, before import.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
What is valid header? What can I do? Please advise. Thanks in advance!
BTW.: Are you sure you want to proceed with OpenCart 4? Because OpenCart is not yet quite suitable for live websites, it is still subject to some development and bugfixes. Either wait for the upcoming 4.0.2.0 (may still take a number of weeks, or longer). Or use the 3.0.x.x_Maintenance branch.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank you for response. I saved the copy/paste data with .xls excel work sheet (this is only choice I can do from my PC). Is it works?
I can see the exported file is .xlsx extension.
Please advise. Thanks in advance!
Yes OC4, will update it to 4.0.2.0 once released it. I can wait. Thanks!JNeuhoff wrote: ↑Wed Mar 08, 2023 6:36 amBTW.: Are you sure you want to proceed with OpenCart 4? Because OpenCart is not yet quite suitable for live websites, it is still subject to some development and bugfixes. Either wait for the upcoming 4.0.2.0 (may still take a number of weeks, or longer). Or use the 3.0.x.x_Maintenance branch.
Download LibreOffice, open the file and save. Ater that extension should import the file.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Just realized the system accepts xlsx, xls, odt extensions for import.
Now import failed and got error log:
2023-03-09 10:26:42 - Exception: Error: Unknown column 'wishlist' in 'field list'<br/>Error No: 1054<br/>INSERT INTO `oc_customer`.........
Can you please advise how to fix it? Thanks in advance!
To repeat what you will be told over and over and over again. OC4 is NOT suitable for production sites - Use at your peril
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Yes I can see 'oc_customer_wishlist' in the database. There is empty result set.
How can I import successfully? What should I do now? Please advise. Thanks in advance!
*I setup with OC v4.01.1. just to fill the products and migrate customers hopefully to get ready for next OC version update. Not a production nor a live site yet.
Check your database and see if there is a column (field) called wishlist in your customer table `oc_customer`
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
This was a bug in the Export/Import tool, there used to be a 'oc_customer.wishlist' DB field in OpenCart 4.0.0.0, but it was removed in later versions.harap wrote: ↑Fri Mar 10, 2023 2:47 amHello,
Just realized the system accepts xlsx, xls, odt extensions for import.
Now import failed and got error log:
2023-03-09 10:26:42 - Exception: Error: Unknown column 'wishlist' in 'field list'<br/>Error No: 1054<br/>INSERT INTO `oc_customer`.........
Can you please advise how to fix it? Thanks in advance!
I have now adjusted the Export/Import tool accordingly in its new version 4.13.2, you can download it from here.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I updated your v4.13.2 to my OC4.0.1.1, still get the error log:JNeuhoff wrote: ↑Fri Mar 10, 2023 9:27 pmThis was a bug in the Export/Import tool, there used to be a 'oc_customer.wishlist' DB field in OpenCart 4.0.0.0, but it was removed in later versions.
I have now adjusted the Export/Import tool accordingly in its new version 4.13.2, you can download it from here.
2023-03-12 11:21:23 - Export/Import: Invalid header in the Customers worksheet
I did not update for my OC2.2.0.0. Do I also need to update it and do export again?
Please advise. Thanks in advance!
It doesn't matter. Because you want to import on 4.0.x.x.....
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
I don't know what you are talking about. There clearly is a version 4.13 of the Export/Import tool for OpenCart 2.2.0.0.
Also read the docs which states:
Requirements and Limitations
Use version 4.13 of the Export/Import tool for systems with PHP Version 7.3 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
If it works on your OC 2.2.0.0 then there is no need to update it there.harap wrote: ↑Mon Mar 13, 2023 2:32 amI updated your v4.13.2 to my OC4.0.1.1, still get the error log:
2023-03-12 11:21:23 - Export/Import: Invalid header in the Customers worksheet
I did not update for my OC2.2.0.0. Do I also need to update it and do export again?
Please advise. Thanks in advance!
The worksheet formats will be slightly different between OC 2.2.0.0 and 4.0.1.1. Please see our FAQ. Also, why don't you look into your OpenCart error.log for details?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote: ↑Mon Mar 13, 2023 7:26 pmAs I mentioned, I can see the error log from OpenCart v4.0.1.1 admin site read as beblow:
2023-03-13 07:55:08 - Export/Import: Invalid header in the Customers worksheet
Upload error note:
Uploaded spreadsheet file has validation errors!
I don't see error.log from my server.
Users browsing this forum: No registered users and 34 guests