Want a sheet that already has your products in it? Jump to How to Update Cost in Bulk Using Excel: Prefilled Sheet.
Fill in the columns
Required:
Column A, Asin. Type in your marketplace ASIN.
Column B, Sku. Type in your marketplace SKU.
You can update a product using either the ASIN or the SKU, only 1 is required.
Column C, Cost. Enter the cost of the item.
Optional:
Column D, Prep Cost. Add any extra costs for this SKU here, such as duty, labor, or packaging.
If the cost went up or down
Enter the new cost in Column C. ConnectBooks then adds a new cost period for that item.
Example: the cost on ConnectBooks is $5 and the price goes up to $10. When you upload the sheet, ConnectBooks creates a new cost period for the item. By default it starts on the day you upload the sheet.
You still have stock at the old cost?
Column E, On Hand Stock. If you still have stock bought at the old cost in your local warehouse, enter that quantity here.
Column F, Calculate FBA Stock. If you also have stock at Amazon, type Yes. ConnectBooks then works out how much you have left at Amazon on its own, and averages your old cost stock with your new cost stock going forward.
Column G, Purchase Qty. Enter how many units you bought at the new cost.
Column H, Purchase Date. Enter the date you bought the units at the new price. If you leave it blank, ConnectBooks uses the day you upload the sheet.
Tip: You can set up more than one cost period for the same item at once using separate rows. Put the SKU with the original cost on the first row, then the SKU with the new cost on the next row, and fill in Columns D, E, and F as needed.
Delete and replace an existing cost
Column I, Delete Cost history. To wipe an existing cost and start over, enter Yes in Column I. ConnectBooks deletes the cost history from the beginning and replaces it with the cost on this sheet.
Upload your sheet
On the Product Cost tab, click Import.
In the Bulk Update window, drag your file in or click choose file.
Click Import to apply your changes.