Export product fields (variations)

  • kkwebdesign

    (@kkwebdesign)


    3 years ago

    I own the plugin Advanced Product Fields for WooCommerce and I am looking for a plugin which will export orders by their Product Fields (parent). For example:
    I receive a new order and its variations are (color = blue, color fish = red) and I want to have in final export csv that things -> Only VARIATIONS (not products and their variations) with blue color in one CSV and only variations with red color in the second csv. I know how to display only variations for example with red color but I need to have in csv only variations that matches with one color not the full product variations.

    Here are the screens:

    https://prnt.sc/1zx3r20 <- single product page (variations)
    https://prnt.sc/1zx3vdj <- that is what final .csv file should look like

    Is this possible to achieve with some code or nah? Thanks for you help.

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

    (@algolplus)

    hello

    final .csv file — was it built based on ONE order ?
    or is it merged attributes from MANY orders?

    Thread Starter kkwebdesign

    (@kkwebdesign)

    From many orders. Because these components (variations of product) are going to be crafted. Thank you.

    Plugin Author algol.plus

    (@algolplus)

    I can only suggest to hire programmer , I don’t see ready solution ??

    even if you add all attributes as columns to export — it will require extra programming.

    Thread Starter kkwebdesign

    (@kkwebdesign)

    What do you mean by adding all attributes as columns to export?

    Plugin Author algol.plus

    (@algolplus)

    I meant , separate columns as Barva|Motyl|…|Slon

    Plugin Author algol.plus

    (@algolplus)

    so if you have all necessary values in these columns – you can rebuild Excel file (add one sheet per color and put variations as rows to these sheets).

    phpExcel allows it, just use hook “woe_xls_print_footer”.
    some examples https://docs.algolplus.com/algol_order_export/format-output/

    Thread Starter kkwebdesign

    (@kkwebdesign)

    Thank you for your reply. Have you got some tutorials or documentation on how to separate columns? Thanks!

    Plugin Author algol.plus

    (@algolplus)

    just use >Setup Fields>Product Order Items>Add Field

    Thread Starter kkwebdesign

    (@kkwebdesign)

    Thank you. And for the required extra programming – you meant the phpExcel hook “woe_xls_print_footer”? Or it will require more programming?

    Plugin Author algol.plus

    (@algolplus)

    “woe_xls_print_footer” is our hook.
    It starts before we send generated XLS to browser.

    And you must use PHPExcel functions to read and modify exported file.

    • This reply was modified 3 years ago by algol.plus.
    Thread Starter kkwebdesign

    (@kkwebdesign)

    Thank you and can you tell me how to get in to PHPExcel to modify that?

    Plugin Author algol.plus

    (@algolplus)

    https://github.com/PHPOffice/PHPExcel/tree/1.8/Documentation

    I’m sorry, I can’t help you more.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Export product fields (variations)’ is closed to new replies.