csv data format export

  • Resolved pavlosp

    (@pavlosp)


    4 years, 10 months ago

    Hello, i have a file that has the below export format, each row contains multiple data from the same product. Until now i only used csv data that every row contains data from one product only in several columns. Is there an option to manage this format or a way to convert rows to columns?

    View post on imgur.com

    sku decription attribute-id attribute-value
    000003 ΜΡ C2050 ATTRIBUTE_1 laser
    000003 ΜΡ C2050 ATTRIBUTE_2 color
    000003 ΜΡ C2050 ATTRIBUTE_3 tray-1
    000004 MP 5500 ATTRIBUTE_1 inject
    000004 MP 5500 ATTRIBUTE_2 mono
    000004 MP 5500 ATTRIBUTE_3 tray-1
    000005 MP 6500 ATTRIBUTE_1 dot matrix
    000005 MP 6500 ATTRIBUTE_2 color
    000005 MP 6500 ATTRIBUTE_3 tray-2

    • This topic was modified 4 years, 10 months ago by pavlosp.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WP All Import

    (@wpallimport)

    Hi @pavlosp

    Is there an option to manage this format or a way to convert rows to columns?

    Do you just need to add the attributes from each row to a product in WooCommerce? If so, you can use the “Don’t touch existing Attributes, add new Attributes” option in the Import Settings: https://d.pr/i/4wkQSy.

    If I misunderstood, can you please elaborate on exactly what you want to happen with the imported data and where you’re importing it (what post type, for example)?

    Thread Starter pavlosp

    (@pavlosp)

    yes, that is the case i want to add each attribute from row to the same product.

    Plugin Author WP All Import

    (@wpallimport)

    Hi @pavlosp

    Thanks for clarifying. In that case, the setting from my screenshot is exactly what you’ll need to use.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘csv data format export’ is closed to new replies.

Tags