Import CSV file to update stock

  • Resolved antoninveinstein

    (@antoninveinstein)


    4 years, 10 months ago

    Hello, I have a CSV file that has the updated stocks. I would like to import this CSV file to update all the products in my shop at once.

    But when I import my file, Woocommerce does not detect my file well.
    It can’t find “Name” and “In stock?” correctly.

    Here is an example of one of my lines:
    “New York, black sofa, 90 cm”,1

    What is in the “” is the name of the product and the number 1 is the stock availability.

    When I import the list, Woocommerce only detects one data when there are 2 (“stock?” and “product name”).

    Can anyone help me?
    Was my question clear enough?

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • MayKato

    (@maykato)

    4 years, 10 months ago

    Hello,

    If you are using the built-in product importer, please make sure to use the correct format. You can download a sample CSV file here (https://github.com/woocommerce/woocommerce/tree/master/sample-data).

    OR the easiest way would be to export some existing products, replace the values, and import back into your store. – that way you’ll have a CSV with the correct formatting to use as a template.

    To learn more about the product importer exporter, please visit this page: https://docs.woocommerce.com/document/product-csv-importer-exporter/

    Thread Starter antoninveinstein

    (@antoninveinstein)

    4 years, 10 months ago

    Thank you for your quick reply.

    This is what I had done unfortunately there are “,” in the titles of my products, which separates the values. This means that when I export all my products and then change the values and want to re-import everything, it doesn’t work.

    That’s why in my file I had tried to put “” to separate the product name and the stock availability.

    Do you see what I mean?
    Do you have a solution for this?

    Thank you once again,

    Antonin

    Plugin Support Sol J. a11n

    (@solstudioim)

    4 years, 10 months ago

    Hi there @antoninveinstein

    Thanks for your clarification.

    This is what I had done unfortunately there are “,” in the titles of my products, which separates the values. This means that when I export all my products and then change the values and want to re-import everything, it doesn’t work.

    That’s why in my file I had tried to put “” to separate the product name and the stock availability.

    I would suggest that you export all the products again into CSV file and download it.

    And then please upload it to Google spreadsheet, select the option to “detect” automatically the format.

    According to my experience, Google is perfect in handling CSV files correctly.

    You should be able to update the stock there and then download it back as CSV and try to upload it to your store.

    I’d suggest creating a staging site as well or a separate test site if you want to test it.

    I hope that helps!

    MayKato

    (@maykato)

    4 years, 9 months ago

    Hi @antoninveinstein

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic.

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

The topic ‘Import CSV file to update stock’ is closed to new replies.