Go to Listings, pick the store, open the Product Cost tab, click Import, then click Sample Template.
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 freight, 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 G must be filled in when E or F is used.
Column H, Purchase Date. Enter the date you bought the units at the new price. If you leave it blank and the item already has a cost, ConnectBooks uses the day you upload the sheet. An item's first cost always applies from the start.
Tip: You can set up more than 1 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. Fill in Columns D to H as needed. Leave the Purchase Date blank only on the original cost row, and give every other row a date. If the item already has a cost, also enter Yes in Column I on that row, or the row with no date starts on the day you upload.
Delete and replace an existing cost
Column I, Delete Cost history. To replace an existing cost, enter Yes in Column I.
If Purchase Date is blank, ConnectBooks deletes all the cost history and replaces it with the cost on this sheet.
If you enter a Purchase Date, only the cost periods that start on or after that date are replaced.
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.
Frequently asked questions
Do I need both the ASIN and the SKU?
No. Only 1 is required.
What if I leave Purchase Date blank?
If the item already has a cost, ConnectBooks uses the day you upload the sheet. An item's first cost always applies from the start. Only 1 row per item can be left without a Purchase Date.
Will Delete Cost history wipe all my costs?
Only when Purchase Date is blank. With a date, ConnectBooks only replaces cost periods that start on or after that date.