Stocks by attributes

[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

Phil

[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

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.

[DivaVocals]

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.. I knew I wasn't crazy either!

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)

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.

[philip937]

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.. I knew I wasn't crazy either!

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.

[DivaVocals]

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

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

[philip937]

The original is still the best!!!

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

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

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

[DivaVocals]

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

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

[exeter_acres]

Yep...sure did...

first thing

[exeter_acres]

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

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