Import Yes/No from CSV Not Working

[metalmattlee11]

THis should be an easy one, but it's apparently not. I'm simply trying to import a Yes/No custom attribute from a CSV file.

The custom attribute is - let's call it upgrade_eligible - where the type is set to Yes/No on the attribute screen. I've tried Yes and No as values, 1 and 0, 'Yes' and 'No' and other examples, but it's not picking up. 

I've also tried setting the attribute type as Dropdown and had "yes" and "no" choices. Neither has worked. Same with MultiSelect,

If I go into the product and manually set the upgrade_eligible to Yes, it shows in the exported csv properly.

What is the trick to getting a Boolean value to be imported correctly through a CSV import, please? As long as it's some type of Boolean field, and I can import, and use it to select that group of products on front-end, and back-end screens, and use it for promos and cart rules, I'm good.

[happymoodhb66e]

Hey — I ran into the same issue with a Boolean attribute. What worked for me:

• Export a sample row where your upgrade_eligible is set to Yes via the admin.
• In your CSV use exactly the same value (case and language) – e.g. “Yes” (not 1 or “yes”) if that’s what appears.
• Ensure that attribute is included in the correct column (either as its own column or inside additional_attributes depending on your import layout).
• Do a small test import (e.g. just a couple of SKUs) and then search for “Yes” in the exported CSV to confirm it got set properly.

If you still hit a wall, maybe a plugin (kind of like how mod-appstores such as happymod help with games) might override/default these values — check if there’s a custom import extension interfering.

[metalmattlee11]

I appreciate the response.

Unfortunately, I tried all of the above (or below?) but still had the issue - which is why I was so surprised. I've been importing/exporting my 500+ attributes for some time. Possibly, it changed with 2.4.8-p3, which I just moved to, from 2.4.7-p8.

My solution for the moment was to enlist the (paid) help of a contractor I've found who is brilliant and will find and fix the issue. I've learned that i can run a business, or spend a lot of time on things I don't have to/count easily solve. So I took the cowards way out.

I'll post the solution here when we (he, really) finds it so we'll all know.

Thanks.