Stock by Attributes 5.0 Beta (for v1.5.0)

[countrycharm]

So, Kevin, I don't know if you also watch the EP4 thread. http://www.zen-cart.com/showthread.p...7&goto=newpost
But, shortly after you posted the above question, someone else posted a similar question in that thread. Although it takes three data points to identify a trend, in many cases I respond on just two. As a result, I have been working on implementation of both a detailed and basic export/import using EP4 and the version of SBA that I have installed. (Again not sure which it really is, but once implemented shouldn't be extremely difficult to replicate for other versions).

I have it working for detailed report, though still have some tweaks to make the results more user understandable and to move away from using the stock_id number when writing back to the database.

But, that said and if you're at all familiar with github, you can go to chadderuski's github and then follow the branch to my version and download the latest available.

As I understand though, chadderruski is looking to push a significant change/update. In the meantime, I will also be rearranging my changes so that they can be easily integrated into his mods with minimal effort.

For now, the functionality of the detailed export/import is to affect quantities (and sort order if respected by output(s)) of items that already are being tracked by SBA. A basic SBA function is in the works to add tracking of stock of individually attributal product(s). So basically if you already have blue frames being tracked and want to adjust the quantity of them then you can do that with the updated code already presented (detailed SBA import/export, but if you want to add a new pink frame, then will have to wait for the new functionality (basic SBA import/export) or develop it on your own.

mc12345678 have you finished implementing the code for easy populate yet? I'm looking and waiting for easy populate 4 and Stock by Attributes to be able to work together showing the qty. Any update on this. I seem not to be able to find you on the github. Thank You

[mc12345678]

mc12345678 have you finished implementing the code for easy populate yet? I'm looking and waiting for easy populate 4 and Stock by Attributes to be able to work together showing the qty. Any update on this. I seem not to be able to find you on the github. Thank You

I had/have implemented a detailed import/export of SBA data (works similar to a detailed attribute file in that existing SBA groupings can have their quantities revised, which I think is what you are asking about. There is one flaw in the coding if the EP4 associated with my account is used and SBA is not found to be installed (correction is in the EP4 forum thread).

Should see Easy Populate 4 on github if you go to htt p s://github com/mc12345678 (spaces removed)

Fyi, if the SBA table is not built as checked in the program and the bug corrected in the eP4 forum is not applied, then import of a file like a full_ep4 file will result in no data being imported. So if you think you have a properly formatted CSV file and it seems like data should be updated, but none is and no error code is provided, then without applying the very small patch, it means that the SBA table in your install (assuming it exists) is different than what the version of EP4 was modified for. If that is the case, please post issues associated with it on the EP4 thread.

[countrycharm]

I had/have implemented a detailed import/export of SBA data (works similar to a detailed attribute file in that existing SBA groupings can have their quantities revised, which I think is what you are asking about. There is one flaw in the coding if the EP4 associated with my account is used and SBA is not found to be installed (correction is in the EP4 forum thread).

Should see Easy Populate 4 on github if you go to htt p s://github com/mc12345678 (spaces removed)

Fyi, if the SBA table is not built as checked in the program and the bug corrected in the eP4 forum is not applied, then import of a file like a full_ep4 file will result in no data being imported. So if you think you have a properly formatted CSV file and it seems like data should be updated, but none is and no error code is provided, then without applying the very small patch, it means that the SBA table in your install (assuming it exists) is different than what the version of EP4 was modified for. If that is the case, please post issues associated with it on the EP4 thread.

Thank you for you speedy response. You mean the bug fix
http://www.zen-cart.com/showthread.p...18#post1236718

[mc12345678]

Thank you for you speedy response. You mean the bug fix
http://www.zen-cart.com/showthread.p...18#post1236718

Yes, without that fix, the modified version of EP4 will work on systems that have the SBA table setup as checked for, but will not import a report that is called/considered a full report, well actually now that I recall the logic, the core information for all imports won't work.

But yes, if you download the version I've modified, make the change referenced in the above link to the import file, then EP4 will work as it "normally" does. If the SBA table is setup as searched for, then a new option will appear on the main menu. If it is not setup as "expected" then no SBA menu option will be available. If that is the case, then it could be made so, but I didn't want to blindly implement that option if there were other details that needed to be understood to properly implement it.

Yes that fix. sorry. :)

[countrycharm]

Yes, without that fix, the modified version of EP4 will work on systems that have the SBA table setup as checked for, but will not import a report that is called/considered a full report, well actually now that I recall the logic, the core information for all imports won't work.

But yes, if you download the version I've modified, make the change referenced in the above link to the import file, then EP4 will work as it "normally" does. If the SBA table is setup as searched for, then a new option will appear on the main menu. If it is not setup as "expected" then no SBA menu option will be available. If that is the case, then it could be made so, but I didn't want to blindly implement that option if there were other details that needed to be understood to properly implement it.

Yes that fix. sorry. :)

One more question if I can so kindly ask. Which Stock by Attributes mod needs to be installed. If this one in this thread I don't where to download it at. The link in here doesn't work anymore.
The link to your easy populate doesn't work either. htt p s://github com/mc12345678 (spaces removed)......lol

[mc12345678]

One more question if I can so kindly ask. Which Stock by Attributes mod needs to be installed. If this one in this thread I don't where to download it at. The link in here doesn't work anymore.
The link to your easy populate doesn't work either. htt p s://github com/mc12345678 (spaces removed)......lol

You are correct that if followed word for word, one would still not be able to find me on github. :)

So, I believe it was the robophung version of SBA that I used, but on my install I had detached the special "wwindows" that would be auto updated based on quantity because that had not been fully developed. I guess I could through that version up onto github, though I don't know what the reason for robophung taking it offline was. Also, if you take a look at I think it is the functions file of EP4, there is a function similar to SBA_EP4Exists that inspects the number of columns and the titles of the columns. If they don't match with the fields in the routine then "SBA" doesn't exist. That was perhaps one of the "easiest" ways I could ensure that the table would be relatively "used" as expected.

So on the web address to be clear(er?) Remove/replace the spaces as necessary to restore the address to a valid web address.

[countrycharm]

You are correct that if followed word for word, one would still not be able to find me on github. :)

So, I believe it was the robophung version of SBA that I used, but on my install I had detached the special "wwindows" that would be auto updated based on quantity because that had not been fully developed. I guess I could through that version up onto github, though I don't know what the reason for robophung taking it offline was. Also, if you take a look at I think it is the functions file of EP4, there is a function similar to SBA_EP4Exists that inspects the number of columns and the titles of the columns. If they don't match with the fields in the routine then "SBA" doesn't exist. That was perhaps one of the "easiest" ways I could ensure that the table would be relatively "used" as expected.

So on the web address to be clear(er?) Remove/replace the spaces as necessary to restore the address to a valid web address.

My client has this version installed creinold_SBA5.1_alpha_version1.5_for_zen_cart_V1.5.0 along with easy populate 4.
Not sure what version of easy populate they have installed.
So I'm just making sure one more time your version you updated will work before I install it on there site.

[mc12345678]

My client has this version installed creinold_SBA5.1_alpha_version1.5_for_zen_cart_V1.5.0 along with easy populate 4.
Not sure what version of easy populate they have installed.
So I'm just making sure one more time your version you updated will work before I install it on there site.

While I don't plan on reviewing creinold's version or much of anything computer related the rest of the night, if you are able to identify the number of fields, the field names and the table "base name" (prefixes are addressed as appropriate). With the modification noted above it will work as EP4 normally does, and with an added export and import option to address the count of items maintained by SBA. If the quantity and type of the above matches, then thenew option will be present, if not, then it will work like EP4 normally does.

[countrycharm]

While I don't plan on reviewing creinold's version or much of anything computer related the rest of the night, if you are able to identify the number of fields, the field names and the table "base name" (prefixes are addressed as appropriate). With the modification noted above it will work as EP4 normally does, and with an added export and import option to address the count of items maintained by SBA. If the quantity and type of the above matches, then thenew option will be present, if not, then it will work like EP4 normally does.

Thank you for all you have done so far. One more question and I'm done. Is there anyway you can send me the sba you have since it is no longer downloadable. I don't know why someone hasn't already uploaded it to zen cart.

Have a good weekend

[mc12345678]

My client has this version installed creinold_SBA5.1_alpha_version1.5_for_zen_cart_V1.5.0 along with easy populate 4.
Not sure what version of easy populate they have installed.
So I'm just making sure one more time your version you updated will work before I install it on there site.

While I don't plan on reviewing creinold's version or much of anything computer related the rest of the night, if you are able to identify the number of fields, the field names and the table "base name" (prefixes are addressed as appropriate). With the modification noted above it will work as EP4 normally does, and with an added export and import option to address the count of items maintained by SBA. If the quantity and type of the above matches, then thenew option will be present, if not, then it will work like EP4 normally does.

Besides, ideally tests should be made with an alternative/backup version of the site. That way problems can be identified on something other than a live store.