Support » Plugin: Advanced Order Export For WooCommerce » How to export product attributes to be usable in Excel?

  • Resolved gore.m

    (@gorem)


    Hello,
    I need export product attributes (custom products attributes) as countable list (Excel). But plugin outputs all attributes as data dump and in one cell:

    {"chryzantema-bila-kopretina":{"name":"Chryzant\u00e9ma b\u00edl\u00e1 kopretina","value":"10","position":2,"is_visible":0,"is_variation":0,"is_taxonomy":0},"germina-cervena-cerny-stred":{"name":"Germina \u010derven\u00e1 \u010dern\u00fd st\u0159ed","value":"30","position":3,"is_visible":0,"is_variation":0,"is_taxonomy":0},"pistacia":{"name":"Pistacia","value":"5","position":4,"is_visible":0,"is_variation":0,"is_taxonomy":0}}

    1) Is it possible to have each attribute/value on own row/cell?
    2) Is it possible to output it with UTF8, without additional data dump?

    Thanks you

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author algol.plus

    (@algolplus)

    Hello

    everything is possible 😉

    what plugin do you use to add these 3 attributes?
    thanks ,Alex

    Thanks you – it would be cool!
    It is not extra plugin, it is Woocommerce > Product > Attribute > Add: Custom product attribute (I added 3 custom attributes).

    ——–
    Little more explanation:
    We are flower shop, every bouquet/product is made from an number of flowers, we would like to print list of all flowers we need for selected array of orders.
    So I thought, that the best idea is set custom product attributes (hide it on front end) and than export orders with products attributes. Or is there better way?

    Thanks you

    • This reply was modified 1 year, 5 months ago by gore.m.
    Plugin Author algol.plus

    (@algolplus)

    Hello

    If bouquet has 3 chryzantemas – how will you set qty for attribute ?

    Please, upload sample Excel to helpdesk.

    thanks, Alex

    Thanks you.
    I submited new ticket with attachment on your helpdesk.
    I just went to Woocommerce > Product > Attribute > Add: Custom product attribute and than set Value(s): to number, so for example:
    “name”:”Chryzant\u00e9ma b\u00edl\u00e1 kopretina“,”value”:”10″

    Plugin Author algol.plus

    (@algolplus)

    thank you , I’ve replied.

    Hello,
    I am having the same issue.
    I have gone into “Setup fields to export”
    Then into “Products”
    Then “Setup Fields to Export”
    Then from the dropdown “product fields”, I have selected “_product_attributes”
    Have pressed add field.
    Then saved

    I get this as the output:
    {"section":{"name":"Section","value":"06","position":0,"is_visible":0,"is_variation":0,"is_taxonomy":0},"class":{"name":"Class","value":"1","position":1,"is_visible":0,"is_variation":0,"is_taxonomy":0}}

    I have two attributes:
    Section
    Class
    and i would like to have them in a column each showing the value. Is this possible?

    Thank you for your time.

    please disregard, I found another post which helped step by step here.
    https://wordpress.org/support/topic/i-dont-know-how-to-export-a-custom-attribute-of-a-simple-product/
    And I was sucessful.
    Thank you very much for this great plugin! 🙂

    Plugin Author algol.plus

    (@algolplus)

    I’m a bit late. thank you for the feedback.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘How to export product attributes to be usable in Excel?’ is closed to new replies.