Product Mapping FAQ

My inventory and cost of goods sold exists in Shopify. How do I sync to QuickBooks?

How to sync, if your products are missing from QuickBooks

How do I add products to QuickBooks?

Connex will create no new products in QuickBooks, if they are inventory parts. Connex receives no inventory count or value of inventory. 

This guide assumes that the product is missing from QuickBooks and the product has no stock or cost of goods sold.

First, let's create the QuickBooks product:

  1. In QuickBooks, go to lists and choose item list.
  2. Click item and click new.
  3. Choose inventory part.
  4. In the item name field, enter your Shopify SKU.
  5. Choose a cost of goods sold and an income account:
  6. Click OK to save the product.
  7. In QuickBooks, go to inventory > adjust quantity value on hand.
  8. Enter the product, its stock, and its value. Here is an example:

Please talk to your Accountant about your quantity on hand, value of inventory, and the proper accounts. 

How do I use a spreadsheet of products from Shopify to import products?

Here are the steps:

  1. In Shopify, go to products.
  2. Export the products to a spreadsheet.
  3. Create a copy of the sheet and remove all products, except one. You will test with a single product.
  4. In QuickBooks, go to lists > item list.
  5. Click Excel > paste from Excel.
  6. Copy paste the variant SKU column to the QuickBooks item name column.
  7. Copy paste the variant title to the sales description and purchase description fields.
  8. Choose a income, asset and COGS account.
  9. In the sales price field, enter the sales price.
  10. In the total value and quantity fields, enter the quantity on hand and the value of inventory. If you have 10 widgets that you purchased for $10, the total value is $100.
  11. Here is the end result:

What is the end result?

When our software syncs orders to QuickBooks our software will record $20 as the cost of goods sold. Here is your profit and loss report:

On your inventory valuation summary, the amount is $80 down from $100: