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

[Oakwood]

I just wanted to jump in and say, I solve my own problem as I did not have any stock setup for "p2" thus it was not showing up in sba.

::smacks forehead, pours another cup of coffee::

[kuroi]

I am using Araxis Merge (araxis com) to verify the changes I have done yesterday.

Except for destroying the Google Cart payment module, I saw no changes as to the hand inserted lines I added yesterday.

So, I just confirmed following the directions.

Admin panel still is not working. Snapshot is the same.

I even added the stock_attributes style to the stylesheet.css. No change.

How do I uninstall the sql patch to retry?

Maybe there is something else wrong with the install?

You can uninstall it by running the following through your Admin > Tools > Install SQL Patches

DROP TABLE products_with_attributes_stock;
DELETE FROM configuration where configuration_key = "STOCK_SHOW_LOW_IN_CART";

but might this be something simpler like not having any stock set up on your products ready to be divided between the product variants?

[kuroi]

1: If I'm running a single database, does the sync quantities button do anything? Doesn't seem to matter if I click it or not after changing product counts.

I suspect that it doesn't anymore. This mod has been maintained by a number of people over the years, and I have a vague memory that the manual syncing may have been automated somewhere along the way - but I'm not absolutely sure. Certainly there's no harm to it though!

2: Is it possible to display remaining quantity of a size to a customer, either when size is selected or at checkout?

Yes. Set the Admin > Stock > "Show available stock level in cart when less than order" flag to "true"

[raineray]

I have installed the mod and all is working great! I would like to know if there is a setting so that when a specific size is out of stock the option for that size will not even be displayed in the dropdown. Is this possible? The way the mod works now the customer can choose the out of stock size and is told in the cart that the item in that size is out of stock and will be put on back order. Thanks in advance for any help.

[kuroi]

No there is no such setting, but the code changes needed to do this under limited circumstances (i.e. no more than one attribute per product) have been discussed previously.

[raineray]

Thanks for the reply. As I understand what you said it can only be done with code changes when there is one attribute for the item not multiple sizes available for the product and one of the sizes is out of stock. Have I stated the situation correctly?
Thanks for your patience.

[kuroi]

No size (however many values it can take) is just one attribute. You can do it with this.

However, if you had a size attribute and a color attribute, it would be more complicated, since you would no longer be able to say whether or not you were out of stock of small, as you might have them in red, but not in blue. So you need to either publish a table of stock positions (ouch) or use AJAX to get the answer for specific cases once a visitor has made their first choice.

[Bunkerage]

I am having some trouble getting Stock by attribute to work properly.

I am using the latest version of Zencart and the latest Stock by Attribute release but for some reason Zencart seems to be ignoring the stock for each attribute.

For Example:

I have a test item called SHIRT and it has the following Attributes

Small: 5 in stock
Medium: 5 in stock
Large: 5 in stock
Total in stock: 15

Whenever I try to order 6 small shirts it allows me to when it should say out of stock..in fact..I can order any number of any attribute up to 15 (the total in stock) for the item.

I think the problem might be that I'm not Overwriting/installing all the files correctly because in the readme it says to rename "includes/modules/YOUR_TEMPLATE" but in my modules folder all I see is a folder named "page" do I rename this or what? Any help on how to install it more properly is appreciated. Thanks to all.

[jill8026]

THANK YOU! This is the best thread that could have happened to me, and thanks for the link tot he thread that helps me define stock in the attributes for the customers to see what we actually have!

MY only question is formatting, how can I get the text for the attribute to sit as follows:

Name
Price
In-stock

I have not been able to figure this out at all....here is a link to a page that shows how it looks now...

http://www.ilovephotogifts.com/index...roducts_id=133

Thanks so much!!!!!!!!!!!!!!!

[Dan Lacey]

Problem with MySQL -

Hi there, thanks for the great contribution, however Im having a problem in that on my customers site I have colours and sizes with stock for each of these attributes - if I leave the attrbutes set to 'all' and add a quantity, I get the following MySQL error message:

att: 81|80|79|136,84|83|82
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE `stock_attributes` = "81,84", `quantity
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (15,"81,84",5) ON DUPLICATE KEY UPDATE `stock_attributes` = "81,84", `quantity` = 5]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

this only happens if i leave the attributes set to 'all' - if i chooses a specific colour and size and add the quantity and submit, it updates the stock levels with no problems....


Thanks in advance....
Dan.