Stocks by attributes

[dthomas]

I just added stock by attributes and dynamic drop downs to my website. Now the product detail pages are showing the attribute dropdown at the bottom of the page. More of a problem is the dynamic dropdowns are showing all possible combinations of attributes added for the item regardless of stock. Any ideas where to start trouble shooting this? An example of my problem can be seen here http://verdasport.com/index.php?main...&products_id=8.

Any help would be greatly appreciated!

[athena]

You should post this wherever assistance is offered on dynamic drop downs mod. This doesn't sound like any common problem I've studied about stock by attributes.

It does sound like a file merging problem. Making sure stock by attributes works the way you want it to by searching this thread (as it is an unstable mod) then starting from scratch with your install of dynamic drop downs after STA is working is my recommendation for what it is worth.

[fvb]

I just installed this mod for the first time, and the only issue I am having is that the 'SAVE' button does not seem to be working so it is not registering that attribute quantities were added.

I have the same problem

[shahram]

Easy Populate 1.2.5.5 with Stock With Attributes
I am using this mod, I am familiar with Easy populate CSV, but on this one I can’t figure out how to add stock by attributes. Is there a column I need to add to make all the sizes I have appear as having “1” in stock? Do I have to add a column in the main CSV file or in the attributes file?

Thanks for any help

[PoopyP]

@pjb923

You may be able to implement a hack similar to that done by yellow1912, but in this case to suppress the text attribute from being affected by stock by attribute.

Does anybody know where I can find or what do I have to edit to make Stock by attribute ignore text boxes (similar to the quoted post to ignore readonly boxes)? I have a store that sells shirts and customers can enter the name on a shirt but if they leave it blank it should still process the order if the size is in stock. So If the size is in stock text box values are irrelevant, they are there to tell me the user wants ZENCART on their tshirt.

Your help is greatly appreciated.

[Slender1]

I did the modifications by Sonicc and come up with the following error: Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

When I look in ep_debug_log. I get this:


MySQL error 1054: Unknown column 'pwas.quantity' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_price as v_products_price,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
pa.products_attributes_id as pwas_attrib_id,
pwas.quantity as pwas_products_quantity,
pov.products_options_values_name as v_options_name
FROM
products as p
JOIN
products_attributes as pa
on p.products_id = pa.products_id
JOIN
products_options_values as 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

I've searched PWAS.quantity and haven't found anyone else having this problem.

Anyone have a clue to what I am doing wrong?
ver 1.3.9h
Easy Populate 1.2.5.5.csv.2

[shop4costumes]

Hi
I'm struggling to get the EasyPopulate mod to work with this.
I have installed the Stock by Attributes mod. This appears to work fine. I can manually add stock for each attribute.
But manually adding is not going to be practical.
I somehow need to add stock by attribute.

So then I have installed the Easy Populate for Stock with Attributes mod.

I'm doing this on a test copy of the live site.

Do people actually use the EP mod with this or has everyone given up ?
If you have it working would you mind me asking for help ?

It seems to be tring to access a data table without the zen_ prefix.

I have limited skills to fix this but prepared to try!
I renamed the table in phpadmin and then created a different error message (and the admin>stock by attributes screen no longer worked), so reversed change...

Totally stuck

Thanks for anyone who may be able to help ???

Sarah
www.shop4costumes.co.uk

[ambers]

I just installed and followed everything pretty flawlessly...until I tried to add an item to my cart through my webstore. I'm getting SQL error that says

1146 Table 'archery.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK' doesn't exist
in:
[select stock_id from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK where products_id = '204']

PLEASE HELP!
-Amber

[JaminT]

Hi,

Thought this was worth sharing as a spent a long time searching the forums for something like this.

When i was told that our website was being built on Zen Cart and i started to do some research i soon realised that some of the dynamic features that i had expected to be standard in ecommerce now were not going to be easy. I could begin to list them but that is not the purpose of this post.

With the stock by attributes mod i realised after beginning to use it that the standard install really was not very friendly for a lot of our products. For clothing and fashion items which are 1 off seasonal orders and could not be re-ordered we did not want to upset many customers that place an order only to be told that their size or colour was not in stock and we would have to refund them. As with the mod if you have 3 colours and 5 sizes then that is 15 combinations of which we may only have 10 in stock and there was no way for the customer to know if their combination was in stock on the product page. If you add one more attribute then the amount of combinations vs actual stock can become very large. ALL of our products are Stock by Attributes!

So i went on the hunt of a mod that made the Stock by Attributes mod dynamic on the customer end by forcing the customer to select attribute names in order and then only showing the option values of the next attribute that were in stock, this is what most major online retailers use now. For instance customer selects blue shirt, the next drop down is lit up and only 3 out of 5 of the sizes are available for selection. No luck. (If anyone knows of this mod please let me know)

So i approached our developers and they have done something that has helped so far, not perfect, but makes our site a bit more user friendly. Basically when a customer has made all the selections possible an Availability box tells them if it is in stock.

Unfortunately i do not know the ins and outs of how it works but i thought this might help other people who need something like this and were wondering how to get it done or being told by their developers that it was not possible.

Please if there are any better ways of tackling this issue or if you have any suggestions or questions please post it here.

To see how it works visit www.redpostequestrian.co.uk and view a product.

[anamika59]

I have heaps of test environments with the mod installed and have never been able to replicate this problem. If somebody has a non-live but publicly accessible Zen Cart with this problem and is prepared to let me poke about behind the scenes (i.e. give me FTP access) I'm rather curious to understand what is going on here too.

This case is very easy to reproduce. I am running into this issue today although the posts are old.

Create a product (say shirt)
create 3 sizes for it. S, M and L
allocate each size to 1. This means there is only 1 small size shirt, 1 M size shirt and 1 L size shirt.
Now try to check out 2 small size shirt.
Zen cart with Stock by attribute will let you check out 2 small size shirt. It will only display "out of stock" if one tries to check out 4 small size shirt which is wrong.