importing customers 1.2.6 -> 1.3.7

[hbtrading]

Ive already have zencart 1.3.7 runing with all the mods I want and was also able to import the products, however when it comes to importing customers with their orders I am stuck with paypal express causing all sorts of problems...can someone please tell me how to import all my customers and orders ?
Thanks in advance!

[Merlinpa1969]

easiest way for you is to make a backup of your old database, the 1.2.6 one
then upload the zc_install folder from the 1.3.7 distro into your old store
run the upgrader,
once you have the entire upgrade done then export all the tables that say customer or order in them,

make sure that you use the drop tables

and now ( after you make a backup of the 1.3.7 DB )

run the sql file you created from the 1.2.6

this will drop the tables and upload them with the old information in them,

[dpicella]

I have the same problem.

Unfortunately, the old ZenCart is no longer in operation. I only have the SQL db. I imported the SQL dump to my new server and I can access the data in PHP MyAdmin.

I compared the customer tables in the old and the new zen cart. I noticed that the new version (1.3.7) has a couple of paypal fields on the end. That must be the issue hbtrading ran into.

Anyway, any advice? I haven't tried anything yet since I wanted to check out what the issues might be first.

If anyone has an answer, you can assume that I would be technically capable of performing the solution!

--Thanks Merlinpa1969! (1.3.7 is very nice!).

[hbtrading]

Pretty simple..

-Install zencart 1.3.7 using a new database

-Dump all the customer related tables of the old database(orders, payment etc...) and the product tables, making sure the add drop tables, add if not exists, add auto_increment value is checked leaving everything else the way it is than export the tables

-Make sure ur exported table prefix's match those of the 1.3.7 install

-Import it into your 1.3.7 database.

-Run the zencart install and select upgrade database then check from which versions you are updating the database from

-all should be working now

[dpicella]

Pretty simple..

-Install zencart 1.3.7 using a new database

-Dump all the customer related tables of the old database(orders, payment etc...) and the product tables, making sure the add drop tables, add if not exists, add auto_increment value is checked leaving everything else the way it is than export the tables

-Make sure ur exported table prefix's match those of the 1.3.7 install

-Import it into your 1.3.7 database.

-Run the zencart install and select upgrade database then check from which versions you are updating the database from

-all should be working now

Actually, that is about what I did. There were three tables:
1. address_book
2. customers
3. customers_info
That I imported from the old DB to the new.

In PHP MyAdmin I just exported without the structure and then imported directly via SQL.

When done... All customers transfered over. No problems.

Oh... If anyone is going to try this at home... please backup first! You never know.

[yosemite]

hi,

i am trying to import the customer table from 1.35 to a new install of 1.37

i am trying this way suggested :
Actually, that is about what I did. There were three tables:
1. address_book
2. customers
3. customers_info

but i get sql error:
#1136 - Column count doesn't match value count at row 1

can any one show me the phpmyadmin setting for the export and import?

thanks