Ok, I'm sorry if I'm asking really basic stuff here, but this thread is 150 pages long and search isn't paring it down well for me at all.


I'm trying to set up Attributes. Pulling down a model/attributes sheet with Easy Populate is not making any sense to me. I made a couple of attributes and gave them values... and threw them on a category of products, and pulled down the sheet with EP again... and it's still not making a lot of sense to me. It's either really complex, or way simpler than what I thought it'd be and that's why I'm confused.

All it's doing so far is listing EVERY product, EVERY attribute on every row, and putting a 0 in one column of the ones that have it assigned. Is that all it does? And doing that is all it takes?

Does anyone have any SQL scripts they use to assign attributes instead of doing it through EP? Because that doesn't seem to be a very simple way of doing it. You'd have to link that model sheet to some other sheet anyways, and if you're joining tables, might as well just go straight to SQL, right?

The main thing I want to do it outside of the default attribute copy interface for, is I need to assign by category and manufacturer. At the least. Not just category. And even probably a lot of manufacturers will have some colors and options only available to certain product lines, and not all of their items under a certain category.

Any advice or help would be awesome.

Most especially just an explanation of what each column in that models/attributes sheet is. Maybe it's just as simple as I'm thinking and I'm over complicating it on myself.

Thanks in advance.