Stocks by attributes

[audradh]

Hi All,
The mod has hit the downloads. For those who received this mod before it hit the downloads, I quote Dr Byte

There was a lot of content to cleanup in the contribution, with extra files unrelated to attribute stock, etc.

There are still a lot of things to fine-tune, but at least now it only contains the files which have changes from core.

It's been activated.

If I get a chance I am going to file compare the original mod to the one now in the downloads, but it may be a bit before I find the time.

Best,
Audra

[Bunster]

Hi all, in need of help as usual :-)
There are a few things I'd like to tweak but don't know how to achieve them.

1. I don't appear to be receiving low stock emails for products with attributes. It works fine for products that do NOT have attributes.

2. My *Stock Level Warning* message does not appear in red against products WITH attributes, but it is against products that do NOT have attributes.

3. I would like to be able to show the amount of stock available in the shopping cart when there is a stock level problem.
e.g. *Stock Level Warning* (6)
I don't want to display the stock level on the Product Info page, only in the shopping cart when there is a stock level problem.

If anyone has any suggestions I'd be willing to try them out.

I've attached a screenshot to help show what I mean.

[Typhoon]

I just installed this stock_attributes and it's super, thank you alot !!

But I also have the same problem as Bunster, no mail when the product are low on stock, not even the ones without the attributes. Any ideas ?

Also, if a product with an attribute are low on stock, lets say size 36 (shoes) but there are still plenty of size 37-40, I would like this size 36 to be shown under Reports -> Product Stock Report, is this possible ?

Plus, also what Bunster said, it would be super if it was shown on the shop that the size 36 were out of stock and maybe not possible to order it... But it's good also that it's shown in the cart...

I also noticed that if I delete an order with attributes and I check the box called "Restock product quantity", the quantity doesn't return to the stock... Could this be done somehow ?

Very nice work !!

Regards,
/Typhoon

[MikeyG]

could some one please explain how the stock_attributes column in the table product_with-attribute_stock can be translated back to work out the name (value) of the attribute option.


I am trying to run a stock management / order processing system using the mysql database but run it locally in MS Access but cannot understand how to extract /interpret the values in this field.


(before you start asking why MS Access - my html and php and mysql skills are not good enough to get the automated functionality that I know how to write/get out of an Access database and I need an order processing stock management system / functionallity that I can seem to see in zen cart)

Unless of course some one has some ideas and suggestions on how to manage my purchasing.

thanks

MG

[papacek]

Have anyone DUAL PRICES (wholesale price) and this STOCKS BY ATTRIBUTES?
I have problem, when I add Dual Prices contrib, STOCKS BY ATTRIBUTES stop function.

[switt]

Greetings;
Have installed "Stock Attribute v3.01" w/ "ZC 1.3.0.2"

Works great with only one attribute, but on product w/ 2 attributes
in drop down form:

http://www.mthighmedia.com/ZC/index....roducts_id=180

-- adding any quantity to cart gives the following
warning text:

Products marked with *** are out of stock.
Items not in stock will be placed on backorder.

(even though each variant has been populated with stock from
"products_with_attributes_stock.php" page in admin & the "Sync Quantities" step taken)

Total Quantity for all variants shows correctly initially & does update
based on "sale" of item/s, even for items tagged with incorrect "***out of stock warning"
Quantity for individual variants does not update, however based on "sale" of said product variant.

SUMMARY: with "Stock Attribute v3.01" installed;

• 1) Works fine with one attribute only.
• 2) However, "test-customer" gets "Out of Stock message" for product variants that are actually "IN STOCK".

This occurs with any product that has more than attribute w/ drop-down style input form.
Test-customer is incorrectly warned that product is out of stock.

Have read 30+ pages of forum and in spite of this bug being referred to previously--
i can't track down the fix for the current version of Stock Attribute v3.01 --any clues?? --data base table set-up via SQL patch, permissions, missed step in config?? or some other oversite--obvious or otherwise??

We'd appreciate any feedback or links to solution.
thanx,
sWitt--OVER!

[xtreme]

Hello I am getting the following error:

1146 Table 'verynyc_zc3.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="1"]


Any ideas. Please take note that i DID install the SQL patch and in myphpadmin I can see the table there.

[switt]

Hello I am getting the following error:

1146 Table 'verynyc_zc3.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="1"]


Any ideas. Please take note that i DID install the SQL patch and in myphpadmin I can see the table there.

Try this, i had the same prob;

looks like the name of your db is "verynyc_zc3" ,right?
and you've added that name to "stock_attribute.sql"
re-edit the SQL patch and remove "zen_" leave the "." period

save and re-apply patch-- when you've done this--
go to admin | Catalog | Products with Attributes Stock

no guarantees, just seems to be the same prob, i had
with properly removing the default prefix in the "stock_attribute.sql" file
and renaming with " your db name"

"and in myphpadmin I can see the table there."
yes, but probably named incorrectly, so can't be called

sWitt--OUT!
PS. still looking for solution to products with 2 attributes
incorrectly showing "out of stock warning"

see previous post #66

[xtreme]

Thanks Switt Worked like a charm! I think it was because I installed zen-cart through Cpanel, which has a lot of presets. Thanks again I owe you one.

[switt]

xtreme, you're welcome.

Tho't that prob sounded familiar.
'mazing how many folks are out there stumbling on the same probs/solutions--
that's why these forums are so useful.

Anyway, if you'd be so kind--or anyone else that has installed this mod--
Please, try the scenario that i describe in post #66,
re:"Stock Attribute v3.01" w/ "ZC 1.3.0.2"

Products w/ >1 dropdown style attribute variant, incorrectly show "out of stock" warning, when added to cart; regardless of inventory.

Here's an example:

http://www.mthighmedia.com/ZC/index....roducts_id=180

ADMIN:
1) add "new product x" to "any--product category"
2) add attributes with dropdown form (Small, Medium, Large…whatever)
3) add 2nd set of attributes, also dropdown form (black,white…whatever)
4) populate each variant of "new product x" with stock (10 each… or whatever)
5) synq quantities

CATALOG/front end:
5) from catalog/categories/any--product category: select "new product x"
6) from product description page: add 1 to cart
7) do you get "out of stock warning" ?
8) RSVP

sWitt--OVER!