older customer info not found

[DrByte]

What do you mean with the sync??
I have exported all the old clients from my old database as SQL and have imported it in my new databse.

was this wrong?

Did you export and import all three tables?

1. address_book
2. customers
3. customers_info

[ilonka]

yes i did. And al the data is showing in teh database.

But the strange thing is that all my new customers are not showing up in my database.

New customers - not in database - can view al the details in admin

old customers - in database - can not view the details in admin

[DrByte]

yes i did. And al the data is showing in teh database.

But the strange thing is that all my new customers are not showing up in my database.

Then ... your Zen Cart configure.php files are not pointing to the same database.

[ilonka]

both my configure.php files are directing to the same correct database.

i am going crazy..... what else can it be?

Cause i find it so strange that my new customers are not shown in my database but they are in my admin. Where does this information go to?

[DrByte]

Zen Cart only pulls customer information from the database identified in the configure.php files.
If you're seeing your data in the customers table in phpMyAdmin but not in Zen Cart, then you're probably looking at two different databases.

[ilonka]

Nope, configure files are both with the correct database....

Zen Cart only pulls customer information from the database identified in the configure.php files.
If you're seeing your data in the customers table in phpMyAdmin but not in Zen Cart, then you're probably looking at two different databases.

[neilg]

Dr Byte,

I had the same problem when bringing over my customers and this fixed it...i had not copied the address book! Thanks!

If i want to bring over the history of orders as well which tables would i need to copy?

Many thanks,
Neil

[DrByte]

If i want to bring over the history of orders as well which tables would i need to copy?

If this is an "upgrade" that you're doing, keep in mind that Zen Cart already allows you to bring forward all your customers and orders ... just by using its database-upgrade script built-in to zc_install.

Blindly importing data from a mismatched version structure is very dangerous and highly unrecommended.

If you're going to import data from another database, *make sure* that *both* databases are at the *same* version level.

As to which tables contain what, see the wiki: http://www.zen-cart.com/wiki/index.p...rdered_by_Data