Import Spreadsheet
First, you need to create a spreadsheet with the following three required columns (or use the template attached to this solution):
ASIN
MSKU
Condition
We strongly suggest that you include quantity, but it is not required. If quantity is omitted, we default the quantity to 1. The maximum value is 10,000.
Fill out appropriate information for the items you would like to import into a shipment.
Optional columns include:
Quantity
Price
Cost
Source
Purchased
Expires
Who Preps (this field accepts "AMAZON" or "SELLER" values)
Who Labels (this field accepts "AMAZON" or "SELLER" values)
Notes (the Condition Notes of the item when importing to a batch)
"tag 1", " tag 1 color", "tag 2", etc. for inventory tags
"batch item tag 1", "batch item tag 1 color", " batch item tag 2", etc for batch item tags
From the Import dropdown in PREP & SHIP, select "Spreadsheet" and select your spreadsheet from your device.
This edit screen will open where you may edit any fields and select the items you wish to import. In the bottom menu, you will see the options to: Select All, Deselect All, Import Selected, or Import All. Once you have finished making any edits and finalizing your selection, make your choice.
The items will now appear in the batch and you may edit them, add more items to the batch, or create your shipment plan.