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

The query that came with the installation only did those 3 things...

listed is the entire .sql file...

CREATE TABLE products_with_attributes_stock (
        stock_id INT NOT NULL AUTO_INCREMENT ,
        products_id INT NOT NULL ,
        stock_attributes VARCHAR( 255 ) NOT NULL ,
        quantity FLOAT NOT NULL ,
        sort INT NOT NULL ,
        PRIMARY KEY ( `stock_id` )
        );

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, 
       configuration_description, configuration_group_id, sort_order, 
       last_modified, date_added, use_function, set_function) 
       VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 
               'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
               '9',
               '6',
               NULL,
               now(),
               NULL,
               "zen_cfg_select_option(array('true', 'false'),"
       ),
       ('Display Images in Admin', 'STOCK_SHOW_IMAGE', 'false', 
               'Display image thumbnails on Products With Attributes Stock page? (warning, setting this to true can severly slow the loading of this page):',
               '9',
               '6',
               NULL,
               now(),
               NULL,
               "zen_cfg_select_option(array('true', 'false'),"
       );
       
       
       

Regardless, I ended up backing up my previous cart and I plan on tackling this at a later time. It's too time consuming and isn't a priority at this time.

Thank you for your help.

If you installed any of the 4.0 versions of SBA from free downloads with Zen Cart v1.5 then THAT is your issue.. It's been posted/document MANY times in this thread that NONE of the versions available in the free downloads work with Zen Cart v1.5..

Skippersyacht:

The query that came with the installation only did those 3 things...

listed is the entire .sql file...

CREATE TABLE products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity FLOAT NOT NULL ,
sort INT NOT NULL ,
PRIMARY KEY ( stock_id )
);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false',
'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
'9',
'6',
NULL,
now(),
NULL,
"zen_cfg_select_option(array('true', 'false'),"
),
('Display Images in Admin', 'STOCK_SHOW_IMAGE', 'false',
'Display image thumbnails on Products With Attributes Stock page? (warning, setting this to true can severly slow the loading of this page):',
'9',
'6',
NULL,
now(),
NULL,
"zen_cfg_select_option(array('true', 'false'),"
);

> 
> Thank you for your help.

:oops: that makes perfect sense now... Thank you for your help.

Skippersyacht:

:oops: that makes perfect sense now... Thank you for your help.This is why I always say it PAYS to read the support thread BEFORE installing add-ons..

Look for the SBA 5.0 thread.. Creinold has a beta version that is working..

athena:

In post #1293 I shared the following fix for zencart version 1.3.9h using the SBA version .13 - it is a no fuss no muss solution to get your store up and running. I have not worked with .14 but if you go back to 1.3.9 I highly recommend this fix. It has solved the problem for many here:

Hi Athena,

Can you elaborate if your solution actually restocks each attribute to the original quantities when an order is deleted and the option to restock is checked??? I've tested it on my store, and it does not restock. I'm using the same exact version of SBA that you're using, along with your suggested fix for the header_php.php.

The modified core file of order.php that SBA uses, is also modified by my following modules:

Fast and Easy Checkout
Super Orders

Although I've merged everything and all modules are fully functioning...my only dilemma now is when customers submit large orders as RFQ's (request for quotes), I need to be able to cancel the order and have all the items auto-restock, or else it becomes a huge hassle to manually adjust them. Thanks!

Stock by Attributes for Zen Cart V 1.5?
I recently upgraded to the most recent version of Zen Cart. Stock by Attributes doesn't seem to be compatible. Is there a newer version, or perhaps this feature is built into the new version? Any input is greatly appreciated, thank you.
Rich

Can you please post a link to where I can download the latest Stock by Attribute Addon?
thanks,
Rich

When I delete an order and check "re-stock product quantity" it does not work, any idea how to solve this problem?

ad post 1550:

the order gets deleted, but the quantity will not get re-stocked.

Just wondered if this has been upgraded to work with zen cart v1.5 yet?

I am getting this error after upgrading Stock by Attributes to 1.4.14:

1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="337" order by sort ASC;]
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.

I'm using ZC 1.3.9d. Was using Stock by Attributes 4.7 (which I found out is only listed as 1.3.8 compatible). I encountered an error where all variants listed somehow deleted themselves (they only showed up as ":" instead of the normal "Color:Red" etc). This became a problem seeing as how I would have to manually re-add hundreds of variants and stock levels for each.

So I downloaded and installed update 1.4.14, which is 1.3.9 compatible and has several fixes as well. I extracted files into my directory, overwriting them (I do have backups). Then I go to admin and see this error. I removed all option values from all products and the error was gone, but no products had attributes. I added one option value to one product and the error came back. The products_id is simply the first item when you're looking at the categories (I deleted the attributes for 337 and the next item in the list was shown). Also set all quantities for those items to 0 using easy populate and still no luck.

Has anyone had this problem before or could someone help me! The rest of the website seems fine, it's just this mod isn't working anymore.

Zen Cart ver 1.39H
Stock By Attributes ver 1.4.14

Okay, I've read through the last 530 posts and have seen this issue mentioned a couple times, but no solutions were forthcoming. First, the install went fine with no errors, product with attributes stock is in admin under catalog just as it should be, and any products that have attributes are loaded in there ready for manipulation. Now, here's the scenario:

First, all of the products in the store have the following attributes:

Gender (unisex)
Age (adult)
Color (various)

These attributes exist only to satisfy the Google feed requirements and are set to ready only and hidden. With me so far?

In addition, some products require a size attribute that is visible and selectable by the customer, IE:

Size:
(4G)
(6G)
(8G)
Etc.

Now, I can manipulate the quantity amount for the items that use only the first three, (hidden), attributes using stock by attributes just fine. Changes the number on the product listing page as it should, when one is added to the cart, it works fine and deducts it as it should. In other words, no issues with the items that only have these three attributes.

However, if I try to manipulate quantities using stock by attributes for any item that has the additional attribute of size, it causes the cart to think the quantity is zero no matter what the quantity is set as in stock by attributes. The same thing happens whether I add a quantity to one size, a couple sizes, or all sizes. If I go back in and delete the variant/s and reset the quantity on the product setup page it works fine again.

If I remove the three hidden attributes from a product with the size attribute, it then works fine. I can add sizes, change quantity of sizes, delete variant/s, etc. It then functions as it should when adding the product to the cart.

I tried athena's fix, (even though it actually addressed a different issue), of replacing header_php.php with the earlier version, but no joy.

Anybody have any ideas to fix this? Or should I just scrap it and go back to an earlier version. If the latter, what earlier version is known to work as intended in Zen 1.39h?

Okay, after dinking with this for a while, I came up with a workaround. There appears to be a bug that causes the issue to manifest itself when configuing all the attributes, (both the hidden and customer usable), simultaneously - which is the only way the mod functions until after the attributes are initially configured. The solution is to add only the user configurable attribute/s to the product in attributes controller then get the quantities set in stock by attributes. After that, add the hidden attributes from attributes controller and it works fine. Just don't go in to "add quantity for product variant", but instead only use the edit quantity link next to each of the individual option values.

This caught my eye..

RescoCCC:

First, all of the products in the store have the following attributes:

Gender (unisex)
Age (adult)
Color (various)

These attributes exist only to satisfy the Google feed requirements and are set to ready only and hidden. With me so far?I know how to make attributes read-only.. What I'm curious about is, how do you set attributes to be hidden??

Flexible Attributes mod:

http://www.zen-cart.com/downloads.php?do=file&id=1030

Further followup. Sometimes my brain is a little slow on the uptake! The only reason I had the attributes as read only is because they were only there for Google compliance and I didn't want customers trying to select them. It suddenly occured to me that since I have them hidden, that problem is moot. Took them off read only, and the issue is solved. Now the item can be configured correctly with all attributes at once in stock by attributes.

RescoCCC:

Flexible Attributes mod:

http://www.zen-cart.com/downloads.php?do=file&id=1030
Got it.. thanks..

To add to my previous post, when I click on the Sort button at top, I get the following error:

1054 Unknown column 'sort' in 'field list'
in:
[UPDATE zen_products_with_attributes_stock set sort = '' WHERE stock_id = '2' LIMIT 1;]
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.

Does that help anyone figure out what could be wrong??

I copied back over the original files and am now still getting this error... I only copied over files, did not update SQL or anything like that. I'm not sure what to do now... Any help or ideas would be appreciated!

simply_sterling:

To add to my previous post, when I click on the Sort button at top, I get the following error:

1054 Unknown column 'sort' in 'field list'
in:
[UPDATE zen_products_with_attributes_stock set sort = '' WHERE stock_id = '2' LIMIT 1;]
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.

Does that help anyone figure out what could be wrong??

I copied back over the original files and am now still getting this error... I only copied over files, did not update SQL or anything like that. I'm not sure what to do now... Any help or ideas would be appreciated!what I highlighted is probably the issue since the error indicates that the products_with_attributes_stock table is missing a column called "sort".. Perhaps updating the SQl is in order..

Is this working for v1.5.0 if so how do you set it up and do I still need the add on or is it all ready set up?

This is what im trying to do http://www.zen-cart.com/showthread.php?197465-Need-to-set-the-quantity-for-different-sizes-on-one-page