How to Export Variations From your WooCommerce Store Using a Free Plugin
In this article, we will show you how to export Orders from your WooCommerce store along with the variation data associated with them
WooCommerce has a great feature for products that allows you to create different ‘variations’ of the product. For example, if you sell T-shirts, your T-shirts will likely come in different sizes and colors. WooCommerce makes it extremely easy for you to set up your store and deal with the numerous different variations.
Getting variation data out of WooCommerce can be a struggle! Fortunately though, by using our free plugin, you are able to do just that – you can get our free plugin here: https://wordpress.org/plugins/order-export-and-more-for-woocommerce/
This plugin mainly enables you to export your orders from your WooCommerce store. While each store is unique and has its own individual needs, the plugin is flexible to cater for your store needs.
If you would like to see a video of this plugin in action please go here: https://www.youtube.com/watch?v=BwfsWdueqMA
In this article, we will run through setting up products in WooCommerce along with the variation data and then exporting the data out.
1. Adding the New Product "T-Shirts"
1.1 Click Products > Add New on the left navigation pane.
1.2. On the Add new product screen, type the product name as T-Shirts.
2. Adding Attributes and Variations to the Product
2.1. After adding the product name, scroll down and select the Product data as Variable product as shown in the following screen.
2.2. Click Attributes and click Add (as highlighted in the following screen) to create some attributes to the product.
In this instance, let us create Size and Color as the two attributes for the product T-Shirt (one at a time).
2.3. Type the Name for the attribute as Size and its Value(s) as Small | Medium | Large | X-Large. Select the option Used for variations and click Save attributes.
2.4. Similarly, create the attribute Color and its Value(s) as Black | White | Blue | Red. Select the option Used for variations and click Save attributes.
2.5. Click Variations.
2.6. From the drop-down menu, select Create variations from all attributes and click Go .
A warning is displayed asking you to confirm you want to proceed.
2.7. Click OK. A message is displayed stating how many variations were added. In this case, it is 16.
2.8. Now we need to add the price to each variation. This is easy! Click the drop-down box and select Set regular prices (as highlighted in the following screen) and enter your price (say $9.99).
2.9. Click Publish.
3. Exporting Product Variation Data From WooCommerce
At this point, go ahead and make sure you have some orders that include different variations of the product you have just set up. Now we can go ahead and export the data.
3.1. Click WooCommerce > Order Export + Pro. The WooCommerce Order Export and More screen appears.
3.2. Click and expand FIELDS TO EXPORT.
3.3. On the right pane, choose Line Items. The LINE ITEM META DATA drop-down menu now displays the attributes Color and Size.
3.4. Select them one at a time and click ADD FIELD to add them on to the left pane.
3.5. Drag and drop ALL LINE META DATA from the bottom of the right pane (highlighted in the following screen). The attributes Size, Color and All Line Metadata is now displayed on the left pane.
3.6. Click Preview to view data at the bottom of the screen in a tabular form. Each row will have the attributes Color, Size and All Line Metadata.
Note: You can drag and drop more fields from the right pane to the left pane to include them in your export results.
3.7. Click Export.
Data pertaining to the added fields (on the left pane) is quickly exported to a spreadsheet.
You can see that you are able to export each variation attribute in its own column. In addition, the plugin has a special field called All Line Metadata that allows you to export ALL variation fields in ONE column. It can be very useful for packing exports and similar needs.
We hope this article shows you how easy it is to export variation data from WooCommerce. If you would like to see a video demonstration, please go here: https://www.youtube.com/watch?v=BwfsWdueqMA