Dependant Attributes - Can I do this?

kuroi:

The products_with_attributes_stock table is inserted by the SQL for stock_by_attributes. If you can't see it in your database, that means a problem with your stock_by_attributes installation. This problem would need to be resolved before you can get any further with dependant attributes. Did you run the stock_by_attributes SQL? Did it give you any errors? Did you run it though a database management tool, phpMyAdmin or the install SQL patch function in the Admin?

Thank you SO MUCH for responding. I did not try re-installing the stock_by_attributes module. I will try that now and post again.

Jan51:

Is the second dropdown box dependent on the first one? For example, can size small in the first drop-down box have one set of colors in the second box and size 5XL have a second set of colors? Or are the values in the second box the same regardless of what is chosen in the first box? If these are TRULY dependent dropdown boxes, I have been waiting for this for years! I haven't been able to use Zen Cart because the only workaround I've been able to live with is to use stock levels to control color choices for different sizes. I was only able to do it with some special mods I got for CubeCart. If dependent attributes are available in Zen, I will definitely switch!

Yes, the values in the 2nd box are dependent on what is selected in the first box.

As an update, I do have this working now. THANKS!

So has anyone tried this for three different attributes?

Example: Style, Size, Color.

Thanks

VCSharpin:

Yes, the values in the 2nd box are dependent on what is selected in the first box.

How do you choose which order is dependant on which?

My options sort order Size 1, Colour 5 but they first drop down is colour and the second one is size. Is it working on the alpha name of the option?

Christine

VCSharpin:

As an update, I do have this working now. THANKS!

I saw your site and it works great! However, I cannot seem to get the dependent attributes to work on mine...any advice to what you did?

Oakwood:

I saw your site and it works great! However, I cannot seem to get the dependent attributes to work on mine...any advice to what you did?

There are two steps to the install. First you have to install the stock_by_attributes module. Then you have to install the dependent attributes module.

I did not install the other stock_by_attributes module first. It's in the instructions for the dependent attributes module, but it's easy to miss.

I installed the latest release of both mods, but no dice. Im testing it now, with a product, (size - mens or ladies; color - white, green, black). Set all at 1000 execpt mens black and ladies green, which I set to zero.

I noticed that on your site in the source code, there is javascript running on the attributes table, but not on mine...but I'm still not certain what I did wrong.

Hi there...I've installed this and it i don't get any errors but it doesn't work properly either. I have 4 attributes and when i view the product i see 4 dropdowns instructing me to select the first attribute. when i click the dropdown for the first attribute they are listed correctly. if i select an attribute and then proceed to the second attribute there is nothing listed in the dropdown. it still says select the first attribute. it seems that after selecting the first attribute it's not refreshing the other drop downs.

Check your Products with Attributes option under Catalog. Make sure that all four attributes are checked off as defining what determines stock. I had a similar problem when I only selected 1 of the 2 options on that screen.

VCSharpin:

As an update, I do have this working now. THANKS!

Hello,

I have a fresh install of 1.3.8 and really need this dynamic drop downs to function before I start really adding content.

I have been getting the error message on the product page

"1146 Table 'mydb.TABLE_PRODUCTS_STOCK' doesn't exist
in:
[select quantity from TABLE_PRODUCTS_STOCK where products_id = '1' AND quantity > 0]"

I do have both stock_by_attributes and dynamic drop down installed. I have read through these forums but nothing in here seems to help. Tried modifying the "includes/database_tables.php" by adding... define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

This only resulted in a completely white screen.

How do I get this working?

Many thanks!

dthomas:

Hello,

I have a fresh install of 1.3.8 and really need this dynamic drop downs to function before I start really adding content.

I have been getting the error message on the product page

"1146 Table 'mydb.TABLE_PRODUCTS_STOCK' doesn't exist
in:
[select quantity from TABLE_PRODUCTS_STOCK where products_id = '1' AND quantity > 0]"

I do have both stock_by_attributes and dynamic drop down installed. I have read through these forums but nothing in here seems to help. Tried modifying the "includes/database_tables.php" by adding... define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

This only resulted in a completely white screen.

How do I get this working?

Many thanks!

You will need to add the define to database_tables.php. This is what my file looks like...

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

hello,

I have the same problem that dthomas.

I have modified the includes/database_tables.php but to me it continues leaving something similar on the product page info:

"1146 Table 'prueba.products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN products_attributes AS b ON (b.options_id=1 AND b.options_values_id=16) WHERE a.products_id = '158' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]"

I have installed Zencart 1,38 with the contributions Stock by Attributes 4-7MULTIADD and Dynamic DropDowns.

Some aid?

thx!

Hi - I have other attributes installed on a Cherry-Zen site; will installing this affect those in any way?
Rufusclc

Does "products_with_attributes_stock" exist in your database?

Cal

no, I dont see it.

rufusclc:

no, I dont see it.

K, I think that suggests that you did not fully install the Stock by Attributes contribution.

Hi ModernM, I'm hunting you down, LOL.

I've installed the dynamic drop downs for attributes stock.

Do you know why, once installed, the attribute images no longer show up, but only when using the sequenced drop downs?

See here:
http://www.monkeypantskids.com/large-fuzzi-bunz-perfect-size-diaper-p-4.html

and then click to go to the next product. One shows the images, one does not.

I want all attribute images to show up at all times, whether or not the attribute option is in stock, but I can't for the life of me get it to happen.

Thanks!

Also, is there a way to add the number in stock next to each drop down item?

jettrue:

Hi ModernM, I'm hunting you down, LOL.

I've installed the dynamic drop downs for attributes stock.

Do you know why, once installed, the attribute images no longer show up, but only when using the sequenced drop downs?

See here:
http://www.monkeypantskids.com/large-fuzzi-bunz-perfect-size-diaper-p-4.html

and then click to go to the next product. One shows the images, one does not.

I want all attribute images to show up at all times, whether or not the attribute option is in stock, but I can't for the life of me get it to happen.

Thanks!

Also, is there a way to add the number in stock next to each drop down item?
I figured it out. Took a while.

in includes/templates/YOUR_TEMPLATE/templates/tpl_modules_attributes.php I changed this:

<?php
if ($options_attributes_image[$i] != '') {
?>
<?php echo $options_attributes_image[$i]; ?>
<?php
}
?>

to this:

<?php
for($i=0;$i<sizeof($options_name);$i++) {
if ($options_attributes_image[$i] != '') {
echo $options_attributes_image[$i]; 
}
}
?>

Hello!

How works this Dynamic Drop Downs.

Can You send me an Example!

Thanks