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:
- Ordered
- Quantity
- Price
- Cost
- Source
- Purchased
- Expires
- Multipack
- Quantity in Case (for case-packed items)
- Number of Cases (for case-packed items)
- Who Preps (this field accepts "amazon" or "seller" values)
- Who Labels (this field accepts "amazon" or "seller" values)
- Notes (Only works when importing to the PO)
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, receive them (for warehouse mode), add more items to the batch, or create your shipment plan.
Please Note: The Support item Notes i.e. "Notes" column is applicable only for POs and not for batches.