Customer Numbers

[Webskipper]

Can I get in and change customer numbers into member numbers?

I am looking for a way to get in after the sale and change the assigned customer number into the assigned member number as one of my sites is for memberships.

Thanks!

[kuroi]

Probably, but there are a number of pitfalls. Firstly, the customer_id is used as the primary index for both the customers and customer_info tables. It's also used as a lookup field for other tables such as address_book, and even order details. You will need to ensure that you change all references simultaneously.

Then you would need to ensure that the auto increment for the customer table index is always higher than your highest membership number in order to ensure that you don't try to create a duplicate primary index (which would cause the insert to fail).

Got to say that a table mapping customer IDs to membership IDs would be a lot safer.

[Webskipper]

Thanks for the insight.

My situation is that the Zen DB is new and the master db is MS Access.

Sounds like I need to cease using Zen until I figure a way to import the CSV into Zen, fix the customer number issue and then that way new customer/members will automatically be assigned a number.

Any tricks to importing from Access Kuroi?

[kuroi]

I used to use Access a lot, but attempts to build web apps with it were dismal failures. More than 5-10 near simultaneous queries and it would fall over in an ungainly heap. Basically it was designed as a desktop database and, although it's hopefully better now, Microsoft has proper server databases so won't want Access muscling in on more expensive commercial products.

MySQL can import CSV files with ease. that wouldn't be your issue. It would be more the data mapping that links your existing data to Zen Cart's tables and whatever supplementary tables you would be adding. That's a highly technical area and not one easily addressed through a forum post.

[Webskipper]

Contact me by PM as your PM box is full. Then you can delete this posting.