Sync your products with Woocommerce

This guide explains how to synchronize product information. For stock synchronization, please follow this guide.

---

#1/ Prerequisites

The barcode in Hiboutik is the unique key used to identify a product or variation. For a Hiboutik product to match its equivalent in WooCommerce, and vice versa, the product barcode (or variation barcode) in Hiboutik must be strictly identical to the product SKU (or variation SKU) in WooCommerce.

---

#2/ Import a WooCommerce Product Database

This section explains how to import a WooCommerce product database into a Hiboutik account.

This process imports categories, products, variations, prices, references, and images.

Stock is not imported as part of this process. Stock synchronization is handled separately through the WooCommerce app.

#Configuration

In WooCommerce, create an API access.

To do so, go to WooCommerce / Settings / Advanced / REST API and add a key with Read/Write permissions.

In the Apps section of your Hiboutik account, install the Import WooCommerce app.

Enter your website URL and the ck and cs keys generated in WooCommerce.

Save the settings, then click Import data.

The import is performed in several steps and may take several minutes depending on the number of products to process.

---

#Categories

WooCommerce categories are automatically created in Hiboutik if they do not already exist.

The category hierarchy is also preserved.

For example:

Shoes
    ├── Men
    └── Women

will be reproduced with the same structure in Hiboutik.

---

#Simple Products

Simple WooCommerce products are imported into Hiboutik with information including:

• product name;
• selling price;
• category;
• SKU;
• images.

When an SKU is specified in WooCommerce, it is used as the product barcode in Hiboutik.

---

#Variable Products

Variable WooCommerce products are imported into Hiboutik with their variations.

For each variable product, the connector first determines the variation type to use in Hiboutik.

To do this, it analyzes the attributes configured for the WooCommerce product.

Global WooCommerce Attribute

The connector first looks for the first product attribute that has a WooCommerce attribute ID.

For example:

Product: Classic T-shirt

Attribute:
Size

Values:
S
M
L
XL

The Size attribute is matched with the corresponding variation type in Hiboutik.

The result will be:

Classic T-shirt
│
└── Variation type: Size
    ├── S
    ├── M
    ├── L
    └── XL

Attribute Defined Directly on the Product

If no variation type can be identified from a global WooCommerce attribute, the connector looks for a match based on the attribute name.

For example:

WooCommerce
Attribute: Shoe size

        ↓

Hiboutik
Variation type: Shoe size

This also allows attributes defined directly on an individual WooCommerce product to be handled.

---

#Creating Variation Types

WooCommerce attributes required for variable products are automatically created in Hiboutik as variation types if they do not already exist.

Their different values are also created automatically.

For example:

WooCommerce

Attribute: Size
Values: S, M, L, XL

becomes:

Hiboutik

Variation type: Size
Variations: S, M, L, XL

---

#Variation Prices

When a WooCommerce variation has its own price, this price is applied to the corresponding variation in Hiboutik.

For example:

S  → €29.90
M  → €29.90
L  → €31.90
XL → €31.90

Price differences between WooCommerce variations are therefore preserved in Hiboutik.

---

#SKUs and Barcodes

The WooCommerce SKU is used as the barcode in Hiboutik.

For variable products, each variation can therefore have its own barcode.

For example:

WooCommerce variation

Size: M
SKU: 3760123456789

        ↓

Hiboutik

Variation: M
Barcode: 3760123456789

An option is also available to automatically generate an EAN-13 barcode when no SKU is specified in WooCommerce.

The generated barcode is then saved in both WooCommerce and Hiboutik so that the same reference is used in both systems.

---

#Images

WooCommerce product images are automatically imported into Hiboutik.

Up to 4 images per product can be imported.

JPEG, PNG, WEBP, and GIF formats are supported.

If an image already exists in the corresponding position in Hiboutik, it is not imported again.

---

#Import Published Products Only

An option allows you to limit the import to products that are currently published in WooCommerce.

When this option is enabled, products that are not published in WooCommerce are not included in the import.

---

#Subsequent Imports

The connector keeps the association between WooCommerce and Hiboutik products.

During subsequent imports, products that are already associated are recognized to prevent duplicates from being created.

New products can therefore be added to the Hiboutik catalog during subsequent imports.

---

Warning: a product import cannot be automatically undone. We recommend checking your WooCommerce catalog configuration before starting your first large import.

---

#3/ Export a Product Database to WooCommerce

This section explains how to export a Hiboutik product database to a WooCommerce website.

#Step 1

In Products / Import-Export / Export data: Products, you will find several options for exporting your product database. On the WooCommerce line, click the Generate icon and download the file. This file is preformatted to simplify the import into WooCommerce.

#Step 2

In WooCommerce, go to the Products section and click the Import button at the top of the page. Then import the CSV file downloaded in Step 1 and follow the WooCommerce import process.

The data in the file should be matched with the WooCommerce fields as follows:

Field	Description
type	Indicates whether the product is simple or variable.
sku	Unique key used for synchronization. Corresponds to the product barcode.
published	0 if the product is archived, otherwise 1.
name	Product name.
catalog_visibility	1 if the 'Online' status is enabled, otherwise 0.
tax_status	By default, products are taxable ('taxable'). You can use 'none' if you are not subject to VAT.
tax_class	'Standard' = tax ID 1 (Settings / VAT rates), 'Reduced Rate' = tax ID 2, 'Zero Rate' = 0% tax. If the mapping is incorrect, edit the file accordingly.
regular_price	Product selling price.
stock	Quantity if stock management is enabled for the product.
categories	Uses the categories from your account. You must first create the same category structure in WooCommerce using identical names.
attribute 1 name	Name of the variation type.
attribute 1 value(s)	Available variations or the name of the variation.
attribute 1 global	Variation status.
parent	SKU of the parent product if the row represents a variation.
description	Product description.
image_id	Link to the first web image on the product page.

The guide for importing products into WooCommerce is available here: https://docs.woocommerce.com/document/importation-exportation-de-produits-au-format-csv/

You can filter the products included in the export file generated by Hiboutik (for example, to export only recently added products):

– go to the Products section; – click the Advanced Search button at the top of the page; – select your filters and check Save search; – run the search.

Files generated in Products / Import-Export / Export data: Products will then include only the products matching your search.