Stocks by attributes

am i missing something :wacko: is there a way of Sync all Quantities of all the attributes in one hit, rather then individualy, got over a 1000 products:lamo: thanks

plantsales:

am i missing something :wacko: is there a way of Sync all Quantities of all the attributes in one hit, rather then individualy, got over a 1000 products:lamo: thanksNope. 'fraid not. But I've never really understood the benefit of this sync anyway.

I installed Kuroi's module and in the admin it seems to be working but then when i went to my website it allowed me to buy 5 of something that there are 0 of in stock!!
I do not have any option in the admin> config>stock except for it not to allow checkout when there is no sstock.
Am I supposed to be doing soemthing else in order to make this work?

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.

Rachelflam:

I installed Kuroi's module and in the admin it seems to be working but then when i went to my website it allowed me to buy 5 of something that there are 0 of in stock!!
I do not have any option in the admin> config>stock except for it not to allow checkout when there is no sstock.
Am I supposed to be doing soemthing else in order to make this work?Do you have

check stock = true
subtract stock = true
allow checkout = false

?

pixelkitty:

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.

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

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 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. :smile:

thX again! And sorry to bug again. :blush:
-CC

Computer Candy:

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.

Computer Candy:

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.

Computer Candy:

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

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.

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.

kuroi:

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. :wink: 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. :smile:

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.

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. :(

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.

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.

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

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

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).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! :D

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?**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?

RedThat 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. :wink:

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. :clap:
-CC

Candy,

I have confirmed that using EasyPopulate with the Attributes spreadsheet and setting the v_attribute_values_price column for EACH of the sizes to '0' (zero) WILL ADD that attribute to each of the products with NO PRICE. You will need to have a separate row in the spreadsheet for each shoe style. So if the price is the same regardless of size, this will add the size selection feature to each of the shoes. The price will be the base price if the "Price with Attributes" is set to NO. Once that is done you may find that "Stock with Attributes" will treat each of the sizes as a separate product and maintain the inventory for you.

Hope this helps.