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

[Jazzyp]

No luck wished (shouldn't be necessary), just advice ...

1. ensure that your old includes/classes/order.php file gets over-written by the new one (sometimes FTP tools don't over-write files that are already there)
2. check that you have your stock settings configured both to check stock and to prevent checkout if its too low (Admin > Configuration > Stock Settings)
3. don't leave any backups sitting around in your classes folder (sometimes FTP tools create these automatically)

Right, I've deleted all the SBA multiadd files and uploaded them again. I used winmerge to check the contents of each file against clean Zen files. The only thing I haven't done is touch the database.

And - it's still not working. Checkout works normally for stock items that don't use attributes, but any attribute items will checkout regardless of stock levels. The warning appears on the shopping cart page but it still lets you checkout.

Am I just going to have to live with it!?

[esugrue]

Hi!

I may have the same issue as jazzyp, I downloaded the latest version 4.7AJAX and have set the stock to Subtract and Not Allow Checkout.

It doesn't allow Checkout but after I checkout and look the stock has not subtracted.

I also looked in the files included and couldn't find the required order.php, in fact no directory for classes just admin, ajax and includes (but no classes under includes).

Should I be able to download this version:
Author: mcinallym
Version: 4.7MULTIADD
Zen Cart™ Version: v1.3.8

and just install it etc?

[DivaVocals]

Right, I've deleted all the SBA multiadd files and uploaded them again. I used winmerge to check the contents of each file against clean Zen files. The only thing I haven't done is touch the database.

And - it's still not working. Checkout works normally for stock items that don't use attributes, but any attribute items will checkout regardless of stock levels. The warning appears on the shopping cart page but it still lets you checkout.

Am I just going to have to live with it!?

If you are using the MultiAdd version, then the answer is yes.. It will warn the customer that the item is out of stock, but it will allow them to checkout..

I'm subscribed top this thread to keep up with updates on this add-on, and color me silly, but I finally today realized that the AJAX version being discussed of late was indeed a new versionof this add-on (I know.. pardon the blonde moment) Sounds like the Ajax version is supposed to prevent checkout, but doesn't adjust stock levels correctly (bummer).

I wasn't clear, but it sounds like merging the MultiAdd version with the Ajax version didn't work. Did I read that wrong??

I wonder if the author of the Ajax version is aware that his version doesn't work.. Hmmmm

[flowerchild5]

I am having a problem with attribute/variant inventory being updated. It is still updating inventory on a products level versus the attribute level.

I am using vers. 4.7 vanilla I have....
1) verified all of the files uploaded correctly including the includes/classes/order.php
2) I have Configuration -> Stock ->
Check stock level true
Subtract stock true
Allow Checkout false

I am using "Fast and Easy Checkout" but apparently that mod does not conflict with this mod because limelites was able to get his inventory to update with the same mod installed.

I read where there was an "attribute stock exceeded" check is missing from "includes/modules/pages/checkout/header_php.php". This file is unique to the "Fast and Easy Checkout" contribution. I made these changes as was suggested and it does does give a warning that stock is low for the particular attribute that was added to the cart, but yet still does not decrement the attribute stock levels.

The only other mod that I can think of that would possibly interfere is the "product attributes grid" mod. There are plenty of people with that mod that are not having conflicts so I am thinking this is not the problem.

Any suggestions?

[flowerchild5]

After a week now of trying to get the attribute inventory to update correctly I have found out the problem though I don't have a solution to it yet.

It is indeed the "attribute grid" mod that is causing the problem. With this particular mod it is required that you create another attribute for each product. I have the option size with the various sizes as values. In order for the attributes to layout in a grid. You must use another attribute. This I used quantity with no value.

Does anybody no of a work around to this? I will work on it tonight and hopefully come up with something, but I was hoping someone might have run into this problem already.

Is this what I am looking for (a hack to exclude readonly attributes) as Kuroi had suggested to another Zenner http://www.zen-cart.com/forum/showth...137#post482137

If so where would I put this code in the file admin/includes/classes/products_with_attributes_stock.php The post was way back in '07 not sure if it would work with 1.38 and this version of SBA

[flowerchild5]

I was thinking I could only select only the attributes from the database that have an option value since my 2nd attribute does not have a value and is only present to create another axis for the attribute grid.
......couldn't figure this out

I then thought that I could filter the attributes to retrieve only attributes where its option value id was NOT 110 or option id was NOT 20 as these are unique to this particular attribute. I am just not seeing this code where the attributes are retrieved from the the products_attributes table.

Any ideas oh wise Zenners?

[Jazzyp]

If you are using the MultiAdd version, then the answer is yes.. It will warn the customer that the item is out of stock, but it will allow them to checkout..

I wasn't clear, but it sounds like merging the MultiAdd version with the Ajax version didn't work. Did I read that wrong??

Yes, you read it right. I combined the files from both multiadd and ajax and it still didn't work.

[Jazzyp]

After a week now of trying to get the attribute inventory to update correctly I have found out the problem though I don't have a solution to it yet.

It is indeed the "attribute grid" mod that is causing the problem. With this particular mod it is required that you create another attribute for each product. I have the option size with the various sizes as values. In order for the attributes to layout in a grid. You must use another attribute. This I used quantity with no value.

Does anybody no of a work around to this? I will work on it tonight and hopefully come up with something, but I was hoping someone might have run into this problem already.

Is this what I am looking for (a hack to exclude readonly attributes) as Kuroi had suggested to another Zenner http://www.zen-cart.com/forum/showth...137#post482137

If so where would I put this code in the file admin/includes/classes/products_with_attributes_stock.php The post was way back in '07 not sure if it would work with 1.38 and this version of SBA

Not sure if it is the attribute grid mod that's causing the problem, as I don't use that mod and I have the problem!

[flowerchild5]

Not sure if it is the attribute grid mod that's causing the problem, as I don't use that mod and I have the problem!

In my case it definitely was the product attribute grid mod. When I disable it attribute inventory works fine.

[g.nencini]

I'm studying how to interface the zen database with a sophisticated program managing the store of a dress factory. I've installed the stock_by_attributes_4-7ajax module, and I begun to consider the color and the size of a dress.

The table `products_with_attributes_stock` contains the fields
`stock_id`,
`products_id`,
`stock_attributes`,
`quantity`

and in my test I've the values

(1, 9, '2,7', 11),
(2, 9, '3,5', 12),
(3, 9, '4,5', 13),
(4, 9, '3,6', 14),
(5, 9, '3,8', 15),
(6, 9, '1,6', 16),
(7, 9, '4,8', 0);

The first row tell me that the dress with the product_id=9 has a attribute combination of '2,7', and there are 11 dresses in stock.
Again in my example I have

2 = Grey 7 = size 44

The problem is that the number 2 is not the attribute identificator, but the position in the drop-down menu of the colors. The same thing is for the number 7.

The possibility to update the table from another program seems to be really very complicated!!!

Ha someone dealed with this problem and can give me some suggestion?

Thanks - Giovanni