Customer Tables

[Dan Cole]

I'm taking my first pass at updating a database to work with a newer version of Phoenix (1.0.8.20) by exporting the tables from my older database into a new one. I've been doing that for awhile for some of the other tables ie products, orders etc and have reached a point where i want to tackle the customer tables. At a glance it looks like I need to export and then import the following customer related tables.

address_book
customers
customers_basket
customers_ info
customers_wishlist

There are a few others that appear to be customer related that don't contain any data and seem to relate to discount coupons or wishlists that I'm not currently using so I'm going leave those behind for now. The tables mentioned above appear to be the critical ones. Anyone know of other customer tables that I may have missed?

Dan

[raiwa]

The first 4 would do it if you do not use wishlist

Note that you should only export data and empty the tables in the new database before import. This ensures to keep the new structure of the tables which may be different to the old database.

[Dan Cole]

Thanks Rainer and yes I turn off the option to "Add CREATE TABLE statement" and turn on the option to "Truncate table before insert" when I export. I probably learned that the hard way at some time or another.

Dan

[burt]

Customer Related Tables

address_book
customers
customers_basket
customers_basket_attributes
customers_gdpr
customers_info
products_notifications
reviews
reviews_description
testimonials
testimonials_description
orders [with associated tables!]
outgoing

If any of these exist with data in your OLD shop...you should port them over, else just leave them as if "just installed" (ie, they exist but are empty). Note that some of these might not exist in the NEW shop if that shop is based on a slightly older version (eg outgoing, which I believe was introduced in 1.0.9.6)

[Dan Cole]

Thanks Gary...I know I already updated a few of those tables but you've included a few I didn't even look at so I'll run through the tables again. I appreciate it.

Dan