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
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 (internal notes for PO items)
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 PO and you may edit them, receive them, add more items to the PO.