At the moment we have our customer ids like the first couple of letters of our client.
I feel this gets messy though especially when you have companies with similar names.
In addition, we are trying to have our ecommerce store data relate somewhat to Sage so we can import invocies. For this, I believe the customer ID is the unique identifier.
I was thinking of changing the customer IDs to numbers. This way I can also change it to numbers on my eccomerce site.
So, Acme, INC would be customer ID: 10001 (in both Sage and my ecommerce store)
Is that a good idea? Do people use numbers?