Over 4.5 million customers use QuickBooks.
Sign up for a free trial!
2016-02-17 00:00:00How To Run Your BusinessEnglishIt’s time to take the first steps towards optimizing your inventory by organizing your products: devising an alphanumeric Stock Keeping...https://quickbooks.intuit.com/au/resources/au_qrc/uploads/2017/01/GettyImages-153337336.jpghttps://quickbooks.intuit.com/au/resources/how-to-run-your-business/effective-inventory-organization-starts-with-skus/Effective Inventory Organization Starts with SKUs

Effective Inventory Organization Starts with SKUs

2 min read

Over the last two weeks, we’ve established the goals of inventory management. Now it’s time to take the first steps towards optimizing your inventory by organizing your products: devising an alphanumeric Stock Keeping Unit (SKU) system.

Here’s a list of three things to take note of when you’re setting up your SKU system:

  1. Make Them Easily UnderstandableSKUs record important product information, so do use letters where applicable for colors, size, type, and seasonal variants. Try to avoid loading the numbers with meaning (for example 1 is blue, 11 is teal, 12 is navy) because this will turn into a confusing string of numbers, and you’ll need to have a legend on hand to decode the meaning behind every SKU.

    When describing a blue dress, size small for Autumn/Winter ‘15, isn’t AW15DrBS easier to understand than 15020101?

  2. Arrange Attributes According to ImportanceThink of how you would describe your product in order of defining characteristics. Choosing to begin with the season/year will help you restrict your searches to the right collection, followed by increasingly broader characteristics like product type, color and size.
  3. Keep It SimpleDon’t use spaces, accents, symbols, or letters that look like numbers

    This is pretty self-explanatory, but using these can confuse your inventory system, so stick to alphanumeric SKUs as much as possible. Avoid using ‘O’ because it can be easily mistaken for a 0. If you’re using Excel, using ‘/’ could result in formatting your SKU as a date, while symbols like ‘>’, ‘*’, ‘^’ can also result in unintended consequences.

Do take note that SKUs are only associated with stock on hand that is available for sale, and do not include ordered products that are still in transit to replenish inventory levels in your warehouse.

By setting up an SKU system, you’ll be able to search and identify stock on hand from orders and invoices. You’ll also be able to track inventory movement right down to the individual variants of every product, such as color, size, and location.

With a good SKU system that defines your product right down to the minute details, you’ll always know where everything is, minimizing opportunities for theft. In a warehouse filled with thousands of products, it’s easy for missing items to slip under the radar. But when individual SKUs only denote a small number of items, it becomes harder for items to disappear.

Once you’ve created a list of SKUs featuring every product and their variants, you can rank them according to popularity so that you’ll know which ones to invest in and which to consider discontinuing. With an effective SKU system in place, you’ll be able to optimize your inventory by calculating the economic order quantity and individual reorder points for every SKU.

We’ll be back next week with a new post focusing on how to calculate your economic order quantity, and why you want to get these just right for your business success!

Rate This Article

This article currently has 3 ratings with an average of 4.3 stars

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Help Your Business Thrive

Sign up for our newsletter

Thanks for signing up!

Check your inbox for a confirmation email.*

*Check your spam folder if you don’t see a confirmation email.

Related Articles

Why better cash management improves business outcomes

If you could receive customer payments faster, how would your business improve?…

Read more

End of Financial Year using QuickBooks Online

The end of financial year process is much more efficient with the…

Read more

The ultimate end of financial year payroll checklist

The end of financial year process is much more efficient with the…

Read more