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

So is this mod supposed to show the stock levels on the product listing page?
Otherwise, how is a customer going to know if their size is available?
Will it automatically hide an attribute when stock is at 0?

hi,
all this mod does is show sold out beside and attribute when its stock level reaches 0.

I'd be interested in finding out what went wrong with in your case digitalrust.

i hope it doenst mess up on my store.

it's not working properly for me either :(

i'll have to figure out what has gone wrong.
Is anybody interested in helping me?

Hi,
Frank_Ivy did say

Keep in mind, these fix will only work for products have one attribute, and product attribute display style is radio buttons or check boxes.

so it must have something to do with the SQL.
I've got products with more than one attribute and attribute stock mixes.

best thing to do would not be to show the attributes at all if they are sold out.
There must be a way to fix this!!

OK so I have a probles...
It DOESN'T show Sold Out on items that i don't have.
I just input the info yesterday, and had an order today for something I do not have in stock. I checked the site and it doesn't say sold out.

I need help fixing this asap!

Thanks guys!

s_p_ike:

It seems to me that there's a problem with checkbox attributes.

...

the problem is $stock_attributes = implode(',',$stock_attributes);You are absolutely right. This mod has a terrible database structure going way back in time to I suspect (for it is long before my time) the osCommerce mod from which it was originally derived. As a result, for precisely the reason that you give, it doesn't play nicely with multi-value form fields (radio buttons and check boxes to you and me).

I have no doubt that when the Zen Cart team integrate this function into version 1.4 (as per the Zen Cart roadmap) they will do a much better job. Until then sadly, we need to accept this as a limitation of the mod.

DJDex:

Ok so currently i have the product installed and adding each stock you know green xl I have 1 yada yada yada. If I dont have say White XXL when someone selects the color is there a way to not show XXL in the other drop down?There's quite a bit of discussion about this on one of the archive threads and even some code in an older version of the mod that seemed to be trying to achieve this AJAX-type functionality (which certainly would be very cool).

However, it doesn't seem to have come to anything. I suspect that it floundered on trying to work with the mod's existing database structure and hope that with a better structure, properly integrated in Zen Cart (rather than bolted on the side) this functionality will become easier to develop.

richcon:

Ok, I'm tripping. The mod is version 4.4 for 1.3.7, and the Readme file was the one from 4.3 (ZC 1.3.6), hence it was the Readme that was out of date, not the mod. The author of this mod probably should update that.The readme was updated for 4.4. You'll find an amendments section for it part way down the document.

Unfortunately, in my haste to make it available, I forgot to amend the header and first paragraph. My apologies for the confusion.

It's still a great mod - even though it has its foibles. :yes:

Hi Crabacle

Many thanks for the encouraging words. Most mods slowly die when when the original developer gives up on them. A few of the more important ones get picked up by a second developer and taken forward, or by Dr Byte who keeps them in line with Zen Cart.

This one has had an unprecedented 4-5 developers, one after another, plus significant contributions from others. That it eats developers like this shows how difficult it is. That it nevertheless keeps getting picked up and carried forward shows how important it is (though you could make a case for it actually being evidence of how daft some developers can be - I wouldn't argue). I will therefore be very pleased to see it properly integrated into Zen Cart, after which we'll be able to concentrate on doing the really flashy stuff! :thumbsup:

hostilerecords:

Please can someone help me out with this, I'm going crazy reading through all the threads/posts trying to find the answer :cry:
I guess something isn't set up right, it is supposed work right?

If it isn't - can someone put me out of my misery and tell me, please.

Below is my original post.I've been trying to reproduce this but have not been able to. In a test environment with the settings exactly as you have them, and a product set up as you have it, it all works perfectly for me.

Do you still have a site with this problem where I can look at the problem at source?

Ben_86:

I also have a problem with the contribution. I tried to install it on several installations but I still keep the following error.

When I add (for example) 10 pieces of attribute A and 10 pieces of attribute B, I get to see for the product 20 total in stock. This is correct! When I order 5 pieces of attribute A and I go to -> Catalog -> Categories / Products and I click to the product, I see at quantity 15 (10 + 10 = 20 - 5 = 15). Also this is correct.
When I enter catalog -> Products with attributes stock and I navigate to the product, I still see at attribute A 10 and attribute B 10! So only at Catalog-> Categories/Products -> Product I see the correct (total)quantity!

Does anyone knows how to solve this?Hi Ben

I think that you've stated this the wrong way around. When products with attribute stock are purchased the attribute stock is reduced (provided Configuration > Stock > Subtract Stock is set to true), but the overall product total isn't.

So if you look at Catalog > Categories / Products you should see 20, whilst Catalog > Products with attributes stock should show 15.

You can manually sync the two by clicking on the Sync Quantities link in Catalog > Products with attributes. Quite why this wasn't automated when the addon was originally written escapes me. Maybe it is because attribute stock levels have taken over from product stock levels and so product stock levels no longer mean much, and it just wasn't considered to be important.

13moons:

I read through the posts and I'm not quite clear on this: If I install the latest version on 1.3.7 must all current products with attributes have stock for each attribute?
Or can I select individually which products with attributes are affected by this mod?

ThanksYou choose whether to add attribute stock to a product. If you do any attributes to which you don't add stock will be treated as having none. If you don't the stock control will continue to be done at the product level.

heavenlynights:

Whenever I place an item in the cart that has attributes by stock it shows up as being out of stock even though it is stated in both admin>catalogue/product and **admin>catalogue>Product with attributes stock **as having the correct amount of stock that I have.You say that you are running Zen Cart 1.3.7 but not which version of the addon you are running.

Also do any of that long list of addons that you have also change any of the following files:
* admin/orders.php
* admin/includes/stylesheet.css
* includes/classes/order.php
* includes/functions/functions_lookups.php
* includes/modules/pages/checkout_shipping/header_php.php
* includes/modules/pages/shopping_cart/header_php.php
If so, did you merge both sets of changes into the core Zen Cart, or overwite one set with another?

frogster:

How do I get the product Quantity in Stock value to show by attribute on the product pages. I have search the for this with no luck.TBrides is right. The mod doesn't do this. Happily I now see that you have found and implemented the revised Grayson solution - well done.

tbrides:

best thing to do would not be to show the attributes at all if they are sold out.
There must be a way to fix this!!Frank should have said > Keep in mind, these fix will only work for products have one attribute, and product attribute display style is NOT radio buttons or check boxes.The mod doesn't work on attributes as such, but on combinations of attributes. To not show the attribute, you would need to ensure that all of the combinations in which it occurs had no stock. And do that for all attributes. This would be easy if your products have just one attribute, but exponentially difficult for every additional attribute that they have. So it can be done, and would be much more feasible than trying to come up with a way of displaying the stock available for every combination in a way that would be meaningful to a customer.

Nevertheless it would be a relatively complex and potentially page-slowing piece of work that scarcely seems justified for a mod whose life will come to an end with the next major release of Zen Cart.

khopek:

OK so I have a probles...
It DOESN'T show Sold Out on items that i don't have.
I just input the info yesterday, and had an order today for something I do not have in stock. I checked the site and it doesn't say sold out.

I need help fixing this asap!

Thanks guys!Do you have the following values set?

Admin > Configuration > Stock >

Check stock level = true
Subtract stock = true
Allow Checkout = false

kuroi:

TBrides is right. The mod doesn't do this. Happily I now see that you have found and implemented the revised Grayson solution - well done.
This sounds a little like the problem im having.

The mod works great but what i need is it to show (to the customer) the quantity of each attribute instead of them finding out after they click the add to cart button.

Is this possible?

I think this is a problem for quite a few people. I know for me it is. The customer should defintely be given the information on the Product Info page, not at check out.

troy77:

what i need is it to show (to the customer) the quantity of each attribute instead of them finding out after they click the add to cart button.

Sickerstore:

one problem we are running into using something that only gives the stock information on the admin side only.

khopek:

The customer should defintely be given the information on the Product Info page, not at check out.

I agree with all of you, and I have pages of notes about the really whizzy things that could be done, some of which people have offered me money to do. But they're unlikely to happen with this mod as the base, and certainly not by my hand. The reasons have been explained many times before on this and other threads, but I'll run through them one final time:

1. There is a solution (the Grayson solution with revisions) that works if you have just one attribute per product
2. However, as you define stock for each combination of attributes, to this as a php solution when you have more than one attribute but avoid giving out misleading aggregated information, your server needs to know before the data leaves it, which combination of attributes your visitor is going to choose - which is a bit difficult to do.
3. Alternatively you could pass data for every combination to the visitor's browser together with code that can be executed on the browser (most likely DHTML) but alas the original data structure is so poor as to make this very difficult to do
4. And since a different, better integrated approach to stock by attributes is scheduled for inclusion in the next major release of Zen Cart, there is little point to producing complex code that will soon be made redundant

kuroi:

This [mod] has had an unprecedented 4-5 developers, one after another, plus significant contributions from others. That it eats developers like this shows how difficult it is.And I'm now going to join the list of retirees. The time I have to donate to supporting people through the forum is limited and better used on things other than keep answering the same point over and over for a mod for which I have no personal use. I'll let somebody else pick up the baton, until the mod draws its last breath. Any volunteers?