Connex for QuickBooks can sync customers, newly created products, and orders from WooCommerce to QuickBooks. Our software can sync inventory updates from QuickBooks to WooCommerce.
Here are the prerequisites:
- Your website must have an SSL certificate.
- White list the Connex IP addresses
- 18.104.22.168 (Connex for QuickBooks Desktop)
- 22.214.171.124 (Connex for QuickBooks Online)
- Disable the Relevanssi search plugin.
- If you are updating inventory from QuickBooks to WooCommerce, disable ModSecurity on your website. If you don't, then you'll receive a 501 not implemented error in your log.
- GoDaddy, BlueHost, or Media Temple are incompatible hosts. These companies have WooCommerce performance issues. In many cases, they place too many websites on one server and the sites load very slow. The sync could be intermittent with these companies.
- Our own website is hosting on Kinsta and we are very happy!
Enable Legacy API
Connex uses the legacy API to pull your website's timezone and a list of refunds, and a list of recently modified sales. To enable the API, follow these steps:
- Log into WooCommerce.
- On the left, click WooCommerce > Settings > Advanced > REST API.
- Enable the legacy API.
Our software uses a special WooCommerce user name and password, known as a consumer key and secret, from your website. To pair your site, follow these steps:
- Login to Connex for QuickBooks.
- On the dashboard, click add a new connection.
- In the wizard, choose WooCommerce.
- Enter your URL, prefixed by https.
- Click submit.
- On the dialog box that appears, click continue.
- Follow the on-screen instructions. You will be asked to login and click the accept button. If Connex says pairing failure, click the link to pair manually. Generate keys manually and enter them into Connex.
- Upon completing these steps, you are redirected to the configure page of our software.
WooCommerce Pairing Failure
Connex for QuickBooks will try to auto-generate a special user name and password to pair your website and our solution. If your website does not auto generate the special credentials, you can easily obtain and add them to your website.
To generate the keys, see generate API keys in this help article.
To enter your pairing credentials, click update login on our dashboard. Enter the consumer key and secret.
How do the fields map with QuickBooks and WooCommerce?
Click here to view a guide.
Replace # Sign
WooCommere sends us a # sign before each order number. You can replace it using our rules engine. See Replace Order Number # Sign for the rule set and rule.
Partial and Full Refund Support
Our tools support partial and full refunds. If you perform a refund, our tool will sync the sale and the refund in the same batch. If the sale exists, then our tool will skip adding it to QuickBooks. If the order status is cancelled, then our tool will sync a refund if there is a matching sale. If you refund an order partially and you refund specific items, then you will see SKUs. If you perform a refund of a non-item, such as sales tax, you will see a single line item called partial refund with the total refunded.
Each product variation has must have a unique SKU in WooCommerce. The variation is treated as its own product in QuickBooks. If the SKU has no matching item name in QuickBooks, then our software makes a new product. The variation SKU will be the item name. If the SKU matches an existing item name, then the software will match to the product.
In this diagram, the parent product is 5063-511:
In WooCommerce, open the order. You will see a list of field names and values, below the order summary. In our software, click manage. Expand advanced transaction and check map custom fields. Once complete, our tool will pull the custom fields and you can map them. Please see this article on custom field support.
Make sure that your products have stock tracking turned on. Make sure that backorder is turned on if items can have negative quantities:
Can I mark items as out of stock, if I send zero or less stock?
By default, Connex for QuickBooks will allow back orders. To show out of stock, follow these steps:
- Login to your Connex for QuickBooks account.
- Click the 'manage' button under your existing Woocommerce connection.
- Expand the Sync Inventory from QuickBooks menu.
- Check mark item as 'out of stock'.
If the product is of type simple, then the manage stock box must be checked to change stock status.
Can I sync Stripe credit card fees onto orders?
Stripe fees are a WooCommerce custom field, which requires a settings adjustment to sync. Before you enter the install wizard, you must follow these steps:
- Log into your Connex for QuickBooks account.
- Click the 'manage' button under your existing connection.
- Expand the Merchant Fees menu.
- Enter a fee item name. Leave the percent and cents as 0.
Can I use custom order statuses?
Legacy API Only
Some fields might be unavailable to map. You must use an older version of the WooCommerce integration to pull orders by custom order status.
You must instruct our software to use the legacy WooCommerce API and contact us with some example sales:
- Login to Connex.
- Click transfer connection.
- If your URL is https://www.example.com enter https://www.example.com/wc-api/v3.
- If you use QuickBooks Desktop, login to QuickBooks as admin and open the company file. Open the web connector and remove the pairing file. Download a new one from Connex and double click it.
- Contact us with the URLs of orders with the custom statuses. We will adjust a setting on your account to allow you to select these statuses.
How do I fix the 301 redirect error?
A 301 redirect will send you to one site and redirect you to another. Go to https://www.bicyclepartsdirect.com/wc-api/v3, and notice how it redirects to https://bicyclepartsdirect.com/wc-api/v3 without the "www" in the URL. This error is common because many sites strip the www from their domains.
To fix this error, follow these steps:
- Log into Connex.
- Click update selling channel URL:
- Enter your website URL without the WWW:
- Log into QuickBooks as admin.
- Open your web connector.
- Remove the pairing file.
- On our dashboard, download a new pairing file.
- Click the file.
- If prompted, click OK to pair. If you see radio buttons, choose the last one from the bottom.