Stocks by attributes

[DivaVocals]

Is it true that it is still not possible to either

1- display to the customer the different attribute variations and how many of each are in stock

or

2- disable the attribute option(s) from the respective dropdown menu's that are not in stock.

This mod out the box does not support this kind of functionality.

I have the Stock By attributes module version 4.7Ajax (up from 4.7 multi add) successfully installed.

I saw posts by several members years to months ago asking about this / almost solving this / etc - but with no stated solutions... has anyone figured out how to do this?! Could you point me to contributed modules that can do this?! If i'm asking this in the wrong spot could you lead me to the correct place?!

Been some talk and possible solutions posted in this and the other Stock by Attributes thread.. You can use the thread search tools to narrow your search to posts in the specific threads.. Don't know if any of these solutions are working or not.. (I haven't personally used any of them..)

[exeter_acres]

I've searched and searched... but I'm lost.....

I've installed the mod in our test database. Shows up and all of our inventory is listed....
but when I click on define variant,
I get an error:
1146 Table 'XXdatabasenameXX.products_attributes' doesn't exist


fair enough...

all of our database tables have a prefix....

I, for the life of me, can't figure out any and all places that need to be modified to show the correct table name.....

any help with this would be great


Thanks

[DivaVocals]

You don't say which flavor of the Stock By Attributes mod you installed:
Kuroi's version 4.7
MultiAdd version 4.7
Ajax version 4.7

I could never get the last two to work.. and since the contributors of both of these versions (MultiAdd or Ajax) have NOT ONCE support their version of this mod, I do not use them. My research of the support threads shows that these two versions are the ones with MULTIPLE problems. I use ONLY the version 4.7 Kuroi wrote. He is the ONLY mod author still actively answering questions in these support threads, so for my money this is the one I will use. However I do like the stylesheets used in the MultiAdd version because it visually makes a nice seperation between the parent product and the variants. but THAT'S ALL that I used from that version!

That said if you used Kuroi's version, it's a VERY straight forward install and should work right away.. No hacks to this mod needed AT ALL!

I've searched and searched... but I'm lost.....

I've installed the mod in our test database. Shows up and all of our inventory is listed....
but when I click on define variant,
I get an error:
1146 Table 'XXdatabasenameXX.products_attributes' doesn't exist


fair enough...

all of our database tables have a prefix....

I, for the life of me, can't figure out any and all places that need to be modified to show the correct table name.....

any help with this would be great


Thanks

[exeter_acres]

Do you have a link to the Kuroi version? I cannot locate it.

[DivaVocals]

Do you have a link to the Kuroi version? I cannot locate it.

It's in the downloads section where you found this mod. The downloads preserves previous versions of add ons below the most current submissions. So if you scroll down and you will see version 4.7 (without MultiAdd or Ajax after the version number) and a download link for that version.

[mkonchalski]

Can someone help me with this problem.

I am using Stock By Attributes MultiAdd but I'm running into a simple problem. I read the entire forum and can't find anything on it...

I need to set my stock quantity to Zero. I can do it by manually manipulating the database, but can't seem to get it to work from the Admin panel. Everytime I try I get a MySQL error that looks like this...

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' attribute_sku=0 where stock_id=68 limit 1' at line 1
in:
[update `products_with_attributes_stock` set quantity=, attribute_sku=0 where stock_id=68 limit 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I added the Attribute_sku. I've tried everything and can't get it to work. It just keeps the Quanit=, and places no value there. If I put in -0 it works though...I don't get it.... Please HELP!

[milobloom]

I think I am using the Stock attributes by decantlor or something like that.

The question I have is, How can I change the ***->
when it says 0 in stock....

http://www.nothingbutcostumes.com/in...ducts_id=11404

I am thinking about changing it to OOS Try another Size!

[magolines]

I have added the "Stock by Attribute" add-on and I was able to add my items. I added 82 items with 11 different categories.

My problem is, when I try and order the things it will let me order more of one atribute than I have, unless I order 83 of them. It is only looking at the prduct inventory to decide if it is out of stock, instead of the stock by attribute.

Does anyone know a fix for this?

Thanks,

Miriam

[julxz]

Im using Stocks by attributes.. thank you for the contributor...

I have a problem with the inventory of each attributes.
Once someone ordered a particular product(Ex: Product A : Size: 8/27" Inseam), after the payment, it doesn't update the product attributes stock.

So if Size: 8/27" Inseam has 5 in stock, after the purchased have been done the remaining stock should be 4... But the add on doesnt deduct the stock, the remaining stock is still 5. What I am doing right now is updating it manually if someone purchase a particular item.

Hope someone could help me with this problem...

[kuroi]

@magoline and @julxz

There are two main possibilities:

if you've installed the AJAX version then you won't have all the files needed - there's lots more about this earlier in the thread (the key missing file is includes/classes/order.php

if you've installed the MultiAdd version, or my version, but not managed to do it properly, i.e. the revised includes/classes/order.php file (yes that one again) hasn't replaced the default Zen Cart one then the mod won't work, and in the way you've described.

See too post #763. A touch embarrassing, but 100% accurate.