Difference between revisions of "Best Practice Sku Format"

From Moogento How-to Guides
Jump to navigation Jump to search
(Created page with "__TOC__ {{idea|We can help you get this setup, just get in touch for a quote :)}} ==SKU basics== ===Background info=== SKU is usually pronounced "skew". A SKU is a...")
 
m
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{#description2:Just getting setup in your warehouse shelving? Or just deciding how to setup your Magento product SKUs? They can be linked, let's dive in and see how we can set this up the best way.}}
 
__TOC__
 
__TOC__
  
Line 42: Line 43:
  
 
====Logical structure====
 
====Logical structure====
 +
When thinking about how to create your SKU format, here's some ideas.
 +
 
# If you sell configurable products, aim at having the product number first, then each sub-feature (possibly hyphenated).
 
# If you sell configurable products, aim at having the product number first, then each sub-feature (possibly hyphenated).
 
#: ''eg. 172772-BLK-XL, 172772-WHT-S, etc''
 
#: ''eg. 172772-BLK-XL, 172772-WHT-S, etc''
Line 48: Line 51:
  
 
You might want to include:
 
You might want to include:
 +
 
# Product code
 
# Product code
 
# Color
 
# Color
Line 54: Line 58:
 
# Season (for eg. fashion)
 
# Season (for eg. fashion)
 
# Other unique product attribute
 
# Other unique product attribute
 +
 +
 +
 +
==Recommended Warehouse Shelving Structure==
 +
 +
If you're just setting out to optimise your warehouse, eg by using [https://moogento.com/picknscan-m2 Pick-n-Scan] and [https://moogento.com/trolleybox-m2 TrolleyBox], you might discover you need to update your shelving location labelling.
 +
 +
The most-used format comes down to:
 +
 +
1) Row, usually A, B, C, D etc. These are the solid rows in the warehouse, with the letters on the end of each row. Often these are split, so one physical unit will have a different letter on each side - eg. AB CD EF etc.
 +
 +
2) Shelf (aka 'Floor'), usually 01, 02, 03, 04, 05 .. 09. This is from the floor to the ceiling. Double digits to avoid sorting issues (10 is sorted ahead of 1 in some systems).
 +
 +
3) Position (aka 'Location'), usually 001, 002, 003 or 01, 02, 03 etc depending on the length of your units. These start at one end and go back, ie. it lets the Picker know how far down the unit to go.
 +
 +
The end result is going to be like:
 +
 +
A-02-06
 +
 +
B-04-06
 +
 +
B-04-08
 +
 +
etc.
 +
 +
===Recommended Shelving Labels===
 +
 +
The usual system is to have magnetic or velcro laminated location labels, but just printing & sticking can work as well.
 +
 +
There's a few key parts.
 +
 +
1) Location code
 +
 +
eg. A-02-06
 +
 +
2) Direction arrow
 +
 +
It's very helpful to your Pickers to indicate, with a large arrow, whether the label is referring to the space above or below the label.
 +
 +
3) Location barcode
 +
 +
When you're saving location to Magento, adding products to a location (or removing them), doing stock checks, etc - it's extremely helpful to have a barcode to scan.
 +
 +
[https://moogento.com/stockeasy-m2 StockEasy] will work with this, so you can for instance:
 +
 +
- scan a barcode of a product that you're adding to stock
 +
- scan/type the qty that's being added
 +
- scan the shelf
 +
 +
or
 +
 +
- scan the shelf and see what the stock should be
 +
 +
etc.
 +
 +
Since these labels quite often are high up, to save time it's handy if these are scannable from a distance - ie. large fonts to read from far and a large barcode to aim at from far are both key.

Latest revision as of 17:55, 29 April 2022

We can help you get this setup, just get in touch for a quote :)






SKU basics

Background info

SKU is usually pronounced "skew".

A SKU is a unique ID for a specific unique product in your warehouse/store.

While you might edit your product title over the years, you'll be aiming to keep you SKU the same - so it's a good idea to start with a decent SKU format.

This is often overlooked at the start but skipping thinking about this early can result in issues later.

Key ideas

  1. Less is more : shorter codes are better
    People are going to have to manually type these codes for the life of the product - help them out :)
  2. Use unique SKUs
  3. Keep them short (5-15 is the standard length, up to 30 is ok)
  4. Don't use the product title in the SKU, use a summary code word or number.
    eg. instead of 'Summer Love Beach Basic Long Sleeved White Small Shirt' you could have 172772-WHT-S

Formatting

Decide on a format before you start, and stick to it!

  1. Use CAPS
  2. Don't use spaces or non-alphanumeric characters
    This will help you integrate with other apps in the future, and any time you want to get into spreadsheets (eg. mapping sales forecasts, creating Purchase Orders, stock lists) you'll thank yourself for not having things like >, *
    Usually acceptable characters are: _ -
  3. Avoid confusable numbers/letters if possible (ie. I, O, L, 1, 0, l)
    Your warehouse crew will thank you
  4. Don't start SKUs with a zero

Logical structure

When thinking about how to create your SKU format, here's some ideas.

  1. If you sell configurable products, aim at having the product number first, then each sub-feature (possibly hyphenated).
    eg. 172772-BLK-XL, 172772-WHT-S, etc
  2. Keep key parts of the product human-readable. This is going to save you and your warehouse team a lot of time and stress.
    eg. instead of 'Summer Love Beach Basic Long Sleeved White Small Shirt' you could have 172772-WHT-S : you can easily read that code as White and Small, which is way easier than trying to remember or lookup eg. 172772-299237-12919373

You might want to include:

  1. Product code
  2. Color
  3. Size
  4. Brand
  5. Season (for eg. fashion)
  6. Other unique product attribute


Recommended Warehouse Shelving Structure

If you're just setting out to optimise your warehouse, eg by using Pick-n-Scan and TrolleyBox, you might discover you need to update your shelving location labelling.

The most-used format comes down to:

1) Row, usually A, B, C, D etc. These are the solid rows in the warehouse, with the letters on the end of each row. Often these are split, so one physical unit will have a different letter on each side - eg. AB CD EF etc.

2) Shelf (aka 'Floor'), usually 01, 02, 03, 04, 05 .. 09. This is from the floor to the ceiling. Double digits to avoid sorting issues (10 is sorted ahead of 1 in some systems).

3) Position (aka 'Location'), usually 001, 002, 003 or 01, 02, 03 etc depending on the length of your units. These start at one end and go back, ie. it lets the Picker know how far down the unit to go.

The end result is going to be like:

A-02-06

B-04-06

B-04-08

etc.

Recommended Shelving Labels

The usual system is to have magnetic or velcro laminated location labels, but just printing & sticking can work as well.

There's a few key parts.

1) Location code

eg. A-02-06

2) Direction arrow

It's very helpful to your Pickers to indicate, with a large arrow, whether the label is referring to the space above or below the label.

3) Location barcode

When you're saving location to Magento, adding products to a location (or removing them), doing stock checks, etc - it's extremely helpful to have a barcode to scan.

StockEasy will work with this, so you can for instance:

- scan a barcode of a product that you're adding to stock - scan/type the qty that's being added - scan the shelf

or

- scan the shelf and see what the stock should be

etc.

Since these labels quite often are high up, to save time it's handy if these are scannable from a distance - ie. large fonts to read from far and a large barcode to aim at from far are both key.

Retrieved from "https://moogento.com/guides/index.php?title=Best_Practice_Sku_Format&oldid=2704"