-
Connex for QuickBooks User Guide
- Getting Started with Connex for QuickBooks
- Remote Desktop (RDP)
- Customers Matching
- Inventory Site
- Inventory Sync
- Multicurrency
- Orders
- Price Levels
- Products
- Purchase Orders
- Refunds
- Sales Tax
- Sales Orders
- Unit of Measure
- Web Connector
- Getting Started with Rules
- Rules Engine Common Rules
- FAQ
- Deposit Match
- Cost of Goods Sold
-
Connex Inventory Planner
-
Frequently Asked Questions
-
General Troubleshooting Guide
- Deposit Match Troubleshooting
- QuickBooks Desktop Error Messages
- Inventory Troubleshooting
- Incorrect Orders Troubleshooting
- Sales Tax Troubleshooting
- Web Connector Troubleshooting
- QuickBooks Online Error Messages
- Match Deposit Tool Troubleshooting
- Product Matching Troubleshooting
- Customer Matching Troubleshooting
- Rules Engine
- Orders from QuickBooks
- Payments Troubleshooting
- Missing Orders Troubleshooting
- Update Shipping Details Troubleshooting
-
Connex for QuickBooks Integrations Guide
For an initial sync of inventory, can I upload a spreadsheet to Shopify?
From QuickBooks Desktop, you can upload a spreadsheet of products and perform an initial inventory sync.
How do I upload the sheet?
Test with a single item, then do more items. To make the sheet, here are the steps:
- Log into QuickBooks.
- Go to lists and click item list.
- On the bottom, click Excel and export all products.
- Select CSV and click OK.
- Rename the item name field to variant SKU.
- Rename the Quantity on Hand field to Variant Stock Qty.
- Create a column called Title and make it equal the variant SKU field.
- Add a column called Variant Inventory Tracking and add shopify as the value.
- Rename sales price to Variant Sales Price.
- Log into Shopify.
- On the left, click products.
- Click the import button.
- Upload the spreadsheet.
- In Shopify, click import.
- You will see that the stock has changed.