Next Youngsday
0

DAYS

0

HOURS

0

MINUTES

0

SECONDS

Home / Tech / E-commerce / E-commerce for beginners (Part B): Main identifiers

E-commerce for beginners (Part B): Main identifiers

“If something is not measurable, it is miserable”…

No matter what kind of work you do, social or commercial, you need to use various performance indicators to keep the track of your business. Especially if you want to measure your success and failure over time, you need to identify key metrics which are called KPIs. Naturally, this hypothesis holds for e-commerce as well.

I will not dive into detail in this article since I will write an article specifically about business intelligence approach in e-commerce. However these below are the essential identifiers that you might need to base your KPIs on:

MAIN

SKU: It’s the alphabet of your online store. Although some websites don’t use this one, it will prevent you from duplicates of same products with double (or even triple) photo shooting, double content editing and so on. How can you differentiate if you had the new-arrived product in your database before it was sold out? You have to avoid the implementation of same production (content creation) process for that same item. Besides, how can you enable your customer to describe the product that he/she purchased or thinks of purchasing?

Order Number:  This one is the main element for your sales, financials and operations. You can consider order number as the most important identifier of your business. As an order is placed by the customer, this will be the key identifier which will be used to track the delivery process as well as the financial process. Whenever your customers contact with the customer service, order number will be the first thing your customer service has to ask. I would say it is even more important than the name of your customer.

All sales, operations and customer service (even marketing) KPIs will be derived from this identifier. Therefore  just make sure you don’t lose control over the order number tracking processes  no matter how deep you are in trouble with frequent orders, excessive amount of customers in a short period etc.

In addition to those two above, E-commerce websites need to have 3 more identifiers to enhance their measurement:

Order IDThis will be used for the same purpose with order number, whereas this needs to be sequential. If you are thinking why there are 2 separate order identifiers, it is because your competitor shouldn’t be able to see how many orders you have daily or monthly, which will be the case if you have sequential order numbers.

For the business purposes, you can use either Order ID or order number, whereas for your customers you should not give the information of order ID.

Item ID: How many items do I sell per order? What is my average basket size? My revenue? Gross margin? Average price intervals?  Item ID is the “cell” of your e-commerce body. For unit economics-related initiatives, for main KPIs in each department and for your overall measurement, you need to identify each unit that is sold.

Item ID is different than SKU. SKU is the identifier of a product in your website, whereas Item ID is the unique ID of a unique product sold. Item ID never duplicates whereas SKU does.

Barcode: Barcode is the key identifier for communication with your suppliers. Some e-commerce companies use supplier barcode, whereas some others create their own barcodes and send it to the supplier before the purchase is placed. It is not as critical as the other identifiers above. However, it is a must for you to scale up. You shouldn’t underestimate the damage of lost items, wrong purchases, misunderstandings, return of purchased items and so on.

There are much more identifiers that you will need to use once you decide to scale up. I will explain those in my BI article in further details.

 

Image source: Flickr

Orkun Basaran

7 comments

  1. You’ve mentioned all the key identifiers, but what it’s more important is the way KPIs are calculated using these identifiers. It’s obvious that an order number is an identifier.. So, I hope you’ll get into more concrete detail next time..

  2. Which of the idenfitifiers is more crucial for an e-commerce site that sells food and beverage? for clothing? for electronics?

  3. i sort of agree with the first comment. great article but would like too see some steps on how to calculating kpi’s using the identifiers you’ve mentioned!

  4. Orkun Basaran

    Thank you for your comments folks! Stay tuned! I will give further details in BI article

  5. Hi! This article has been a great help. I’m working on a school project where we have to come up with an e-commerce idea and generate a business model. I’ve used the ones you’ve put here for the key identifiers. Thanks!

  6. Selam!
    You’ve said that “barcode” is a must for you to scale up.. what do you mean by that?
    btw, i’ve been following you guys for some time. youngsday is a great initiative. i hope you’ll keep writing articles and enhancing the variety of authors..

  7. hey orkun.. how can i reach you? there are a couple of things i wanna ask

Leave a Comment

Your email address will not be published. Required fields are marked *

*

* Copy This Password *

* Type Or Paste Password Here *

Scroll To Top
x
Sign up for our Newsletter to keep updated for

Enter your email and stay on top of things,

Close
Youngsday on Twitter!
Follow us on Twitter!