An attribute defines the additional data related to a product. Product attributes are characteristics that include size, color and other features that make it distinct from other products. The WebToffee plugin, Product Import Export for WooCommerce helps import the WooCommerce products with attributes. From a consumer perspective, these attributes may even influence the ultimate purchase decision in the increasingly crowded e-commerce marketplace. Based on the defined product attributes, the store owners can create variable products.
Two types of product attributes in WooCommerce are:
- Global attributes: In a store, any product can use the global attributes and its respective terms. As created in the Attributes section of WooCommerce settings, global attributes are defined globally.
- Local attributes: We could apply local attributes only to a particular product and are custom attributes. They are created in the Attributes section of the respective product data meta-box.
Mandatory: The exported CSV should contain attributes that can be configured in the WooCommerce Product page, as shown in the screenshot below:
Let us say you have a CSV file with a product containing attributes ‘Size’ and ‘Color’. Here, the attributes with the prefix “pa_” are global attributes.
The pipe symbol “|” is used to add multiple attributes.
Value of attribute data is given in the format: position | visible | variation.
- position: Defines the position of the attribute in the front-end.NOTE: Existing attribute will be moved down if you set a lower position value for the new attribute. Attributes with a low position value will be placed at the top and attribute with a bigger position value will be placed last.
- visible: Displays 1, if the attribute is visible at the front end. Else, displays 0.
- variation: Displays 1, If the attribute is used for variation. Else, displays 0.
Note: Download Sample CSV of Import Attributes.
Importing products with attributes
As a first step, install and activate the product import export plugin. Click on WebToffee Import Export (Pro) > Import menu from the WordPress admin panel.
- Select Products under post type.
- Select an import method: One can choose among: Quick import, Pre-saved template and Advanced import .
- Map import columns: To map import columns. Here, you can map the commercial names to WooCommerce columns. Use Evaluation Field to fix/update the required value for a particular field.
- Advanced Options/Batch Import: Provides advanced options to import and scheduling import.
Click on Import to import the WooCommerce products with attributes.
Finally, head on to Products from WordPress dashboard to view the imported products as shown below:
To view its attributes, move to the Attributes section in the respective product page.
Here is the view of the attributes in the product page.
To check Global attributes, go to Products > Attributes.
Know more about import and export of products.