Stock by Attribute v4.0 addon for v1.3.5-1.3.9

Oh shoot...meant to post that in the other thread 1.5.1....never mind.... ;)

I just installed stock by attributes. Ran the install.php and it said it was installed When I went to Catalog, Products with attributes stock was not there? What went wrong and how do I fix it any help will be gratefully appreciated.

https://www.sandsfiredart.com

Im using this mod on several sites and its great.
I have a question about how to use it.

If I want to say delete all the stock levels Ive entered for a product, or overwrite them say, how is that done?
I know there is the delete button, but this happens a lot when we restock and there are about 60 combinations per product so thats a lot of click/confirm that I have to do.

Why cant we just overwrite a stock level?

If I select "All" for each attribute and make it a number like say 20, I get a whole bunch of new attribute "ID's", it would be better if they were overwritten.
Thats another question if size 5, colour red has 2 "ID's" which one does the store use and are they both reduced by 1 when a sale is made.

Using ZC Ver. 1.51

I am using the flavor of Stock by Attributes written by Kuroi and last Updated by gonsman - 3 Jan 2013. Since there seem to be several SBA plugins all named the same thing I was unable to locate a specific thread for this one. So I will just put forth my dilema here.

One of our product types has several attributes. Each attribute has several elements. Of course with SBA this combination results in an exponitial number of variants. I stopped counting at 150 variants per product.

Questions:

How can I remove the variants from the products in question without having to manually edit 7500 plus entries?

Is there are way to exclude a category from SBA?

I will take my answer off the air.

And where is the 1.51 thread?

lafaverp:

And where is the 1.51 thread?
As you pointed out there are several variants for SBA floating around out here, and the only v1.5.1 support thread is for one of those variants.. and since that version is clearly different form the one you are running you won't want to post there.. Suffice it to say that there isn't a specific support thread for some of variants of SBA available in the free downloads.. It's been somewhat of a free for all for quite some time now..

Is anyone able to help with my question below?

Chargin:

Im using this mod on several sites and its great.
I have a question about how to use it.

If I want to say delete all the stock levels Ive entered for a product, or overwrite them say, how is that done?
I know there is the delete button, but this happens a lot when we restock and there are about 60 combinations per product so thats a lot of click/confirm that I have to do.

Why cant we just overwrite a stock level?

If I select "All" for each attribute and make it a number like say 20, I get a whole bunch of new attribute "ID's", it would be better if they were overwritten.
Thats another question if size 5, colour red has 2 "ID's" which one does the store use and are they both reduced by 1 when a sale is made.

Chargin:

Im using this mod on several sites and its great.
I have a question about how to use it.

If I want to say delete all the stock levels Ive entered for a product, or overwrite them say, how is that done?
I know there is the delete button, but this happens a lot when we restock and there are about 60 combinations per product so thats a lot of click/confirm that I have to do.

Why cant we just overwrite a stock level?

If I select "All" for each attribute and make it a number like say 20, I get a whole bunch of new attribute "ID's", it would be better if they were overwritten.
Thats another question if size 5, colour red has 2 "ID's" which one does the store use and are they both reduced by 1 when a sale is made.

There is no easy way to do this.....

Look in your admin section of products with attributes with stock and find your product id number (the number net to the model number).
Then you can run this sql table update. BACK UP YOUR DATABASE FIRST!!
In the >Admin>Tools>Install sql Patches

UPDATE products_with_attributes_stock SET quantity=0
WHERE products_id=???

Substitute the ??? for the product_id number you want to change - and you can set quantity to any number you have, this would set all attributes with that product_id to the quantity you enter.
Hope this helps.

Thanks for that, I can work with that.
What would the query be to delete all the stock attribute levels for a product?

Pablo:

There is no easy way to do this.....

Look in your admin section of products with attributes with stock and find your product id number (the number net to the model number).
Then you can run this sql table update. BACK UP YOUR DATABASE FIRST!!
In the >Admin>Tools>Install sql Patches

UPDATE products_with_attributes_stock SET quantity=0
WHERE products_id=???

Substitute the ??? for the product_id number you want to change - and you can set quantity to any number you have, this would set all attributes with that product_id to the quantity you enter.
Hope this helps.

Is anyone available for paid support for this mod?
I have a feature request, we want to have the stock levels show up in the dropdown list. All our products have more than one attribute, so some sort of ajax cascading options system.

My client loses a lot of sales because things are out of stock and we would like to be able to show customers before they hit the cart.

Ok just a tip for anyone, if you duplicate a product in zencart it doesnt duplicate the stock by attributes settings so thats a way to delete them all. I cloned the product and then deleted the original product.

Chargin:

Thanks for that, I can work with that.
What would the query be to delete all the stock attribute levels for a product?

The query would be

UPDATE products_with_attributes_stock SET quantity=0
WHERE products_id=??? AND stock_id=???

as per above replace ??? with your product id number and the last ??? with your stock id number

Hello there.
i'm using 1.5.1 . stock v.4.0
i installed the stock by attributes ad don and everything is good.
the only problem is that the user see only the total count of the attribute.
my Q is :if there any way to display the attributes like this:
large 22 in stock
small 22 in stock
right now it show 44 in stock .

After a 2 day exhausting search, I am stumped. I have the Stock by Attribute addon working fine, however is there a way to prevent checkout if a buyer tries to purchase 10 large shirts, if there are only 7 large shirts in stock? The site is preventing buyer right now from checking out if they try to order more than the total quantity available, however I need to prevent them from buying by attribute, not total.

make sense?

Niko2013:

After a 2 day exhausting search, I am stumped. I have the Stock by Attribute addon working fine, however is there a way to prevent checkout if a buyer tries to purchase 10 large shirts, if there are only 7 large shirts in stock? The site is preventing buyer right now from checking out if they try to order more than the total quantity available, however I need to prevent them from buying by attribute, not total.

make sense?

Try setting ALLOW CHECKOUT in Admin>Stock to "false"
This should let the customer know to pick a low quantity to be able to checkout.

Thanks for the idea but that does not work, it will allow the checkout based on the total stock on hand, not what is available for each attribute. Does anybody else have a resolution to this problem?

Hello people.
How can i set easy populate for this mod?
and also i can i show my customer the stock level not as total item?
thanks .

last problem ,please somebody....please.
i set up stock by attribute that working great thanks.
now the problem that i have is that:
out of stock massage is not showing only for product with no attribute (product with attribute is working fine)
i hope somebody will understand my problem and help me.

ChrisD24:

Holy cow I think I figured it out. Please tell me this works for you!

ChrisD24,

well, lot of time passed since your contribution, but I really lost one full day to be able to find why the hell I had no more notifications in my carts of articles being present in quantities above availability and no chance to confirm the purchase from my customer...
All of this without any notification at all..

I think you deserve one more THANK YOU !!!

It works like a charm now, while before no notification at all, for any article (not only those with attributes...).

Strange nobody thought about updating the package available for download with this fix...

And, to cancel any misunderstanding, I'm on ZC v.1.3.9h, using v1.4.14 of this addon... :P

Hi,

I'm using ZC 1.5.1 and SBA 1.5.0. I love this plugin, but have the following situation...

A few of my products have 2 attributes, each with 2 choices. Rollers ("black" and "white") are removable and thus available in unlimited quantities, while sleeves ("decorated" and "smooth") are fixed and only available in very small quantities (1 smooth and 2 decorated, for a total of 3 sets). The plugin mixes and matches the attributes, and wants me to tell it that there are so many sets with black rollers + decorated sleeves, white rollers + decorated sleeves, black rollers + smooth sleeves, and white rollers + smooth sleeves. When I do 1 each, I end up with a total of 4 (while I only have 3), and people can't get 2 sets with decorated sleeves and the same color rollers (although in fact that would be possible as the rollers can be replaced at will).

Short of setting up the decorated-sleeved and smooth-sleeved sets as 2 separate products, is there a way not to count the rollers at all, just the sleeves? How would I go about achieving the end result like this:
2 sets with decorated sleeves + either black or white rollers
1 set with smooth sleeves + either black or white rollers

Thank you!
Magz