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

[hostilerecords]

Hello, I have a problem with this addon.

I am using V4.31 of the addon and version 3.16 of Zencart.


I have installed it and then set up stock values for each attribute, however you can still checkout with variations which are out of stock, for example;

Army Camo Jacket
10 Total
5 Medium
5 Large

I can't checkout with more than 10, thats fine.
But I can checkout with 6 Medium.

How can I Fix this?

Stock config:
Check stock level- True
Subtract stock- True
Allow Checkout- False
Show stock when low- True

[s_p_ike]

Hello, problem here.

ZC 1.3.7 fresh (test installation with demo data)
Stock by Attributes 4.4

Admin config:

allow checkout false
show stock when low true

I set up a product with 1 attribute (checkbox) with 3 values, assigned each of them quantity 1, so total quantity is 3.

My product:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: yes

When I buy the product, if I select only 1 attribute, everything is ok. If I select 2 attributes, I obtain the low level alert and quantity available 0.

If I select 1st attribute, then go back to product page, select the second, then go back to product page and select the third, I've three products in my cart, one for each attribute and this would be ok, but selecting all the attributes in one step cause the alert to come out.

What's happening?

Unfortunately no url, just testing at office.

[s_p_ike]

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

in functions_lookups.php

function zen_get_products_stock processes the $attributes variable passed as argument in this way:

if(is_array($attributes) and sizeof($attributes) > 0){

....

then

$query = 'select products_attributes_id from '.TABLE_PRODUCTS_ATTRIBUTES.' '.$first_search.' and products_id="'.$products_id.'" order by products_attributes_id';
$attributes_new = $db->Execute($query);

at this point we have an array with products_attributes_id

then

while(!$attributes_new->EOF){
$stock_attributes[] = $attributes_new->fields['products_attributes_id'];
$attributes_new->MoveNext();
}
if(sizeof($stock_attributes) > 1){
$stock_attributes = implode(',',$stock_attributes);
} else {
$stock_attributes = $stock_attributes[0];
}

$stock_query = 'select quantity as products_quantity from '.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.' where products_id = "'.(int)$products_id.'" and stock_attributes="'.$stock_attributes.'"';



the problem is $stock_attributes = implode(',',$stock_attributes);

because this code is executed even if I selected only 2 values of the same checkbox attribute and when this occurs, $stock_attributes value is something like '14,15' but of course if they're 2 values of the same checkbox attribute they won't be stored in TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK in this way.

So the result of the last query will be 0, and the quantity will be 0- product_quantity, --> always marked as out of stock.

Ok, discovered the problem, now searching the solution. Any help is appreciated.

[s_p_ike]

I totally changed the approach to what I was trying to achieve: possibility to manage product with sub-products, so customers may buy the whole product or some sub-products (if bought some subproducts, then next customer would have the possibility to buy the 'whole' product but without sub-products already bought).

I achieved this by implementing some mods in categories management in admin (already heavily modified for other functionalities) and just 1 extra function and some mods in tpl_modules_product_listing.php.
Of course sub-products must have no attributes.
The 'whole' product in effect doesn't exist, it's a category containing all sub-products. But if the customer access this kind of category, he will find both products list and a "buy all available products" button which puts all products of that category in the cart (with max quantity available for each product, since this was asked to me).

For these reasons I stop working on checkbox issue.

[tbrides]

Has anybody else had any issues with this on v1.3.7. Need to know before I install it!
Thought I read somewhere that it was going to be packaged as part of 1.3.6

[gjh42]

Something like it is scheduled to be part of the v1.4 release. See the Roadmap up in Announcements.

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

[Beer_man]

[FONT=Century Gothic]Hi guys, [/FONT]

[FONT=Century Gothic]I have a need to control stock by attributes, but my requirement is a little different to most others in that I need to control one ‘pool’ of stock, with various attributes..[/FONT]

[FONT=Century Gothic]I sell grain in my shop which I buy in 25Kg sacks. My attributes are set in a drop-down so that you could by 0.25kg, 1Kg, 0.5Kg etc. [/FONT]

[FONT=Century Gothic]So if someone came and bought that lot, my stock level would need to show 23.75Kg left in stock based on stock from just one sack (i.e. not separate sources for each product in the drop down)[/FONT]

[FONT=Century Gothic]Will this module deal with this?[/FONT]

[FONT=Century Gothic]Cheers[/FONT]

[tbrides]

DJDex , do u have this installed on v1.3.7, if so is everything working ok for you?

[woodlandsprite]

[FONT=Century Gothic]Hi guys, [/FONT]

[FONT=Century Gothic]I have a need to control stock by attributes, but my requirement is a little different to most others in that I need to control one ‘pool’ of stock, with various attributes..[/FONT]

[FONT=Century Gothic]I sell grain in my shop which I buy in 25Kg sacks. My attributes are set in a drop-down so that you could by 0.25kg, 1Kg, 0.5Kg etc. [/FONT]

[FONT=Century Gothic]So if someone came and bought that lot, my stock level would need to show 23.75Kg left in stock based on stock from just one sack (i.e. not separate sources for each product in the drop down)[/FONT]

[FONT=Century Gothic]Will this module deal with this?[/FONT]

[FONT=Century Gothic]Cheers[/FONT]

BeerMan
Someone else may come and have a better answer, but I would set it up so people can buy by .25 kg quantities, and if you are offering a price break for higher volume, you can set it up for volume pricing.
that way if someone wants 1 kg, they purchase 4 .25kg "units"

For your total stock, you would enter the units available - I suspect that would be 100 x .25kg

Not sure if it is smart enough to do it as cleanly as you would like - I know there was someone on here a while back looking to sell bulk tea, but I don't for the life of me recall if they posted in the stock by attribute family of threads.

Good Luck to you.