Stocks by attributes

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

[sobebabies]

Thank you so much!

[osdude]

Is there a way to add 'X' stock to each product?

I already have the car populated with products and attributes. What I want, is to add 'X' stock to all products with an attribute.

I was thinking SQL?

ANyone have an idea?

[dab]

I have ZenCart 1.3.7 and have just upgraded Stock By Attributes from 4.4 to 4.6, which seems to be fine.

One thing is confusing me though:
I have a product that has 3 attributes A, B and C, and I have put a quantity of 1 at product level and deleted all the product variants at attribute level. This now allows one product to be ordered for of each of the attributes - 3 in total.

Is this the expected behaviour, or should it only allow a total of one product to be ordered regardless which attribute is selected.

Any help would be appreciated.

[kuroi]

Is there a way to add 'X' stock to each product?

I already have the car populated with products and attributes. What I want, is to add 'X' stock to all products with an attribute.

I was thinking SQL?

SQL is the answer. But the devil will be in the detail of the type and number of attributes on each product, which version of stock by attributes you're using and whether you intend to use attribute stock for all products with attributes or just some of them. Even in the simplest of the cases, the SQL's going to be very complex. The table structure just doesn't really work well with this approach.

[kuroi]

I have ZenCart 1.3.7 and have just upgraded Stock By Attributes from 4.4 to 4.6, which seems to be fine.

One thing is confusing me though:
I have a product that has 3 attributes A, B and C, and I have put a quantity of 1 at product level and deleted all the product variants at attribute level. This now allows one product to be ordered for of each of the attributes - 3 in total.

Is this the expected behaviour, or should it only allow a total of one product to be ordered regardless which attribute is selected.

Any help would be appreciated.

I'm afraid that's how it works. But that's nothing to do with stock by attribute (which you've effectively disabled for this product). It's core Zen Cart doing this. Each time a customer adds a product to their cart, it checks against the product stock level and not other products already in their cart, or already in the carts of other shoppers on the site at the same time.