Post by harap » Fri Mar 03, 2023 2:03 am

Hello,

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!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Fri Mar 03, 2023 2:24 am

From phpMyAdmin or using a free Export/Import extension
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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by harap » Tue Mar 07, 2023 12:28 am

@xxvirusxx,
Thank you for advicing.

I only need to download and install the extension for OC v4.0.1.1. to both of my sites (OC2.2.0.0 and OC4.0.1.1.), is that right?

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Tue Mar 07, 2023 1:40 am

yes

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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by harap » Wed Mar 08, 2023 12:37 am

I can see customers data exported from my OC v2.2.0.0. But when I try to import from OC v4.0.1.1. it was failed. I checked the error log it says: Export/Import: Invalid header in the Customers worksheet.

What is valid header? What can I do? Please advise. Thanks in advance!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by JNeuhoff » Wed Mar 08, 2023 6:36 am

Do a Customers export first off your OpenCart 4 site, even if empty, to see the new worksheet formats. The copy/paste from your old worksheets into the new ones, and then import to your OpenCart 4.

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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by harap » Thu Mar 09, 2023 1:21 am

@ JNeuhoff,
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!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by harap » Thu Mar 09, 2023 12:48 pm

JNeuhoff wrote:
Wed Mar 08, 2023 6:36 am
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.
Yes OC4, will update it to 4.0.2.0 once released it. I can wait. Thanks!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Thu Mar 09, 2023 2:43 pm

harap wrote:
Wed Mar 08, 2023 12:37 am
Invalid header in the Customers worksheet.
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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by harap » Fri Mar 10, 2023 2:47 am

Hello,

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!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by by mona » Fri Mar 10, 2023 3:18 am

DFY5CVJUwAUSPIF.jpg

DFY5CVJUwAUSPIF.jpg (94.79 KiB) Viewed 2311 times

Check your database and see if there is a field named wishlist in your customers table (if there is a table customers at all).

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


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by harap » Fri Mar 10, 2023 10:38 am

Hi @by mona,
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.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by by mona » Fri Mar 10, 2023 12:42 pm

Unknown column 'wishlist' IN TABLE `oc_customer`
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


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by JNeuhoff » Fri Mar 10, 2023 9:27 pm

harap wrote:
Fri Mar 10, 2023 2:47 am
Hello,

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!
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.

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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by harap » Mon Mar 13, 2023 2:32 am

JNeuhoff wrote:
Fri Mar 10, 2023 9:27 pm
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.

I have now adjusted the Export/Import tool accordingly in its new version 4.13.2, you can download it from here.
I 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!

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by harap » Mon Mar 13, 2023 12:05 pm

@JNeuhoff,
It seems your extension for OC v2.2.0.0. has not update yet. I just downloaded and found it is V3.22.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States

Post by xxvirusxx » Mon Mar 13, 2023 3:26 pm

harap wrote:
Mon Mar 13, 2023 12:05 pm
It seems your extension for OC v2.2.0.0. has not update yet.
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


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by JNeuhoff » Mon Mar 13, 2023 7:22 pm

harap wrote:
Mon Mar 13, 2023 12:05 pm
@JNeuhoff,
It seems your extension for OC v2.2.0.0. has not update yet. I just downloaded and found it is V3.22.
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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Mon Mar 13, 2023 7:26 pm

harap wrote:
Mon Mar 13, 2023 2:32 am
I 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!
If it works on your OC 2.2.0.0 then there is no need to update it there.

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


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by harap » Mon Mar 13, 2023 11:11 pm

JNeuhoff wrote:
Mon Mar 13, 2023 7:26 pm
harap wrote:
Mon Mar 13, 2023 2:32 am
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?
As 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.

Active Member

Posts

Joined
Wed Sep 16, 2015 12:34 am
Location - United States
Who is online

Users browsing this forum: No registered users and 34 guests