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

[athena]

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

[sandsfiredarts]

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.

www.sandsfiredart.com

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

[lafaverp]

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.

[lafaverp]

And where is the 1.51 thread?

[DivaVocals]

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

[Chargin]

Is anyone able to help with my question below?

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.

[Pablo]

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.

[Chargin]

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

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.

[Chargin]

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.