Create and Import Your Own Buy List

You can create your own Buy List and import it directly into your InventoryLab List page.

To make sure your template has all of the columns you need, just download the template attached to the bottom of this article.

Buy List Requirements

• Must be formatted as a .csv file
• Required Columns:
  • ASIN
  • List Price
  • Quantity
• If the Condition is not included in the file, InventoryLab will default the Condition as New.
• A LISTPRICE greater than $0.00 must be entered for each item included in your Buy List.

Optional Columns 

While the ASIN, List Price, and Quantity columns are required, you have the option to add the following columns to use this feature to truly create your listings in full:

• Title
• Cost/Unit
• Purchased Date
• Supplier
• Condition
• MSKU
• Sales Tax
• Discount
• Expiration Date
• Condition Notes
• Tax Code
• Min Price
• Max Price

Optional MSKU Column

Adding an MSKU column to the spreadsheet allows you manually enter MSKUs for the items in your Buy List. This can be useful if you have a unique MSKU system already in place for your business.

If you happen to duplicate an MSKU you’ve used in the past, you’ll be alerted during the Amazon Validation step of the importing process and will not able to create your batch until addressed.

The option to either REMOVE the item or Create New MSKU will appear. You can also CANCEL the import, modify the duplicated MSKU in your Buy List spreadsheet, SAVE, and import the file again.

If you choose: 

• Create New MSKU: A new MSKU is generated for you based on your Variable MSKU Settings in InventoryLab.
• Remove: The item is removed from the current batch and can be listed to a new batch at a later time.

* To enter your own custom MSKU, Cancel the import and modify the MSKU for that item in the .csv file before importing it again. Or you can remove the item entirely by clicking on the Remove button and list it another time.

Optional Condition Column

Comply with Amazon Condition Guidelines by entering the appropriate product conditions as follow:
• New
• Used Like New
• Used Very Good
• Used Good
• Used Acceptable
• Collectible Like New
• Collectible Very Good
• Collectible Good
• Collectible Acceptable
• Refurbished

I imported my Buy List but I entered the wrong Condition for an MSKU!

If you notice a condition was entered incorrectly you’ll need to cancel the import>enter the correct Condition in the spreadsheet>SAVE and import the file again.

* If the item has already been accepted into the batch the original MSKU is now tied to that ASIN in that condition. Listing the ASIN again with a different condition will require you to assign a new MSKU.

Mapping Your Buy List Columns

When you import your buy list, you will be able to map your headings to the correct column attribute, regardless of the order or title of your columns. For efficient, automatic mapping, we suggest you use the following titles:

ASIN (required) – ASIN
Title – TITLE or NAME
Cost/Unit – BUYCOST or COST PRICE
List Price (required) – LISTPRICE or LIST PRICE
Quantity (required) – QUANTITY 
Purchased Date – PURCHASEDDATE or DATE PURCHASED 
Supplier – SUPPLIER
Condition – CONDITION
MSKU – MSKU 
Sales Tax – SALESTAX
Discount – DISCOUNT
Expiration Date – EXPIRATION DATE
Condition Notes – NOTES
Tax Code – TAXCODE

NOTE: When including an MSKU in your buy list, it will be accepted automatically during the Replenish Validation step unless you are replenishing that item.

In this instance, the existing MSKU will be used. 

For the complete list of Buy List Import steps, go to the Importing Your Buy List page.

For more detailed information, check out our video on Importing Your Scoutify Buy List: