Stocks by attributes

[double e]

I compared all of the files with a fresh download of the Stock by attributes and
I found a few differences which fixed the problem that I was having with the "out of stock" not coming up when an item attribute is added to the cart with a 0 stock level but I still have the problem with Firefox putting double entries when adding attribute stock levels in the admin section. I don't know why this should happen.

[sobebabies]

I've got one product I drop ship that have 4 attributes with quite a few options on some of them - it adds up to 420 permutations. I'd do this in SQL if I have to - is there any quicker way to make all combos for a given product have a very high number in stock? I am doing most combos by hand for the rest of my inventory, as boring as that is, but, well, this one product is going to take weeks to do manually.

[kuroi]

I've got one product I drop ship that have 4 attributes with quite a few options on some of them - it adds up to 420 permutations. I'd do this in SQL if I have to - is there any quicker way to make all combos for a given product have a very high number in stock? I am doing most combos by hand for the rest of my inventory, as boring as that is, but, well, this one product is going to take weeks to do manually.

It you only drop ship for this product and therefore want all possible combinations to be available, just put a high stock value on the product itself and don't create any attribute stock.

If some of the combinations are are not possible, then you would need to set attribute stock to zero to disable the combinations that visitors are not able to purchase. There is no built in way to achieve this, and because of the way in the which the data is structured, a purely SQL solution would be very complex. This really feels like it needs an upload file, possibly imported via your database management tool (or phpMyAdmin).

[sobebabies]

It you only drop ship for this product and therefore want all possible combinations to be available, just put a high stock value on the product itself and don't create any attribute stock.

Oh! I didn't realize that! No, this isn't the only product I drop ship but this is such an easier solution. Thanks! :)

I installed this module a few weeks ago and was gonna get to updating the numbers. Someone called me saying something was out of stock - I hadn't even realized that people noticed the *** and bright pink (for me, anyway) warning because order were coming in anyway and stuff going negative. So anyway, I've been scrambling to get the inventory in correctly - sales were suspiciously low.

[sobebabies]

It you only drop ship for this product and therefore want all possible combinations to be available, just put a high stock value on the product itself and don't create any attribute stock.

If some of the combinations are are not possible, then you would need to set attribute stock to zero to disable the combinations that visitors are not able to purchase. There is no built in way to achieve this, and because of the way in the which the data is structured, a purely SQL solution would be very complex. This really feels like it needs an upload file, possibly imported via your database management tool (or phpMyAdmin).

This didn't do the trick. It still says the product is backordered no matter what combination I use.

[sobebabies]

I'd love to get a quickie guide on how to tweak the database to get this done. Which tables, how do I find what I need? The SQL syntax for the INSERT or UPDATE would be helpful. I just want to be able to set this type of product to have all attributes to super high and never have to touch it again manually.

[kuroi]

This didn't do the trick. It still says the product is backordered no matter what combination I use.

What version of Stock by Attribute are you using, and what version of Zen Cart?

[sobebabies]

What version of Stock by Attribute are you using, and what version of Zen Cart?

Why, is this fixed? I have v4.4 and 1.3.7. Upgrade scheduled but tough time of year!

[kuroi]

4.4 is an all or nothing version which requires attribute stock to be set up for all attribute combinations, or they're treated as zero and orders then go to backorder.

Download version 4.6 (not 4.7) and take replace only your includes/functions/functions_lookups.php with the one from the newer version.

This is the change that allows the product level quantity to be used when no attribute level stock has been set. The change was made for a client in a very similar position to you and is working perfectly for him.