Want to start from a blank file instead? See How to Update Cost in Bulk Using Excel.
The prefilled sheet lists your products and every cost you've entered for them, each with its start date (the first one has no date). You can change many costs at once without typing ASINs or SKUs.
Step 1: Download the sheet
Go to Listings, open the Product Cost tab, and click Export.
Step 2: Know the columns
Column | What it is |
A, Asin and B, Sku | The product. Already filled in. |
C, Cost | What 1 unit costs you. |
D, Prep Cost | Extra cost per unit, like labor or packaging. Optional. |
E, On-Hand Stock | Units you still have at the old cost. Optional. |
F, Calculate FBA Stock | Type Yes and ConnectBooks counts what's left at Amazon for you. Optional. |
G, Purchase Qty | Units you bought at the new cost. Needed if you fill in E or F. |
H, Purchase Date | The day this cost starts. |
I, Avg Cost | Read only. Ignore it. |
J, Delete Cost history | Yes = replace this product's cost history with what's on the sheet. |
A product can have more than 1 row, 1 for each cost period.
Step 3: Make your change
Your cost changed, starting today
Delete the other rows for that product.
Type the new cost in Column C.
Leave Purchase Date (H) empty.
Change Delete Cost history (J) to No.
ConnectBooks starts the new cost today and keeps your old costs.
You still have stock at the old cost
Do the same, and also fill in On-Hand Stock (E), or type Yes in Calculate FBA Stock (F). Add Purchase Qty (G) for the new units. ConnectBooks blends the old and new costs.
A past cost was wrong
Find the row with that Purchase Date and fix the cost in Column C. Leave Delete Cost history as Yes. This changes the cost from that date on.
Important: The sheet comes with Delete Cost history set to Yes on every row. With Yes, what's on the sheet replaces the product's cost history, so any row you delete is removed from it.
Step 4: Upload the sheet
On the Product Cost tab, click Import.
In the Bulk Update window, drag your file in or click "choose file".
Click Import.
If any rows have a problem, ConnectBooks downloads a sheet that tells you which ones and why.
Frequently asked questions
I typed a new cost, but my old months changed too.
That row still had its old Purchase Date and Delete Cost history set to Yes, so the old cost period was changed. Use the steps in "Your cost changed, starting today".
Can I leave Purchase Date empty on more than 1 row?
No. Only 1 row per product can have no date.
What if I upload the sheet without changing anything?
Nothing changes.