How to Make Useful Product SKUS for Amazon Items
Articles,  Blog

How to Make Useful Product SKUS for Amazon Items

How’s everyone doing? It’s your
man here, Sky G aka Ricki analog. If you guys don’t know who I am, I
am one half of the management team over at Reezy Resells. Me and Reezy have been business partners
for longer than I can remember. We run multiple businesses together. Our main moneymaker is our
Amazon book selling business and he’s been in the spotlight for a
while now making videos and tutorials and I kind of played the background. Nevertheless, I’m here. I comment
sometimes on his… on his group page and I try to help people and I
think there’s just only so much he can cover and get to. And it’s kind
of on my to-do list to start helping them out a little more with
some of these things that are more geared towards helping you guys. The first video, I guess I’m going
to make, is this video here today. Aptly titled, step your SKU game
up, the anatomy of a proper SKU. I see lots of you guys posting pictures
of shots of sales that you make and a lot of times I could see
your SKUs that you’re using and the SKUs are a lot of times,
these randomly generated numbers by whatever third-party company
you use to make your uploads. There’s a right way and a
wrong way to make SKUs and just using a randomly generated
number is definitely not helping you. I want to teach you how to make SKUs
that benefit you later on down the road. So there’s a few things that you
should be able to do with your SKU and you do it by encoding
data into the SKU itself. Now, some of the pieces of data
that you can include in your SKU. You can include a source. You can
include the date the inventory was listed or acquired. You
can include the sourcer, now don’t get that
mixed up with source. Source and sourcer are
completely different things. The source is where the book came from.
Your sourcer, if you pay people to get inventory for you, would be
who that person or entity is. The product’s condition, not
everybody is selling new products like if you do retail arbitrage,
most your stuff’s new. But a lot of us that sell used
books or toys for that matter, board games and things, you can
put the condition in there. The price you paid and the quantity of
units that you acquired for that SKU. And one last thing is we use what we
call ‘wild cards’ which are just things that we put in a SKU that allow us
to apply different pricing templates to those SKUs. We currently use repriceit
for pricing our inventory and it allows for a wildcards, so
an example would be putting ‘-TB’ for textbooks in the SKU of books
that are considered textbooks. And then we have a pricing
template and we price it that applies only to books
with that in the SKU. So our typical SKU, I guess I
should just get right into that: it goes the source. So let’s say it’s
Reezy’s location, it’s going to be CFL and we always use all caps. So if I don’t tell you whether
it’s caps or not, it is. It’s always all caps in the SKUs.
CFL- the date. And the format we use for the
date is, year so 2016 – the MLA abbreviated month so say it’s
January JAN – the day so 23 – condition of the book. So VG, G, LN, whatever it
happens to be – the number which is a random number at
the end which allows you to keep using the same SKU but
just the next one in that list. So I guess technically, the
last number is not really a randomly generated numbers just the
next number in a sequential order. Now, obviously I left out some of the
things that you can put into a SKU that was… those are our
base SKUs for our bulk books. But we also have books that
are gotten by sourcers. We have books that come from…
or not books, not only books but like we have products that
come from retail arbitrage so we’ll have the source in there
and things like the price paid and the quantity. I guess it’s also important to note
that what you put at the beginning of your SKU is only important for
sorting in seller central dashboard in the inventory in there. Because if you’re using an Excel sheet,
you can sort by the middle of a SKU, the end of a SKU, the
beginning of the SKU. Excel sheets are really, really useful
because they’re so easily manipulated to give you the data you
want in the order you want. So, when I’m telling you
pick out a good prefix, it’s only for pricing manually if
you’re using seller central dashboard to price your books. I had somebody ask why should
you put that data in your SKU if you’re using a service? Say like
Inventory Lab where you can put that data into Inventory Lab like your
cost, the quantity and the date and your source all these things. Or
even if you’re using like Caleb Roth’s tracking spreadsheet where…
or not the tracking spreadsheet but it’s listing spreadsheet
which again has those… has cells for those pieces of data. So why is it that you should do
it in the actual SKU itself? Well two reasons really. The first reason is, if you
ever stop using that service and you’ve been using randomly
generated numbers for your SKUs, you don’t necessarily get to take
all that data that you put in there with you to whatever
company maybe you move to or if you don’t use a third-party
service anymore after that. You lose all that data. This way (adjusting your own SKUs)
you can take the data with you wherever you go, it’s yours. It’s your
proprietary data that you have created and doesn’t belong to anybody. The second big reason for that is,
putting all these things in your SKU allow you to gain major
insights into your sales without having to drill down further
into the the actual sale itself. So, if I go and look at a
sale and I’m wondering, ‘oh I wonder where that book came from?
Or I wonder who bought that? Or I wonder what the the
margin is on that?’ You know or just different things
you might have questions about, where if you don’t include
this in your SKU, you got a lot of digging to do
to go find that information. I can look at my SKUs and
my sales and tell you exactly where that book came
from, when it was listed, like the condition it was in, who
was the sourcer, was it a textbook? Different things like… And that’s so useful to just be
able to gain insight like that by just merely looking at a SKU. So I really hope that you guys
watch this and implement it. Don’t just watch this in nod your head. Stop using these
randomly generated SKUs. It… it hurts me when I see you guys
posting your sales on the Facebook group and there’s just some weird random SKU
and I’m going this guy’s going to have a headache later on when, you know, you realise that your SKUs don’t
mean anything, they mean zilch. So if you guys liked this video,
we’ll keep more of them coming. I know it’s a very boring dull video.
I’m literally in my office right now and using a lamp here for extra light.
It’s probably a hideous video. It’s not going to have a lot of
crazy good editing or anything. It’s not going to be exciting
but hopefully you take away the actual meaning from this and
that is use data in your SKUs. Make your SKUs purposeful. Till next time guys, peace out.
It’s Ricky analog. Reezy Resells step your SKU game up.


  • Brian Miller

    What if I've been using randomly generated ones w inventory lab and I want to switch to this? I've been thinking about switching to ScanLister + Caleb Roth spreadsheet but I'm kinda stuck in my way but maybe I could increase my speed using something other than inventory lab?

  • Misfit Maker

    super helpful!!! thanks for covering this im just starting out and i just sent in my first shipment in last week. my goal is to send in 200 books a week. Would it be realistic for me to make 10k or more a year sending in that amount each week. thanks

  • Israel Barba

    Can you guys make a video on how you setup your FBA Scan app to run well? Or how you guys have yours set? I'm having so much issues with mine, I almost want to use a different app. It freezes, it doesn't communicate with optiscan scanner very well. Please Help!

  • Gemini

    Great info been taking notes all day, whats the best programs to use? I got scanlister for shipping, what other programs for scanning at source and inventory should I look into?

  • Muma Genc

    Do you have amazon professional account or individual account? and What is your minimum profit margin when you are considering buying a book? Thanks!

  • Rebekah Long

    Hello Reezy ! just wondering, When you are making a label for a book. and you look it up to check the price then you find the photo is different then what is in your hand. (same author, same book, same ISBN number.) everything seems to be the same except for the cover photo. Do still make that label or do you make a new listing ? P.s Thanks for all the great videos. I have really enjoyed them. See if you can ask your wife to pop in a few more of them. Does she help you out often ?

  • Rebekah Long

    #Q2: If a box of books went over the 50lb mark by just a few pounds, have you ever sent it in? I just filled a box up and it says 54 lbs would I get in trouble? I listened to your video when you said your cut off is 49 lbs. which is a great idea. I just have not figured out how to take items off one shipment list and add them to another. maybe you could make a video on that ? Thanks so much for your time and efforts. Great videos.

  • Paul Rhodes

    Thanks for the great info bro! I just started watching you guys and I am excited about getting started selling books. After a car accident and failed back surgery it has been tough the last year I am finally excited about something and it is really going to help my family thanks for all you do. Have a wonderful week. -Paul


    Hey Reezy Resells! Love your vids!

    Got a few questions that would help me out a lot!

    My FBA Scan app is set to Buy/Reject mode, so it works very "black & white" if that makes sense. Will there times when you buy a "Reject" book and reject a "Buy" book. If so, what are the circumstances? Is there a better mode within the app in your opinion?

    Also, is there anyway to bypass Amazon's multiple locations rule. Because sometimes I'll be setting up an FBA shipment and it want's to send like 9/10 books to location #1 and just one book to another, which really frustrates me. Is that something I've got to live with or what is a way I can bypass that setting.

    Thanks Reezy and keep up the great work!

  • Amateur Tech

    You guys are awesome – thanks a lot for taking the time to help us new folks , I mean I know you guys don't have to do this so it's so helpful and such a nice gesture. so thank you

  • Sheyne Bittner

    Great video with great info. Just started selling books, got laid off from my real job, on as I am in Canada and not near the border to ship to .com. I may do that down the road if I can find a cost effective way to get them there.

    I am now going to start putting info. into my SKU's as this will make it much easier to glean data with a quick glance at a sale. Do you manually generate them and then paste them in or how do you get each one into the SKU location. I am manually uploading onto Amazon right now and have not started to use any software due to cost but eventually will migrate over.

  • Robert Watson

    Currently use IL for listing, migrating to ScanLister soon (after mandatory Mac OS upgrade to gain accessibility), but already DO practice smart SKUs, keyword specific, for fast decisions in SellerCentral.

    What's the character count limit for a sku via ScanLister?


    P.S. 'Boring' to wannabe entrepreneurs, perhaps, but details matter, so I value said information.


  • TM O

    Thanks for this info, Scotty. I've been encoding my SKUs for a long time but still got a couple of ideas on more info to add to them.

  • Mike Martin

    Thanks for the video. It was extremely helpful when completing my first FBA shipment ever. I used your SKU advice when labeling my products.

  • MrMosoani

    Very helpful. Pls make a complete guide for a total noob. I want to start selling online not on Amazon and I had no idea what SKU is and what it means and why it's important. Thanks for the SKU tip. I hope we see more tutorials. Back to your sample, "price paid" is that the selling price?

  • Seth Allen

    Great video I know I’m two years late but I got a question. Say you have two of the same book that is same condition but sourced a year apart does it allow you to make anew individual sku for that book or do you have to go back and use the sku from a year ago on that same book? Cause that’d suck if it only allowed you one sku cause your sku data would be off

  • Jeffery Brown

    Thanks for the video. I’m just starting out but eventually I will scale business so I might as well do it right from the beginning 👌🏾.

Leave a Reply

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