Best way to define Customer Number

(0) Share

Report

Posted on by sandipdjadhav

18,306

One of my friend is having his own eCommerce web site and he sells his items on ebay,Amazon and other eCommerce site. What will be best way to define customer number?

Thanks

Sandip

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

sandipdjadhav 18,306 on at

Like (0)

Report

RE: Best way to define Customer Number

One more - He is using Dynamics GP. We want to define Customer ID in Dynamics GP.

Thanks

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Best way to define Customer Number

I am actually thinking of considering several factors when numbering these customers, especially that the customer segmentation is almost narrow to e-commerce businesses.

Although, I might think of the following categorization to be considered as a suggestion:

e-commerce Type Segment (BB, BC): in your case, it is apparently only business to business, I would consider BC for any possible future expansion

B2B Business to Business

B2C Business to Customer

Business Branch Segment: regardless of the fact that an online website is not restricted to one location, it is needless to say that each e-commerce business could have several branches in several countries (Amazon for instance has several branches all over the world such as Germany, France, Italy ...etc), I would limit the branch segment into two characters as derived from the ISO country code

FR for France

IN for India

...etc

Customer Name Segment: distinguished characters through which the business can be clearly figured out

AMZ for Amazon

EBY for ebay

.. etc

All in all, the Customer number will be as follows;

e-commerce type - Branch Code - Customer Name - Serial

As a matter of fact, Amazon Branch in France would be coded as follows

BB-FR-AMZ-001

Hope this helps !

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

RE: Best way to define Customer Number

Hi Moh'd,

Much appreciate your response.

Thanks

Sandip

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Best way to define Customer Number

Hi Sandip,

The other thing I would do is to document the naming rules as a window note on the customer maintenance window.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Best way to define Customer Number

The customer numbering sequence - which becomes the Customer ID in GP...could just be sequential numbering?

The analysis could be handled through the customer class ID and the user defined fields.

It would be a lot easier to just code a sequential number for customer ID. So each time a new customer adds themselves - you increase the last number by one - then auto generate the class ID based on location, business sector, customer type etc. This way you can use the class ID to roll down common values during integration [I presume you are using eConnect?] - and you can analyse / report based on the class ID.

Ian.

Was this reply helpful? Yes No