Product import from csv “invalid product”

  • Resolved robbymoors

    (@robbymoors)


    3 years, 6 months ago

    Hi,

    I just made a .csv to import some products.

    First import works fine. Every product is imported with al the data needed.

    Then when we change the original csv. Let’s say the description of a product. And try to do a new import “with override existing products” option checked. We got errors an all products. Saying “invalid product”

    Does anyone has some experience with this?

    I would love to get this to work. The import works so nice.

    Thanks in advance,

    Robby

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Shaun Kuschel a11n

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey @robbymoors,

    Glad to hear that the initial import worked as expected! When importing changes to existing products, is the full error message just “invalid product”? Or does it mention one of the fields specifically as well, like “Invalid Product Type”?

    If you can provide a screenshot of the error message or copy paste what shows in the logs, that would be super helpful. Thanks!

    Thread Starter robbymoors

    (@robbymoors)

    Hi,

    Thanks for the fast reply.

    Here the screenshot:

    https://robbio.be/wp-content/uploads/2021/05/fail.jpg

    Kind regards,

    Robby

    Plugin Support Shaun Kuschel a11n

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey Robby,

    Based on the screenshot, it looks like CSV file itself may not be formatted correctly- like it has merged the rows into single cells, instead of keeping everything separate. For example:

    https://d.pr/i/b2dZsB

    The CSV file should look like this example, where each column contains only the data specific to it:

    https://d.pr/i/rMlMUF

    I would suggest exporting the product data again and then saving a copy of that CSV file that you can edit- but leave the columns as they were exported (so the importer will know which column the data is related to).

    Plugin Support Shaun Kuschel a11n

    (@shaunkuschel)

    Automattic Happiness Engineer

    Hey Robby,

    Since we haven’t heard anything in a while, I’m going to close out this thread but if the info provided above doesn’t help, feel free to create a new post. Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Product import from csv “invalid product”’ is closed to new replies.