Dependant Attributes - Can I do this?

Hi - I am new to the firum and would like to ask a pre-sale type question.

Does anyone know whether Zen Cart will do the following or can someone code this option for me?

I have a number of T Shirt designs which are all available on Unisex T Shirts, Kids T Shirts, Hoodies etc

What I need is the ability for a customer to intially choose a design, then choose a garment and depending on what they choose, the next option would only show sizes and colours that relate to the choice of garment the customer made.

Does anyone know whether this can be done?

I have tried Cube Cart but it will not allow me to achieve this, hopefully Zen Cart will :)

Regards
Marc

www.dogsndubs.com

I just spent about 2 hours researching this, and came up empty handed. It appears that Zen Cart does not offer this at all, and it doesn't appear to be on the list of goals for the next year or two of development. I couldn't find any module add-ons that offered this either. AND I couldn't find any other free shopping cart solutions that had this functionality. D'oh!

You're left with basically 3 options:

1) Use notes in the drop-downs to tell the customers when options aren't available, e.g. "Royal Blue (Unisex Only)". This is the method I'm currently using, but it's not a very good one - customers are dumb (or not web-savvy, at least) and often pick attributes clearly labeled as invalid.

2) Separate top-tier attributes into categories. In this case you'd have a category for Hoodies, a category for Ladies' Cut, etc. This could be a fairly good solution depending on how many different options you want to have (too many and it'd get cluttered). This also assumes you only have 1 level of dependency - meaning that, different options are set for Hoodies/Ladies'/Kid's, but don't depend on anything else. If your colors ALSO depend on size, for example, this method would be too messy to use.

3) Code it. Either figure out the PHP or Javascript code to make it happen yourself, or pay someone to do it. This is the method I'll employ when I have the time to do so, but that could be a while. I also don't know how easy it would be to modify something like this and still make it 'external' enough to upgrade easily; you might have to do some extra manual steps each time you update, depending.



On a side note, this question should really be in the FAQ (if it's in there, I sure didn't see it). I've seen this asked a LOT here when I was searching for past posts in the topic, and they usually either go unanswered or are answered with "Zen Cart doesn't currently support dependent attributes".

Zencart's attributes feature in the current version, does not enable field validation on input.

I believe the devs are looking at putting it into the next version...

For two sets of attributes, you can use the Product Attribute Grid mod to display the available combinations.

Good point Glenn... I forgot about this!

Check out Dynamic Drop Downs for Stock by Attributes in the contrib section. The sequenced drop downs work great for multiple attributes. Use the single drop down for single attributes and have the ability to show out of stock next to the attribute.


Cal

Here is an example of the Dynamic Drop Downs contrib in action...


http://www.modernmunchkin.com/mix-ma...hirts-198.html


Cal

Hi - Thanks everybody for your replies. Sorry I didn't reply earlier - computer and work problems :(

I will look into the options you have suggested and see if I can work around it using the mods.

Thanks again.:smile:

Quote:

---

Originally Posted by modernm

Check out Dynamic Drop Downs for Stock by Attributes in the contrib section. The sequenced drop downs work great for multiple attributes. Use the single drop down for single attributes and have the ability to show out of stock next to the attribute.


Cal

---

Hi, this feature is great. I tried installed it in my testing store which was runing with stock by attributes well. After installation, this message appear after the product description, and do not show the product attributes:

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

any idea on this?

Thanks.

This is a problem with the integration of the osCommerce based product attribute dropdown mod into Zen Cart. in the current version of the mod (1.3) line 87 of the pad_sequenced_dropdowns.php class calls for data from a table that doesn't exist in Zen Cart or Stock by Attributes. Hopefully modernm will pop back and fix that.

Quote:

---

Originally Posted by uvfch

Hi, this feature is great. I tried installed it in my testing store which was runing with stock by attributes well. After installation, this message appear after the product description, and do not show the product attributes:

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

any idea on this?

Thanks.

---

Add the following line to includes/database_tables.php

Code:

---

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

---

Cal

Quote:

---

Originally Posted by modernm

Add the following line to includes/database_tables.php

Code:

---

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

---

Cal

---

I was hoping that it would turn out to be something straightforward like this ... though rather than editing a core and non-overwriteable file, it would be better to change the pad_sequenced_dropdowns.php class to select from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK instead of TABLE_PRODUCTS_STOCK.

Quote:

---

Originally Posted by uvfch

Hi, this feature is great. I tried installed it in my testing store which was runing with stock by attributes well. After installation, this message appear after the product description, and do not show the product attributes:

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

any idea on this?

Thanks.

---

Quote:

---

Originally Posted by kuroi

I was hoping that it would turn out to be something straightforward like this ... though rather than editing a core and non-overwriteable file, it would be better to change the pad_sequenced_dropdowns.php class to select from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK instead of TABLE_PRODUCTS_STOCK.

---

Your absolutely right. When I free this week I will do some clean up of the contrib and update it.

Cal

Cal, you should be kissed! I can't wait to see this mod! It's been driving me beserk for the last three weeks...

I've installed this mod and have the following error:

1146 Table 'multiplayeru.products_with_attributes_stock' doesn't exist in: [select quantity from products_with_attributes_stock where products_id='182' AND quantity > 0]

Thanks in advance!

Quote:

---

Originally Posted by VCSharpin

I've installed this mod and have the following error:

1146 Table 'multiplayeru.products_with_attributes_stock' doesn't exist in: [select quantity from products_with_attributes_stock where products_id='182' AND quantity > 0]

---

It sounds as though you have a problem with your Stock by Attributes installation. Recheck that you have followed the step for installing the SQL patch.

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!

Quote:

---

Originally Posted by kuroi

It sounds as though you have a problem with your Stock by Attributes installation. Recheck that you have followed the step for installing the SQL patch.

---

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

Here's the link to my page if you want to see the error in action:
http://www.multiplayeru.com/index.ph...roducts_id=182

Thanks in advance!

Quote:

---

Originally Posted by VCSharpin

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

Here's the link to my page if you want to see the error in action:
http://www.multiplayeru.com/index.ph...roducts_id=182

Thanks in advance!

---

I still need assistance with this. I reinstalled everything, same error. I backed everything out so going to my site won't show the error any longer. If I can't get this to work I may have to change ecommerce solutions, and I really don't want to do that since I use zen for my other site.

Thanks!

Quote:

---

Originally Posted by VCSharpin

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

---

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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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...

Code:

---


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.

Quote:

---

Originally Posted by 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...iaper-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?

Quote:

---

Originally Posted by 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...iaper-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:

Code:

---

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

---

to this:

Code:

---

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

I'm experimenting with this right now, and it (sort of) works..

I see the selection boxes, the first one is fully populated, but the second one doesn't include all possible variants..

Right now I'm just a bit too tired of setting up everything that I can't really see straight and follow the code, so please give me some advice here..
:(

The generated selection box code on the page is this:

HTML Code:

---

<!--bof Attributes Module -->
<div id="productAttributes">
  <table border="0" cellspacing="0" cellpadding="2">
    <tr>
      <td class="main" colspan="2"><b>Glöm inte att välja: </b></td>
    </tr>
    <tr>
      <td align="right" class="main"><b>Storlek:</b></td>
      <td class="main"><select name="id[1]" onchange="i1(this.form);">
          <option value="0" selected="selected">First select Storlek</option>
          <option value="1">8½</option>
          <option value="2">9</option>
          <option value="3">9½</option>
          <option value="4">10</option>
          <option value="5">10½</option>
          <option value="6">11</option>
        </select></td>
    </tr>
    <tr>
      <td align="right" class="main"><b>Färg:</b></td>
      <td class="main"><select name="id[2]">
          <option value="0" selected="selected">Next select Färg</option>
        </select></td>
    </tr>
    <tr>
      <td colspan="2">&nbsp;
        <script type="text/javascript" language="javascript"><!--
  var stk={1:{8:1,9:1,13:1},2:{8:1,9:1,13:1},3:{8:1,9:1,13:1},4:{8:1,9:1,13:1},5:{8:1,9:1,13:1},6:{8:1,9:1,13:1}};
  var txt2={8:'Svart ',9:'Barely black ',11:'Platina ',12:'Choklad ',13:'Brons '};
  function i1(frm) {
    frm['id[2]'].length=1;
    for (opt in stk[frm['id[1]'].value]) {
      frm['id[2]'].options[frm['id[2]'].length]=new Option(txt2[opt],opt);
    }
  }
  i1(document.cart_quantity);
  function chksel() {
    var ok=true;
    if (this['id[1]'].value==0) ok=false;
    if (this['id[2]'].value==0) ok=false;
    if (!ok) alert('Du måste välja vilken storlek, färg med mera du vill ha.');
    return ok;
  }
  document.cart_quantity.onsubmit=chksel;
//--></script></td>
    </tr>
  </table>
  <br class="clearBoth" />
</div>
<!--eof Attributes Module -->

---

But the database contains the proper values, and as far as I can see, quite some more options to choose from in the second selection box.

Code:

---

stock_id ; products_id ; stock_attributes ; quantity ;
1 ; 4 ; 1,7 ; 500000
2 ; 4 ; 2,7 ; 500000
3 ; 4 ; 3,7 ; 500000
4 ; 4 ; 4,7 ; 500000
5 ; 4 ; 5,7 ; 500000
6 ; 4 ; 6,7 ; 500000
7 ; 4 ; 1,8 ; 500000
8 ; 4 ; 2,8 ; 500000
9 ; 4 ; 3,8 ; 500000
10 ; 4 ; 4,8 ; 500000
11 ; 4 ; 5,8 ; 500000
12 ; 4 ; 6,8 ; 500000
13 ; 4 ; 11,1 ; 500000
14 ; 4 ; 11,2 ; 500000
15 ; 4 ; 11,3 ; 500000
16 ; 4 ; 11,4 ; 500000
17 ; 4 ; 11,5 ; 500000
18 ; 4 ; 11,6 ; 500000
19 ; 4 ; 10,1 ; 500000
20 ; 4 ; 10,2 ; 500000
21 ; 4 ; 10,3 ; 500000
22 ; 4 ; 10,4 ; 500000
23 ; 4 ; 10,5 ; 500000
24 ; 4 ; 10,6 ; 500000
25 ; 4 ; 1,9 ; 500000
26 ; 4 ; 2,9 ; 500000
27 ; 4 ; 3,9 ; 500000
28 ; 4 ; 4,9 ; 500000
29 ; 4 ; 5,9 ; 500000
30 ; 4 ; 6,9 ; 500000

---

:shocking:

I think I'm on to something...

In pad_multiple_dropdowns.php there's a query in the beginning that I understand is to get the combinations available, it reads:

Code:

---

$attribute_stock_query = $db->Execute("
SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN products_attributes AS b
ON (b.options_id=". (int)$attributes[$o]['oid'] ."
AND b.options_values_id=".(int)$attributes[$o]['ovals'][$a]['id'].")
WHERE a.products_id = '" . (int)$this->products_id . "'
AND a.stock_attributes = b.products_attributes_id
AND a.quantity > 0 order by b.products_options_sort_order
");

---

And I think the problem is in the 'a.stock_attributes = b.products_attributes_id' part..
a.stock_attributes is a comma delimited varchar field,
b.products_attributes_id is a integer field in the database.. It's like comparing apples to bananas.

Like in my case, the query tried to test if the integer 11 is equal to the string "11,6" - Which it can't be of course.

I need to dig more in this..

Seems like the biggest problem is how the stock_attributes is populated when using some of the "All" alternatives when adding attributes in admin/products_with_attributes_stock.php

For some reason, the values are added in the wrong order.. Instead of (example) adding:
0,4,13
0,4,14

the values are added as:
0,13,4
0,14,4

which confuses the parser when reading in the values for populating the selection boxes. Highly annoying since I have some 60-70 combinations per article to enter..

Can't say if it's "correct", but editing admin/products_with_attributes_stock.php seems to work for me.

Section:

Code:

---

if(sizeof($attributes) > 1) {
        sort($attributes);
        $stock_attributes = implode(',', $attributes);
} else {
        $stock_attributes = $attributes[0];

---

Comment out the array sort:
// sort($attributes);

I am also having this error:

1146 Table 'jus0912702071770.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=3 AND b.options_values_id=5) WHERE a.products_id = '1' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]

I have added this to database_tables.php
define('TABLE_PRODUCTS_STOCK', DB_PREFIX . 'products_with_attributes_stock');

the table is in my database (zen_products_with_attributes_stock), but still the error...help? Please?

I have read through this thread and cannot find the answer to my issue. I have installed the stocks by attributes 4.7 and it was working. I then installed the dynamic dropdowns and I am receiving this error,

1146 Table 'tablename_zc1.products_with_attributes_stock' doesn't exist
in:
[select quantity from products_with_attributes_stock where products_id = '2' AND quantity > 0]

When I check my database, I see this table.

Please help.

Hi Jade,

I noticed that on this Monkey Pants page [http://www.monkeypantskids.com/fuzzi...aper-p-5.html] each colour swatch is shown 3 times. Is this because each colour is in stock in each size?

The repeated swatches effect does not appear to be happening on other pages, such as [http://www.monkeypantskids.com/thirs...over-p-8.html]. Have you coded this page differently to prevent it happening?

Also, you asked about displaying stock quantities against attributes - have you had any luck getting this to work?

Thanks!

I can not find the dependent attributes module in the free software add ons. Can some one tell where it is?
Jerry

Quote:

---

Originally Posted by jerryclunsford

I can not find the dependent attributes module in the free software add ons. Can some one tell where it is?

---

I suspect that you mean this.

Quote:

---

Originally Posted by kuroi

I suspect that you mean this.

---

I have found and installed the The above mentioned mod.
in another post it was stated you had to install it and the Dependant Attributes mod.
Please forgive my ignorance I am new to this. Are they in the same package?
Jerry

Quote:

---

Originally Posted by VCSharpin

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.

---

This is what I was Going By.
Jerry

Quote:

---

Originally Posted by jerryclunsford

I have found and installed the The above mentioned mod.
in another post it was stated you had to install it and the Dependant Attributes mod.
Please forgive my ignorance I am new to this. Are they in the same package?

---

No, they're the same thing. As your post immediately above shows, you were reading about the need to install the "stock by attributes" (SbyA) with this package, since this package depends on the data collected and entered by SbyA.

OK, Thanks got it now. Up too late last night when I first read all this.
I didn't pay enough attention to the requirements for Dynamic Drop Downs for Stock by Attributes. Now will I have to uninstall the Dynamic Drop Downs for Stock by Attributes, install the stock by attributes and re-install the Dynamic Drop Downs for Stock by Attributes? Or can I simply install the Stock by attributes?
Jerry

Kuroi,
I am attempting to install Stock By Attributes. In in the install instructions it says to
"Prepare the package for upload to your server by renaming the following folders to match your template name: includes/modules/YOUR_TEMPLATE and includes/templates/YOUR_TEMPLATE."
I do not see a folder includes/modules/YOUR_TEMPLATE. I did find includes/templates/YOUR_TEMPLATE and have changed it. The only file in the package under includes/templates is pages. I do have a file in includes/modules for my template can I simply place the pages folder there? Sorry but I am very new to this.

It looks like I have Products with attributes installed. Not sure if it works yet. Time for a Break !!! I will read its operational instructions after and test it then re-install Dynamic Drop Downs for products with attributes.
Thank you
Jerry
P.S. I just put the pages folder in includes/modules/YOUR_TEMPLATE folder.

You all should read through the Dynamic Dropdowns support thread.. You will see that the module DOES NOT work, and the mod author appears to no longer be supporting it..

Thank You for the information. I can stop trying to get it to work now. It seems like it would save time if said on download that it doesn't work.
Jerry

Quote:

---

Originally Posted by jerryclunsford

Thank You for the information. I can stop trying to get it to work now. It seems like it would save time if said on download that it doesn't work.
Jerry

---

You're welcome..

You can certainly upload an update to the module that lets people know it doesn't work.. The modules like the application are all built and maintained by volunteers so it's unlikely that the module will be updated with this data unless the community takes the initiative to do so.. That's why it's always strongly recommended that you backup before installing.. I personally recommend building a test store to test modules before applying them to your live shop.. Gives you an opportunity to test things out to see how/if they work..

I always build tests for the website. Even when only adding pages. I would rather do that and check it than have someone go the site and have something not work or not work as I intended it to.
It appears that this is going to take a LONG time to set up go get close to what I want.
The website is for a Trailer Sales and Manufacturer. The Shopping cart will be used to give the visitor a price estimate for the trailer they are considering purchasing. There are many types and models of trailers. Each in various lengths with optional equipment. Some of the Optional equipment is price by the foot according to the length of the trailer. While other options can be purchased in multiples e.g. 4" D Rings for tie downs.
I looks likes without something like the dependent attributes it will take a while to get something that is functional and as clean as I would like.
Once again Thank You for keeping me from wasting more time on something that doesn't work.
Jerry

I'm all of a sudden getting this as well.

This happened right after I installed the dynamic dropdowns for stock by attibutes 1.3.4.

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

My site is http://www.klkreflectiveimages.com/zen


I have already installed Stock By Attributes and it is running fine.
I've followed all of the steps from the above posts, but nothing is working.

Please help... I'm dead in the water

Anybody?

hmmmmft

I gave up and recreated the site.

Moderator can remove all my posts if needed.

Quote:

---

Originally Posted by jerryclunsford

I always build tests for the website. Even when only adding pages. I would rather do that and check it than have someone go the site and have something not work or not work as I intended it to.
It appears that this is going to take a LONG time to set up go get close to what I want.
The website is for a Trailer Sales and Manufacturer. The Shopping cart will be used to give the visitor a price estimate for the trailer they are considering purchasing. There are many types and models of trailers. Each in various lengths with optional equipment. Some of the Optional equipment is price by the foot according to the length of the trailer. While other options can be purchased in multiples e.g. 4" D Rings for tie downs.
I looks likes without something like the dependent attributes it will take a while to get something that is functional and as clean as I would like.
Once again Thank You for keeping me from wasting more time on something that doesn't work.
Jerry

---

While what you want may not be available here in the free downloads, if you really need it you could investigate having this code built for you by either posting in the commercial forum here or using a site like Rent-A-Coder.

Before I do something like request someone to build, has anything been updated with this or is it impossible on the zencart platform for the time being?

Looking for something that will go from one dependent variable down through several to get to a specific part (which may have a specific price).

For example, if I sold jeans.

Levis or CK or etc.
and then the type of jean by each
then to the size (and all sizes have partially differential prices)
to eventually get to locate the exact model.

The only other way I can think of doing this is obviously category to category, but I was thinking a dropdown in the product would be a bit quicker for the customer than building out many categories.

And if there is not a free add on, is there one to purchase? If not, any other cart solutions with this?

Almost anything is possible to do in Zen Cart... depending on your skills or budget. The problem with dependent attributes is not that they are inherently difficult for a good coder to do, but that there are so many possible ways for them to be organized that a "universal" mod that will work for everyone would be fiendishly complicated.

So, refine your exact flow requirements and post a request in an appropriate place.
Obviously, the more alternates you can handle in categories, the fewer you need to handle in product attributes.