If you want to update the cost of your products using the prefilled Excel sheet, jump to Prefilled Item Sheet and Current Cost
Column A - Type in your marketplace ASIN.
Column B - Type in your marketplace SKU.
You can update the product cost either by using the ASIN or by SKU.
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.
What if you want to delete and update my existing cost?
Column I - 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.