Skip to main content

How Product Costs Sync from GoFlow

Learn how ConnectBooks gets your product cost (COGS) from GoFlow each day, and where to see and fix it.

When you connect a store to GoFlow 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:

  1. Looks at the orders GoFlow shipped that day.

  2. Works out the average cost of 1 unit for each listing SKU on those orders.

  3. 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 the GoFlow order lines for SKU MUG12 that shipped on May 3 add up to $23 of COGS for 5 units. ConnectBooks works out $23 ÷ 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:

  1. Go to the Listings page and pick your store.

  2. Open the Product Cost tab.

  3. 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:

  1. On the Listings page, open the Product Cost tab.

  2. Check the Missing Cost filter.

  3. Enter the cost in the Item Cost column.

  4. 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 GoFlow 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:

  1. On the Listings page, open the Product Cost tab.

  2. In the Cost Period column, click the cell for your listing.

  3. Click Edit.

  4. Find the row whose dates cover the wrong cost, and change its Item Cost.

  5. Click Save.

The cost in a row applies to every date in that row.

To edit many costs at once in Excel:

  1. On the Product Cost tab, click Export.

  2. In the sheet, fix the costs. The Purchase Date column shows the day each cost starts. Leave the first cost's date blank.

  3. 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 GoFlow too. If you don't, the sync can put the GoFlow 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 listing SKU on the GoFlow 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 GoFlow. For a store you imported from GoFlow, see How to import your marketplace stores from GoFlow.

  • If you also connect GoFlow 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 COGS GoFlow shows on each order line. It works out the total COGS for that day ÷ the number of units. Lines with no COGS are left out.

Which cost type should I pick on my reports?

Pick Default Cost. Your GoFlow 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 Goflow 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 GoFlow, 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 GoFlow cost for that day is different, it saves the GoFlow cost from that day on. Edits to earlier dates stay. To keep a new cost, fix it in GoFlow too.

Need help? Use the chat icon in ConnectBooks.

Did this answer your question?