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

[swamyg1]

Does anyone know why I occassionally have to press the "Sync product quantity" button next to the product? If I don't do this, my entered stock values are not being reflected on the front end... Is this something that's necessary with the ajax version? The previous versions did not require this to the best of my knowledge.

[buzzworm2]

Is there a bug regarding the sort column in SBA 1-4-13? This is the only version of SBA I have tried but when I try to add stock on the "Products with Attributes Stock" page I get this error:

1364 Field 'sort' doesn't have a default value
in:
[insert into `jfaz_products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (68,"1",6) ON DUPLICATE KEY UPDATE `stock_attributes` = "1", `quantity` = 6]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Looking at the code I see the sort column is in fact defined as "NOT NULL" by the stock_attribute.sql file in the download. However, the insert statements in the file admin/products_with_attributes_stock.php do not populate the "sort" column. As a test, I altered the *products_with_attributes_stock.sort column to have a default of 0. This fixed the error but of course every record has "0" in this column which probably defeats whatever purpose this column has.

Does anyone know what the "sort" column is used for and why the table definition doesn't match the insert statements?

thanks

[ellivir]

After installing Stock by Attributes 1.4.13, the shipping addresses (all 3 in the customer orders in admin) disappeared. In the place of them, there is only a comma! Since orders.php has been edited for this module, there may be some bug in it. Has anyone else noted this?

Elli

[evaudio]

OK so apparently i am not installing this mod correctly. I followed the instructions, but it does not stat where to put the ajax folder files at. I figured it was just into the main area, but apparently not.

I am using 1.3.9h and followed everything to the letter. I did have to add a /* - */ between line 3007 - 3020, i had to do this so the admin area would show back up.

I am selling a bunch of shirts, and it is a pain in the rear to keep track of and this would help a ton.

[athena]

Does anyone know why I occassionally have to press the "Sync product quantity" button next to the product? If I don't do this, my entered stock values are not being reflected on the front end... Is this something that's necessary with the ajax version? The previous versions did not require this to the best of my knowledge.

We are double checking the sync procedure also as we noticed this.....i think you have it installed correctly. We do like the newer feature of being able to change multiple attributes at a time (since our last upgrade) so it is worth the effort.

[evaudio]

Does this mod generate any type of report that can be printed or emailed?

[athena]

OK so apparently i am not installing this mod correctly. I followed the instructions, but it does not stat where to put the ajax folder files at. I figured it was just into the main area, but apparently not.

I am using 1.3.9h and followed everything to the letter. I did have to add a /* - */ between line 3007 - 3020, i had to do this so the admin area would show back up.

I am selling a bunch of shirts, and it is a pain in the rear to keep track of and this would help a ton.

Hi...I'm not an expert...but you are right, the ajax folder is placed in the the same folder as your admin.

When the mod shows a file structure with "admin" it means the file you renamed for your own admin.

So:

admin (aka "your admin folder")
ajax
includes

means they should look just like that in your directory.

I did this install with three issues that we corrected by starting over again...and again...but it works pretty flawlessly:

First issue: Lots of mods installed so BTW only had to make the one edit to orders.php required by the mod

Second issue: needed to run the extra sql statement as we were upgrading: update_1_4_10.sql

Third issue: the file /includes/modules/pages/shopping_cart/header_php.php in the newest version still wrecks havoc with the stock totals...has been updated but still has issues with things being added to the cart that do not have attributes after items that do have attributes, showing out of stock. see my post above for the file to replace for that.

[jazdeep]

Hi,

where is this file located? I can't seem to find it ...

products_with_attributes_stock.php

thanks

[jazdeep]

nvm found it im new at this haha

[ellivir]

Hi...

First issue: Lots of mods installed so BTW only had to make the one edit to orders.php required by the mod

Did you experience also this:
"After installing Stock by Attributes 1.4.13, the shipping addresses (all 3 in the customer orders in admin) disappeared. In the place of them, there is only a comma! Since orders.php has been edited for this module, there may be some bug in it. Has anyone else noted this?"

Maybe it would be worth to try to take an original 1.39h file and make the modification manually for it. Something must be wrong with the package file.

Elli