Stocks by attributes

Hi Kev

I look forward to seeing it - as I'm sure a considerable number of others do as well.

Ryk

krazykev:

I don't think I was very clear. I have no intention of releasing this commercially. ... What I want to avoid is releasing a free mod that would be stepping on the toes of a commercially available mod and upsetting the author.LOL. I was in the middle of a long response explaining the ins and outs of open source licensing.

I'd say go ahead. Anyone (even somebody as nice as Langer) who produces a commercial mod for an Open Source platform shouldn't expect that they'll get a clear run that leaves useful extensions unavailable to users of the main package who haven't paid.

I'd recommend making it a separate mod. It sounds like an extension to Easy Populate that recognizes the attribute and attribute tables, but I would still treat it as different unless it also enhances the existing Easy Populate functionality significantly; name it so that it pops up alongside the other variants of Easy Populate in the downloads section; and create and point to a support thread specifically for it.

I have uploaded this as a contribution with the name "Easy Populate with Stock With Attributes". Subject to a successful review by the Zen Cart team you will have this soon.

Kev

krazykev:

Hi Kellan,

I did something very similar but didn't check for null/0 so didn't have to make your second change above.

select pov.products_options_values_id,
pov.products_options_values_name,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
on pa.options_values_id = pov.products_options_values_id
join 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 pa.options_values_id = pov.products_options_values_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "'
and PWAS.quantity > 0 " .
$order_by;

This is in attributes.php

Kev
the only reason I did the null is that I have some items that will have attributes that don't have an individual quantity specified so I wanted to make sure those are displayed. Do you have this on a live site? If so, have you noticed any side affects? How many transactions are you running? Thanks!!!

Hi,

yes I have this on a live site with no side effects that I have noticed. I don't do transactions though so probably not the best test bed.

Kev

I am working on a site and I am working with the classic template.
what I need to do is:
I have 6 nappies
4 x medium and 2 x small

I have made attributes for the medium and small
what I need to know is how do I add and control the qty,s available for each size.

At the moment I just have the available sizes but nothing for the qtys available I have been reading and reading and just can not find what I need to be able to do this.

This is the site:
http://clothiebumz.com.au/

the owner wants to launch on sunday so i really need to get this finalised..

Thanks in advance for any help you can give me..
:no:

wheretostartwebsites:

I am working on a site and I am working with the classic template.
what I need to do is:
I have 6 nappies
4 x medium and 2 x small

I have made attributes for the medium and small
what I need to know is how do I add and control the qty,s available for each size.

At the moment I just have the available sizes but nothing for the qtys available I have been reading and reading and just can not find what I need to be able to do this.

This is the site:
http://clothiebumz.com.au/

the owner wants to launch on sunday so i really need to get this finalised..

Thanks in advance for any help you can give me..
:no:

I think i have found the add on to be able to do what I need to do.
attributes_separate_stock_v0-1. is this what i need..**

would someone be willing to install it for me as i am not familiar with SQL..
I am happy to pay someone to do it for me so i can get it right the first time.
TIA:frusty:**

Hi,

you need to ownload and install the Stock with Attributes mod.

There are 2 versions, am not sure on the idfferences - some else may be able to comment on that but I use the MULTIADD version just fine.

Go to the Freeware Software Add Ons page and search fgor "Stock By Attributes" and download this

Stock by Attributes
Last Updated by: mcinallym Jun 03 2008
v1.3.8
4.7MULTIADD

Kev

Thanks for that Kev

do you know of anyone that would be willing to install this mod into my site..

I am a little uneasy doing it myself as this is my first attempt at anything like this..
:D

Hi,

I will gladly help you - for free!!! I can either do it for you or talk you through it on MSN or similar if we are online at the same time.

I have sent you an e-mail through your web site - let me know when you get it!

Kevin

I sent you an e-mail as well if you can't get set up with Kev I'll be glad to help you out as well. Just let me know.

Hey just a quick question, but if I forget to select my attributes when adding an item to the card I get TEXT_SELECT_OPTIONS in an error message. Anyone know where this is so I can change it to a more friendly error?

I'm obviously not looking in the right spot.

I can't find an answer to this question, so maybe someone could help me out. I'm sure it's a common question but i'm starting to get a headache looking through 58 pages.

Plain and simple: I need an attribute to disappear from the drop down menu when it is out of stock.
I know it says **OUT OF STOCK on the checkout page but I want the option to choose that attribute to not even be visible on the drop down if it is not in stock. There has to be an easier way than going through and deleting all of the attributes (size in my case) for each product that is sold out in a size.

Hi,

look at my post dated 8th Feb 09 on page 57 and Kellan's (kellan4459) dated 7th Feb 09.

Your answer is there!

Kev

THANK YOU!
You saved me from going crazy! It worked :)

Nice one - if you have any problems post here!

One other thing... How do I change the sort order of the sizes I have listed? I have tried in the admin backend but they still display alphabetically it looks like:

-Large
-Medium
-Small

instead of S, M, L.

In the attribute controller (where you create the attributes) you can give each attribute a sort order (a numerical value). Lower values are listed first. e.g.

10 => small
20 => large
30 => x-large

Applied the changes below, and get the error message

1146 Table 'cactus2_zc2.products_with_attributes_stock' doesn't exist
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa.* from zen_products_attributes pa join zen_products_options_values pov on pa.options_values_id = pov.products_options_values_id join products_with_attributes_stock PWAS on PWAS.stock_attributes = pa.products_attributes_id where pa.products_id = '339' and pa.options_id = '23' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' and PWAS.quantity > 0 order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]

pasted the change from the post, so should be good. Zcart 1.3.8, php 5.2.6.

Stock with attributes worked OK before applying the change, with the Out of Stock items being displayed as OOS at checkout.

Verified table "cactus2_zc2.products_with_attributes_stock" does exist.

Should
"Join products_with_attributes_stock PWAS"
be
"join pa.products_with_attributes_stock PWAS" ??

krazykev:

Hi Kellan,

I did something very similar but didn't check for null/0 so didn't have to make your second change above.

select pov.products_options_values_id,
pov.products_options_values_name,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
on pa.options_values_id = pov.products_options_values_id
join 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 pa.options_values_id = pov.products_options_values_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "'
and PWAS.quantity > 0 " .
$order_by;

This is in attributes.php

Hi,

Verified table "cactus2_zc2.products_with_attributes_stock" does exist.

Are you absolutely sure it exists? (Check for prefixes)

Should "Join products_with_attributes_stock PWAS" be "join pa.products_with_attributes_stock PWAS" ??

No - this isn't valid SQL.

Are you using table prefixes - in which case cactus2_zc2.products_with_attributes_stock may really be something like cactus2_zc2.zen_products_with_attributes_stock.

In fact, to test this theory, I have amended the SQL to use the table define - try this query instead

select pov.products_options_values_id,
pov.products_options_values_name,
pa.*
from " . TABLE_PRODUCTS_ATTRIBUTES . " pa join " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
on pa.options_values_id = pov.products_options_values_id
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 pa.options_values_id = pov.products_options_values_id
and pov.language_id = '" . (int)$_SESSION['languages_id'] . "'
and PWAS.quantity > 0 " .
$order_by;

Post back with your results.

Kev