Customer I.D. numbers

[tico]

Somehow I doubt that what you ask for is possible. Perhaps I am missing the full extent of your question, but here goes anyway. Within Zen Cart, there is quite a heavy dependence on valid id numbers. For example, orders are linked to customers via customer id. So hypothetically, if you were to change a customer's id number, you'd have to change all its occurrences in the three customer-related tables, the customers_basket table, the customers_basket_attributes table, the order table, and probably a bunch of others as well. Not easily done.

Or perhaps I'm missing something which might become clearer if you explain your situation in a bit more detail.

Regards.
Apsona
http://apsona.com

So I can't change the customer I.D. in ZC. I now understand that. I will have to cross reference my customer I.D.'S with the ones that ZC cart gives.

[schoolboy]

So I can't change the customer I.D. in ZC. I now understand that. I will have to cross reference my customer I.D.'S with the ones that ZC cart gives.

Zencart's "ID system" is a principle applied to many data-sets and is the KEY mechanism used to create internal relationships between commonly used bits of data acros the database. It is not something that has relevance from the user's (website visitor's) point of view.

This system uses the AUTO-INCREMENT function common to all modern databases, and it simply increments the value by one integer as each new data record is added.

While technically possible to "synchronise" this internal ID with the unique Id you give your customers, the administration of this would be a nightmare, because you would need to know every instance where the internal customer ID is referenced, and make sure that all these ID's are not only unique, but they EXACTLY match up... One tiny error and you will get the database delivering results of some database queries, of information belonging to "Mr Smith", being served up to "Mr Jones".

[skipwater]

Your question is can I change the customer ID #

The customers_id is a int(11) field so the value you are allowed is 1-99999999999 no alpha, -+_,@&# etc. the customer # that you want to use will meet this requirement?

And at this point there are no customers in your zen cart system?

Skip