I was just wondering if we should change the setting in the database table to make the field "product_model" Null=No;
1 - Can this be done without harming other functions?
2 - Would this prevent me (as it should) from adding a product without this important value?
3 - Wouldn't this prevent importing products with a null value - again, as it should?
~Lynne
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.
Can I change the field product_model to "unique" without causing any problems for other functions?
I have started work on a WIKI entry for Easy Populate that Newbies may find helpful.
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Additionally, there are probably 100,000,000,000 users of Zencart and EP that are more intelligent than me, so I'd appreciate it if EP experts could take a look and alert me to errors, etc. (As it's the WIKI, users can edit at will !)
20 years a Zencart User
Misty, thanks. I know the number has to be unique but in my products table the field doesn't have that setting in the table structure. Also, Null isn't set to no. Should I change these in my table/field attributes?
Bookmarks