You can create your own Buy List and import it to create a new batch on the List > List & Prep page.
To make sure your template has all of the columns you need, download the template attached to the bottom of this article.
Buy List Requirements
Your Buy List file must meet the following requirements:
Must be formatted as a .CSV file (NOT .txt, .xlsx, etc.).
Do NOT add commas in the headings of your import as the file type causes comma separation.
Required Columns: ASIN, LIST Price, Quantity
A List Price greater than 0.00 must be entered for each item.
Dates must be valid and in MM/DD/YY or MM/DD/YYYY format.
Note: If the Condition is not included for the items in the file, InventoryLab will default the Condition as New.
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
MFN Shipping Template
Condition Notes
Tax Code
Min Price
Max Price
Optional Condition Column
Comply with Amazon Condition Guidelines by entering the appropriate product conditions as follows:
• New
• Used Like New
• Used Very Good
• Used Good
• Used Acceptable
• Collectible Like New
• Collectible Very Good
• Collectible Good
• Collectible Acceptable
• Refurbished
Note: If you get the error that 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. You will receive the following error.
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.
If you notice that any information was entered incorrectly before moving to Box It, you can update your items by clicking the three stacked dots next to the item's name in the Batch Content section and selecting Edit Item.
Scroll to whichever field you need, and update it accordingly.
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
MFN Shipping Template – MFN SHIPPING TEMPLATE
Condition Notes – NOTES
Tax Code – TAXCODE
AZ Min Price – MIN PRICE
AZ Max Price – MAX PRICE
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.
What's next?
For the complete list of Buy List Import steps, go to Importing Your Buy List.