Stocks by attributes

Quote:

---

Originally Posted by philip937

Posted via Mobile Device

---

I have just tested again to make sure I wasn't being stupid..

My attributes most definitely DO disappear when the stock of the particular attribute hits zero.

So for example I have:

S = 4
M= 0
L = 10

When I look at the product info page and select the drop down, I currently get:
Please Select
Small
Large

It has hidden the Medium..

Now just to test there was no glitch, I then wen and changed the value of Small to = 0. the drop down now shows:
Please Select
Large

So it works perfectly how I want it to, but I merely want to change the threshold of these attributes dissapearing from zero to 30..

I hope someone can help :blink:

Phil

Quote:

---

Originally Posted by philip937

I have just tested again to make sure I wasn't being stupid..

My attributes most definitely DO disappear when the stock of the particular attribute hits zero.

So for example I have:

S = 4
M= 0
L = 10

When I look at the product info page and select the drop down, I currently get:
Please Select
Small
Large

It has hidden the Medium..

Now just to test there was no glitch, I then wen and changed the value of Small to = 0. the drop down now shows:
Please Select
Large

So it works perfectly how I want it to, but I merely want to change the threshold of these attributes dissapearing from zero to 30..

I hope someone can help :blink:

Phil

---

My bad, found the solution.

I had already been over this before.. Just forgot!

To make your attributes turn off when stock for attribute hits zero, you have to do this:
http://www.zen-cart.com/forum/showth...=34977&page=65
I had already done this!! Durrr im so stupid..

so quite clearly where the replaced code says to put:
(pwas.quantity > 0 or pwas.quantity IS NULL)

Ive changed mine to say
(pwas.quantity > 30 or pwas.quantity IS NULL)

sorted.

Quote:

---

Originally Posted by philip937

Diva,

I'm confused. You say the answer is NO to hiding attributes? Mine does hide the attributes when stock is 0. What I was asking is how to change this from 0 to 30.
For the attributes to hide at stock 0 they must be being told to do this somewhere?

---

Out the box this behavior isn't there.. Looks like you must've modified it to do this..

ETA: okay.. looks like that's what you confirmed you did..:laugh: I knew I wasn't crazy either!:laugh:

And so this is clear for anyone reading this, you never said which version of SBA you are using.. It makes a HUGE difference if you are pointing people to solutions.. The link you posted looks like this refers to the MultiAdd version.. I haven't looked at the code in the Kuroi version, but if here are differences, a solution meant to work with one version may not apply to other versions of this mod..

Another thing I wanted to point out that this solution only appears to work for SINGLE attribute variants. It doesn't appear to be a solution for variants with multiple attributes (Small shirt versus Small, Blue shirt)

Quote:

---

Originally Posted by philip937

My bad, found the solution.

I had already been over this before.. Just forgot!

To make your attributes turn off when stock for attribute hits zero, you have to do this:
http://www.zen-cart.com/forum/showth...=34977&page=65
I had already done this!! Durrr im so stupid..

so quite clearly where the replaced code says to put:
(pwas.quantity > 0 or pwas.quantity IS NULL)

Ive changed mine to say
(pwas.quantity > 30 or pwas.quantity IS NULL)

sorted.

---

Quote:

---

Originally Posted by DivaVocals

Out the box this behavior isn't there.. Looks like you must've modified it to do this..

ETA: okay.. looks like that's what you confirmed you did..:laugh: I knew I wasn't crazy either!:laugh:

And so this is clear for anyone reading this, you never said which version of SBA you are using.. It makes a HUGE difference if you are pointing people to solutions.. The link you posted looks like this refers to the MultiAdd version.. I haven't looked at the code in the Kuroi version, but if here are differences, a solution meant to work with one version may not apply to other versions of this mod..

Another thing I wanted to point out that this solution only appears to work for SINGLE attribute variants. It doesn't appear to be a solution for variants with multiple attributes (Small shirt versus Small, Blue shirt)

---

Hey,

Sorry, yes for clarification, I have only tested this on my scenario, i.e 1 set of attributes.

I am using Kuroi's 4.7 version.

So where as it works perfectly for what I need, be warned it may not work for everyones requirements.

:smartalec:

Quote:

---

Originally Posted by philip937

Hey,

Sorry, yes for clarification, I have only tested this on my scenario, i.e 1 set of attributes.

I am using Kuroi's 4.7 version.

---

The original is still the best!!! :yes:

The admin stylesheet from the MultiAdd version is the only improvement I would suggest.. The MultiAdd admin stylesheet really visually helps distinguish the parent product from the variants..:yes:

Quote:

---

Originally Posted by DivaVocals

The original is still the best!!! :yes:

The admin stylesheet from the MultiAdd version is the only improvement I would suggest.. The MultiAdd admin stylesheet really visually helps distinguish the parent product from the variants..:yes:

---

oh really, cool I shall give that one a try and see what it looks like :D

Help!!!!!!

Latest update
version 4.7 stocks by attrribute....

if I add anything to the shopping cart I get:

1146 Table 'XXdatabasenamexx.TABLE_EF_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist


but the table does exist...

Now what?!?!?!?!?!?!

Sounds like you didn't run the SQL file which creates the SBA tables..

Quote:

---

Originally Posted by exeter_acres

Help!!!!!!

Latest update
version 4.7 stocks by attrribute....

if I add anything to the shopping cart I get:

1146 Table 'XXdatabasenamexx.TABLE_EF_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist


but the table does exist...

Now what?!?!?!?!?!?!

---

Yep...sure did...

first thing

Restored a backup,
re-did the whole upgrade....

store working,
but a bit hesitant to run this mod again...