Customer I.D. numbers

I have a wholesale company and now I will be selling wholesale online. I want to use the same customer numbers that I have for my company software in ZC instead of ZC assigning new customer I.D. #’s. I tried uploading with Apsona but it did not work. Can anyone help please?

tico:

I have a wholesale company and now I will be selling wholesale online. I want to use the same customer numbers that I have for my company software in ZC instead of ZC assigning new customer I.D. #’s. I tried uploading with Apsona but it did not work. Can anyone help please?

Hi Tico,

When you say "it did not work" - could you please describe what exactly happened, and where ShopAdmin fell short?
We'd like to fix it.

Regards,
Apsona
http://apsona.com

I exported the customer file form ZC through Apsona. Them I tried to create a new customer with a account number that I use in another software. Navision by Microsoft. ZC would not accept the new customer I.D. I guess it need to create it's own customer I.D. What I would like to do is use the same account numbers I already have. I hope this helps you understand. Any help would be appreciated.Thank in advance!

Are your current customer numbers sequential?

tico:

I exported the customer file form ZC through Apsona. Them I tried to create a new customer with a account number that I use in another software. Navision by Microsoft. ZC would not accept the new customer I.D. I guess it need to create it's own customer I.D. What I would like to do is use the same account numbers I already have. I hope this helps you understand. Any help would be appreciated.Thank in advance!

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

tico:

I have a wholesale company and now I will be selling wholesale online. I want to use the same customer numbers that I have for my company software in ZC instead of ZC assigning new customer I.D. #’s. I tried uploading with Apsona but it did not work. Can anyone help please?

Add an additional field to customers for this purpose and let zen-cart do what its does best (with its ID numbers)

There seems to be at 2 least add-ons that might do what you want
"Additional Customers Fields" is one of them

apsona:

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.

Kim:

Are your current customer numbers sequential?

Yes they are. I was hoping to upload all of my customers to ZC and then email everyone their login info so they could order with out having to create a customer.

gilby:

Add an additional field to customers for this purpose and let zen-cart do what its does best (with its ID numbers)

There seems to be at 2 least add-ons that might do what you want
"Additional Customers Fields" is one of them

Ok this may work. Thank you!

tico:

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".

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