If you copy the columns as I mentioned in my post …
… everything should line up. However, if you want to use “quantitiy” you can.
I’ll say this though.
Having all SKU’s the same Qu. is a trigger for dropshipping to Amazon.
Reposting the “Details” in full (with minor update)- OSFE Post I made, but haven’t updated lately
(Change edit multiple listings bulk handling time shipping time time to ship lead time)
I posted this some time ago …
Edit Production Time (Handling Time) - Link no longer works but leaving it in … BUT I’ve updated the links since Amazon re-did the Help Pages
If you are a Pro Merchant Selling Plan you can do so by file upload …
File Upload :
US - Price & Quantity File located on this page
OR :
CA - Price & Quantity File located on this page
… and use the leadtime-to-ship Handling Time.
All that is needed is SKU and leadtime-to-ship Handling Time. Pretty sure you don’t need the add/delete column …
PREVIOUSLY you couldn’t change for Books … I suppose we can now though but it still says you have to ship within 2 days in the Prohibited seller activities and actions help page NOW IS UNDER Selling media products
2 Day Media Shipping
Sellers are required to ship all Books, Music, Video and DVD products within two business days of the date the order confirmation is made available to you. Shipping rates and service options are set by Amazon. For more information, see Shipping BMVD Products.
Using a report to do all your inventory I would :
-
Open in Excel
-
Copy the SKU column
-
Paste it into the Price & Quantity template
-
Copy the Price column
-
Paste it into the Price & Quantity template
-
Use only sku, price & handling-time to avoid issues with Quantity being overwritten against pending orders
(I get the same download URL showing whether US or CA)* Set the PT as needed -
US - Upload as Price & Quantity Feed … Under Inventory in Seller Central > Add Products via Upload
OR
CA - Upload as Price & Quantity Feed … Under Inventory in Seller Central > Add Products via Upload