Stocks by attributes

[Computer Candy]

Ok, please be merciful if i missed this. I have been looking for almost an hour now in this topic and the archived topic and still cannot find a solid answer...

I would like to be able to hide attributes that are not in stock. I have found "How can I show the amount of stock available next to each attribute on the product information page?" in the wiki but not how to just hide an attribute alltogether when it is out of stock.

I know i just must be missing it since it seems like a very common question. I seem to keep finding the question, but not the answer.

Any help would be greatly appreciated. :)
-CC

[Computer Candy]

P.S. Is there a mod to automatically add multiple specified attributes for a product category? I am building a store that will sell shoes and there are sizes 4, 4.5, 5 ...through... 11 and we need to have all sizes set for all shoes. Then we can just go in and enter the stock numbers only for those size attributes that they actually have in stock. If i am correct, all attributes will automatically be interpreted as 0 unless set otherwise. So this would save us a lot of time and extra steps.

Sorry, i tried to edit my last post but it wouldn't let me.

[Computer Candy]

I hate to be a pest but since this topic has been inactive the last week or so, i thought i would try to resurrect my questions. I hope that's ok.

thX again! And sorry to bug again.
-CC

[kuroi]

I would like to be able to hide attributes that are not in stock. I have found "How can I show the amount of stock available next to each attribute on the product information page?" in the wiki but not how to just hide an attribute alltogether when it is out of stock.

Extracting the quantity for each product variant is the trickiest bit. Using that data to suppress display of the attribute is very straightforward, but the exact code would depend on your specific template files which is probably why nobody has posted a specific response to this.

Is there a mod to automatically add multiple specified attributes for a product category?

I think you mean, is there a way to set all the attribute combinations for a product in one go - answer no. Although obvious how this could be achieved when there is only one attribute (even if it can take multiple values such as shoe sizes) per product, it would get horrendously complex when there where multiple attributes. So useful, but unlikely to happen until this functionality has been incorporated into Zen cart 1.4.

If i am correct, all attributes will automatically be interpreted as 0 unless set otherwise.

You are correct.

[Computer Candy]

Extracting the quantity for each product variant is the trickiest bit. Using that data to suppress display of the attribute is very straightforward, but the exact code would depend on your specific template files which is probably why nobody has posted a specific response to this.

Thank you very much for you reply on this. I am using the 'Cherry Zen Template' if anyone is feeling super ambitious enough to help. I am only a novice coder but i am starting to get a _basic_ grasp of the logic to it so even some starting pointers might help to at least get me in the right direction.

I think you mean, is there a way to set all the attribute combinations for a product in one go - answer no. Although obvious how this could be achieved when there is only one attribute (even if it can take multiple values such as shoe sizes) per product, it would get horrendously complex when there where multiple attributes. So useful, but unlikely to happen until this functionality has been incorporated into Zen cart 1.4.

Ok, thank you for that. I wonder if there would be an SQL query that could be run to add the values only to items in a specific category. I am not good enough to figure that out but again, if anyone has a bit of time and is feeling extra ambitious, that would be great, hehehe. It's not a big deal when i add a few new pairs of shoes now and then to add all of the sizes manually. But in the beginning like this we are adding a LOT of shoes and it sure would save some time. I only need this for shoe sizes so it is only the one attribute for all items in my 'Shoes' category.

To take one bit out by itself...

Although obvious how this could be achieved when there is only one attribute <--snip-->

I'm afraid i am not seeing it. Do you mean that i should easily be able to do it for a product with only one attribute ...or... do you mean, even if i do it for one attribute it will screw up other items with more than one attribute? Or maybe you just mean that it would be an easy mod for a coder if it were for one attribute only, but beyond that it is too complex and therefore it prolly won't happen anytime soon?

...hehehe, sorry about the confusion.

Anyhow, thX again so much for the reply. It is very appreciated.

[mauryg]

P.S. Is there a mod to automatically add multiple specified attributes for a product category? I am building a store that will sell shoes and there are sizes 4, 4.5, 5 ...through... 11 and we need to have all sizes set for all shoes. Then we can just go in and enter the stock numbers only for those size attributes that they actually have in stock. If i am correct, all attributes will automatically be interpreted as 0 unless set otherwise. So this would save us a lot of time and extra steps.

Sorry, i tried to edit my last post but it wouldn't let me.

I think I just found an answer to your question.
Look at improved_attributes_controller_1.1b in the admin section of the downloads page. It replaces one admin php file. Then when you select the option name in the first box on the attributes controller page, the second box shows ONLY those values that apply to that option AND you can make MUTIPLE selections at one time. So you can select "size" in the first box and then select ALL the sizes for that product in one pass. NOT automatic, but a big time saver.

Hope this helps.

[Computer Candy]

Thank you very much for that. I actually already use the Improved Attributes Controller (i should have noted that, sorry) and it is indeed a big time saver. I guess i was looking for more of a multiple product at once tool. But i'll take what i can get and that does help. Thank you again for the suggestion.

[mauryg]

Computer Candy


Now as I think about your question, there is another possibility. If you "Price by attribute", you could use Easy Populate to add the attributes to a whole category in one pass. Set up the attributes and then download an "Attributes" file. Open it in Excel, add all the product numbers in the first column and then copy ALL the attribute columns down for your newly added products. Put a price in the attributes you want to add, save the file (in text format) and upload it with Easy Populate to the database. All the attributes will be added to each product. If all of the attributes have the same price, the base price is set to zero and the product is marked "Price by attributes" = YES, then the total price will be the price of the attribute. OR you might be able to just set the base price to what you want, leave the product marked "Price by attribute"=NO, and set the attribute price to zero (haven't tried this yet).

[Redcinamn]

Candy,

Am I incorrect in saying that all you are trying to do is add
4, 4.5, 5 ...through... 11 on every item in your store?

Then you would go into the Products with attributes stock and add each number of shoe available per shoe name?

Red

[Computer Candy]

Computer Candy

Now as I think about your question, there is another possibility. If you "Price by attribute", you could use Easy Populate to add the attributes to a whole category in one pass. Set up the attributes and then download an "Attributes" file. Open it in Excel, add all the product numbers in the first column and then copy ALL the attribute columns down for your newly added products. Put a price in the attributes you want to add, save the file (in text format) and upload it with Easy Populate to the database. All the attributes will be added to each product. If all of the attributes have the same price, the base price is set to zero and the product is marked "Price by attributes" = YES, then the total price will be the price of the attribute. OR you might be able to just set the base price to what you want, leave the product marked "Price by attribute"=NO, and set the attribute price to zero (haven't tried this yet).

I hadn't thought if that. That is a good idea. I do not set prices by attribute, but i still might be able to use Easy Populate to accomplish this. I haven't tried that feature/mod yet but I will mess around with it and see what i can come up with. thX a lot!

Candy,

Am I incorrect in saying that all you are trying to do is add
4, 4.5, 5 ...through... 11 on every item in your store?

Well, kind of. I am trying to add all shoe sizes to every product in the 'Shoes' category. (not to every product in the entire store) But you get the general idea.

Then you would go into the Products with attributes stock and add each number of shoe available per shoe name?

Red

That is what i am trying to avoid if i can help it. I have no problem doing it this way if i can't find a more efficient method. But if i can find a way to add all shoe sizes to all products in the 'Shoes' category in a more efficient shot, that would be a huge time saver for our initial setup. It won't be such a big deal later when we are just adding a few new pairs of shoes at a time but right now we are adding a lot. thX though.


-----
If i can use a cool little trick with Easy Populate as mauryg described, then all i really still have to figure out is how to hide sizes of shoes not in stock with the 'Cherry Zen' template.

thX again everyone for your great help! I am very quickly starting to see that i made the right decision by choosing Zen Cart just with the community support alone.
-CC