Duplicate SKUs with several different import templates

  • Resolved Sobolle

    (@sobolle)


    1 year, 5 months ago

    I have two import templates.
    One is for updating products that have changed in half an hour. It only for changed, disappeared or appeared products.

    The second template is to update all products every week.
    It contains all the products, including those that have not changed.

    The total number of goods is 50,000.
    Uniqueness in all templates is set by SKU.
    Both templates are the same, except the settings.

    Weekly:
    Skip Woocommerce products if their data in this import file has not changed
    Remove or modify Woocommerce products that are not present in this import file

    Half hour:
    Skip Woocommerce products if their data in this import file has not changed – is OFF
    Remove or modify WooCommerce products that are not present in this import file – is OFF

    But when I created a half an hour template, Woocommerce update starts creating new products instead of updating existing products. Woocommerce creates a product with the same SKUs.

    How I can avoid this?
    Or how can I force Woocommerce to update the product if it already exists, instead of creating a duplicate?


Viewing 1 replies (of 1 total)

  • Hi,

    how can I force Woocommerce to update the product if it already exists, instead of creating a duplicate?

    To update products via CSV when using the WooCommerce Product CSV Importer and Exporter, follow the steps below:

    1. Export your existing products: First, you need to have a CSV file that contains the products you want to update. You can either create a new CSV or export your existing products by going to WooCommerce > Products, and then clicking the Export button at the top. During the export, choose the columns you want to include and set “Export all columns” to “Yes” if you want all product data to be included in the CSV file. Click the Generate CSV button to create the file.

    2. Update the CSV file: Open the CSV file using spreadsheet software like Microsoft Excel or Google Sheets. Update the required product data that you need to modify (e.g., product title, price, stock status, or other product attributes). Make sure not to change the “ID” or “SKU” column, as these are used to identify the products during the update process. Do not change the header row. Save your changes as a new CSV file.

    3. Import the updated CSV file: Go back to your WordPress dashboard, then go to WooCommerce > Products, and click the Import button at the top. In the “Choose a CSV file” section, click on Choose File and select the updated CSV file from your computer. Click Continue to proceed with the import.

    4. Map CSV fields to products: WooCommerce will automatically attempt to match the CSV columns with product fields. Verify if the column mappings are correct, especially for the ID or SKU field.

    5. Update existing products: Before starting the import, ensure that the “Update existing products” checkbox is checked. WooCommerce will tell you how many products were updated when the process ends.

    If the above does not work, I’d like to reproduce the same behavior on my end, can you provide the CSV file you are using to update the products? You can leave it with only 1 product it is not necessary to send it all. That way I can execute the file on my end to see how that goes, then provide you with assistance. You can provide the URL to the file via Google Suite.

    Looking forward to hearing from you.

Viewing 1 replies (of 1 total)
  • The topic ‘Duplicate SKUs with several different import templates’ is closed to new replies.