Stocks by attributes

[kuroi]

Hi again guys.

Im rather confused.

I have my cart working great, and recently got some stock in that is easier to sell via Attribute (Colour).

How do I tell Stocks By Attribute how many units I have of each Product per colour?

I can't find it anywhere and I'm getting rather frustrated - I've read through this thread a couple of times now.

Thanks in advance.

Provided you have installed the mod correctly, you go to Admin > Catalog ? Products with Attribute Stock (usually at the bottom) and then find the product for which you wish to add Attribute stock and click on its "Add Quantity for Product Variant" link.

[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.

[JimCrown]

This module looks like what I've been searching for.
However...I'm a novice and this is probably a stupid question, but...
How do I run the stock_attribute.sql
and where do I find it?
Also, we run our databases through our hosting service. Will this still work for the database required for "Stock by Attributes"?
Thanks much.

[ckosloff]

Hi,
I don't quite remember what comes included in this mod since I have it installed live for some time now.
But, if a .sql patch is included, you install it through Admin -> Tools -> Install SQL patches.
You don't need to worry about a special database, it is the old mySQL that your hosting service already has, if you are running Zen Cart.

[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.

[shannda]

I have recently upgraded my clients site to 1.3.7.1 and the Stock by Attributes module is no longer working correctly. Customers are placing orders for items where the stock is zero. I've installed the most current version of the module 4.5. The host is running PHP5. Does anyone know if the module is compatible with PHP5?

The store is obviously live and my client is very understandable but its something I would love to get resolved for her.

Thanks in advance for any info or suggestions you can offer.

[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.