Properties for creating/updating products importing a csv on Woocommerce

  • Resolved mktjrfalcao

    (@mktjrfalcao)


    2 years ago

    Woocommerce has an option to import a csv to update/create products. On the csv structure, each column header reffers to one property of the product. So the collumn named “Regular price” maps to the property “regular_price” and updates the product price with the value on the csv file.
    I use this method for creating/updating my products since there are many.

    My question is: I want to use my csv file to create/update products with its quantities and step control filled out. Is it possible? Wich properties/property names i have to use?

    Here is an example of what i’m talking about: https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hannan

    (@phpcoderhannan)

    2 years ago

    Hello mktjrfalcao,

    Yes, Its is possible but when you will going to export your product then you need to select this option ( https://prnt.sc/8qPP7fgxjMwD ). otherwise, it will not work.

    Regards,
    Hannan

    Thread Starter mktjrfalcao

    (@mktjrfalcao)

    2 years ago

    Hello Hannan,

    It worked, thank you.

    Just to maybe help someone in the future, in order to update the values with the csv file, the collumn headers should be:

    meta:default_quantity
    meta:max_quantity
    meta:min_quantity
    meta:product_step

    The “meta:” prefix informs the importer that this is metadata. It must be included before the id of the property of any custom fields you want to update with the csv.

    In order to see this collumns when exporting the products, you have to check the option as you’ve shown.

    Thank you for your answer and for this plugin. It is just what i was looking for.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Properties for creating/updating products importing a csv on Woocommerce’ is closed to new replies.