This article covers how the synchronization and importing of Products between WooCommerce and QuickBooks Commerce works for the integration.
We now Support WC3.1.x however, please ensure to create a backup before upgrading as a precautionary step. Please be advised that you will need to have authentic SSL enabled on your website to ensure a successful integration experience.
WooCommerce Products on QuickBooks Commerce
- A Simple Product in WooCommerce will be imported into QuickBooks Commerce as a Product with a single Variant.
- A Variable Product in WooCommerce will be imported into QuickBooks Commerce as a Single Product with multiple variants.
- Product types in WooCommerce that sync to QuickBooks Commerce: Simple, Variable, Subscription, Variable-subscription
- Product types in WooCommerce that do not sync to QuickBooks Commerce: External/Affiliate, Grouped
- QuickBooks Commerce only syncs the first three attributes of any product from WooCommerce.
Publishing Variants from QuickBooks Commerce
- Publishing a single variant from QuickBooks Commerce will create a Simple Product on WooCommerce.
- Publishing another variant of the same Product from QuickBooks Commerce will result in a conversion of the Simple WooCommerce Product to a Variable WooCommerce Product.
Images Sync
- When a Product is first created on QuickBooks Commerce, only the Primary or Default image of that Product will sync to WooCommerce due to system limitation. We recommend handling image uploading from within WooCommerce.
- However, if we later update (add, delete, etc.) images on QuickBooks Commerce or on WooCommerce, these changes will not sync.
Deleting a product
- Deleting a product in QuickBooks Commerce results in deleting the product in WooCommerce.
- Deleting a product in WooCommerce will simply unlink the QuickBooks Commerce product, but it will still be active on QuickBooks Commerce.
Create new relationships
- Creating a relationship in WooCommerce creates a corresponding relationship in QuickBooks Commerce.
Simple product
|
WooCommerce Product |
Syncs as |
QuickBooks Commerce Product |
|
title |
⇆ |
name |
|
description |
⇆ |
description |
|
tags |
→ |
tags |
|
product_type (This will sync to QuickBooks Commerce when you import your products) |
→ |
product_type (Changing product type on QuickBooks Commerce will not change product type in Woocommerce) |
When there is more than one variant on QuickBooks Commerce
|
WooCommerce Product |
Syncs as |
QuickBooks Commerce Variant |
| title |
⇆ |
name Note
WC variations do not have names so the QuickBooks Commerce variants will be created with a name based on the Woocommerce product name |
|
managing_stock |
⇆ |
manage_stock |
|
SKU |
⇆ |
SKU |
|
stock_quantity |
⇆ |
initial_stock_level Note
This sync will only happen on import, changing the stock quantity in Woocommerce will not update the stock level on QuickBooks Commerce. Create a stock adjustment or PO instead to update the stock quantity of your Woocommerce product.
|
|
weight |
⇆ |
weight |
|
regular_price |
⇆ |
will sync depending on price_list_id setting on the channel. Defaults to sync with TG retail_price |
|
sale_price |
⇆ |
will sync depending on sale_price_list_id setting on the channel. |
|
WooCommerce Product |
Imports as |
QuickBooks Commerce Product |
|
title |
→ |
name |
|
description |
→ |
description |
|
tags |
→ |
tags |
|
product_type (will on sync on import) |
→ |
product_type (changing product type in QuickBooks Commerce will not change the product type in Woocommerce) |
|
wc_attributes name |
→ |
option1 |
|
wc_attributes name |
→ |
option2 |
|
wc_attributes name |
→ |
option3 |
|
WooCommerce Variation |
Imports as |
QuickBooks Commerce Variant |
| title |
→ |
name (Woocomerce variants do not have names so the QuickBooks Commerce variants will be created with a name based on the Woocommerce product name + Woocommerce variant SKU) |
|
managing_stock |
→ |
manage_stock |
|
SKU |
→ |
SKU |
|
stock_quantity |
→ |
initial_stock_level (this sync will only happen on import. Thereafter, changes to stock_quantity in WooCommerce would not apply to QuickBooks Commerce. User should create a stock adjustment or PO instead to update the stock quantity of their WooCommerce product) |
|
weight |
→ |
weight |
|
regular_price |
→ |
will sync depending on price_list_id setting on the channel. Defaults to sync with QuickBooks Commerce retail_price |
|
sale_price |
→ |
will sync depending on sale_price_list_id setting on the channel. |
|
wc_attributes option |
→ |
option1 |
|
wc_attributes option |
→ |
option2 |
|
wc_attributes option |
→ |
option3 |
- Ensure that your WooCommerce products/variants have SKUs. If you do NOT have SKUs for your products/variants you will be unable to publish or import those products into QuickBooks Commerce.
- Do not manually update the Product Type from WooCommerce. This means changing the product type to Simple to Variable and vice versa
Please contact us if you are unable to install WooCommerce. Alternatively, you can refer to this article WooCommerce Installation Error Messages- What To Do.