Products can be imported from WooCommerce to Katana in the following cases:
You can choose to import all your products from WooCommerce to Katana during the initial integration connection. NB! If you are using SKUs in WooCommerce, then make sure they are unique for the import to Katana to work properly.
Note: If you have variable products in WooCommerce, make sure that you have a unique SKU defined for each variant, otherwise, the variant will not be imported.
If you choose not to import all products, only those products will be imported to Katana during the initial connection that appears on imported Sales orders. Read more
Later, when new Sales orders are synced from WooCommerce to Katana, then products on those orders are imported Katana.
Products cannot be synced from Katana to WooCommerce.
Creating and matching products
Katana matches products imported from WooCommerce to your existing products in Katana.
If a match is found, no new products are created.
If a match is not found, a new product is created in Katana.
This is how we identify whether a product already exists in Katana:
1. Checking SKU code. SKU code in WooCommerce will be compared to Variant Code in Katana as the primary condition to make the match. SKU codes are case-sensitive. For example, if SKU in WooCommerce is "code-1" and Variant Code in Katana is "CODE-1", these are not considered equal and a new product variant for "code-1" is created in Katana.
2. Checking WooCommerce ID. If you do not use SKU codes for your products or if there is no SKU match, then we use WooCommerce ID to match the product. This match cannot be made at the first time you are syncing the product. When a product variant is pulled from WooCommerce to Katana for the first time, a WooCommerce ID (hidden from the user) is added to the product variant in Katana for future identification. If the same product variant is pulled in the future, Katana matches the ID.
If the imported product does not match with any existing products in Katana, then a new product is created in Katana.
Product data from WooCommerce is imported to Katana product data fields as follows:
WooCommerce | Katana | Comments |
Name | Product name | - |
Product type | Variants | Katana imports "Simple products" , "Variable products" and "Bundle products" from WooCommerce. "Grouped products" and "External/affiliate products" are not imported. |
- | Unit of Measure | Unit of measure does not exist in WooCommerce, Katana will use "pcs" as a default value for Unit of Measure. |
SKU | Variant Code | - |
- | Safety stock level | Safety stock level does not exist in WooCommerce, so this will be left blank in Katana. Low Stock Threshold in WooCommerce will not be imported to Katana. |
Regular Price | Default Sales Price | When you have chosen to import all products during initial connection, then the Regular Price (not Sale Price) of the product in WooCommerce will be imported as the Default Sales Price for products in Katana. The Default Sales Price is determined based on the selected tax rate settings. Read more |
- | Cost |
Editing or deleting a product is not synced
Editing data in either WooCommerce or Katana for a product that has already been imported does not reflect in the other system. Any changes to the product name, variations or sales price are not synced.
Deleting products in either Katana or WooCommerce does not delete the product automatically in the other system.
Syncing new products when the integration is already enabled
After you have enabled the WooCommerce x Katana integration, new products created in WooCommerce or Katana are not synced to the other system automatically.
New products are imported from WooCommerce to Katana only if:
The product is included in a Sales order that is synced from WooCommerce to Katana.
You complete the reconfiguration flow for WooCommerce integration in Katana and select to import all your products. Read more here.
Product import if multiple WooCommerce stores are connected to Katana
If you have connected more than one WooCommerce store to Katana, the integration works exactly in the same way for each store. Product import and matching work identically for all stores.
For example, if the same product (i.e. same SKU code) exists at multiple stores, then products will be matched (i.e. duplicates not created) in Katana if the same product has already been imported from another WooCommerce store.