WooCommerce products can be exported along with their local and global attributes using the Product Import Export Plugin for WooCommerce. Attributes are exported in separate columns in the output file.
Let us understand this procedure with an example. Suppose you have two products in your WooCommerce store.
- Variable product: Men’s Cotton T-Shirt
- Simple product: Samsung Galaxy Ace Duos
Simple Product
Simple product with attributes in the product edit page is as shown:
Website view of the simple product with attributes is shown below:
Variable Product
Variable product with attributes in the product edit page is as shown:
Website view of the variable product with attributes is shown below:
Steps to export products with attributes
From the WordPress admin panel, navigate to the menu: WebToffee Import Export (Pro).
- Click on Export and specify the post type as Product.
- In step 2, you can choose the required export method.
- In step 3, filter the data to be exported.
- On reaching step 4, map and reorder the export columns. Expand Attributes to view the mapped attributes.
- Click on Step 5 to finish the export.
For a detailed export process documentation, refer: How to export products.
Click to download the Sample CSV.
Comments (2)
Henrik
May 13, 2024
Hello there,
When exporting product attributes, global attributes contain values like 6|1|0 in the attribute_data: column
What does these values mean?
Can I leave this field blank and just fill attribute: column?
I want to bulk update product attributes
Looking forward to your reply
BR, Henrik
Hema
May 15, 2024
Hello Henrik,
Thanks for reaching out. The global attribute contains the metadata about the attribute.
Display order | Visible or not | Used for variation.
This type of values can be observed in variable products. Kindly go through this article to know more about the metadata.
This field when left blank may affect the variable product.