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

[mc12345678]

So, I'm not sure your method of viewing this forum "thread" but yes in the last couple of pages it has been posted how to assign data information to apply data to get a non-stock tracked attribute "portion" assigned. I thought that the stock_by_attr_install screen was also updated to reflect some of the information related. I'm still waiting for other to provide feedback on its use/success before I dig into the user interface to improve its accesibility.

Ie. Right now a sql script has to be applied manually. There are a few ways and places I think it would be beneficial to allow applying such feature, but don't want to spend too much time on a feature if there are already major issues with it.

Post 2725 has instructions on how to apply the "gift wrap" option and also is some additional information before that.

[ivopivo]

Post 2725 has instructions on how to apply the "gift wrap" option and also is some additional information before that.

Thanks. I'm running SBA Version 1.5.4 / Zen Cart Version 1.5.4.

I don't have the "products_with_attributes_stock_attributes_non_stock" table, should I create it?

Or is this for another version of SBA?

I'm happy to give this a good test as I have many products that this feature would apply to.

[mc12345678]

Thanks. I'm running SBA Version 1.5.4 / Zen Cart Version 1.5.4.

I don't have the "products_with_attributes_stock_attributes_non_stock" table, should I create it?

Or is this for another version of SBA?

I'm happy to give this a good test as I have many products that this feature would apply to.

Use of the table takes more than just creating it. Unfortunately, version control is more so by date than version number. The date is related to when the software was downloaded from github at the following link: https://github.com/mc12345678/Stock_...butes_Combined which has been observed/reported as operational for ZC 1.5.0 through 1.5.5e. I have also incorporated ZC 1.5.6 files as they were on the date of incorporation.

Be glad to get some feedback other than need instructions. :) that part I know, but there is a lot of instruction covered in these later pages of the thread.

[basil3legs]

Hi mc12345678,

I decided to start my upgrade but ran into a couple of problems...

Firstly one of the files just would not load onto my server despite trying 2 different ftp programs - I haven't a clue why as it said it was copying fine but wasn't appearing server side. I managed to get around that by logging onto the server back end and pulling the file in from there! I hope there are no other files missing but I guess time will tell. This isn't an issue with what you have written so don't worry, just REALLY annoying! When I get around to updating the real site I might have to pull in all the files to be on the safe side.

Secondly I had a couple of problems with the Install program.

There are 2 typos in there
Line 1321 is missing the $ in !$field_exists
Line 1335 has "options" spelt wrong - this didn't effect me, I just happened to notice it.

Having corrected these it appeared to run through fine (just telling me to delete some old files) although it didn't add the idx_products_id_stock_attributes unique key to the products_with_attributes_stock table. I'm not sure how important that is but added it in manually anyway.

It is late now so I haven't even tried anything on the site itself but looking good so far.

[mc12345678]

The two items identified by line number have been updated in the install file.

Don't know what to say about the files not wanting to upload... :) as to the index key, well it is intended to help find data. Supposedly it would end up in there on its own, but better to start off with a good index all the same. Will see if there is something off about the script in that area.

[ivopivo]

Use of the table takes more than just creating it. Unfortunately, version control is more so by date than version number. The date is related to when the software was downloaded from github at the following link: https://github.com/mc12345678/Stock_...butes_Combined which has been observed/reported as operational for ZC 1.5.0 through 1.5.5e. I have also incorporated ZC 1.5.6 files as they were on the date of incorporation.

Be glad to get some feedback other than need instructions. :) that part I know, but there is a lot of instruction covered in these later pages of the thread.

I am using the method now. I haven't had issues, its been flawless. I have numerous products and have received orders with no issues to report in the SBA functionality. Everything working as it should.

[mc12345678]

I am using the method now. I haven't had issues, its been flawless. I have numerous products and have received orders with no issues to report in the SBA functionality. Everything working as it should.

Glad to hear and thank you for reporting back. :)

Hard to fix something that isn't known nor expressed to be a problem.

[izar74]

Hi,
just a question about SBA and Edit Orders. I installed both modules on a fresh 1.55e install. It seem all fine untill You try edit an order, in wich case i got this error:

[11-Oct-2017 00:16:09 UTC] Request URI: /../edit_orders.php?origin=index&page=1&oID=3&action=update_order, IP address: ::1
#1  products_with_attributes_stock_admin->updateEditOrdersAddProduct() called at [C:\..\includes\classes\class.base.php:103]
#2  base->notify() called at [C:\..\..min\includes\functions\extra_functions\edit_orders_functions.php:971]
#3  eo_add_product_to_order() called at [C:\w..\..admin\edit_orders.php:381]


[11-Oct-2017 00:16:09 UTC] PHP Warning:  Invalid argument supplied for foreach() in C:\..\...min\includes\classes\observers\class.products_with_attributes_stock.php on line 576

[11-Oct-2017 00:16:09 UTC] PHP Stack trace:

[11-Oct-2017 00:16:09 UTC] PHP   1. {main}() C:\...\..min\edit_orders.php:0

[11-Oct-2017 00:16:09 UTC] PHP   2. eo_add_product_to_order() C:\...\..min\edit_orders.php:381

[11-Oct-2017 00:16:09 UTC] PHP   3. base->notify() C:\..\..min\includes\functions\extra_functions\edit_orders_functions.php:971

[11-Oct-2017 00:16:09 UTC] PHP   4. products_with_attributes_stock_admin->updateEditOrdersAddProduct() C:\..\includes\classes\class.base.php:103 

What i noticed is that this error show if an article in the order has no SBA variant, infact it also show in the upper part the warning :
" Product 2 in the list below, named 'xxxxx', with a quantity of 1 did not exist. Attribute(s) selected:
Quantity: 50grams
Its attribute(s) were not updated.

Reading around i found quite nothing on how to integrate the 2 contributions or solve this, any help would be really appreciated.

Zencart 1.55e
Edit Orders 4.3.0 (last version from github)
SBA 1.5.4 (github last version)
PHP 5.6.31

[izar74]

An update...

The error shown before will be generate always when updating an order, no matter if the order has articles with SBA variants or not.
If you put an article with no SBA variant in the order it will not update and show the Warning:
" Product 2 in the list below, named 'xxxxx', with a quantity of 1 did not exist. Attribute(s) selected:
Quantity: 50grams
Its attribute(s) were not updated."

Sorry for the double post

[mc12345678]

Hi,
just a question about SBA and Edit Orders. I installed both modules on a fresh 1.55e install. It seem all fine untill You try edit an order, in wich case i got this error:

[11-Oct-2017 00:16:09 UTC] Request URI: /../edit_orders.php?origin=index&page=1&oID=3&action=update_order, IP address: ::1
#1  products_with_attributes_stock_admin->updateEditOrdersAddProduct() called at [C:\..\includes\classes\class.base.php:103]
#2  base->notify() called at [C:\..\..min\includes\functions\extra_functions\edit_orders_functions.php:971]
#3  eo_add_product_to_order() called at [C:\w..\..admin\edit_orders.php:381]


[11-Oct-2017 00:16:09 UTC] PHP Warning:  Invalid argument supplied for foreach() in C:\..\...min\includes\classes\observers\class.products_with_attributes_stock.php on line 576

[11-Oct-2017 00:16:09 UTC] PHP Stack trace:

[11-Oct-2017 00:16:09 UTC] PHP   1. {main}() C:\...\..min\edit_orders.php:0

[11-Oct-2017 00:16:09 UTC] PHP   2. eo_add_product_to_order() C:\...\..min\edit_orders.php:381

[11-Oct-2017 00:16:09 UTC] PHP   3. base->notify() C:\..\..min\includes\functions\extra_functions\edit_orders_functions.php:971

[11-Oct-2017 00:16:09 UTC] PHP   4. products_with_attributes_stock_admin->updateEditOrdersAddProduct() C:\..\includes\classes\class.base.php:103 

What i noticed is that this error show if an article in the order has no SBA variant, infact it also show in the upper part the warning :
" Product 2 in the list below, named 'xxxxx', with a quantity of 1 did not exist. Attribute(s) selected:
Quantity: 50grams
Its attribute(s) were not updated.

Reading around i found quite nothing on how to integrate the 2 contributions or solve this, any help would be really appreciated.

Zencart 1.55e
Edit Orders 4.3.0 (last version from github)
SBA 1.5.4 (github last version)
PHP 5.6.31

An update...

The error shown before will be generate always when updating an order, no matter if the order has articles with SBA variants or not.
If you put an article with no SBA variant in the order it will not update and show the Warning:
" Product 2 in the list below, named 'xxxxx', with a quantity of 1 did not exist. Attribute(s) selected:
Quantity: 50grams
Its attribute(s) were not updated."

Sorry for the double post

Yeah, you're the first one to report anything about it. Issues confirmed to exist and have been corrected through the following "comparison" commit (though this was discovered through use of EO 4.1.7 on ZC 1.5.5 that was slightly modified to work with SBA).

https://github.com/mc12345678/Stock_...3d1a60cda91485

These exist on the master branch of the plugin.