You can sync products that you create in your online store to QuickBooks. By default, Connex will sync products associated with new orders. Our system has a special task to sync product updates and new products to QB, regardless of orders.
If you're seeking to import several hundred products, export your data into a spreadsheet. Go into QuickBooks > Lists > Item List > Excel and import a spreadsheet. This feed is ideal for a few hundred or so products.
Our system uses the income, inventory asset, and COGS account under the transaction tab > account area.
These systems support the feed:
- Channel Advisor
If your solution is not listed, please let us know. We will look into creating a feed for you.
On the My Connections page, click configure. Click the Product Feed section and enable the feed.
Our system will queue these updates in the background. Go to the account tab and click pending inventory to see the products. Our system will sync new products to QuickBooks, when you run the web connector.
Can you create products with colors or sizes?
Yes, Connex supports product variants. Connex groups by the item title:
ABC Shirt - Black Large
ABC Shirt - Green Medium
ABC Shirt - Green Small
Connex creates ABC shirt with a color and size attribute:
Size (Large, Medium, Small)
Colors (Black, Green)
Next, Connex creates a variant for all three products.
Underneath the enable button, you can change the dates of the sync. If you wanted to export products created several months ago, adjust the sync dates:
How does Connex prevent new products syncing to QuickBooks and back to my website?
When Connex creates new items, the stock quantity is zero in QuickBooks. If our tool added the stock, then the inventory would have no value. When the inventory is sold, QuickBooks records no inventory asset or COGS.
The problem with zero inventory in QuickBooks is Connex will wipe out inventory on the website. Here is a use case:
- Connex creates new product in QuickBooks.
- Product has been recently created, so it has been recently modified.
- Connex will sync the stock quantity of 0 back to the website.
Users will see a rule called product feed exclude inventory sync in their rules engine. It says if the product was newly created by the product feed, then do not sync it back to the website.
I use QuickBooks Point of Sale. Can I sync pictures?
Yes, Connex can sync pictures from your site to QB POS. You must enable pictures in QB POS and add pictures to your products. Here are the steps:
- In QB POS, go to file > preferences > company.
- On the left, click inventory.
- Check I want to associate pictures with my inventory items.
- Login to Connex.
- Click configure at my connections.
- At the configure page, click the inventory tab.
- Scroll down to product feed settings.
- Enable the sync pictures checkbox.
In your website, create a new product and add pictures. The pictures must use JPG format. Connex will find matching products in QB POS: