If you want to update the cost using the blank template, jump to the Blank template sheet
Prefilled Data:
Column A - Product ASIN
Column B - Product SKU
You can update the product cost either by using the ASIN or by SKU.
Required Feilds:
Column C - Enter the cost of the item.
Optional:
Column D - You can add any additional costs for this SKU here. like, inbound freight, duty, labor, or packaging costs.
What if the cost went up/down? (Variable Cost)
Enter the new cost in Column C, and ConnectBooks will add a new period for this item with the new cost.
For example, if the existing cost on ConnectBooks is $5, and now the price increased to $10, when you upload the new cost sheet, ConnectBooks will create a new cost period for this item. (By default the new period will start on the date of the sheet upload).
What if there is existing inventory with the old cost?
Column E - If you have remaining stock purchased at the old cost in your local warehouse, enter the amount in column E.
Column F - If you also have remaining stock by Amazon type in Yes, and ConnectBooks will automatically calculate the amount you still have remaining by Amazon.
(ConnectBooks is going to make an average going forward of the Remaining Stock with the old cost and the new stock with the new cost)
Column G - Enter the amount of stock purchased at the new cost.
Column H - Enter the date the items were purchased with the new price.
(If left empty, we will use the day you upload the document)
Note: You can update multiple cost periods for one item at the same time using separate rows. On the first row enter the item Sku with the original cost, on the next row enter the Sku with the new cost for the item and fill out columns D, E, and F as needed.
Column I - Ignore this column, this column just shows you the current avg cost on ConnectBooks.
What if I want to delete and update my existing cost? (Variable Cost)
Column J - To correct and override an existing cost, enter "Yes" in column G. ConnectBooks will then delete the cost history from the beginning and update it with the cost of this sheet.
Note: Only write “Yes” if you want ConnectBooks to completely delete the existing cost on ConnectBooks, otherwise type in “No” and ConnectBooks will only update the cost going forward.