Stock For Product With Different Attributes (OLD)

I'm no expert with this contribution, but I think this is the first time someone has mentioned wanted to have checkbox attributes, and allow the customer to choose more than one option. I'm wondering if this is even possible with this?

What I would do, is just do it as a dropdown menu. Then if your customer wants to have both the 138 yard and the 140 yard, then they can just add one to the cart, then add the other to the cart.

Stock For Product With Different Attributes:

If I have a product that has 5 attribtes and each attribute has between 12 and 20 values. Can I mark this product so it doesn't use this module? Right now if I leave no values on the attributes but I put in a quantity number on the product, when they add to cart it shows out of stock. It doesn't show out of stock on the product listing but when they add to cart it does.

There are hundreds of possible combinations on this that I just can't go through and set a quantity on each item.

Any ideas? Thanks.

Read back through the pages... someone else had the same situation and aparantly solved it.

- Steven

I have read the whole thread twice and can't find the answer to a question that was posed on page 5 and I have having the same problem. I get this message
1146 Table 'XXXXX.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist.
The table has been set up correctly under zen1_. So I don't know why it is looking for Table XXXXX.

Also, under Catalog I am getting BOX_CATALOG_PRODUCTS instead of Products with Attributes.

When I click on BOX_CATALOG_PRODUCTS I can only see one product in there, when there should be about 100. This is what I see:
1146 Table 'XXXXX.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
Product ID Product Name Quantity of all variants Add Quantity For Product Variant Sync Quantities
41 Flower Pots 999 Add Quantity For Product Variant Sync Quantities

And because the table "does not exist" I am unable to do anything.

Can someone please point me in the right direction. Thanks heaps.

In the sql commands that you used, try again without any prefix.

I am not very familiar with MySQL so sorry I have to ask the question.

By prefix do you mean the
CREATE TABLE `[COLOR=red]zen[/COLOR=red]_products_with_attributes_stock` (
`stock_id` INT NOT NULL AUTO_INCREMENT ,
`products_id` INT NOT NULL ,
`stock_attributes` VARCHAR( 255 ) NOT NULL ,
`quantity` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
)
I remove the word zen. If so, I tried that and still the same problem.

That's right, but did you remove the _ too?

get rid of "zen_" not just "zen"

- Steven

I tried that, but surely setting up the table without the "zen-" it would not read from the other zen_ tables.

It did not work either.

Copy of catalog_dhtml.php
$za_contents = array();
$za_heading = array('text' => BOX_HEADING_CATALOG, 'link' => zen_href_link(FILENAME_ALT_NAV, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_PRODUCTS, 'link' => zen_href_link(FILENAME_CATEGORIES, '', 'NONSSL'));
// Edit
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK, 'link' => zen_href_link(FILENAME_PRODUCTS_WITH_ATTRIBUTES_STOCK, '', 'NONSSL'));
// end edit
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_TYPES, 'link' => zen_href_link(FILENAME_PRODUCT_TYPES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_PRICE_MANAGER, 'link' => zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_OPTIONS_NAME_MANAGER, 'link' => zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_OPTIONS_VALUES_MANAGER, 'link' => zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_ATTRIBUTES_CONTROLLER, 'link' => zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_CATEGORIES_ATTRIBUTES_DOWNLOADS_MANAGER, 'link' => zen_href_link(FILENAME_DOWNLOADS_MANAGER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_OPTIONS_NAME, 'link' => zen_href_link(FILENAME_PRODUCTS_OPTIONS_NAME, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCT_OPTIONS_VALUES, 'link' => zen_href_link(FILENAME_PRODUCTS_OPTIONS_VALUES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_MANUFACTURERS, 'link' => zen_href_link(FILENAME_MANUFACTURERS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_REVIEWS, 'link' => zen_href_link(FILENAME_REVIEWS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_SPECIALS, 'link' => zen_href_link(FILENAME_SPECIALS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_FEATURED, 'link' => zen_href_link(FILENAME_FEATURED, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_SALEMAKER, 'link' => zen_href_link(FILENAME_SALEMAKER, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => zen_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL'));


if ($za_dir = @dir(DIR_WS_BOXES . 'extra_boxes')) {
while ($zv_file = $za_dir->read()) {
if (preg_match('/catalog_dhtml.php$/', $zv_file)) {
require(DIR_WS_BOXES . 'extra_boxes/' . $zv_file);
}
}
}

?>
<!-- catalog //-->
<?php
echo zen_draw_admin_box(&#036;za_heading, &#036;za_contents);
?>
&#60;&#33;-- catalog_eof //--&#62;



Copy of database tables.php

// define the database table names used in the project
if (&#33;defined(&#39;DB_PREFIX&#39;)) define(&#39;DB_PREFIX&#39;, &#39;&#39;);
define(&#39;TABLE_ADDRESS_BOOK&#39;, DB_PREFIX . &#39;address_book&#39;);
define(&#39;TABLE_ADMIN&#39;, DB_PREFIX . &#39;admin&#39;);
define(&#39;TABLE_ADMIN_ACTIVITY_LOG&#39;, DB_PREFIX . &#39;admin_activity_log&#39;);
define(&#39;TABLE_ADDRESS_FORMAT&#39;, DB_PREFIX . &#39;address_format&#39;);
define(&#39;TABLE_AUTHORIZENET&#39;, DB_PREFIX . &#39;authorizenet&#39;);
define(&#39;TABLE_BANNERS&#39;, DB_PREFIX . &#39;banners&#39;);
define(&#39;TABLE_BANNERS_HISTORY&#39;, DB_PREFIX . &#39;banners_history&#39;);
define(&#39;TABLE_CATEGORIES&#39;, DB_PREFIX . &#39;categories&#39;);
define(&#39;TABLE_CATEGORIES_DESCRIPTION&#39;, DB_PREFIX . &#39;categories_description&#39;);
define(&#39;TABLE_CONFIGURATION&#39;, DB_PREFIX . &#39;configuration&#39;);
define(&#39;TABLE_CONFIGURATION_GROUP&#39;, DB_PREFIX . &#39;configuration_group&#39;);
define(&#39;TABLE_COUNTER&#39;, DB_PREFIX . &#39;counter&#39;);
define(&#39;TABLE_COUNTER_HISTORY&#39;, DB_PREFIX . &#39;counter_history&#39;);
define(&#39;TABLE_COUNTRIES&#39;, DB_PREFIX . &#39;countries&#39;);
define(&#39;TABLE_COUPON_GV_QUEUE&#39;, DB_PREFIX . &#39;coupon_gv_queue&#39;);
define(&#39;TABLE_COUPON_GV_CUSTOMER&#39;, DB_PREFIX . &#39;coupon_gv_customer&#39;);
define(&#39;TABLE_COUPON_EMAIL_TRACK&#39;, DB_PREFIX . &#39;coupon_email_track&#39;);
define(&#39;TABLE_COUPON_REDEEM_TRACK&#39;, DB_PREFIX . &#39;coupon_redeem_track&#39;);
define(&#39;TABLE_COUPON_RESTRICT&#39;, DB_PREFIX . &#39;coupon_restrict&#39;);
define(&#39;TABLE_COUPONS&#39;, DB_PREFIX . &#39;coupons&#39;);
define(&#39;TABLE_COUPONS_DESCRIPTION&#39;, DB_PREFIX . &#39;coupons_description&#39;);
define(&#39;TABLE_CURRENCIES&#39;, DB_PREFIX . &#39;currencies&#39;);
define(&#39;TABLE_CUSTOMERS&#39;, DB_PREFIX . &#39;customers&#39;);
define(&#39;TABLE_CUSTOMERS_BASKET&#39;, DB_PREFIX . &#39;customers_basket&#39;);
define(&#39;TABLE_CUSTOMERS_BASKET_ATTRIBUTES&#39;, DB_PREFIX . &#39;customers_basket_attributes&#39;);
define(&#39;TABLE_CUSTOMERS_INFO&#39;, DB_PREFIX . &#39;customers_info&#39;);
define(&#39;TABLE_DB_CACHE&#39;, DB_PREFIX . &#39;db_cache&#39;);
define(&#39;TABLE_EMAIL_ARCHIVE&#39;, DB_PREFIX . &#39;email_archive&#39;);
define(&#39;TABLE_FEATURED&#39;, DB_PREFIX . &#39;featured&#39;);
define(&#39;TABLE_FILES_UPLOADED&#39;, DB_PREFIX . &#39;files_uploaded&#39;);
define(&#39;TABLE_GROUP_PRICING&#39;, DB_PREFIX . &#39;group_pricing&#39;);
define(&#39;TABLE_GET_TERMS_TO_FILTER&#39;, DB_PREFIX . &#39;get_terms_to_filter&#39;);
define(&#39;TABLE_LANGUAGES&#39;, DB_PREFIX . &#39;languages&#39;);
define(&#39;TABLE_LAYOUT_BOXES&#39;, DB_PREFIX . &#39;layout_boxes&#39;);
define(&#39;TABLE_MANUFACTURERS&#39;, DB_PREFIX . &#39;manufacturers&#39;);
define(&#39;TABLE_MANUFACTURERS_INFO&#39;, DB_PREFIX . &#39;manufacturers_info&#39;);
define(&#39;TABLE_META_TAGS_PRODUCTS_DESCRIPTION&#39;, DB_PREFIX . &#39;meta_tags_products_description&#39;);
define(&#39;TABLE_NEWSLETTERS&#39;, DB_PREFIX . &#39;newsletters&#39;);
define(&#39;TABLE_ORDERS&#39;, DB_PREFIX . &#39;orders&#39;);
define(&#39;TABLE_ORDERS_PRODUCTS&#39;, DB_PREFIX . &#39;orders_products&#39;);
define(&#39;TABLE_ORDERS_PRODUCTS_ATTRIBUTES&#39;, DB_PREFIX . &#39;orders_products_attributes&#39;);
define(&#39;TABLE_ORDERS_PRODUCTS_DOWNLOAD&#39;, DB_PREFIX . &#39;orders_products_download&#39;);
define(&#39;TABLE_ORDERS_STATUS&#39;, DB_PREFIX . &#39;orders_status&#39;);
define(&#39;TABLE_ORDERS_STATUS_HISTORY&#39;, DB_PREFIX . &#39;orders_status_history&#39;);
define(&#39;TABLE_ORDERS_TYPE&#39;, DB_PREFIX . &#39;orders_type&#39;);
define(&#39;TABLE_ORDERS_TOTAL&#39;, DB_PREFIX . &#39;orders_total&#39;);
define(&#39;TABLE_PAYPAL&#39;, DB_PREFIX . &#39;paypal&#39;);
define(&#39;TABLE_PAYPAL_SESSION&#39;, DB_PREFIX . &#39;paypal_session&#39;);
define(&#39;TABLE_PAYPAL_PAYMENT_STATUS&#39;, DB_PREFIX . &#39;paypal_payment_status&#39;);
define(&#39;TABLE_PAYPAL_PAYMENT_STATUS_HISTORY&#39;, DB_PREFIX . &#39;paypal_payment_status_history&#39;);
define(&#39;TABLE_PRODUCTS&#39;, DB_PREFIX . &#39;products&#39;);
define(&#39;TABLE_PRODUCT_TYPES&#39;, DB_PREFIX . &#39;product_types&#39;);
define(&#39;TABLE_PRODUCT_TYPE_LAYOUT&#39;, DB_PREFIX . &#39;product_type_layout&#39;);
define(&#39;TABLE_PRODUCT_TYPES_TO_CATEGORY&#39;, DB_PREFIX . &#39;product_types_to_category&#39;);
define(&#39;TABLE_PRODUCTS_ATTRIBUTES&#39;, DB_PREFIX . &#39;products_attributes&#39;);
define(&#39;TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD&#39;, DB_PREFIX . &#39;products_attributes_download&#39;);
define(&#39;TABLE_PRODUCTS_DESCRIPTION&#39;, DB_PREFIX . &#39;products_description&#39;);
define(&#39;TABLE_PRODUCTS_DISCOUNT_QUANTITY&#39;, DB_PREFIX . &#39;products_discount_quantity&#39;);
define(&#39;TABLE_PRODUCTS_NOTIFICATIONS&#39;, DB_PREFIX . &#39;products_notifications&#39;);
define(&#39;TABLE_PRODUCTS_OPTIONS&#39;, DB_PREFIX . &#39;products_options&#39;);
define(&#39;TABLE_PRODUCTS_OPTIONS_VALUES&#39;, DB_PREFIX . &#39;products_options_values&#39;);
define(&#39;TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS&#39;, DB_PREFIX . &#39;products_options_values_to_products_options&#39;);
define(&#39;TABLE_PRODUCTS_OPTIONS_TYPES&#39;, DB_PREFIX . &#39;products_options_types&#39;);
define(&#39;TABLE_PRODUCTS_TO_CATEGORIES&#39;, DB_PREFIX . &#39;products_to_categories&#39;);
define(&#39;TABLE_PROJECT_VERSION&#39;, DB_PREFIX . &#39;project_version&#39;);
define(&#39;TABLE_PROJECT_VERSION_HISTORY&#39;, DB_PREFIX . &#39;project_version_history&#39;);
define(&#39;TABLE_QUERY_BUILDER&#39;, DB_PREFIX . &#39;query_builder&#39;);
define(&#39;TABLE_REVIEWS&#39;, DB_PREFIX . &#39;reviews&#39;);
define(&#39;TABLE_REVIEWS_DESCRIPTION&#39;, DB_PREFIX . &#39;reviews_description&#39;);
define(&#39;TABLE_SALEMAKER_SALES&#39;, DB_PREFIX . &#39;salemaker_sales&#39;);
define(&#39;TABLE_SESSIONS&#39;, DB_PREFIX . &#39;sessions&#39;);
define(&#39;TABLE_SPECIALS&#39;, DB_PREFIX . &#39;specials&#39;);
define(&#39;TABLE_TEMPLATE_SELECT&#39;, DB_PREFIX . &#39;template_select&#39;);
define(&#39;TABLE_TAX_CLASS&#39;, DB_PREFIX . &#39;tax_class&#39;);
define(&#39;TABLE_TAX_RATES&#39;, DB_PREFIX . &#39;tax_rates&#39;);
define(&#39;TABLE_GEO_ZONES&#39;, DB_PREFIX . &#39;geo_zones&#39;);
define(&#39;TABLE_ZONES_TO_GEO_ZONES&#39;, DB_PREFIX . &#39;zones_to_geo_zones&#39;);
define(&#39;TABLE_UPGRADE_EXCEPTIONS&#39;, DB_PREFIX . &#39;upgrade_exceptions&#39;);
define(&#39;TABLE_WISHLIST&#39;, DB_PREFIX . &#39;customers_wishlist&#39;);
define(&#39;TABLE_WHOS_ONLINE&#39;, DB_PREFIX . &#39;whos_online&#39;);
define(&#39;TABLE_ZONES&#39;, DB_PREFIX . &#39;zones&#39;);

define(&#39;TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK&#39;, DB_PREFIX . &#39;products_with_attributes_stock&#39;);

?>

ginar,

I had the exact same problem you are having. I went back to the mysql panel from my server and I changed the create table from:
CREATE TABLE `zen_products_with_attributes_stock` (
`stock_id` INT NOT NULL AUTO_INCREMENT ,
`products_id` INT NOT NULL ,
`stock_attributes` VARCHAR( 255 ) NOT NULL ,
`quantity` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
)

to exactly what my error message said it couldn&#39;t find, in your case:
1146 Table &#39;XXXXX.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK&#39; doesn&#39;t exist.

So I changed my create table to:

CREATE TABLE `TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK` (
`stock_id` INT NOT NULL AUTO_INCREMENT ,
`products_id` INT NOT NULL ,
`stock_attributes` VARCHAR( 255 ) NOT NULL ,
`quantity` INT NOT NULL ,
PRIMARY KEY ( `stock_id` )
)

I used ALL CAPITAL letters just like my error message. I don&#39;t know if it is case sensitive or not but when I deleted the previous table I created and then re-created the new one it started working fine for me.

Hope this helps

I read through the whole thread and found two entries about this same question:

=====================
Just wanted to see if anyone has a suggestion for a case where I have certain products of unlimited quantity with about 200 attributes. It&#39;s a candle site and the candles are made to order so we don&#39;t need to list a quantity for each scent - it is unlimited. I don&#39;t really want to create a new entry for each one with quantity of 1,000,000 or something. Seems like there&#39;s got to be a way to have it ignore stock for certain items/attributes. Any thoughts?


I had a similar problem. There were some attributes I did not want to include in my stock count for certain products and there were products I just did not track stock for since they were always available.

I modifed the contrib so that it only includes the attributes that you want for the products that you want.

You can control this behavior through the attributes control panel. I basically added a switch in the panel to either include the attribute in the stock count or ignore it. (Trying to see if there is a way to control the count here too.)

I did have to modfiy some core functions to do this however, but it works like a champ. I am working on packaging it into soemthing readable as it is a lot of hacked code at this point.

As soon as it is ready I will post a link to download.

======================

And

======================
hmmm... if I added this mod to my doorknobs site how long would it take to enter all the possible product combinations?

Take one product for example: a simple doorknob set can have:
1 of 4 functions
1 of 2 backsets
1 of 2 door handings
1 of 15 outside finishes
1 of 15 inside finishes
1 of 36 outside knobs/levers
1 of 36 inside knobs/levers
1 of 12 rosettes on outside
1 of 12 rosettes on inside
too many choices to figure out on my fingers, but the trusty old calculator says that&#39;s a total of 671,846,400 possible combinations. Damn good thing they&#39;re made to order: I wouldn&#39;t want to have even one of each possible combination in stock...
=========================

That was a long read&#33; 40+ pages. Neither of these posts really help me or tell me how to fix the problem I have with the product with multiple 5 attributes with 12-20 values in each. Is there a way to just tell that product not to use this contrib?

Any additions to these? Thanks.