Skip to main content

Nineyard Inventory Integration Explained

How ConnectBooks gets item costs from Nineyard, and how to fix items missing a cost.

When you connect Nineyard to ConnectBooks, ConnectBooks gets an accurate cost of goods sold (COGS) for your items. Here's how it works.

What data does ConnectBooks pull from Nineyard?

ConnectBooks connects directly to your marketplace and pulls all transaction data from it. The only missing piece is the cost of goods, which Nineyard provides. Nineyard works out an average cost per item per day, so it keeps up with price changes. This is the cost that ConnectBooks pulls in.

How to view the cost of your items

Once Nineyard is connected, item costs show in the cost column of the P&L report.

Resolving orders with missing costs

ConnectBooks asks Nineyard for a cost for every item. Sometimes Nineyard doesn't have a cost for an item, for example when a bill wasn't entered. The cost then shows as missing.

ConnectBooks needs a cost for every transaction. If a cost is missing, ConnectBooks shows the SKU so you can fix it before exporting to QuickBooks.

To fix missing costs:

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

  2. In the COGS column on the Accounting Export page, click Missing cost (or the issues label), then click Fix.

  1. You'll see all items missing a cost. Enter the cost for each item, then click Save.

Viewing the cost per item per day

Item prices can change a lot, so you can see the cost of each item for each day:

  1. Go to the Listings page and select a store.

  2. Open the Product Cost tab.

  3. You'll see all items and their cost for each day.

Frequently asked questions

Where does the cost in my P&L come from?

From Nineyard. It's Nineyard's average cost per item per day.

Why does an item show Missing cost?

Nineyard didn't have a cost for that item, for example because a bill wasn't entered. In the COGS column on the Accounting Export page, click Missing cost (or the issues label), then click Fix. Enter the cost and click Save.

Can I see how an item's cost changed day by day?

Yes. Go to Listings, select the store and open the Product Cost tab.

Did this answer your question?