cancel
Showing results for 
Search instead for 
Did you mean: 

Import Yes/No from CSV Not Working

Import Yes/No from CSV Not Working

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.