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

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.

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

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

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.

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.php?main_page=product_info&products_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?? :wacko:

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

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.

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.

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

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.

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.php?main_page=product_info&products_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" :yes: :no: ?
8) RSVP

sWitt--OVER!

sWitt,
I am not seeing this same behavior on my test cart. See here:
https://www.naturewearorganics.com/store_v1302

Papacek,
I do know that the original PWAS by Dafonz was NOT compatible w/ Dual Prices, so I'm not surprised to hear that you are having trouble. I thought someone was working on getting the two to work together way back when, but I don't think it ever happenned. Take a look at the archived thread for Dual Prices.

Audra

audradh,
thanx for the reply;

Stocks by attributes WORKS ON audradh's test site
i was able to test a working example
on your site (see link in previous post)
with two dropdown attributes for size & color.

--no "out of stock warning" that i've been experiencing!
--does this give any one a clue?
--could i have some db problems?
--applying the SQL patch, took 3 tries to get the name right
(mentioned in a post above) could there be a corruption
with similarly named tables?? i'll look to see if I can find
the first two improperly named tables & delete them--
any other leads??

thanx,
sWitt--OVER!

switt:

audradh,
thanx for the reply;

Stocks by attributes WORKS ON audradh's test site
i was able to test a working example
on your site (see link in previous post)
with two dropdown attributes for size & color.

--no "out of stock warning" that i've been experiencing!
--does this give any one a clue?
--could i have some db problems?
--applying the SQL patch, took 3 tries to get the name right
(mentioned in a post above) could there be a corruption
with similarly named tables?? i'll look to see if I can find
the first two improperly named tables & delete them--
any other leads??

thanx,
sWitt--OVER!
switt...

One thing I think of is to make sure that your templates/tpl_shopping_cart_default.php is correct. And also maybe just reload all of the files for the mod. Sometimes just one file can be forgotten....

Did you do any of the adjustments that were suggested in the older thread? Perhaps you're mixing a change with 1.2.6 for this version?

Just grasping at straws for ya!

Just to follow up on my previous post.

I have managed to convince my cart that it should display the stock level warning in red by editing the following piece of code in includes\functions\function_lookups.php

// modified to include attributes
function zen_check_stock($products_id, $products_quantity, $attributes = '') {

$stock_left = zen_get_products_stock($products_id, $attributes) - $products_quantity;
$out_of_stock = '';


if ($stock_left < 0 && !is_array($attributes)) {
  $out_of_stock = '<br/><span class="alert bold"><span class="markProductOutOfStock">' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . '</span>';
}
elseif ($stock_left < 0 && is_array($attributes)) {
  $out_of_stock = '<br/><span class="alert bold"><span class="markProductOutOfStock">' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . '</span>';
}

return $out_of_stock;

}

BUT the thing I still cannot get to show is the available stock quantity.

Anyone any clues what to add to make the available stock show up?

Please,, pretty please

Bunster

Bunster:

BUT the thing I still cannot get to show is the available stock quantity.

Anyone any clues what to add to make the available stock show up?

Please,, pretty please

Bunster

it isn't automatic. It requires additional coding and it doesn't work for tierd attributes. I can't remember if I posted about it earlier in this thread.

OK, so how would I transfer the data for this mod from my 1.2.7 database to the 1.3.0.2 database? Or does it all have to be manually entered again in the admin?

Nevermind, I figured it out :) The database patch is the same I guess, so it just automatically transferred them over when I upgraded the database. It wasn't showing before because for some reason the files didn't upload correctly into cpanel!

hi. this is a great module and a must have for my online store.

installed it and am having some concern. doesnt know if its my installation or what.
anyhow this is the scenario.

i have two items on cart ...

1 SHIRT-BLUE SIZE 60cm
1 SHIRT-BLUE SIZE 80cm

SHIRT-BLUE SIZE 80cm, is 0 in stock.

In shopping cart, there is a message the items is out of stock, but doesnt mark which item is actually out of stock. shouldn't SHIRT-BLUE SIZE 80cm have "***" ?

How do I mark out of stock items with '***'?

makulit:

hi. this is a great module and a must have for my online store.

installed it and am having some concern. doesnt know if its my installation or what.
anyhow this is the scenario.

i have two items on cart ...

1 SHIRT-BLUE SIZE 60cm
1 SHIRT-BLUE SIZE 80cm

SHIRT-BLUE SIZE 80cm, is 0 in stock.

In shopping cart, there is a message the items is out of stock, but doesnt mark which item is actually out of stock. shouldn't SHIRT-BLUE SIZE 80cm have "***" ?

How do I mark out of stock items with '***'?

In your admin, under Configuration-Stock, you will see an option called Mark Product Out Of Stock. That is where you would enter *** or whatever you would like to use as an out of stock symbol.

Danielle:

In your admin, under Configuration-Stock, you will see an option called Mark Product Out Of Stock. That is where you would enter *** or whatever you would like to use as an out of stock symbol.

Hi Danielle.

Yes, Admin > Configuration > Stock > Mark Product Out of Stock is set to ***
But it doesnt show on checkout :(

Where else can I check this problem? Any idea?

Thanks!