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

[Chargin]

How can I have a "cutdown" version of this plugin?
I find its really slow to use now, we have a few hundred products and each has about 40 or so attribute combinations. Particularly tedious when we have to edit a dozen or more stock levels for a particular product, each submit send you back to the list of all of the attribute stock levels.
Theres no pagination so the mod loads everything on the page at once.
All I want is the base page to only show the search function. That way I can edit the product I want and not load all the others.

Perhaps a way of using it as it is now as well, but I would be happy even just using 2 files and renaming one if I need the entire list.

I looked at the code but couldnt see an easy way of just deleting the part that lists everything.

[potteryhouse]

How can I have a "cutdown" version of this plugin?
I find its really slow to use now, we have a few hundred products and each has about 40 or so attribute combinations. Particularly tedious when we have to edit a dozen or more stock levels for a particular product, each submit send you back to the list of all of the attribute stock levels.
Theres no pagination so the mod loads everything on the page at once.
All I want is the base page to only show the search function. That way I can edit the product I want and not load all the others.

Perhaps a way of using it as it is now as well, but I would be happy even just using 2 files and renaming one if I need the entire list.

I looked at the code but couldnt see an easy way of just deleting the part that lists everything.

The attached file is a "Quick Fix", please test it to see if it does what you want before using on an active site.
The file will replace: stock_by_attribute\admin\includes\classes\products_with_attributes_stock.php
I suggest you back up before using this.
It will give you a search box, no product listing, and you must know the product ID number or product name to search for it (I commented out the model number as it gave me too many returns, you can change it back if you like, it is still in the file on line 115). Attachment 12884

Let me know how it goes please.


FYI, I have been trying to get pagination working with no good results as of yet.

[Chargin]

AWESOME :) thanks.
I will be sure to provide feedback within a couple of days.

The attached file is a "Quick Fix", please test it to see if it does what you want before using on an active site.
The file will replace: stock_by_attribute\admin\includes\classes\products_with_attributes_stock.php
I suggest you back up before using this.
It will give you a search box, no product listing, and you must know the product ID number or product name to search for it (I commented out the model number as it gave me too many returns, you can change it back if you like, it is still in the file on line 115). Attachment 12884

Let me know how it goes please.


FYI, I have been trying to get pagination working with no good results as of yet.

[maishane]

Oh my god I just found out I have an issue after installing this attribute module.

here is my website: http://www.minicoboutique.com
ZC version: 1.3.9.h


I have 2 types of products, the first one is no attributes needed, the second one is attributes needed. So I installed this Stock by Attribute module.

But I just realized only the products with attributes shows can be ordered, the products without attributes can't be ordered neither show detail.

Example:
With attributes: http://www.minicoboutique.com/index....products_id=92
Without attributes: http://www.minicoboutique.com/index....products_id=87

Looks like the products without attributes will be counted as 0 quantity even through I added quantity on product/category pages!? How can I fix it??

Thanks!!!

[potteryhouse]

Which version of the MOD did you install?
For Zen Cart 1.3.x you should have used Stock by Attributes - Version: 1.4.14
This is noted on the download page and in the installation instructions.

You may need to check your setting under Configuration/Stock
In there you have an option to allow checkout with low and out of stock items, this may need to be set to true.

Remember to ALWAYS test mods out on a local test server before putting them onto an active store, all too often mods will conflict with other mods you have installed. Because of the large number of mods available we seldom know of a problem until someone runs into it.

[maishane]

Which version of the MOD did you install?
For Zen Cart 1.3.x you should have used Stock by Attributes - Version: 1.4.14
This is noted on the download page and in the installation instructions.

You may need to check your setting under Configuration/Stock
In there you have an option to allow checkout with low and out of stock items, this may need to be set to true.

Remember to ALWAYS test mods out on a local test server before putting them onto an active store, all too often mods will conflict with other mods you have installed. Because of the large number of mods available we seldom know of a problem until someone runs into it.

Thank you for reply sir.

I checked the mod version is 1.4.14, Allow checkout is set as TRUE in Configuration/Stock. Do I still miss something?

Thanks...

[potteryhouse]

I checked the mod version is 1.4.14, Allow checkout is set as TRUE in Configuration/Stock. Do I still miss something?

You might also set "Configuration/Stock/Check stock level" to false
Just to see if that is causing the problem.

[Pablo]

AWESOME :) thanks.
I will be sure to provide feedback within a couple of days.

This works great but it is still a hassle to find the product id number.

I have modified one line in the stats_products_purchased.php file located in the root of YOUR_ADMIN folder.

FROM THIS:
$products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id']. "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name";

TO THIS:
$products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id']. "' group by pd.products_id order by pd.products_name ASC, p.products_id";

This will still show you the products purchased, but it displays them by name rather than by quantity purchased
and will also show zero quantity purchases so you can easily get a product id number.

Be sure to BACKUP your original file before you modify it.

[Chargin]

The attached file is a "Quick Fix", please test it to see if it does what you want before using on an active site.
The file will replace: stock_by_attribute\admin\includes\classes\products_with_attributes_stock.php
I suggest you back up before using this.
It will give you a search box, no product listing, and you must know the product ID number or product name to search for it (I commented out the model number as it gave me too many returns, you can change it back if you like, it is still in the file on line 115). Attachment 12884

Let me know how it goes please.


FYI, I have been trying to get pagination working with no good results as of yet.

This had worked out great for me, the stock edits are way faster now, love it.

The only feature I could see as being handy would be after editing or adding a stock level and hitting save, the page loaded next could show that product and its stock/attribute levels. That might be tricky though I dont know.

Thanks for this update, Im using it on a live site with no problems.

[Pablo]

The attached file is a "Quick Fix", please test it to see if it does what you want before using on an active site.
The file will replace: stock_by_attribute\admin\includes\classes\products_with_attributes_stock.php
I suggest you back up before using this.
It will give you a search box, no product listing, and you must know the product ID number or product name to search for it (I commented out the model number as it gave me too many returns, you can change it back if you like, it is still in the file on line 115). Attachment 12884

Let me know how it goes please.


FYI, I have been trying to get pagination working with no good results as of yet.

This works great but it is still a hassle to find the product id number.

I have modified one line in the stats_products_purchased.php file located in the root of YOUR_ADMIN folder.

FROM THIS:
$products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id']. "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name";

TO THIS:
$products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id']. "' group by pd.products_id order by pd.products_name ASC, p.products_id";

This will still show you the products purchased, but it displays them by name rather than by quantity purchased
and will also show zero quantity purchases so you can easily get a product id number.

Be sure to BACKUP your original file before you modify it.