Stocks by attributes

I just download this mod from the Zen-Cart site.
On the admin/products_with_attributes_stock.php and the admin/functions/extra_functions/functions_qty_attribute.php files I had to fix the table calls. Instead of calling the defined tables, the scrips were calling the actual table names.

Stock Attribute v3.01.1 is the version that was on Free Add On page. Obviously, this needs to be updated.

LoganSix:

I just download this mod from the Zen-Cart site.
On the admin/products_with_attributes_stock.php and the admin/functions/extra_functions/functions_qty_attribute.php files I had to fix the table calls. Instead of calling the defined tables, the scrips were calling the actual table names.

What's the difference between defined tables and actual table names in terms of examples and why it matters?

If I were to guess I'd say that the difference is like that of creating a sql query or referencing a previously created sql query from one of the header_php.php files. My guess doesn't sound close to me.

oboeonetwothree:

What's the difference between defined tables and actual table names in terms of examples and why it matters?

The difference:
WRONG

"SELECT options_id FROM products_attributes WHERE products_id = $products_id..."

CORRECT

"SELECT options_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = $products_id..."

When the tables names are defined they include the assigned table prefix.

define('TABLE_PRODUCTS_ATTRIBUTES', DB_PREFIX . 'products_attributes');

If you assigned a table prefix to your Zen Cart tables, then not using the defined table name would cause an "table not found" error.

Apparently the Stock by Attributes from mcinallym is compatible with v1.3.8, unlike the StockAttribute from danielcor. So, I guess I will try to use that instead. I guess I'll pay more attention to the version numbers.

However, the issue that I found still needs to be fixed for the older versions.

LoganSix:

Apparently the Stock by Attributes from mcinallym is compatible with v1.3.8, unlike the StockAttribute from danielcor. So, I guess I will try to use that instead. I guess I'll pay more attention to the version numbers.

However, the issue that I found still needs to be fixed for the older versions.
The version that you originally downloaded was only compatible with Zen Cart versions prior 1.3.5. There's no need to update it, since 1.3.5 was a major security update and anybody using an easrlier version would use their time better by upgrading that trying to fix redunandant mods (there was a heap of other bugs in the older version too that were squeezed out in Stock by Attributes 4.0).

kuroi:

There's no need to update it, since 1.3.5 was a major security update and anybody using an easrlier version would use their time better by upgrading that trying to fix redunandant mods

They should remove it from the download page then.

Nonsense. It can be very useful when upgrading new clients' sites to be able to go back and see the original files for the mods installed.

Just because it's not a good idea to use it to build sites any more, doesn't mean that it isn't useful, and the downloads area is often an invaluable reference source.

How about a simple :

!! This download if for review only. The file contains errors. It is recommended that you use another add on. !!

And maybe link to the other add on.
Or, just move it to the Archived "older" Contributions link.

What is the point of having it in the download list if it is completely obsolete?

BTW, the Stock by Attributes v4.7a installed fine.
Thanks for your work on it.

I wish I had noticed it first and not had to uninstall the older version.

Followed all the instructions, all the files seem to be in place. However when I access Admin > Product with Attributes Stock I just get the following unfrormated text:

Product ID Product Name Product Model Quantity for all variants Add Quantity For Product Variant Sync Quantities

I'm at quite a loss about what's happening :(

Can anyone please help me with this...I'm kind of a novice, and after I installed the "stock_by_attributes_4-7MULTIADD" module, my product info pages has dissapeared...any help, pleaseeeee:shocking:

I have the mod installed and working fine. My question is it created a Product__wih_attributes_stock table whit has product_id Stock_attributes and quantity columns. I understand product ID has a relationship with the producs table and quantity is based on the product and attributes hence stock by attributes. My question is the stock_attributes_column does not appear to use the same value_ID as the attribute has in the products_attributes table. Can you explain what stock_attributes has a relationship with? I am having a hard time finding it. If I find a decent erd diagram program for mysql first I might find it and then I'll let you know.

Thanks

nevermind I obviously just had my brain turned off. Stock_attributes are simply the product_attribute_ID from the product attributes table. I didn't notice that the attribute is actually added to each individual product therfore being that each option on each product has a unique value.

Hi, I apologize if this has been posted before, but I've searched and haven't found any similar problem so here goes:
I've just installed "Stock by Attributes Version 4.7MULTIADD" to my shop Zen Cart Version v1.3.8.

When I view the new add-on in my admin/catalog drop down menu it say's: BOX_CATALOG_PRODUCTS_WITH_ATTRIBUTES_STOCK
When clicking on the link the table names and links looks funny, it display the file/php (?) name instead, like PWA_PRODUCT_ID, PWA_PRODUCT_NAME, PWA_PRODUCT_MODEL etc..

What did I do wrong? Please see attached screenshot...

Please help :blush:, thanks!
/Kicki

Found it, since I have another language installed as default it couldn't find the right file to add the titles. Had to copy the files from the English folder into my country folder...

/Kicki

Hi!

I've installed Stock by Attributes (4.7MULTIADD) on my ZenCart 1.3.8.

It works ok, but I can't delete variants. I confirm to delete product variant but there is no changes. It's still there.

I have to delete variants directly from MySql database. :dontgetit

I switched language of ZenCart in Admin Panel from Polish to English version and now Stocks by Attributes works OK...

There must be something wrong with language definitions, but I still don't know what...

Does this module allow each attribute to have a model number? Because I installed this and cannot seem to find out how to assign the model number to each attribute.... On http://www.zen-cart.com/wiki/index.php/Contribution:Stock_by_Attributes it said in the update that it is possible?

ryanb4614:

Does this module allow each attribute to have a model number? Because I installed this and cannot seem to find out how to assign the model number to each attribute.... On http://www.zen-cart.com/wiki/index.php/Contribution:Stock_by_Attributes it said in the update that it is possible?No, it doesn't. I think you must have misunderstood the bit of the wiki where it says you can add a "stock value" for each product variant. This has been updated to read "stock quantity".

Warning

I see that a lot of people are using the Multiadd variant of this mod. That's natural, since it's the lastest version. However, it doesn't appear to be supported by it's author or anybody using it.

When posting, please make clear what version you are using and which version of Zen Cart you have installed it upon.