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

[mc12345678]

Maybe I didn't read enough of the documenatation (or possibly didn't read the right documentation), but I'm trying to figure out how to correct a system response that I was seeing using the beta version posted for Zc 1.5.3.

Product has two attributes, they are dependent on each other, meaning whatever is selected for the first attribute the identifies how what is available of the second attribute. (I'm sure that it could/would work the other way, that picking the second option updates the availability of the first). All available combinations of items have the additional id tied to them in the sBA table. The first option has four values, the second option also has four values When looking at the list of the first option, there are 16 items presented, each having the applicable additional model# field next to the designation. The site is locally hosted, so I do not have a link. The install was performed using the all option. No additional "optional" SQL queries were run.

In reading the immediately available on screen information, I was not able to determine if I needed to run one of the optional SQLs, nor was itclear to me if running the "all" install query included or excluded the optionl queries. I'm guessing that the response seen is expected, and that I need to run an additional optional query, if the documentation available with the otherwise latest copy downloadable from the plugins section (official copy) clearly states this, I fully apologize for askingthe question and will take due diligence to review and answer my own question. I'm wondering in the interim if someone knows the answer if they could help me out.

Thank you, and I am so glad that so much has been done to make this feature available to ZC.

[webmiss]

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

[mc12345678]

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

Blank page typically results in n error log in store/logs folder. Please provide with dmin directory information obscured.

[jeking]

Just installed the mod stock_by_attribute_1.5.3 on latest version of zen-cart. When I went to the domain/admin/stock_by_attr_install.php all I got was a blank page. Now I get the same blank page when I go directly to the admin section to login. What do I do now?

Additionally, this plugin is not yet compatible with the 'latest version of zen-cart'. It's in the works though.

[mc12345678]

Additionally, this plugin is not yet compatible with the 'latest version of zen-cart'. It's in the works though.

Blank page typically results in n error log in store/logs folder. Please provide with dmin directory information obscured.

Doh! Yes, that is true. I thought there was something "off" about the version info, but I didn't chase it before posting.

[webmiss]

Do you know how long it will be til a newer version is available? My client really needs this. And I am running zc version 1.5.3.

[mc12345678]

Maybe I didn't read enough of the documenatation (or possibly didn't read the right documentation), but I'm trying to figure out how to correct a system response that I was seeing using the beta version posted for Zc 1.5.3.

Product has two attributes, they are dependent on each other, meaning whatever is selected for the first attribute the identifies how what is available of the second attribute. (I'm sure that it could/would work the other way, that picking the second option updates the availability of the first). All available combinations of items have the additional id tied to them in the sBA table. The first option has four values, the second option also has four values When looking at the list of the first option, there are 16 items presented, each having the applicable additional model# field next to the designation. The site is locally hosted, so I do not have a link. The install was performed using the all option. No additional "optional" SQL queries were run.

In reading the immediately available on screen information, I was not able to determine if I needed to run one of the optional SQLs, nor was itclear to me if running the "all" install query included or excluded the optionl queries. I'm guessing that the response seen is expected, and that I need to run an additional optional query, if the documentation available with the otherwise latest copy downloadable from the plugins section (official copy) clearly states this, I fully apologize for askingthe question and will take due diligence to review and answer my own question. I'm wondering in the interim if someone knows the answer if they could help me out.

Thank you, and I am so glad that so much has been done to make this feature available to ZC.

Okay, I have reread the help page for the install (This still is applicable to the 1.5.x Beta version for ZC 1.5.3.) The optional SQL does not appear to offer a change of how the attributes are displayed. So, as I stated above, two attributes (option names), each attribute has four values. In the SBA catalog option have created a total of 16 pairings of attributes (one mixture of each pairing, no single attribute). So, let's say I have attribute #1 that has values of 1,2,3,and 4. attribute #2 has values a, b,c,and d.

Therefore I have 1a, 1b, 1c, 1d, 2a, 2b, etc... Each of those has a customid filled in. (For reproduction, technically the customid is a number or if type cast to a number would have the same "result") When I go to the product_info page, the first attribute listed is populated with in essence all available combinations...

See attached image, if able. :)



For other information, the first attribute (misspelled) has a lower option number than the second. The sort order numbers are in the same sequence.

The installation is a vanilla ZC 1.5.3 hotfix 1, with mysql database backup, display logs, and superglobals installed.

I have noticed that after I make a selection (using firefox) that there is an error that is reported regarding the onchange option. that selectItemImage is not defined... Potentially a typing error? missing space? (Action is called on line 51 of includes\functions\extra_functions\products_with_attributes.php) No additional upgrade of jquery has been made beyond what is included in the beta plugin. Internet search has not revealed a similar function yet. Will look to see if that function is covered in the official ZC available version of SBA 1.5.3, but thought I would report it if there is something to be addressed for overall functionality.

[mc12345678]

Okay, I have reread the help page for the install (This still is applicable to the 1.5.x Beta version for ZC 1.5.3.) The optional SQL does not appear to offer a change of how the attributes are displayed. So, as I stated above, two attributes (option names), each attribute has four values. In the SBA catalog option have created a total of 16 pairings of attributes (one mixture of each pairing, no single attribute). So, let's say I have attribute #1 that has values of 1,2,3,and 4. attribute #2 has values a, b,c,and d.

Therefore I have 1a, 1b, 1c, 1d, 2a, 2b, etc... Each of those has a customid filled in. (For reproduction, technically the customid is a number or if type cast to a number would have the same "result") When I go to the product_info page, the first attribute listed is populated with in essence all available combinations...

See attached image, if able. :)



For other information, the first attribute (misspelled) has a lower option number than the second. The sort order numbers are in the same sequence.

The installation is a vanilla ZC 1.5.3 hotfix 1, with mysql database backup, display logs, and superglobals installed.

I have noticed that after I make a selection (using firefox) that there is an error that is reported regarding the onchange option. that selectItemImage is not defined... Potentially a typing error? missing space? (Action is called on line 51 of includes\functions\extra_functions\products_with_attributes.php) No additional upgrade of jquery has been made beyond what is included in the beta plugin. Internet search has not revealed a similar function yet. Will look to see if that function is covered in the official ZC available version of SBA 1.5.3, but thought I would report it if there is something to be addressed for overall functionality.

FYI, Haven't proven it yet, but I think that the revised SQL statement in the includes/modules/YOUR_TEMPLATE/attributes.php file at lines 101-114 and removal of the previous 122-126 may have caused this issue. Basically thinking (again no proof) that the new SQL returns more lines of data than are applicable whereas the previous first returned a "correct" number and then the second sql used data from the first instead of attempting to push all the response into one sql response... This seems to be the only real change in the file that potentially could affect the quantity of items in a list. Other changes were to identify new/different table abbreviations.

Curious what the affect will be to restore that sql statement and the follow-on changes made to accomodate. Seems to me that it should work like it used to... unless someone saw an issue with the way it worked before?

[mc12345678]

FYI, Haven't proven it yet, but I think that the revised SQL statement in the includes/modules/YOUR_TEMPLATE/attributes.php file at lines 101-114 and removal of the previous 122-126 may have caused this issue. Basically thinking (again no proof) that the new SQL returns more lines of data than are applicable whereas the previous first returned a "correct" number and then the second sql used data from the first instead of attempting to push all the response into one sql response... This seems to be the only real change in the file that potentially could affect the quantity of items in a list. Other changes were to identify new/different table abbreviations.

Curious what the affect will be to restore that sql statement and the follow-on changes made to accomodate. Seems to me that it should work like it used to... unless someone saw an issue with the way it worked before?

I see part of the issue... Want to have the quantity associated available and possibly the customid; however, access to that information becomes somewhat more difficult/unreliable without further scripting to reload the other dropdown(s) when the one is selected... Hmm.. Works fine if there is one attribute, but when starting to mix them? Well, seems that doesn't update the other when the one is selected..

So, found a partial solution... That is without additional javascript/ajax... Essentially if the product has one attribute tracked by SBA the solution would provide the ability to see the remaining quantity and designated customid for that product, if there is more than one attribute associated through SBA with the product then only the attribute's value name would be displayed...

Thinking of some alternatives, either the page reloads after an attribute is changed with the currently selected options passed to the new load, or some other means of updating (javascript or otherwise) is implemented to populate the remaining field(s).

The only thing that in my opinion/understanding is that it seems that the customid is intended to be used to designate a combination or particular series of attributes and therefore doesn't necessarily make sense on an individual basis when combined with others... I guess I could be wrong about that and maybe there is a grander scheme, but I've been pondering this aspect for a long time. :/ For the example provided in the previous image, I attempted to designate a quantity of the individual first attribute that also had a combination with the second attribute and can not see how that addition impacted anything other than populating a record in the database. Maybe once I have "sold out" of one or more of its combination attributes it may be clearer...

I'll present my solution if there is any interest soon, but don't really want to confuse things if there is a direction being headed... Don't need to go making more variants of this program which is finally coming together.

[potteryhouse]

I see part of the issue... .

I'll present my solution if there is any interest soon, but don't really want to confuse things if there is a direction being headed... Don't need to go making more variants of this program which is finally coming together.

Hi,

I have been trying to resolve this issue for sometime (and a related Orders and Basket thing I see), with limited susses. I am currently working a significant change (new concept) to the mode locally as a possible solution. But that may not end up working, so if you have another option please send what you think so we can have other perspectives. As a note, this mod has never to my knowledge supported multiple drop-downs that change when one has a selection change. I think others have used a separate filter plugin to do that, but that plugin does not work well with current changes, so I hope to build that functionality into the mod.

We (jeking and I) have started working together on this, there is a GitHub working copy available, but it is not for formal release, just development. Obviously when a production version is available it will be placed in the normal Zen Cart Plugins.