This article explains how to sync your product database with Woocommerce.
To sync your inventory, please consult this guide.
The barcode in Hiboutik is the single key to identity a product or its variant.
To sync a product between Hiboutik and Woocommerce: the product barcode (or the variant barcode) in Hiboutik must match with the product SKU (or variant SKU) in Woocommerce.
This section explains how to import a Woocommerce product database into an Hiboutik account.
Products data excepted attributes and quantity in inventory will be imported. To import your inventory you should use an import file (for a stock order or an inventory count).
Login your Woocommerce account, to create an API access.
Go to 'Dashboard / Settings / Advanced / Rest API' and add a key with Read and Write permissions.
In the 'Apps' section of your Hiboutik acccount, install the 'Import Woocommerce' application.
Enter te URL address of your website and paste the ck and cs keys generated on Woocommerce.
Save and click on the 'Import data' button.
The import can take some minutes. You must keep the application page active to perform the import.
Product data (name, price, tax rate), images and categories are imported.
For products with variants, only the first variation is imported (ex: size). For others variations (ex: colors), as many different products will be created on your account.
The product SKU is imported in the barcode field.
If a new import is performed, only new Woocommerce products will be created.
Note: It is not possible to cancel an import (except through a total reset in demo mode).
This section explains how to export an Hiboutik product database into a Woocommerce account.
Step 1:
In 'Products/Export-import/Export data: Products', export files of your product database are available.
For the Woocommerce line, click on the 'Generate' icon and download the file.
This file is preformatted to be seamlessly imported into Woocommerce.
Step 2:
From Woocommerce, go to the 'Products' section and click on the 'Import' button at the top of the page.
Import the downloaded CSV file at step 1 and follow import instructions.
The file data to map in the import wizard are:
Name | Notes |
---|---|
type | Set the product type to simple or with variations. |
sku | Key data for the sync. It is the product barcode. |
published | 0 if archived, otherwise 1. |
name | Product name. |
catalog_visibility | 1 if 'Online' status enabled, otherwise 0. |
tax_status | All products are by default 'taxable'. If you are not tax submitted you can set 'none'. |
tax_class | 'Standard' = tax ID 1 (Setting/Sales taxes), 'Reduced Rate'= tax ID 2, 'Zero Rate'= tax 0%. If taxes don’t match please change the values. |
regular_price | Product selling price. |
stock | Quantity if you track the product into inventory. |
categories | Category the product belongs to. It should match with your Woocommerce categories otherwise the category will be created. |
attribute 1 name | Name of the global Attribute (Variant type). |
attribute 1 value(s) | List of variants for the attribute or the variant value of the variation. |
attribute 1 global | Variation visibility. |
parent | SKU of the the parent product for variations. |
description | Product description. |
image_id | Link to the first web image of the product form. |
To consult the Woocommerce import guide : https://docs.woocommerce.com/document/product-csv-importer-exporter/
You can filter results in the export file generated on Hiboutik (ex: to only export last new products):
– go to the 'Products' section,
– click on the 'Advanced search' button at the top of the page,
– select your filter options and tick the 'Save results' box,
– and launch the search.
Files generated in 'Products/Export-import/Export data: Products' will only include products sorted out in the search.