Qblue Inventory
>
 

WooCommerce

Bookmarks: WooCommerce integration after Qblue go live | Add products to the WooCommerce website feed | How to map import tax with a non-diminishing product line item for overseas website orders

Connecting to WooCommerce

Before connecting to the website, ensure the following API details have been entered:

  • Click on your name initials (top right)
  • Click Integrations
  • Click WooCommerce
  • Click Settings (from the left)
  • Fill in the following information:
    • Your shop URL, for example: https://myshop.com
    • Consumer key
    • Consumer secret
    • Leave the Api version as 3, otherwise if you know the version of your WooCommerce API version, select it from the "Api version" dropdown box

Click here to view how to get your consumer key and secret.

 

WooCommerce integration during the implementation stage

For a brand new implementation, we usually start by importing all the products from the website onto Qblue. By doing this, details of the product records are imported automatically. These include: product attributes, group and variation products, images, product detailed HTML descriptions/specifications and so on.

With this method of implementation, you can choose what to or what not to sync from Qblue to the website. To do this:

  • On the WooCommerce integration settings page, toggle the different options

For example:

  • Toggle ON for "DON'T send images, do all images on website"
    • When this option is ON, it means Qblue will not send images and that all images must be done or managed on the WooCommerce admin portal

 

WooCommerce integration after Qblue go live

* This applies to existing websites only *

Because the product records initially imported into Qblue did not have all the website product details (such as images, HTML descriptions and categories), therefore it is recommended to turn on ONLY the "Send just quantities" sync option. This tells Qblue not to send undefined (or empty) product details to the website, thus overriding the existing website product information. 

Here are the options should be ticked or turned on for this:

  • Turn on new orders sync
    • Download new orders into Qblue automatically
    • Other options for syncing new orders are optional
  • Turn on products sync
    • Turn on "Send just quantities"

With this setup, you manage or maintain all product details directly on the WooCommerce admin portal.  When setting up new products, the same SKU must be entered onto both Qblue and WooCommerce.

 

Select the inventory locations to feed product quantities to the website

By default, when sending products to the website, the inventory quantities will be taken from the system default location (or primary location). If you have multiple locations, choose which locations quantities to send to the website. For example:

 

 

Add products to the WooCommerce website feed

To tell Qblue what products to sync with the website:

  • Go to Products menu, then "Channel feeds"
  • Ensure WooCommerce is selected from the channels dropdown box like the below:
  • To add products in bulk, click "+ Add products"
  • Select the products to add to the channel

Alternatively, you can add a single product to the WooCommerce sync from the product's editor:

  • Go to Products menu, then "Products / Sku variations"
  • Search for a product, then click on the SKU to edit
  • From the "Publish to:" channels dropdown box, select WooCommerce, like the below:

 

FAQ

How to convert a single variation product into a multi-variant product?

Step 1:

Check to ensure each variation has variation options:

  • Edit the variation product
  • Click "Variations" on the left
  • Click "Edit variants"
  • Enter and add the options respectively. For example: size or colour
  • Ensure each set of options are unique in all of the variations

 

Step 2:

Check if the variation product has already been sent to WooCommerce. If so, reset the API id for the variation product in order for the system to sync it into the grouped product on WooCommerce.

  • Go to Products menu > Channel feeds
  • Ensure "WooCommerce" is selected from the list of channels dropdown box
  • Search for the grouped product's description
  • Check in the "Notes" column (on the right) to see if any of the variations that have been sent to WooCommerce as "simple" products. A simple product on WooCommerce means it is a standalone product with no variations.
  • Tick the variations that has "simple" on the Notes column
  • Click "Reset API ID"
    • By doing this, the system will clear the "simple" product API id and re-sends the variation products into their grouped product on WooCommerce
  • See below for an example:

 

 

How to move a variation product into another list (group product)?

Step 1:

Transfer the variation product to another grouped product:

  • Edit the variation
  • Look to the left to check if this product is already belong to a grouped product that has more than 1 variations
    • If it has 1, it means this product has only got the one variation by itself
  • Click "Transfer to listing" (bottom right)
  • Search for the grouped product
  • Click "Confirm transfer"
  • This will result in:
    • The variation product is grouped together with the selected grouped product to form a multi-variant styled listing
    • If any, the variation product's image will be retained

 

Step 2:

Check to ensure each variation has variation options:

  • Edit the variation product
  • Click "Variations" on the left
  • Click "Edit variants"
  • Enter and add the options respectively. For example: size or colour
  • Ensure each set of options are unique in all of the variations

 

Step 3:

Check if the variation product has already been sent to WooCommerce. If so, reset the API id for the variation product in order for the system to sync it into the grouped product on WooCommerce.

  • Go to Products menu > Channel feeds
  • Ensure "WooCommerce" is selected from the list of channels dropdown box
  • Search for the grouped product's description
  • Check in the "Notes" column (on the right) to see if any of the variations that have been sent to WooCommerce as "simple" products. A simple product on WooCommerce means it is a standalone product with no variations.
  • Tick the variations that has "simple" on the Notes column
  • Click "Reset API ID"
    • By doing this, the system will clear the "simple" product API id and re-sends the variation products into their grouped product on WooCommerce
  • See below for an example:

 

 

How to map import tax with a non-diminishing product line item for overseas website orders

Step 1: Set up a import tax product SKU (non-diminishing)

  1. Go to Products, then select Products / Sku variations.
  2. Create a new non-diminishing product SKU e.g. ImportTax.
  3. Click Edit variant on the left access menu.
  4. Click Edit GL.
  5. Map the GL accounts to a tax related GL code from Xero and if necessary, choose a tax type. The GL code should be entered into both "Sales income" and "Expense account for purchasing or trading" fields.
     

Step 2: Enter this import tax SKU onto the WooCommerce integration's page

When a new overseas website order (currency is NOT in the base currency) is being imported, the system will set the order as tax exempt and if any, add the import tax value into a separate line item into the order.

If you have any questions, ask us by creating a help desk ticket.