Connex for QuickBooks Desktop User Guide
Connex for QuickBooks Online User Guide
Frequently Asked Questions
Integrations Help Guide
- Amazon Settlement Report
- Channel Advisor
- Match Deposit Tool
- Other Partners
- Roaster Tools
- Spreadsheet Import Tool
Rules Engine Guide
General Troubleshooting Guide
QuickBooks Point of Sale (POS) - ARCHIVED
How do I perform an initial import of products from Shopify to QuickBooks?
How to import products from a SpreadSheet
My website has over 10,000 top level products. Is Connex compatible?
Our tool will import products, if they are tied to incoming orders. To perform an initial import, follow these steps:
- In Shopify, click the products tab on the left.
- Click export.
- Choose all products and the second box for CSV.
- Save a copy of the CSV.
- Delete all rows except the first.
- Add three columns: income, asset, COGS.
- Enter an inventory asset account in the asset field. Enter a COGS account in the COGS field. Enter an income account in the income field. QuickBooks will later ask you to map accounts, so you will map these columns.
- In QuickBooks, go to the gear box.
- Click import data.
- Choose products.
- Upload the CSV with the single row.
From here, you will be asked to map fields.