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

[yosemite]

found the answer in another post from dr byte
---------------------------------------
ACK!

Don't go dropping tables and reloading from old versions!

While your manually adding the new column back may have accomplished it for you, you are tempting fate.


It's far better to do an upgrade via zc_install on an entire database, rather than hack one table at a time.

If you must hack one table at a time, then use COMPLETE INSERTS when you export your data from the old database... that way it will also supply the field names so that your data can be inserted "almost" properly.

In this case, the "new" column was not calculated with information based on prior data; however, if the new column was supposed to have a default setting based on info in other columns in your table, you would be out of luck, and would have to manually go find the SQL statement in the upgrader that brought those columns up to date.

[yosemite]

to import your customer information from the database to another database

this seems to work fine when importing from 1.35 to 1.37

import these fields
1. address_book
2. customers
3. customers_info

phpmyadmin settings for export

select table: ie> customers

sql options= NONE

uncheck "structure"
check> Add AUTO_INCREMENT value
check> Enclose table and field names with backquotes
check>data
check> "complete inserts"
check>Use hexadecimal for binary fields

then import into new database. i have only done this import into a fresh install so i am not sure what will happen if you import into a db with other customers.