Woocommerce Import Doesn’t Update Products by SKU

  • Resolved maipiusenza

    (@maipiusenza)


    3 years ago

    I have a very simple CSV with two columns:
    SKU,quanity

    The products are variable products.

    As I run the import with the check on “update existing products”, I get an error saying that the process has been skipped as no product has been found.

    If I run the import without the check, it creates a new product with the same sku of the variation I need to update.

    The variation SKU is correct, I cam export it from WC, import again, and get the same skip warning.
    There are no special characters, just digits, numbers and dashes.

    If I search for that sku in wp_postmeta table, it exists.

    The same identical CSV works correctly in other sites with the same products configurations.

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

  • Hello there,

    So sorry to hear about what happened.

    As a reference, you can check this article regarding the structure of the CSV to import products.

    I am assuming the header is called “stock” in your file instead of quantity. Is this correct?
    CSVField
    Link to image: https://snipboard.io/eb2j4l.jpg

    Please upload a screenshot of the file you are using so that we can take a look.

    You can use https://snipboard.io – please follow the instructions on that page, then paste the URL in this thread.

    Thanks.

    Thread Starter maipiusenza

    (@maipiusenza)

    The two columns names are
    COD,Magazzino

    It is an Italian version of the site and the two columns corresponds to SKU and Stock

    They are correct, I use them on other twin sites and they work fine.
    Moreover, as said, I can export the same columns, import them again and I get the error.

    https://snipboard.io/VB2CmQ.jpg

    File sample: https://snipboard.io/wKHtFB.jpg

    I already tried to:
    – use quotation marks or quotes for the fields
    – save the file with different encodings

    Moreover, at the second step of import, the file is correctly read as it shows the sample content:
    https://snipboard.io/OVvLfK.jpg

    I tried to run a safe mode with only woocommerce active.. same problem

    Thanks

    • This reply was modified 2 years, 12 months ago by maipiusenza.
    Mirko P.

    (@rainfallnixfig)

    Hi @maipiusenza,

    Thanks for sharing more details.

    If you’re using the default Product CSV Importer and Exporter you’d need to follow the Product CSV Import Schema as pointed out earlier by @ihereira.

    CSV column names COD and Magazzino do not exist on the Import Schema:

    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    The changes you made may work for some reasons but are not recommended and we can’t provide support for this type of customization.

    You may want to consider other import/export tools like Product CSV Import Suite or WP All Import that have more features than the default built-in tool.

    Thanks.

    Thread Starter maipiusenza

    (@maipiusenza)

    In Italian they don’t exist in the select:
    https://snipboard.io/rxlLzY.jpg

    The strange thing is that now, with no upgrade of anything, it started working again as it did before, both using COD,Magazzino or SKU,Stock (in the second case, as you see in the image, it associates it to the columns COD,Magazzino)

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    Thanks for letting us know that it started working again.

    Since the thread is closed, I’d recommend creating a new topic if you have any further questions.

    Cheers.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Woocommerce Import Doesn’t Update Products by SKU’ is closed to new replies.