Stocks by attributes

Quote:

---

Originally Posted by shackrock

man really? I feel like a majority of people would fail miserably at this task then... heck I might too, haha.

---

I think a majority would fail miserably if they were provided only the code changes.. AND, the mod author has no way of knowing what other changes you may have already made for other add-ons.. If this is what you're used to with OSC, then that explains a LOT of the problems I saw with mods when last I peeked in there..

Quote:

---

Originally Posted by shackrock

Looks like I might be sticking with OSC afterall.... unless somebody else has some tips?

---

Yes.. get Winmerge (or a similar tool) and try 1st before giving up.. :smile:

as for OSC??? IMO staying with OSC is a step backwards.. That project is NOT moving forward at all..

Most recent version.

I think this is a bug. When I do a search that works properly. The sort is achieved. However, clearing that search is a problem.

It looks like a post (or get) parameter is not being cleared. Every time the page refreshes after that - regardless - that search is implemented.

Have others noticed this?

Nick

Trying to get this mod to work.....

I have installed it in a test database..
No errors..
I can adjust the quantities in admin....

but when i add an item to the cart that I have set its attribute to zero, nothing happens and it is allowed to be added to the cart....

did I miss something?

thoughts on this??

Thanks
Exeter

Quote:

---

Originally Posted by niccol

Most recent version.

I think this is a bug. When I do a search that works properly. The sort is achieved. However, clearing that search is a problem.

It looks like a post (or get) parameter is not being cleared. Every time the page refreshes after that - regardless - that search is implemented.

Have others noticed this?

Nick

---

The most recent version (which is supposed to fix the Ajax version) has a few bugs.. Go back to page 83 of this thread.. I posted my musings on the matter..:smile:

Gonna stick with what works.. Kuroi's version still works without any issues..

Quote:

---

Originally Posted by exeter_acres

Trying to get this mod to work.....

I have installed it in a test database..
No errors..
I can adjust the quantities in admin....

but when i add an item to the cart that I have set its attribute to zero, nothing happens and it is allowed to be added to the cart....

did I miss something?

thoughts on this??

Thanks
Exeter

---

anyone?

Quote:

---

Originally Posted by limelites

Additionally, if you want the attribute in the drop down menu to automatically disable when the attribute quantity = zero, then you have to open /includes/modules/attributes.php and replace this:

PHP Code:

---

$sql = "select    pov.products_options_values_id,
                        pov.products_options_values_name,
                        pa.*
              from      " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
              where     pa.products_id = '" . (int)$_GET['products_id'] . "'
              and       pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
              and       pa.options_values_id = pov.products_options_values_id
              and       pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
                $order_by; 


---

with this:

PHP Code:

---

$sql=    "SELECT  pov.products_options_values_id,
                            pov.products_options_values_name,
                            pa.*,
                            pwas.*
                FROM   " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " pwas ON pwas.stock_attributes = pa.products_attributes_id
                WHERE   pa.products_id = '" . (int)$_GET['products_id'] . "'
                   and    pa.options_id = '" . (int)$products_options_names->fields['products_options_id'] . "'
                and    (pwas.quantity > 0 or pwas.quantity IS NULL)
                  and    pa.options_values_id = pov.products_options_values_id
                 and       pov.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
                $order_by; 


---

---

Like many, many others, I also want to hide attributes with 0 quantity.

I'm using drop down menus and only one attribute "category" for each product.

Been reading this thread for a few hours now, tried the solution above, it does not work for me, do I need to do something else as well?

I'm running Zen cart 1.3.8 with Stock by Attributes v4.7ajax.

Noticed some mentioned the MULTIADD version of SAB but that one seems older...

Truly greatful for some advice here. Thank you.

Sorry this thread was the solution for me :

http://www.zen-cart.com/forum/showpo...&postcount=625

Thank you s58smith!

Hi Guys,

I've had a search through this thread and I can't seem to find what I'm after.

Basically, what I'd like to do is create one product, which is available in different colours and styles, assign stock levels to each colour or style, and list each colour/style as a separate product. So, for example, a ########ie's Guitar Strap - exactly the same length and material - but it's available in a star pattern, in checkerboard etc. Can I make a ########ie's Guitar Strap, assign colours and styles as attributes, then generate separate products for those attributes. So I'd have ########ie's Star Guitar Strap, ########ie's Checkerboard Guitar Strap, etc listed separately in the product listing. I'm sure you can imagine when there's 20 or so colours it's a huge job. Can this be done, or have I completely missed the point of this module? If I have could anyone recommend anything...

Thanks very much!

Quote:

---

Originally Posted by OK Computer

Hi Guys,

I've had a search through this thread and I can't seem to find what I'm after.

Basically, what I'd like to do is create one product, which is available in different colours and styles, assign stock levels to each colour or style, and list each colour/style as a separate product. So, for example, a ########ie's Guitar Strap - exactly the same length and material - but it's available in a star pattern, in checkerboard etc. Can I make a ########ie's Guitar Strap, assign colours and styles as attributes, then generate separate products for those attributes. So I'd have ########ie's Star Guitar Strap, ########ie's Checkerboard Guitar Strap, etc listed separately in the product listing. I'm sure you can imagine when there's 20 or so colours it's a huge job. Can this be done, or have I completely missed the point of this module? If I have could anyone recommend anything...

Thanks very much!

---

If I understand you correctly, then this mod is not what you want. What you want to do is simply create a separate product for each guitar strap/length/color. You can simplify adding all of those products by creating one product then copying it and editing the newly created product in order to create a new variation. The stock would be product stock defined in the product details, as allowed for in Zen Cart base functioning, not stock by attributes.

To simplify the addition of those products even more, check out the Easy Populate mod. Then you could add the new products via spreadsheet.

HTH,
Audra

Quote:

---

Originally Posted by audradh

If I understand you correctly, then this mod is not what you want. What you want to do is simply create a separate product for each guitar strap/length/color. You can simplify adding all of those products by creating one product then copying it and editing the newly created product in order to create a new variation. The stock would be product stock defined in the product details, as allowed for in Zen Cart base functioning, not stock by attributes.

To simplify the addition of those products even more, check out the Easy Populate mod. Then you could add the new products via spreadsheet.

HTH,
Audra

---

Super, thanks very much for that, I had looked into it but wasn't sure. After your comment I decided to go for it, and though it's proving a bit of work now, it's going to make life a lot easier in the long run. Thanks very much!