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

[Lunny]

Hi Greg.

Did you find a fix for this yet? I've been having the same issue too for about a week now. I'm also using v1.5.1. Everything else works fine. The funny thing is though, that when when I select the "Products with Attributes Stock (aka SBA)" option, it then says shows the heading of the page to be "Stock By Attribute (SBA) Stock Page Version 1.5.2". So is there a compatibility problem because the site is 1.5.1 but it's saying that particular page is 1.5.2?

Thanks.

[magz]

Hi,

I'm testing SBA 1.5.2 (upgrade from 1.5.0) on ZC 1.5.1, and am grateful for the fact that available stock appears in the cart for products both with and without attributes. However, I'm having trouble with miscalculated stock for products with attributes. It's probably just a setting somewhere that I need to change, but can't figure out which one. Here's the situation:

I have ukuleles that can be purchased with or without optional gig bags. In my test, I use 2 ukes of the same model. The desired behavior is: if someone orders 1 or 2 ukes (both with bags OR both without bags OR 1 with and 1 without), they should NOT get an insufficient stock message. If someone tries to buy 3 or more ukes (with or without bags), they SHOULD get the insufficient stock message. Currently, the system somehow thinks that I have 2 ukes with bags and 2 separate ukes without bags, so someone can put 2 ukes with bags and 2 without in their cart and not get the low stock warning, though they should. What am I doing wrong?

Here's how I have the uke set up:
- the gig bag attribute type is check box
- quantity of the product is set to 2
- qty of attribute is 2 (when it was 0, I was getting low stock msg even when ordering 1 uke with bag, and available qty was blank, not even 0)
- in Configuration->Stock, "SBA Show Available Stock Level in Cart (when less than order)" is set to true, the other SBA items are set to false.

I'll appreciate your guidance.... Thank you!
Magz

[Lunny]

Hi Greg.

Did you find a fix for this yet? I've been having the same issue too for about a week now. I'm also using v1.5.1. Everything else works fine. The funny thing is though, that when when I select the "Products with Attributes Stock (aka SBA)" option, it then says shows the heading of the page to be "Stock By Attribute (SBA) Stock Page Version 1.5.2". So is there a compatibility problem because the site is 1.5.1 but it's saying that particular page is 1.5.2?

Thanks.

[DivaVocals]

Hi Greg.

Did you find a fix for this yet? I've been having the same issue too for about a week now. I'm also using v1.5.1. Everything else works fine. The funny thing is though, that when when I select the "Products with Attributes Stock (aka SBA)" option, it then says shows the heading of the page to be "Stock By Attribute (SBA) Stock Page Version 1.5.2". So is there a compatibility problem because the site is 1.5.1 but it's saying that particular page is 1.5.2?

Thanks.

FYI.. post bumping or duplicating your posts is very much frowned upon.. if no one has responded to your post it may be that people are busy where they don't have an answer..

also a posting tip for you it always helps if you quote the post you're responding to.. otherwise it's very hard to tell what problem you are also having..

[potteryhouse]

Hi Greg.

Did you find a fix for this yet? I've been having the same issue too for about a week now. I'm also using v1.5.1. Everything else works fine. The funny thing is though, that when when I select the "Products with Attributes Stock (aka SBA)" option, it then says shows the heading of the page to be "Stock By Attribute (SBA) Stock Page Version 1.5.2". So is there a compatibility problem because the site is 1.5.1 but it's saying that particular page is 1.5.2?

Thanks.

Hi,
The SBA Mod version 1.5.2 was written for Zen Cart 1.5.1, the version 1.5.2 was used to indicated a MAJOR or Significant change. In this case the mod version 1.5.2 now supports a "Custom ID" field. But, to use this new mod and new field there was a change to the SBA Table, thus if you have not, you should run the

Full/Upgrade DB Install
Full, makes all script changes to the database (DB) (i.e., adds new SBA table, adds entries into the Admin page, and new entries into the Configuration file).
Upgrade, updates Configuration file and the SBA table as needed. If run again, it will "Clean" table entries and reapply the settings, it will not affect current data in the "products_with_attributes_stock" table.

This will add the new field to the database, based on the testing I just conducted I suspect those having problems with 1.5.2 have not run this script or that for some reason it has not added the new field.

`customid` VARCHAR(255) NULL DEFAULT NULL,

Have you run this script to "Update" the database table?
Do you have this new field in the database table for SBA?

FYI, I was on vacation and could not help as I did not have access to a test environment.

[palafirst]

Something strange is happening and I cannot find the answer in any of my searches. Have been building a new Zen Cart (v1.5.1) site using Stock by Attributes (the new version by potteryhouse). Everything was working fine, but shortly after moving the site to the actual server the Products with Attributes Stock isn't working. When I click on the menu option under Catelog I get the list of the products with attributes and I can click "Add Quantity For Product Variant" or "Edit Quantity" and see the product attribute (size), but when I make any change and click "Submit" I immediately get an error page "The connection was reset. The connection to the server was reset while the page was loading."

I don't think this is connected to moving to the new server because someone has been able to add some inventory numbers since the move.

Any ideas. I'm rather desperate. Really need to get this site up and running. The site is at www.cocoroots.com/cart

Thanks,
Greg

THE PLOT THICKENS...

PotteryHouse has been trying to help me with this issue and it looks like it could be something with the fact that the site is hosted on GoDaddy. I installed the identical site on BlueHost and it works fine. Anyone else having this problem? Anyone come up with a solution? To help here is what PotteryHouse has written me about this:

BEGINNING OF MESSAGE: I suspect that GoDaddy has some base site configuration issue, since the same files worked fine for you on Bluehost, Also, I use both bluehost and hostmonster (they are the same company just different brand manning, and for the most part same servers)

Things to check to compare GoDaddy and Bluehost I think would be the htaccesss files, the version of PHP used, and the versions of the MySQL databases.
Any of these may cause issues if too new or too old. as a note, the Zen Cart team recently released a Beta version of Zen Cart 1.5.2 that is to address issues with PHP 5.4 and 5.5, this is a first step to the next major release of Zen Cart 1.6.

Anyway the log error foreach() sounds to me to be a PHP version issue, on bluehost and hostmonster you can add a line in the htaccess file to specify which version of PHP to use. GoDaddy may also support this, but I do not know for sure since I have never used them. END OF MESSAGE

The error message he refers to is: PHP Warning: Invalid argument supplied for foreach() in /home/content/15/7409315/html/cart/zcadmin/products_with_attributes_stock.php on line 414

I do not know if this error is the real problem since I've tried testing this problem several times today and there have been no new errors logged.

Thanks in advance for any assistance. This one is starting to hurt.

[jsarwar]

Installed on 1.3.9h all files uploaded after sql successful upload but now getting following error message on product detail page

1146 Table 'freshhea_zc1.zen_zen_products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM zen_zen_products_with_attributes_stock AS a LEFT JOIN zen_products_attributes AS b ON (b.options_id=2 AND b.options_values_id=2) WHERE a.products_id = '58' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]


Any idea how to fix this or uninstall this module?

Thanks

[potteryhouse]

Installed on 1.3.9h all files uploaded after sql successful upload but now getting following error message on product detail page

1146 Table 'freshhea_zc1.zen_zen_products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM zen_zen_products_with_attributes_stock AS a LEFT JOIN zen_products_attributes AS b ON (b.options_id=2 AND b.options_values_id=2) WHERE a.products_id = '58' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]


Any idea how to fix this or uninstall this module?

Thanks

Hi,

For Zen Cart version 1.3.X you should have installed "Stock by Attributes - Version: 1.4.14" this is noted on the plugin page, each SBA version indicates what version of Zen Cart it will support.

If you have version 1.4.14 than the removal is to delete the files you added for this mod, in the case of files you updated / merged, replace them with the backup copies you (I hope you made) have. The changes to the database should not affect anything once those files are reverted, they can just be left alone.

If you installed the SBA version 1.5.x than you do basically the same thing as above, with the exception, the 1.5.x version has a script to remove the database changes the versions 1.5.1.2 and 1.5.2 have the script available from the "Configuration -> Products with Attributes Stock (aka SBA) Setup", read the provided instructions from the download, it explains the removal.

If you have suggestions for improvement please let us know and we can update the instructions.

[magz]

Hi,

I'm testing SBA 1.5.2 (upgrade from 1.5.0) on ZC 1.5.1, and am grateful for the fact that available stock appears in the cart for products both with and without attributes. However, I'm having trouble with miscalculated stock for products with attributes. It's probably just a setting somewhere that I need to change, but can't figure out which one. Here's the situation:

I have ukuleles that can be purchased with or without optional gig bags. In my test, I use 2 ukes of the same model. The desired behavior is: if someone orders 1 or 2 ukes (both with bags OR both without bags OR 1 with and 1 without), they should NOT get an insufficient stock message. If someone tries to buy 3 or more ukes (with or without bags), they SHOULD get the insufficient stock message. Currently, the system somehow thinks that I have 2 ukes with bags and 2 separate ukes without bags, so someone can put 2 ukes with bags and 2 without in their cart and not get the low stock warning, though they should. What am I doing wrong?

Here's how I have the uke set up:
- the gig bag attribute type is check box
- quantity of the product (on product setup page) is set to 2
- qty of attribute is 2 (when it was 0, I was getting low stock msg even when ordering 1 uke with bag, and available qty was blank, not even 0)
- in Configuration->Stock, "SBA Show Available Stock Level in Cart (when less than order)" is set to true, the other SBA items are set to false.
- settings in attributes controller:


I'll appreciate your guidance.... Thank you!
Magz

PS- sorry for this duplicate post, I didn't know before that I could change the subject and I think my msg from Dec 1 drowned in the flood and went unnoticed...

[jsarwar]

I installed the correct version. I was able to get this corrected.
Thanks