Are You Creating Your Amazon SKUs Correctly?

Here’s some easy-to-follow advice for creating Amazon SKUs for every one of your products. One of the first new words learned by Amazon sellers is SKU (stock keeping unit, pronounced ‘skew’).

One of the first new words learned by Amazon sellers is SKU (stock keeping unit, pronounced ‘skew’). For those who have experienced self-checkout at the grocery store, most likely you’ve purchased produce where you had to type in a four-digit number to determine the cost. That four-digit number is a SKU. When entered, it told the inventory management system that you just bought a pound of bananas at 39 cents a pound.  That’s the Reader’s Digest version of what a SKU is and how it works. Keep reading to learn how SKUs play an important role in your ecommerce growth.

Now that you know you’ve already used SKUs, it’s time to learn the fine art of creating your own SKUs that provide critical data such as stock on hand, time to order more, what size/color/shape sells best, etc.

Here’s some easy-to-follow advice for creating Amazon SKUs for every one of your products. But first, we’re going to tell you why you need SKUs and what kind of data-magic they can provide, and why that is important to your ecommerce company’s growth and profits.

Know that most sellers find Amazon SKUs confusing. A real head-scratcher. If this is where you are, you’re normal. After reading this post, you’ll get the how and why of Amazon SKUs. You may even learn to love them (probably not).

Try to think of SKUs as your personal language to help you organize, manage and grow your ecommerce business. Remember, as you create your SKUs, there are no right or wrong methods. You are creating them as your “secret code” that you can glance at and quickly extrapolate a handful of useful data. That said, create SKUs for your benefit.

Definition of an Amazon SKU
An Amazon SKU is a unique alphanumeric code used to track a product for inventory and sales purposes. Typically, it includes product attribution details such as size, color and any other pertinent information    that you can glean at a glance.

Danger Will Robinson! ASINs
One of the most confusing things for Amazon sellers is understanding the difference between a SKU and Amazon’s ASIN. An ASIN is Amazon’s SKU to identify a product universally and should NEVER be used as your SKU. An ASIN simply means a product exists on Amazon for sale, but danger Will Robinson, it is not YOUR SKU. When listing products, configure your own SKUs and don’t let Amazon configure them for you, or rely on ASINs.

What’s an attribute?
When people buy a product, such as a TV, they’re looking for specific features, or attributes, such as brand, size, resolution, price, smart, DVD, etc. These attributes are the information you structure within your SKU. They will help you manage your inventory.

Why you need SKUs
SKUs living in your inventory management system will make it possible for you to:

• Record loss
• Make strategic inventory forecasting decisions
• Track item location within your warehouse
Improve inventory accuracy—no overselling
• Identify shrinkage
• Reconcile inventory in your inventory management system with items actually in stock
• Make it easy for employees to look up inventory for customers
• Perform profit analysis by SKU to determine best/worst sellers via attributes
• Use same SKUs on all your marketplaces
• Have better communication with vendors
• Pick, pack and ship orders faster
• Understand how long the product has been in inventory

Where your SKUs live
Each SKU needs to be entered into your tracking system (not a spreadsheet!), which will most likely be QuickBooks Online, QuickBooks Enterprise, or QuickBooks Pro/Premier. Whichever accounting system you use, you can ecommerce automation software to connect your store and your accounting solution. If you sell on multiple marketplaces, multichannel inventory sync capabilities can act as a hub for your SKUs. (And by the way, you should use the same SKUs on all marketplaces.) This is where all the SKU magic happens.

Should I let Amazon create my SKUs for me?

If you let Amazon create your SKUs, you’ll forfeit all your potential SKU magic. Essentially, the SKUs will be meaningless to you ─ all the above benefits why you need SKUs are negated. And if that’s not a big enough reason not to let Amazon create your SKUs, perhaps this one is: if you are selling on more than one Amazon store, Amazon will assign separate SKUs for the same products selling in different stores. (Imagine the inventory nightmare this can create.)

There are far more advantages to creating your own SKUs.

What format is best to use to create SKUs for Amazon?
Creating a SKU architecture or format that enables you to quickly gain information about your products and sales, to pick orders quickly and to manage your inventory effectively is your best bet.

Typically a SKU is built with this information: (Keep in mind all the things you want a SKU to do for your business in terms of reporting, inventory, etc.) These are suggestions. You can build a SKU any way you’d like, but keep your nomenclature consistent.

  • Broad descriptor ─ Identify the category or group your products belong to, such as BK for books or DF for dog food
  • Seasonal Identifier – Have seasonal products? Identify your products for their respective season/year within the SKU. This will help identify which products to include in end of season sales to indicate that a Garden Hose is a summer season product.
  • Condition identifier – Use a component of your SKU to indicate condition such as new, used, open box.
  • Attributes ─ size, color, etc.
  • Cost identifier ─you may choose to use what you paid for the product or the selling price
  • Warehouse location ─this helps quickly identify which warehouse the product is located
  • Date entered into inventory ─this will help you identify what’s selling and what’s not
  • End with sequential numbers Using sequential numbering (001, 002, 003) for the final series of a SKU helps you identify older versus newer items in a product line
  • Product source/supplier–Consider using two letters to identify your source or supplier, for example: WM for Walmart.

You can create codes that represent warehouse locations, store location, categories, etc. You are creating an architecture that your company will use for years to come. Think about your strategy and know that you can’t exceed 40 characters in an Amazon SKU. And fewer characters are easier to manage.

Best practices for creating SKUs:
• Use the same SKU to refer to a product in all your stores on all your channels.

• Never use the same SKU for more than one product or variant of product.

• Don’t stray from your SKU format. Once you have created a format for your SKUs, make sure subsequent SKUs conform to it.  

• This is important: Document your rules of SKU creation and make sure everyone understands why you have a format, why they can’t deviate from it, how the SKUs will help them and be sure everyone follows them.

• It’s a good idea to make it a rule not to use a capital I (i) as it can easily be mistaken for a 1.

• Consider using all caps to identify a segment of your SKU, but do it consistently.

• Do not begin a SKU with a zero as it can be misinterpreted by some data storing software.

• Know that can use currency and other symbols in your SKU, but they are not recommended.

• Avoid using spaces.

Ready to take your Amazon inventory management to the next level? Webgility keeps inventory updated with every sale and return, and it tracks multiple inventory sites. 


The Webgility Team

Subscribe via Email