Skip to main content
All CollectionsInventory & Shipping Integrations GoFlow
Goflow Inventory Integration Explained
Goflow Inventory Integration Explained

This article explains how the data from Goflow is used to track your costs accurately.

C
Written by Chava Teller
Updated over a week ago

Integrating Goflow with ConnectBooks ensures seamless and accurate tracking of your costs of goods sold (COGS). Here’s a detailed guide on how this integration works and how to maximize its benefits.

What data Does ConnectBooks Pull from Goflow?

Since ConnectBooks connects directly with your marketplace, it pulls all transaction data from the marketplace. The only missing piece is the cost of goods, which Goflow provides. Goflow calculates an average cost per order, accounting for constant price fluctuations. This is the cost that ConnectBooks retrieves.

How to View the Cost of Your Items.

Once connected to Goflow, item costs will appear in the P&L reports in the cost column, if you want to see it per order, read below.


Resolving Orders with Missing Costs.

When ConnectBooks connects to Goflow, it requests a cost for every order, refund, and adjustment. Sometimes, Goflow might not have the cost for a transaction due to various reasons, such as a bill not being entered or received after the order has shipped, which will show the cost as 0.

As an accounting software, ConnectBooks reconciles every transaction to determine its cost. If a cost is missing for a transaction, ConnectBooks will display the SKU and order ID to highlight this issue. Additionally, an indicator will appear next to the cost field in reports for transactions with missing costs.

To resolve missing costs:

  1. Navigate to the Accounting Export page and select a store.

  2. In the Settlement Export Status column, where it says “item missing cost,” click Resolve.

Here, you'll see all orders missing a cost. Sometimes, a prefilled cost representing the current average cost for the product will be shown. If this cost is acceptable, click Save. Otherwise, input the correct cost.

If you know that Goflow has updated information, click Sync with Goflow to update the data.

Viewing the Cost Per Order.

In the profit and loss reports, you can view the cost per item. To view the cost per order:

  1. Navigate to the Accounting Export page and select a store.

  2. Select the More button in the Settlement Export Status column.

  3. Select Download COGS Excel.

This report can be downloaded per settlement.

By following these steps, you can ensure accurate and seamless tracking of your costs of goods with ConnectBooks and GoflowG.

Did this answer your question?