Sequenced attributes based on stock addon...

[modernm]

I have been able to build a mod re-using code from other projects that will give sequenced drop downs for attributes based on stock. If anyone is interested in testing please PM me. I would like to contribute my work to the Zen Cart project even if it is only a temp fix until 1.4 comes out. This requires the Stock by Attributes mod installed and working.


Single drop down based on stock... (can be setup in multiple ways but currently setup to prevent adding items to cart and still show all attributes. Medium is out of stock if you want to test)

http://www.modernmunchkin.com/boys-1...-plaid-27.html


Sequenced drop downs based on stock...

http://www.modernmunchkin.com/gift-c...oduct-193.html



Cal

[Kim]

Please package your code and add it to the downloads section.

[modernm]

I attempted to upload but got a warning saying no file uploaded. Tried twice with no luck.


Cal

[kuroi]

It's certainly there now and is a useful extension of Stock by Attributes. The current version (1.3) seems to have a bit of a bug however, as line 87 of the pad_sequenced_dropdowns.php class calls up data from a table that doesn't exist in Zen Cart or Stock by Attributes.

[modernm]

It's certainly there now and is a useful extension of Stock by Attributes. The current version (1.3) seems to have a bit of a bug however, as line 87 of the pad_sequenced_dropdowns.php class calls up data from a table that doesn't exist in Zen Cart or Stock by Attributes.

Thanks, I will try and update the contrib tonight.

Modify includes/database_tables.php

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

[HeathenMagic]

Hello there,

This is a fine extension. Just wondered, am I to define this message in the enlgish.php file:-

TEXT_OUT_OF_STOCK_MESSAGE

also, if an item is out of stock, it shows TEXT_OUT_OF_STOCK next to it.

Regards,

Heathenmagic

[modernm]

Hello there,

This is a fine extension. Just wondered, am I to define this message in the enlgish.php file:-

TEXT_OUT_OF_STOCK_MESSAGE

also, if an item is out of stock, it shows TEXT_OUT_OF_STOCK next to it.

Regards,

Heathenmagic

Heathenmagic,

I am uploading a update for that now. Please check the contrib later tonight.


Cal

[dscott1966]

I installed the mod but cant seem to get it work properly. To get the sequence to work, i added the different options but it does not come up with the correct it says that i have all in stock. Should it be if i have say 3 gold shoes in size 6 but none in 6.5, then the 6.5 should not show, if correct in saying right.

also it does not display the out of stock message

you can see it here:http://dealz-r-us.com/index.php?main...&products_id=5

how do i go about fixing this?

[blackjm75]

Cal,

This is excellent and very close to what I am looking for! I wanted to look at how the 'Sequenced drop downs based on stock...' worked but the link below was broken

http://www.modernmunchkin.com/gift-c...oduct-193.html

do you have an example of it working?

I want to have 'my site' 'look' at the attributes selected and if the combination selected is out of stock display a message in a sidebox but still allow them to purchase the product if they wish - we will order it in for them.

I presume that as you select the 1st attribute the site 'looks' at the stock and decides what to display as in or out of stock? If so it shouldnt be too hard to convert it to what I want.

Joe

[dashton]

I just installed Sequenced Attributes and I have this error-

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

I noticed that in Modify "includes/database_tables.php" by adding...

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

there is no DB_PREFIX, so I tried changing it to

define('TABLE_PRODUCTS_STOCK', DB_PREFIX .'products_with_attributes_stock');

That seemed to fix it.