Using Bulk Import to reset variable default attribute to blank

  • Resolved tomcarmichael2

    (@tomcarmichael2)


    5 years, 4 months ago

    Hi,

    Is there a way to use the bulk import to reset the ‘Attribute 1 default’ back to blank for all product?

    Most of our products have two attribute types, colour and size. We uploaded our products with a default for each, but this doesn’t look very good, each product shows the customer the default image for one second and then starts loading the image of the default colour instead of letting the customer their chosen colour, for a couple of seconds.

    I’m thinking it would be better if we could bulk update all products to keep their default size, but remove their default colour, so that the customer would only have the primary image on opening the page, but because a size is already selected, as soon as they just click a colour, the image changes to the colour they picked.

    I have tried doing a test import with just two columns for one SKU:

    Column 1: SKU
    Column 2: Attribute 1 default

    I have tried putting “0”, ” “, “No default colour…” (like shown on the product page), and leaving it blank. But nothing has updated the product to reset its default colour.

    Does anybody know how to do this? Have 100 products uploaded so far, and don’t want to change them all manually…

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 4 months ago

    Hi there,

    The built-in CSV import functionality should work for resetting the product to have no default selected. Please note, the default is set on the parent Variable product itself, not individual variations, so you will need to set the “blank” Attribute 1 default value on the parent product.

    I exported a variable product from my site, and saw the default options listed in the CSV:

    attributes
    Link to image: https://d.pr/i/1oJ0AT

    I clicked in the Attribute 1 default column and deleted the Blue value (just leaving it completely blank — no 0, no ). After that, I ran the import with the option to update existing products selected, and saw that the product was updated to have no default Color:

    product
    Link to image: https://d.pr/i/nXCHY8

    So it is definitely possible!

    Please make sure you are following all other guidelines for importing:
    https://docs.woocommerce.com/document/product-csv-importer-exporter/

    And make sure the rest of your CSV matches the schema defined here:
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    Plugin Support abwaita a11n

    (@abwaita)

    5 years, 4 months ago

    Hi @tomcarmichael2,

    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.

    Thanks.

    Thread Starter tomcarmichael2

    (@tomcarmichael2)

    5 years, 3 months ago

    Hi,

    I was trying to do this again, I think my problem was that I tried it before with only two columns in the csv.

    So I was going to upload all columns but I noticed excel had reformatted some of my product sizes to dates, so I thought I would just delete those columns to prevent errors and and upload it without some columns, thinking it would only update the columns which match and leave the others as they are.

    We have 150 products with 2 attributes each, by bulk updating all products with a csv which only had columns and data for 1 attribute, all 150 products now only have 1 attribute, the data for the other attribute seems to be gone, I can’t see them in the settings for each product.

    Is there a way to completely undo the update?

    Thanks,
    Tom

    Thread Starter tomcarmichael2

    (@tomcarmichael2)

    5 years, 3 months ago

    Assuming this is the along the lines of how it would be done: I can probably get the product data again from yesterday’s website backup, but I need some guidance on how to access it and what to do with it please.

    I can’t roll the whole website back to last night’s update as there was plenty of other non-woocommerce related work done on it today.

    Thanks,
    Tom

    Thread Starter tomcarmichael2

    (@tomcarmichael2)

    5 years, 3 months ago

    Started a new topic which was replied to and resolved here https://wordpress.org/support/topic/undo-bulk-import/

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

The topic ‘Using Bulk Import to reset variable default attribute to blank’ is closed to new replies.