One of the first things we do with our clients is gather ALL product information together in one sheet. We call this the Master Product List and it becomes one of the most important documents that any Amazon seller or SellerPlex client has.
Why? Because it’s the holy grail of product information. Any and all information about products you’re selling goes into one spreadsheet, with easily trackable and exportable information.
We do this first because we know that every seller needs to have this. You simply cannot scale a business with this important info in random places in your Google Drive or Dropbox.
A good seller can find a product’s weight in the same second that they can be find the SKU associated with that product. There shouldn’t be any more time spent on that search. It will be vital in organizing shipments, understanding costs, and working with suppliers.
And it’s not just a list for the sake of having one. It’s a list that needs to be accurate, updated, and reviewed.
Because a good seller doesn’t stop at one simple Master Product List. The data from that list will go into purchase order trackers, cost of goods trackers, and more. A simple knowledge of exporting data in Google Sheets can auto-populate this info. But it means your Master Product List has to be 100% accurate and up-to-date.
This is a big MUST for businesses we work with. Having accurate and accessible info—and having a one-stop-shop for that like a Master Product List is our way of ensuring it happens. It needs to be yours too.
Interesting: Product Launch Roadmap From Designing 6,000+ Successful Products
What Goes Into A Proper Master Product List?
The Master Product List is a database of all products listed under FBA, along with the other vital information for each product such as:
Description (short), Brand, SKU, ASIN, FNSKU, UPC, SUPPLIER’S COMPANY, INCO TERM, HS CODE, DUTY RATE, UNITS / CTN, Length, Width, Height, CBM/ CTN, GW/ CTN.
Product Vitals
column name | Where To get |
---|---|
Description (short) | Seller supplied |
Brand | Brand of the Product in Question |
SKU | Amazon Seller central |
Product 4 | Amazon Seller Central |
ASIN | Amazon Seller Central |
FNSKU | Amazon Seller Central |
UPC | Amazon Seller Central |
Supplier's Company |
Seller supplied, Purchase Order (PO), Proforma Invoice (PI), Packing List (PL) |
INCO TERM |
Pre-Onboarding Sheet, Purchase Order (PO), Proforma Invoice (PI), Packing List (PL) |
HS CODE |
Seller Supplied |
Duty Rate |
Seller supplied |
units/ CTN |
Seller supplied, packing list (pL) |
Length |
seller supplied, packing lisy (pL) |
height |
seller supplied, packing list (pL) |
cBM/CTN |
seller supplied, packing list (pL) |
gW/CTN |
Seller Supplied, Packing List (PL) |
There’s more to our Master Product Lists. Simply sign-up below and see how we code info from Suppliers and the rest of our MUST HAVE Master Product List columns. You can see both the list and a full usable template in our Foundation SOP package.
Must Read: Get access to nine other ESSENTIAL SOPs for running a scalable and sellable Amazon business. Don’t miss out—you don’t want to scale without these and you’ll have trouble finding a decent seller unless you’re organized and ready!