Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[milobloom]

I made the change and It looks like I can work with that.

http://www.nothingbutcostumes.com/fi...e-p-15662.html

Do you know where I can find the TXT string that says Qty?

I want to change it to Available Stock Qty

[potteryhouse]

I made the change and It looks like I can work with that.

http://www.nothingbutcostumes.com/fi...e-p-15662.html

Do you know where I can find the TXT string that says Qty?

I want to change it to Available Stock Qty

You will find it in the file at:
includes\languages\english\extra_definitions\products_with_attributes.php

I noticed your shopping cart checkout page has incorrect info related to availability, the TEST2 mod I gave you a link to should fix that.
Let me know if you were able to get the test mod and your tests results. Thanks

[Kevin205]

Can I hide the attribute value if stock is Zero instead of saying it is out of stock?

If I understand your question correctly, You can hide the Out of Stock Message, by going to admin>Configuration>Stock>Check stock level ,and set it to False!

That stops the display of Out of Stock Message.

I hope it helps.

[ellivir]

I had a version from January but can't find a guide text if I need to run the full upgrade / install script in case I upgrade from the Jan 3 version to this latest version of 1.5.1.2. Atleast the upgrade script runs to a warning:

WARNING: An Error occurred, please refresh the page and try again.

The error log has this "FATAL ERROR":
PHP Fatal error: 1146:Table 'customer123_ws.products_with_attributes_stock' doesn't exist :: UPDATE products_with_attributes_stock SET quantity = '3' WHERE products_with_attributes_stock.stock_id =263 LIMIT 1 in /home/customer123/public_html/shop/includes/classes/db/mysql/query_factory.php on line 120

[ellivir]

ADDITIONALLY comes also an error:

PHP Fatal error: 1146: Table 'customer123_ws.zen_products_with_attributes_stock' doesn't exist :: SELECT pas.stock_id, COUNT(pas.stock_id) AS stockCount
FROM zen_products_with_attributes_stock pas
GROUP BY pas.products_id, pas.stock_attributes
HAVING stockCount > 1 in /home/customer123/public_html/kauppa/includes/classes/db/mysql/query_factory.php on line 120

so, it seems it doesn't understand that there is a PREFIX used in our webshop. How to fix that?

There is no "out of stock" or "stock saldo" visible on the product info page even if set up in configuration so.

[Kevin205]

I had a version from January but can't find a guide text if I need to run the full upgrade / install script in case I upgrade from the Jan 3 version to this latest version of 1.5.1.2. Atleast the upgrade script runs to a warning:

WARNING: An Error occurred, please refresh the page and try again.

The error log has this "FATAL ERROR":
PHP Fatal error: 1146:Table 'customer123_ws.products_with_attributes_stock' doesn't exist :: UPDATE products_with_attributes_stock SET quantity = '3' WHERE products_with_attributes_stock.stock_id =263 LIMIT 1 in /home/customer123/public_html/shop/includes/classes/db/mysql/query_factory.php on line 120

Where did you get version 1.5.1.2 from?

[Kevin205]

I had a version from January but can't find a guide text if I need to run the full upgrade / install script in case I upgrade from the Jan 3 version to this latest version of 1.5.1.2. Atleast the upgrade script runs to a warning:

WARNING: An Error occurred, please refresh the page and try again.

The error log has this "FATAL ERROR":
PHP Fatal error: 1146:Table 'customer123_ws.products_with_attributes_stock' doesn't exist :: UPDATE products_with_attributes_stock SET quantity = '3' WHERE products_with_attributes_stock.stock_id =263 LIMIT 1 in /home/customer123/public_html/shop/includes/classes/db/mysql/query_factory.php on line 120

It seems that Stock by Attributes has been released.


Make sure you are not trying to upgrade from 1.4.XX on Zen Cart 1.3.X.

Are you installing this mod on Zen Cart 1.5.1?

Have you installed any other versions of this mod on your cart? If yes, which version?

[potteryhouse]

ADDITIONALLY comes also an error:

so, it seems it doesn't understand that there is a PREFIX used in our webshop. How to fix that?

There is no "out of stock" or "stock saldo" visible on the product info page even if set up in configuration so.

You were correct, There was one instance (line 293) that was missing the database table prefix. The attached file is corrected, and will be included in the next version. Attachment 13088

Thank you.

[potteryhouse]

I had a version from January but can't find a guide text if I need to run the full upgrade / install script in case I upgrade from the Jan 3 version to this latest version of 1.5.1.2. Atleast the upgrade script runs to a warning:

WARNING: An Error occurred, please refresh the page and try again.

The error log has this "FATAL ERROR":
PHP Fatal error: 1146:Table 'customer123_ws.products_with_attributes_stock' doesn't exist :: UPDATE products_with_attributes_stock SET quantity = '3' WHERE products_with_attributes_stock.stock_id =263 LIMIT 1 in /home/customer123/public_html/shop/includes/classes/db/mysql/query_factory.php on line 120

Hi,
I was wondering if the updated file I provided on the forum corrected your install errors.

Thanks.

[ray-the-otter]

HI, is it possible to do a 'bulk' or 'batch' action to "Add Quantity For Product Variant" on all products at once?

My problem see, is that I seem to have to mouse-click on "Add Quantity For Product Variant" for each product, then select ALL and the add Quantity to create the Stock ID.

I'd like to be able to Add "Quantity For Product Variant" on all products that have attributes at once. As I have 2000+ products, all with the same 15 attributes. And it is taking some time to do this individually, product by product, just to create the 'Stock ID'

All help appreciated, thanks