Create and Import Your Own Buy List

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

Optional Columns

• Optional MSKU Column
• Optional Condition Column

Mapping You Buy List Columns

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, Stratify 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
• Condition Notes
• Tax Code
• Min Price
• Max Price

Optional MSKU Column

Adding an MSKU column to the spreadsheet allows you to 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 be 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 MSKU Customization settings in Stratify
• Remove - The item is removed from the current batch and can be listed in a new batch at a later time.

Note: To enter your own custom MSKUs, 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
• 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. 

You can also enter multiple buy costs in a buy list as well! For more information on this, check out our article Enter Multiple Buy Costs During List - Entering Buy Costs Using a Buy List

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