Multiple Box Inventory Upload

I think I can. I think I can. I know I can. I know I can.

SEE THE UPDATE AT THE BOTTOM OF THIS POST FOR INVENTORY LAB USERS.

You've probably heard that Amazon wants sellers to upload a pack list when sending multiple boxes for one shipment. Oh fun!

Yes, I did it. I screamed and pulled my hair out and said inappropriate words, but I did figure out how to do it, and how to do it efficiently. At least for the moment.

Number 1. Try to get everything for a shipment in one box if at all possible. Not possible? See number 2. (I sort my items before packing in order to estimate what I need box wise).

Number 2. Once you hit approve, then go to each shipment, and download one packing slip at a time. Copy / paste into a spreadsheet (or try to right-click and see if you can get it to save as a spreadsheet). Remove unnecessary columns (like condition and SKU). Don't forget to title the spreadsheet with the shipping information.

Number 3. Build new columns to the right (make a column for each box that you think you will need for the shipment), and name them "Box 1", "Box 2", and so forth.

Number 4. Print your spreadsheets with gridlines. Pack one shipment at a time. Number your boxes (it can be a small mark on the inside of the lid). Use a pencil to tally mark on your spreadsheet (in the numbered box column) with how many of each item that you put into a box. This way you can adjust your shipment easily. Just erase and remark your tallys.

Number 5. Once your shipment it packed, then enter the number you have for each item in the correct column. Save.

Number 6. Finish your shipment as usual (weight, measurement, except charges), and upload the spreadsheet. That's it. Really.

It takes a little extra time, but I will say that it does force you to double check that you have everything packed correctly in your boxes. Just be sure to create your spreadsheet after you approve the shipment, but before you start packing the boxes.

INVENTORY LAB USERS / 30 up USERS:  After you create your shipments, go to Seller Central to finish. Go to each shipment one at a time. There is a big yellow button that says you can edit quantities. Click on it. Scroll down the page a bit and print your 30 ups for just that shipment. Once you finish packing one box, and see that you still have inventory to pack a second box, go back to Seller Central, download your packing list, and make a spreadsheet. Then use your labels to put in your counts for Box 2. The rest of the items are already in Box 1, so all you have to do is put the numbers in the column! This makes it even easier, and since your labels indicate how many you have in a shipment, you won't make a mistake.

Dymo Users: You can still print off 30 up labels onto a sheet of paper and use it as a count sheet.