Want to start from a blank file instead? See the article "How to Update Cost in Bulk Using Excel".
The prefilled sheet, called the Item Costs worksheet, already lists all your products. That means you can update many costs at once without retyping ASINs or SKUs.
Step 1: Get the prefilled sheet
Go to Listings, then the Product Cost tab, and click Export in the top right. ConnectBooks builds an Excel file already filled with your products and their current costs.
Step 2: Know the columns
Some columns are filled in for you. Some you fill in yourself.
Already filled in:
Column A, Asin
Column B, Sku
You can update a product using either the ASIN or the SKU.
Required:
Column C, Cost. The cost of the item.
Optional:
Column D, Prep Cost. Any extra cost per item, such as duty, labor, or packaging.
The cost went up or down
Type the new cost in Column C. ConnectBooks then creates a new cost period for that item.
Example: your current cost is $5 and it goes up to $10. When you upload the sheet, ConnectBooks starts a new cost period at $10 beginning on the upload date.
You still have old stock at the old price?
Use these columns so ConnectBooks blends the old and new costs correctly:
Column E, On Hand Stock. How many units you still have at the old cost in your local warehouse.
Column F, Calculate FBA Stock. Type Yes and ConnectBooks works out how much is left at Amazon (FBA) on its own. It then averages your old cost stock with your new cost stock going forward.
Column G, Purchase Qty. How many units you bought at the new cost.
Column H, Purchase Date. The date you bought the new cost units. If you leave it blank, ConnectBooks uses the upload date.
Tip: You can set up more than one cost period for the same item using separate rows. Put the original cost in the first row, then the new cost in the next row with Columns D, E, and F filled in as needed.
Column I, Avg Cost. Read only. Ignore this one. It just shows the current average cost already in ConnectBooks.
Wipe the old cost and start fresh
Column J, Delete Cost history. Type Yes to delete the item's full cost history and replace it with the cost on this sheet.
Type Yes only if you truly want to erase all past cost data. Otherwise type No, and ConnectBooks just updates the cost going forward.
Step 3: Upload your sheet
On the Product Cost tab, click Import.
In the Bulk Update window, drag your file in or click choose file. The Sample Template link here shows the correct format.
Click Import to apply your changes.