Home Forums Plugins Store Exporter Deluxe [Resolved] Orders Export. Multiple Variations?

Welcome to our community support forums! We're here to help - but if you have an urgent request for a Pro Plugin, you will get a prioritised response through our Premium Support page.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #43036

    Hello. Love the plugin! One thing we can’t quite figure out when we export orders though.

    We sell clothing and often times there are multiple attribute variation options per product. For example, we offer the same tee shirt design on Color variation Blue or Green and in Size variation Small-XL. When we export orders it only populates info for the Size variation. It would be great if we could see each variation in its own column. This would help us see/sort the total items ordered in each Color & Size. The WooCommerce order retains the complete variation selections when we look at the order.

    Any suggestions?

    Thanks for your time.

    Michael Visser

    Hi mintprintworks, thanks for asking! What you have in your WooCommerce store are two types of Variations; Global Variations and per-Product Variations which are assigned to Products.

    Global Variations are managed by the Products > Attributes screen which we can automatically detect as they are saved as Term Taxonomies which we can show as export fields. In your case this is the Size Attribute.

    Per-Product Variations are managed on the individual Edit Product screen for each Product and cannot be automatically detected as we would need to scan all the Products to generate this list (it’s on the todo list). This is the Color Attribute in your case. So what you need to do is:

    1. open WooCommerce > Store Export
    2. switch to the Manual Export tab
    3. select the Products export type
    4. scroll down to Custom Product Fields
    5. in the field Custom attribute enter the name of the per-Product Attribute in lowercase, replacing spaces with – (dashes):



    would be entered as


    6. Click Save Custom Fields

    That’s it!

    Select the new export field from the Orders export type and you’re good to go. You may need to run a few Product exports to ensure you’ve set the correct custom Attribute name for harder Attribute names (e.g. Box Size becomes box-size, etc.) 🙂

    (Let me know how you go)

Viewing 2 posts - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] Orders Export. Multiple Variations?’ is closed to new replies.