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

[SlyRick]

What version of zen-cart are you installing this on?

The latest version, 1.5. As I said in my post I had SBA installed for v1.39 of Zen-cart (Can remember version number of SBA) would this be affecting the version of your's I've installed?

[SlyRick]

Okay I see the problem. Got to fix the SQL insert for admin page registration. Will do later tonight. Sorry about that ;)

Ah sweet as will be good to get this sorted for my client (She's pregnant and overdue so stress levels are whacked ) and have it back up and running fine as.

[creinold]

Not sure what is happening, I got it to show up on my Admin menu on my clients live site without a problem, with my test site: that's a whole new story. It won't show.

I decided to move all the configuration setting into the "stock" settings in admin. IE: Configuration --> Stock

The settings have to deal with stock so I felt they best go there. Best of all don't have to register the page in Admin page since that by default is already registered.

Now getting it to show up to work in the Catalog --> Products with Stock is making me mad. LOL So for a work around type the url to get to it. (Make sure you log in to your admin first)

YourDomain.com/Admin/products_with_attributes_stock.php

I'll keep working on getting it to register on the Admin menu. I am just baffled why I can get to work on one site but not my others?

Here is an update SQL that puts the settings into the admin Stock Configuration:

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` ));

ALTER TABLE products_options 
  ADD products_options_track_stock tinyint(4) default '1' not null
  AFTER products_options_name;

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('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'),");

INSERT IGNORE INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (9, 'Stocks With Attributes', 'Stocks With Attributes', 9, 1);

INSERT IGNORE 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', '1', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false'),");

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Single Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_SINGLE', 'multiple_dropdowns', 'The plugin used for displaying attributes on the product information page.', 9, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Product Info Multiple Attribute Display Plugin', 'PRODINFO_ATTRIBUTE_PLUGIN_MULTI', 'sequenced_dropdowns', 'The plugin used for displaying attributes on the product information page.', 9, 1, now(), NULL, 'zen_cfg_select_option(array(\'single_radioset\', \'single_dropdown\',\'multiple_dropdowns\',\'sequenced_dropdowns\'),');

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Show Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_SHOW_OUT_OF_STOCK', 'True', 'Controls the display of out of stock attributes.', 9, 10, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Mark Out of Stock Attributes', 'PRODINFO_ATTRIBUTE_MARK_OUT_OF_STOCK', 'Right', 'Controls how out of stock attributes are marked as out of stock.', 9, 20, now(), NULL, 'zen_cfg_select_option(array(\'None\', \'Right\', \'Left\'),');

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Display Out of Stock Message Line', 'PRODINFO_ATTRIBUTE_OUT_OF_STOCK_MSGLINE', 'True', 'Controls the display of a message line indicating an out of stock attributes is selected.', 9, 30, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');

INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Prevent Adding Out of Stock to Cart', 'PRODINFO_ATTRIBUTE_NO_ADD_OUT_OF_STOCK', 'True', 'Prevents adding an out of stock attribute combination to the cart.', 9, 40, now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'),');

INSERT IGNORE INTO `configuration` VALUES (1286, 'Disable drop down menu when stock equals zero', 'sba_zero_disable ', 'true', 'Set drop down menu to automatically disable when the attribute quantity equals zero:', 9, 6, '2010-07-25 15:29:27', '2010-07-25 14:44:56', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

# Register the pages for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('products with attributes stock', 'BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK', 'FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK', '', 'catalog', 'Y', 100);

[creinold]

Update to my files including the last SQL I posted in post above:

http://www.sidewalkstyles.com/Stock_...V1.5.0alpha1.3

[SlyRick]

Update to my files including the last SQL I posted in post above:

http://www.sidewalkstyles.com/Stock_...V1.5.0alpha1.3

Link doesn't work and the SQL patch gives me

WARNING: An Error occurred, please refresh the page and try again.

[creinold]

Need to use phpadmin to delete these table:

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` ));


and this column:
ALTER TABLE products_options
ADD products_options_track_stock tinyint(4) default '1' not null
AFTER products_options_name;

Then run the SQL again

I re-uploaded file. Seems to download okay for me?

[callmeal]

Hi, I updated my cart (version v1.3.9e) with Version: 1.4.14 of Stock by Attributes. I am also using a free template from picaflor.

I'm a total newbie at this so sorry if this is a stupid question. I think I have installed the files correctly, as I'm getting the stock and products with attributes stock menus, and I've tried adding a few quantities for a few attributes (size ones) - but when i get to my website it still doesn't show? I choose a size in the dropdown, but the quantity available doesn't update... effectively in the actual website I can't see anything indicating the stock level by attribute. The website is jibadoo.com.au/products.

Help anybody?

[Sheryll]

To register the page here's the edit:

# Register the pages for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('products with attributes stock', 'BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK', 'FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK', '', 'catalog', 'Y', 100);

remove 'CATALOG' from 'language_key': 'BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK' should be 'BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK'

-OR-

To do it manually on Admin Page Registration page, enter the following values:

Page Key: products with attributes stock
Page Name: BOX_PRODUCTS_WITH_ATTRIBUTES_STOCK
Page Filename: FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK
Page Parameters: [leave blank]
Menu (select): Catalog
Display on Menu?: [check]
Sort Order: 999

Thank you creinold for your fix, it works for me on v1.5, however, there's just one thing:

On the product info page, I have 2 attributes options. The new drop down versions and the old radio button options. How do I get rid of the old radio button option?

Thanks again for your help, I wouldn't have been able to get this far without your efforts.

[Sheryll]

One more thing, I'm assuming the dynamic drop down menu is supposed to be ajax based. The function doesn't seem to be working though for example length + color option. If the user selects the length option first, the colors drop down menu should refresh to display the available colors that are in stock.

This is beyond the scope of my knowledge so I'm unable to troubleshoot further. I wouldn't know how to check if it's an ajax problem or sql problem.

[Sheryll]

You can ignore the previous post, I got the it to work.