Download products from WooCommerce
Overview
Find out how to download products from WooCommerce.
Products are the goods your business buys or manufactures and sells.
And over time, as your market changes and business grows, you’ll add new products to your inventory. If you prefer to create new products in WooCommerce, you can then download them to Cin7 Omni.
When you download products, Omni breaks your WooCommerce product catalog into three groups:
Mapped products
Unmapped, mappable products
Unmapped, unmappable products
A mapped product already exists in WooCommerce and Omni. A mapping has already been created, too, between its WooCommerce and Omni versions. When you download products from WooCommerce, these products are ignored.
An unmapped, mappable product already exists in WooCommerce and Omni. But a mapping has not been created between its WooCommerce and Omni versions. When you download products from WooCommerce, mappings are created for these products. Find out more about mapping WooCommerce and Omni products.
And finally, an unmapped, unmappable product only exists in WooCommerce – these are your new products. When you download products from WooCommerce, a matching Omni product is created for each new product. A mapping between the WooCommerce and Omni versions is created too, so their sales, stock levels, and other details keep in sync.
If you create new products in Omni, upload products to WooCommerce instead.
Download products
Before downloading products from WooCommerce:
Confirm each product has an SKU (or, if it’s a variable product, that each variation has an SKU) and that its Status is Published.
Review how WooCommerce products with and without variations are downloaded (see below).
Keep in mind that what WooCommerce calls variations Omni calls product options, and while WooCommerce products may have no variations, Omni products always have at least one option (the default option).
Now download products from WooCommerce:
Log in to Cin7 Omni.
From the Integrations menu in the navigation, open your WooCommerce integration.
Select Download Products on the Product Status tile.
Open the Download Products tab.
Select Import Products Created Since Last Import.
-
You’ll be shown the total number of WooCommerce products that are either:
Unmapped and mappable, for which Omni will create mappings, or
Unmapped and unmappable, for which Omni will create matching products and mappings.
-
Select Next, which takes you to the Products Not Matched tab, where you’ll be shown a summary (note that, at this stage, mappings have been created for any unmapped, mappable product):
New Products is the number of new (that is, unmapped and unmappable) WooCommerce products, for which Omni will create matching products and mappings.
New Product Options is the number of variations across the new (that is, unmapped and unmappable) WooCommerce products, for which Omni will create matching product options and mappings.
Existing Price Options Linked is the number of unmapped and mappable WooCommerce products, for which Omni has created mappings (find out more about mapping products).
Review the summary and sample. Then select Next. You’ll be taken to the Custom Mappings tab.
You don’t want to create custom mappings, so select Next (find out more about creating custom mappings). You’ll be taken to the Products to Import tab.
Optionally, if you want to download only a subset of new WooCommerce products, select Download Products to Import. A spreadsheet will download. Remove from the spreadsheet the rows of products you don’t want to download. Then, in Omni, select Choose File and upload the edited spreadsheet.
Select Next. You’ll be taken to the Create New Products Tab.
Select Import New Products.
If the products you’ve downloaded were assigned to unmapped WooCommerce product categories, you’ll be asked to map those product categories to new or existing Omni product Categories:
To map to a new Category, choose Create New Category: … and then Import New Categories.
To map to an existing Category, choose the Category and then Import New Categories.
To not create a mapping (that is, to not categorize the downloaded products), select Back to Dashboard.
You’ve finished downloading your new WooCommerce products. Now, how each product was downloaded depends on whether it has variations (that is, whether it’s a simple product or variable product). Here’s how WooCommerce products with and without variations are downloaded:
Products without variations (simple products)
Omni products always have at least one option (the default option).
When you download a WooCommerce simple product (that is, one without variations), Omni creates a product with only the default option. The WooCommerce product’s details are downloaded to the Omni product (and default option) as follows:
WooCommerce product |
Cin7 Omni product (and default option) |
Product Name |
Product Name |
Product Description |
Description (only shown if Show Website Options is enabled in your product settings) |
Regular Price |
Retail |
Sale Price |
Special$ |
SKU |
Style Code (of product) and Code (of default option) |
Weight |
Weight (of default option) |
Product Category |
Category |
Tags |
Tags (is only shown if Show Website Options is enabled in your product settings) |
Products with variations (variable products)
When you download a WooCommerce variable product (that is, one with variations), Omni creates a new product with an option for each variation.
In order to create the Omni product options, the Names of the WooCommerce product’s attributes become the Option Labels of the Omni product, and the Values of the WooCommerce product’s attributes become the values of the corresponding Option Label of the Omni product.
The details of the WooCommerce product and its variations are downloaded to the Omni product and its options as follows:
WooCommerce product |
WooCommerce product variation |
Cin7 Omni product |
Cin7 Omni product option |
Product Name |
|
Product Name |
|
Product Description |
|
Description (only shown if Show Website Options is enabled in your product settings) |
|
Product Category |
|
Category |
|
Tags |
|
Tags (is only shown if Show Website Options is enabled in your product settings) |
|
SKU |
|
Style Code |
|
|
Regular Price |
|
Retail |
|
Sale Price |
|
$Special |
|
SKU |
|
Code |
|
Weight |
|
Weight |
Download new variations
If you create new variations of a WooCommerce product that’s already mapped to an Omni product, you must delete the product's mappings and redownload the product and its variations:
Log in to Cin7 Omni.
From the Integrations menu in the navigation, select your WooCommerce integration.
On the Product Status tile of your WooCommerce integration’s dashboard, select View Mapped Products. You’ll see a list of your product mappings.
Delete the product’s current mappings – don’t select Delete All, which would delete all mappings.
Now download the product again (see above) – when you download the product, the old mappings will be recreated at step 7, and the new variations will be downloaded and mapped at step 12.