Home Forums Plugins Store Exporter Deluxe [Resolved] Exporting WooCommerce Product Add-On fields on an Order Export

This topic contains 3 replies, has 2 voices, and was last updated by  Michael Visser 11 months ago.

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 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #45262

    David
    Participant

    I’m exporting order information from our shop. I’m getting most of the data, but there is one whose contents are not always being shown in the .csv file.
    For example, we have a product that has a product radio button add-on called Lunch. The add-on item is not required input. This add-on adds $5 to the price of the item. The base item costs $50.
    I see several orders that have the item at a cost of $55. When I hover over the tiny ? on the Orders page under WooCommerce I see “Lunch ($5.00): Yes”.
    I tried adding Lunch to both the Order Meta and Order Items Meta. There are actually 3 columns in the .csv file that say lunch. 2 with the heading “Order Items: Lunch”, and 1 with the heading of “Lunch”.
    The 1st column “Order Items: Lunch” has some records with a No in them, but none with a Yes. The other 2 columns are empty for all records.
    What could I be doing wrong?

    #45272

    Michael Visser
    Keymaster

    Hi David, thanks for getting in touch. You’ve stumbled on the most frustrating bit of WooCommerce Product Add-ons but there is a simple fix. 🙂

    Within the Custom Order Fields dialog on the WooCommerce > Store Export > Quick Export screen clear the Order meta and Custom Meta text boxes and enter “Lunch” within the Custom Product Add-ons textbox. It’s under the Orders export type in 2.2+ but back in 2.1 and before it was found under the Products export type. Hit Save Custom Fields, select the “Product Add-ons: Lunch” export field and hit Export.

    Background: WooCommerce Product Add-ons stores the Price symbol and value (e.g. ‘Lunch ($5.00)’ ) within the Post meta key which makes it a PITA to query as we (Store Exporter Deluxe) don’t know whether Lunch is $5.00 or €10.00 or ¥500, and the name has to be matching to return a result.

    #45273

    David
    Participant

    Thanks! That was fairly simple and it worked.
    I have some other add-on fields that weren’t showing up either. I assume the same procedure will correct them as well.

    #45279

    Michael Visser
    Keymaster

    Spot on David, if you need further assistance please open a Support ticket and we can get it looked at 🙂

    https://www.visser.com.au/premium-support/

Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘[Resolved] Exporting WooCommerce Product Add-On fields on an Order Export’ is closed to new replies.