When you connect a store to SellerCloud for costs, ConnectBooks brings in that store's product costs and saves them on your listings. These costs then show in the cost column of your Profit & Loss reports.
How it works
After each day ends, ConnectBooks:
Looks at the orders SellerCloud shipped that day.
Works out the average cost of 1 unit for each SKU on those orders.
Saves that cost on the listing with the same SKU. A listing is how your product shows up in ConnectBooks for your store.
The cost stays in place until a day with a different cost comes in.
For example, say SKU MUG12 shipped on 2 order lines on May 3. The first line has 2 units at an average cost of $4. The second has 3 units at an average cost of $5. ConnectBooks works out (2 × $4 + 3 × $5) ÷ 5 = $4.60. Your MUG12 listing keeps a cost of $4.60 from May 3 until a day with a different cost comes in.
See your costs
To see the costs on a listing:
Go to the Listings page and pick your store.
Open the Product Cost tab.
In the Cost Period column, click the cell for your listing.
You'll see each cost and the dates it covers. To open the cost periods, you need permission to edit product costs.
Fix a missing cost
You need permission to edit product costs.
To add a missing cost:
On the Listings page, open the Product Cost tab.
Check the Missing Cost filter.
Enter the cost in the Item Cost column.
Click Save.
You can also start from the Accounting Export page. Click "Missing cost" (or the number of issues) on a settlement, then click Fix next to "Missing cost".
Tip: add the cost in SellerCloud too, so new days come in with a cost.
Edit a cost
If a cost is wrong, you can change it. You need permission to edit product costs.
To edit 1 listing:
On the Listings page, open the Product Cost tab.
In the Cost Period column, click the cell for your listing.
Click Edit.
Find the row whose dates cover the wrong cost, and change its Item Cost.
Click Save.
The cost in a row applies to every date in that row.
To edit many costs at once in Excel:
On the Product Cost tab, click Export.
In the sheet, fix the costs. The Purchase Date column shows the day each cost starts. Leave the first cost's date blank.
Click Import. Add your file, then click Import in the window that opens.
Important: the sheet replaces the cost history of each listing on it, so don't delete rows you want to keep. Before you upload, read the prefilled Excel sheet guide. It explains each column and how to fix a past cost.
Tip: fix the cost in SellerCloud too. If you don't, the sync can put the SellerCloud cost back, starting on the first synced day where the 2 costs are different. That day can be as recent as yesterday.
Things to know
The SKU on the SellerCloud order must match the SKU of the listing in ConnectBooks. If it doesn't, the listing gets no cost.
Only days that are over get synced. Today's cost comes in after today ends.
If no orders with that SKU shipped on a day, nothing is saved for that day. The last cost stays in place.
For a store you connected straight to its marketplace, your sales and fees come from the marketplace, not from SellerCloud. For a store you imported from SellerCloud, see How to import your marketplace stores from SellerCloud.
If you also connect SellerCloud for shipping, it brings in your shipping cost too.
The old "Resolve" and "Download COGS excel" options are gone. You now check and fix costs on the Listings page.
Frequently asked questions
How is the average cost worked out?
ConnectBooks uses the average cost SellerCloud shows on each order line. For each line, it works out average cost × units. It adds those up for the day, then works out that total ÷ the total units. Lines with no average cost are left out.
Which cost type should I pick on my reports?
Pick Default Cost. Your SellerCloud costs are saved on your listings, and Default Cost uses the cost on your listings. There are 2 exceptions:
If you use ConnectStock, Default Cost uses your ConnectStock cost from your ConnectStock start date.
If you display items by QuickBooks Item Name, it uses the latest QuickBooks cost first.
If you still see Sellercloud Cost in the list, don't pick it. It doesn't use your synced costs, so your cost can be wrong.
Does the first sync bring in past days?
Yes. When you first connect SellerCloud, ConnectBooks also syncs some past days. Dates before the first synced day keep the listing's existing cost. If the listing had no cost, the first synced cost is used for those earlier dates too.
Will the sync undo my edits?
It can, for the newest days. Each time it runs, the sync checks the last synced day again, then each new day. If the SellerCloud cost for that day is different, it saves the SellerCloud cost from that day on. Edits to earlier dates stay. To keep a new cost, fix it in SellerCloud too.
An order line has no average cost in SellerCloud. What happens?
That line is left out. ConnectBooks can use the site cost on that order line instead. Contact us if you want this turned on.
Need help? Use the chat icon in ConnectBooks.