-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
Kevin205
Bump..
How could this be done, one product at a time for 1000s of products with 2, 3, 4, 5 attributes for each product?
Any one with any ideas?
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.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Hi
Will the Robophung version work with 1.5.1 Zen Cart? The install.txt says "These files are only for Zen-Cart version 1.5.0!!!"
Thanks!
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
Strelizia
Hi
Will the Robophung version work with 1.5.1 Zen Cart? The install.txt says "These files are only for Zen-Cart version 1.5.0!!!"
Thanks!
I may be going out on a limb, but I have recently begn the process of updating from 1.5.0 to .1 (even though at any time 1.6.0 may get released), from the comparisons and the writeups out there, I would say that there is not enough changed that would prevent it's use. Realize however, in incorporating the changes any core files that are modified (or copies f in the case of templates) may be different than those of 1.5.1. Ultimately I would think the statement was made to prevent installation of the plug-in to older versions of Zen-Cart that would not (or may not) support the product as written.
That said, when doing the appropriate file comparisons care should be taken to understand what the modified does and why it is being changed. (Ie is it part of thhe plugin or there for some other reason.)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Yep, so I thought - thanks!
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
just wondering.....is this being migrated from
Stock by Attributes 4.7Multiadd WITH TABLE FILTER
http://www.zen-cart.com/downloads.php?do=file&id=838
or a different one?
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
AmandaGero
Personally, I'm not sure I understand the qestion correctly. I think there are 4 or 5 versions of SBA that zen-cart recognizes as "official" versions of SBA. This thread was begun with version 5 by creinold, but then robophung picked up the software (or a similar version) and went on to develop some "improvements". So this version may now be a mix of several versions, as for migrating "from" another version, not sure that makes sense in this context. There may be attributes of that version captured in this, but I couldn't answer that aspect.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
AmandaGero
IMHO, SBA is one of the most FRAGMENTED and OVER FORKED modules in use for Zen Cart.. It's hard to say WHICH version of SBA was the basis of SBA v5.0. It was contributed by creinold, then forked or updated by robophung later.. Who knows.. For the record this version seems the best of the bunch..
Best thing you can do is to download this version and do a file comparison with Winmerge or Beyond Compare to see if you can spot the differences and where they occur.
Personally I would love to see a REAL SBA solution put together that covers ALL SBA needs, and not just the one or two needs of the contributors as most of these SBA variants are setup..
Good luck..
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
The reason i was asking is because when i was using zc 1.3.8 i hired a programmer to create a module for me that would allow me to have unique product sku per attribute. he did so, but in the documentation he sent me it said that i had to have the above module that i have mentioned installed first before it would work. so i installed the sba with table filter that i mentioned, and then installed the module that he created, and it did indeed work. i used it for some time on my site, but then i decided to shut my site down and stop using zc. i have recently decided i am going to start my new site up with wordpress but i wanted to offer some of the old zc modules that i had before. i have been trying to get this one to work with 1.5 but i just cannot get it. so if you guys are close with this one, i wanted to try to merge my old files with this version, but i am really not sure why this had to be installed in the first place.
Quote:
Originally Posted by
DivaVocals
IMHO, SBA is one of the most FRAGMENTED and OVER FORKED modules in use for Zen Cart.. It's hard to say WHICH version of SBA was the basis of SBA v5.0. It was contributed by creinold, then forked or updated by robophung later.. Who knows.. For the record this version seems the best of the bunch..
Best thing you can do is to download this version and do a file comparison with Winmerge or Beyond Compare to see if you can spot the differences and where they occur.
Personally I would love to see a REAL SBA solution put together that covers ALL SBA needs, and not just the one or two needs of the contributors as most of these SBA variants are setup..
Good luck..
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
AmandaGero
The reason i was asking is because when i was using zc 1.3.8 i hired a programmer to create a module for me that would allow me to have unique product sku per attribute. he did so, but in the documentation he sent me it said that i had to have the above module that i have mentioned installed first before it would work. so i installed the sba with table filter that i mentioned, and then installed the module that he created, and it did indeed work. i used it for some time on my site, but then i decided to shut my site down and stop using zc. i have recently decided i am going to start my new site up with wordpress but i wanted to offer some of the old zc modules that i had before. i have been trying to get this one to work with 1.5 but i just cannot get it. so if you guys are close with this one, i wanted to try to merge my old files with this version, but i am really not sure why this had to be installed in the first place.
So to me the reason is that SBA (whatever version employed) or something similar that ties the attributes available for a product directly to each product is the only way to modify a piece of information that is already unique to the product. Certainly an alternative would have been to possibly calculate on the fly, but it seems that you wanted to designate the unique SKU to that product (or at least have that ability). By using the existing program, additional programming was simplified. It may be that it could be modified to work with other versions of SBA, but would have to identify the "triggers" or interface between the two programs. Also, there may be other factors of ZC 1.5.x that are different preventing/inhibiting the use of that mod.
Basically, other SBAs may have be compatible, but the programmer had what they had and knew that it worked with that version, so I would say I don't blame them for making the statement that they did about compatibility.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
so my thing is, i want to have this available for the community since it is so wanted but i need help with it. but on the other hand i did pay alot for the programmer to do this for me. im going to keep trying to see if i can get this to work, and if i can get it to work on my own i will host it as a commercial add on, if not i will suck it up and post the package so the community may be able to figure it out.
edit: so i dont have to re-read all 30 pages, what are the known bugs for this version so far.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
While installing and comparing, "stock_by_attribute_1.5.1.1" vs "creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0".
I noticed a field called products_options_track_stock is added to the products_options table by "creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0". I am hoping it does as it's named. That is, If it's set to 0 for an attribute, the mod will NOT keep track of the inventory for that particular attribute or attributes. (by default it's set 1)
The shop owner has products that are priced by size attribute, but there are many other attributes defined as Read Only for the purposes of filtering and describing the products while searching in the product listing page, through the Dynamic Filter Mod. These read only attributes are color, shape and etc.
What is the purpose of products_options_track_stock? Because as I place a 0 in the products_options table for products_options_track_stock, it is still tracking and showing and trying to keep inventory of Color and Shape attributes.
Am I missing or doing something wrong here?
The other issues and problems that I have are:
- Can this mod keep track of only one attribute (in this case size)?
- How can I display the available inventory for the size attribute on the product info page?
- Why is it that when an attribute is not in the inventory, it does not show an Out of Stock Message on the product info page?
- If you already have products with attribute in your live site. How do populate the "products_with_attributes_stock" table with quantity data?
-
1 Attachment(s)
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Hey All...
I just installed "Stocks by Attributes" in Zen Cart 1.5.1. Everything seems to be working fine...EXCEPT...in my dropdown to choose size where I can see the quantity of each size I'm getting the HTML codes for bold so that it looks like this:
<b>Qty</b> 20
Attachment 13187
Can't figure out where that's coming from. Thanks in advance.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
palafirst
Hey All...
I just installed "Stocks by Attributes" in Zen Cart 1.5.1. Everything seems to be working fine...EXCEPT...in my dropdown to choose size where I can see the quantity of each size I'm getting the HTML codes for bold so that it looks like this:
<b>Qty</b> 20
Attachment 13187
Can't figure out where that's coming from. Thanks in advance.
Two thoughts, either in a language definition file or in the code that generates the information for the drop down. Do a search for Qty in your files from the admin panel. Try to identify where that is used: if there is a define statement with a word in all caps, search on the all caps word, otherwise open the code that uses the phrase specifically and should be able to follow where the html code gets put around the word if it not right where you found the phrase.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
I've searched the entire Zen Cart installation and I can't find anything that looks like it could be generating the <b>Qty</b> code. It is very strange. Was hoping that someone who has used the Stock by Attributes module might have had (and fixed) the same problem. The funny thing about it is that if I choose the Radio button or Checkbox option for the size attribute then it shows Qty just fine.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
palafirst
I've searched the entire Zen Cart installation and I can't find anything that looks like it could be generating the <b>Qty</b> code. It is very strange. Was hoping that someone who has used the Stock by Attributes module might have had (and fixed) the same problem. The funny thing about it is that if I choose the Radio button or Checkbox option for the size attribute then it shows Qty just fine.
Well there is a difference in generation of the content, a drop down doesn't really support html, while something like a radio button and a checkbox places the text in the processing area. So you mean to say that when you went to the admin panel, tools, developer's tool kit, then in the bottom left box typed in the three letters qty, then in the next box to the right selected admin/catalog, and starting with .php tried each file type and nothing came up? Or did you search with the anchors as part of the search?
I recall having some difficulty with content of drop downs when I installed SBA, but my problem is that it was one of my first plug-ins installed and as such, I didn't totally know what I was doing, but glad that I got it working to it's limited ability and presenting the way I wanted it to.
Be sure in the word search not to force it to be case sensitive.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Well there is a difference in generation of the content, a drop down doesn't really support html, while something like a radio button and a checkbox places the text in the processing area. So you mean to say that when you went to the admin panel, tools, developer's tool kit, then in the bottom left box typed in the three letters qty, then in the next box to the right selected admin/catalog, and starting with .php tried each file type and nothing came up? Or did you search with the anchors as part of the search?
I recall having some difficulty with content of drop downs when I installed SBA, but my problem is that it was one of my first plug-ins installed and as such, I didn't totally know what I was doing, but glad that I got it working to it's limited ability and presenting the way I wanted it to.
Be sure in the word search not to force it to be case sensitive.
On the other hand, it may be a field that has been populated in the database. Perhapps if you can search for other information in the vicinity of the Qty statement (or someone else remembers where this part is documented) then can narrow down what database entry contains that statement or could do a search from your mySQLadmin foor the qty entry. My previous response was provided to ensure clarity and accuracy of our discussion. This is something in addition to that if I happened to be repeating what you did or if I was wrong.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Just in case someone else comes across this problem I'm pasting the helpful private message I received from "potteryhouse."
Hi,
The forum you posted to is for a different branch of this mod, but if you are using the one I updated (1.5.1.2) than the file located at:
includes\languages\english\extra_definitions\products_with_attributes.php
is where the issue resides, simply update the file with a text editor and remove the <b> </b> found around the text.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
palafirst
Just in case someone else comes across this problem I'm pasting the helpful private message I received from "potteryhouse."
Hi,
The forum you posted to is for a different branch of this mod, but if you are using the one I updated (1.5.1.2) than the file located at:
includes\languages\english\extra_definitions\products_with_attributes.php
is where the issue resides, simply update the file with a text editor and remove the <b> </b> found around the text.
This file should have been identified by the search performed from ZC Admin Panel->Tools->Developers Tool Kit then entering in the Look-up in all Files Key or Name field the word qty, selecting in the All Files in Look-ups field At a minimum All Files-Catalog although All Files - Catalog/Admin would also find it, in this case selecting File Type as .php and leaving the Case Sensitive checkbox unselected then selecting the Search button to the right of that row.
As a side note, looking at the other defines applicable to the plugin described (not the one associated with this thread), there are other attributes that have < B > applied and may result in similar issues depending on how/where that plugin presents the information.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Hello all,
I'm looking for the best possible version of stock by attributes with dynamic dropdowns-- it seems like the version in this thread might be the best option.
I've combed through the posts in this thread but can't seem to find a working link to download the mod. http://www.robophung.net/zencart/cre...art_V1.5.0.zip
The one listed above returns a not found page.
Anybody have a working link?
Thanks zencart community for all the work!
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
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
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
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.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
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
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
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. :P sorry. :)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
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. :P 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
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
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. :P
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
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. :P
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. :D
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
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. :D
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.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
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
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
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. :D
Quote:
Originally Posted by
mc12345678
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.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
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
Buried I think it is in this thread, one of the other three/four, or yet another thread is a discussion on SBA outlining that ZC has basically stopped allowing the new addition of ever more SBA strains... There are too many out there now as it is, and it seems that not one of them "consolidates" all of the features and functionality of the others to give a consistent/uniform implementation.
I plan to upload the/a version that I obtained from this thread last year, but thing is I don't plan on maintaining it... Will be hard to keep saying that when/if continually asked, but I'd be posting it to allow the community to continue working on it. Something I have dreams of doing, but am working on a few other projects first and maintaining what little I've helped out on.
As for "the SBA I have" well, I started at one point to try to figure out which of the three or four versions I had installed, but got distracted as I think I had narrowed it down, but hadn't determined specifically which I had installed. So now as I upgrade through ZC versions, I just keep an eye out for SBA related code and incorporate it as applicable.
From what I have seen across the versions, it seems like the base framework of all SBA versions need some revamping. I could be wrong, but it seems like the table structure used to build the product variant quantities contains "too much" information and is not structured as it should be for a database dependent program such as ZC. It's all fine and dandy for me to say that, but implementation also is not/will not be fun. Will probably have to add a few handlers to be able to insert/retrieve the data in a format that remains understandable by the existing code, and then from there can improve on the code if any is needed.
Anyways, I'll try to get the copy of robophungs that I retrieved relatively "recently" before the link no longer worked up today in github.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Buried I think it is in this thread, one of the other three/four, or yet another thread is a discussion on SBA outlining that ZC has basically stopped allowing the new addition of ever more SBA strains... There are too many out there now as it is, and it seems that not one of them "consolidates" all of the features and functionality of the others to give a consistent/uniform implementation.
I plan to upload the/a version that I obtained from this thread last year, but thing is I don't plan on maintaining it... Will be hard to keep saying that when/if continually asked, but I'd be posting it to allow the community to continue working on it. Something I have dreams of doing, but am working on a few other projects first and maintaining what little I've helped out on.
As for "the SBA I have" well, I started at one point to try to figure out which of the three or four versions I had installed, but got distracted as I think I had narrowed it down, but hadn't determined specifically which I had installed. So now as I upgrade through ZC versions, I just keep an eye out for SBA related code and incorporate it as applicable.
From what I have seen across the versions, it seems like the base framework of all SBA versions need some revamping. I could be wrong, but it seems like the table structure used to build the product variant quantities contains "too much" information and is not structured as it should be for a database dependent program such as ZC. It's all fine and dandy for me to say that, but implementation also is not/will not be fun. Will probably have to add a few handlers to be able to insert/retrieve the data in a format that remains understandable by the existing code, and then from there can improve on the code if any is needed.
Anyways, I'll try to get the copy of robophungs that I retrieved relatively "recently" before the link no longer worked up today in github.
Sounds good and we all appreciate your fine work and support you have given.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
So I'm assuming my client is using the right version of SBA module.
After installing everything on my test site easy populate is adding another download link. I guess this is the right link.
Detailed Stock By Attributes Data (detailed multi-line)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
countrycharm
So I'm assuming my client is using the right version of SBA module.
After installing everything on my test site easy populate is adding another download link. I guess this is the right link.
Detailed Stock By Attributes Data (detailed multi-line)
At least it is a version that shouldn't be wrongly affected... :) At the very least you should be able to modify the available SBA quantities. Implementing the "Basic" import/export is actually a little more advanced than the "detailed" version, which is somewhat counter-intuitive unless you truly look at all that is going on in the process and it may be the differences in SBA modules that will change how the basic import/export is done, but in the meantime just about everything else can be done with EP4 and then the admin panel used to properly set the initial set of pattributes that will be tracked against the stock. :)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Hi
I have a lot of attributes for my products. I have set them a unique ID (code number) for each instance, but the ID doesn't appear on the order.
Is this normal, or are the custom Id's just for stock reference? Is there a way around this? Please advise.
Thanks in advance.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
dharrison
Hi
I have a lot of attributes for my products. I have set them a unique ID (code number) for each instance, but the ID doesn't appear on the order.
Is this normal, or are the custom Id's just for stock reference? Is there a way around this? Please advise.
Thanks in advance.
Not sure where this custom id you are referring to is, did you create another unique field, did you just happen to add more to the attribute text? Perhaps could share a web page link and a little bit of description about what special code we should expect to see? Could be that you don't have a setting turned on to display attributes in checkout, etc. Could be a template issue, could be that the orders.php file doesn't include that part of the order info. Help us, help you.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
dharrison
Hi
I have a lot of attributes for my products. I have set them a unique ID (code number) for each instance, but the ID doesn't appear on the order.
Is this normal, or are the custom Id's just for stock reference? Is there a way around this? Please advise.
Thanks in advance.
The description sounds like you are using the version supported in the thread: http://www.zen-cart.com/showthread.p...07#post1237407
If so, than in the "Configuration -> Stock" page, check your setting for "SBA Display Custom ID - Display Custom Id (if defined) in cart, checkout process and invoice. Options (True/False)"
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
potteryhouse
The description sounds like you are using the version supported in the thread:
http://www.zen-cart.com/showthread.p...07#post1237407
If so, than in the "Configuration -> Stock" page, check your setting for "
SBA Display Custom ID - Display Custom Id (if defined) in cart, checkout process and invoice. Options (True/False)"
Spot on! Thanks for your help.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Buried I think it is in this thread, one of the other three/four, or yet another thread is a discussion on SBA outlining that ZC has basically stopped allowing the new addition of ever more SBA strains... There are too many out there now as it is, and it seems that not one of them "consolidates" all of the features and functionality of the others to give a consistent/uniform implementation.
Which should have happened YEARS ago.. Like the many confusing cross sell mods, SBA got forked and forked and forked again, and NOT ONE of these forks (IMHO) did anything to bring an overall IMPROVED product to the table.. Some of these forks were added by authors who do not understand what the concept of OPEN SOURCE means.. So they fork an add-on because they added some NEW feature.. (the "model number" version of SBA is GREAT example of this - StockByAttributes with my stock id)
Some folks fork add-ons because they don't want to "make the author mad" by submitting an update with their NEW feature included.. Some submit them because they want "top billing" for their plugin.. Whatever the reason it makes NO SENSE to fork something unless it TRULY takes the add-on dev in a NEW direction.. (adding the ability to assign a model number to a product variant is NOT one of those reasons)
Each one of these versions of SBA added some new feature that the contributor felt he "had to have" but instead of adding it to the BASE version they would create their NEW fork (Fork A).. many of these fork authors didn't address any of the BUGS in the version they were forking from. So they would submit their NEW forked version with their NEW feature, but would leave broken features in place in their fork..
Then someone else would come along and take Fork A version FIX some broken functionality and add new functionality and submit it as a yet another NEW fork (ie: Stock by Attributes 4.7Multiadd WITH TABLE FILTER ). Then yet another person would fix fork A, but not consolidate it with fork B or even better yet consolidate it with the BASE version.. In the meantime folks were updating the base, but not bringing in the features from the forks.. Then there were the versions that never made it to the plugins repository AT ALL..
Anyway I could go on, but it's has been the MESSIEST of all mods because all these forks diluted the whole, and provided HALF working versions to anyone who DARED install SBA.. Rubbish..
Thank goodness for the recent work on SBA by potteryhouse.. He has fixed issues with SBA, IMPROVED the functionality of SBA and CONSOLIDATED features from the "multi-add" and "stock ID" forks of SBA back into the BASE version of SBA!!! Which is how it should have been done in the first place and it renders the need to install these version moot.. Anyone coming here looking for the now defunct RoboPhung fork of SBA should use the latest version of SBA by potteryhouse instead..
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
DivaVocals
Which should have happened YEARS ago.. Like the many confusing cross sell mods, SBA got forked and forked and forked again, and NOT ONE of these forks (IMHO) did anything to bring an overall IMPROVED product to the table.. Some of these forks were added by authors who do not understand what the concept of OPEN SOURCE means.. So they fork an add-on because they added some NEW feature.. (the "model number" version of SBA is GREAT example of this -
StockByAttributes with my stock id)
Some folks fork add-ons because they don't want to "make the author mad" by submitting an update with their NEW feature included.. Some submit them because they want "top billing" for their plugin.. Whatever the reason it makes NO SENSE to fork something unless it TRULY takes the add-on dev in a NEW direction.. (adding the ability to assign a model number to a product variant is NOT one of those reasons)
Each one of these versions of SBA added some new feature that the contributor felt he "had to have" but instead of adding it to the BASE version they would create their NEW fork (Fork A).. many of these fork authors didn't address any of the BUGS in the version they were forking from. So they would submit their NEW forked version with their NEW feature, but would leave broken features in place in their fork..
Then someone else would come along and take Fork A version FIX some broken functionality and add new functionality and submit it as a yet another NEW fork (ie:
Stock by Attributes 4.7Multiadd WITH TABLE FILTER ). Then yet another person would fix fork A, but not consolidate it with fork B or even better yet consolidate it with the BASE version.. In the meantime folks were updating the base, but not bringing in the features from the forks.. Then there were the versions that never made it to the plugins repository AT ALL..
Anyway I could go on, but it's has been the MESSIEST of all mods because all these forks diluted the whole, and provided HALF working versions to anyone who DARED install SBA.. Rubbish..
Thank goodness for the recent work on SBA by potteryhouse.. He has fixed issues with SBA, IMPROVED the functionality of SBA and CONSOLIDATED features from the "multi-add" and "stock ID" forks of SBA back into the BASE version of SBA!!! Which is how it should have been done in the first place and it renders the need to install these version moot.. Anyone coming here looking for the now defunct RoboPhung fork of SBA should use the latest version of SBA by potteryhouse instead..
Thank you Diva for the summary. Fortunately I didn't find a copy of the robophung version on the one computer I was looking in, and based on the above I will stop that search. Also, the mod I did for EP4, I will make corrections as necessary, including a note to appear suggesting that the above version be used in place of the one tested for if mods are identified in how I've written the additional code. (For others, this means that I will keep the existing code in place to support those that have come to use it and "refuse" to upgrade, but that the "new" version will be the one that will be incorporated.)
Timeline unknown, but this is the type of input I was hoping to hear. I realize that some of the above is opinion, but if it has been identified as the "fix" to some of the base issues then that is the direction I plan to assist with until something "better" is developed.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Thank you Diva for the summary. Fortunately I didn't find a copy of the robophung version on the one computer I was looking in, and based on the above I will stop that search. Also, the mod I did for EP4, I will make corrections as necessary, including a note to appear suggesting that the above version be used in place of the one tested for if mods are identified in how I've written the additional code. (For others, this means that I will keep the existing code in place to support those that have come to use it and "refuse" to upgrade, but that the "new" version will be the one that will be incorporated.)
Timeline unknown, but this is the type of input I was hoping to hear. I realize that some of the above is opinion, but if it has been identified as the "fix" to some of the base issues then that is the direction I plan to assist with until something "better" is developed.
ALL of what I wrote is of course my opinion..:smile: I've had strong opinions about SBA and these silly forks of SBA for YEARS.. I liked the ORIGINAL version Kuroi developed, but I knew it ad flaws, and I never like the fact that ther was no way to exclude attributes from a product inventory variant. So I paid a developer to update the ORIGINAL Kuroi version of SBA so that my ONE client who uses it could use it while I continued to watch and wait for the SBA scene to improve.
(and before anyone asks.. why didn't I share this version of SBA?? I didn't because my client would NOT sign off on contributing it --she had paid for these improvements and didn't want to share-- and I didn't want to submit something I had NO PLANS to support..)
I am FIRMLY of the opinion that all this forking of SBA was unnecessary and made SBA a USELESS and WEAK add-on for the community as a whole.. It's great that some folks are able to use some of these forked versions in their stores, but others are not.. The MANY ad-hoc SBA threads is proof of this.. the fact that Numinix developed a commercial product variant module is proof of this, the fact that the late Conor Kerr was developing a HIGHLY anticipated product variants module is further proof of the fact that all this SBA forking has not resulted in a universally USEFUL add-on and a GAP in this kind of functionality still exists..
This all only serves to illustrate my point that these forks only served to dilute the whole by creating multiple WEAK versions of SBA. potteryhouse at LEAST is trying to create ONE functioning version of SBA by bringing together features from these MANY forks.. If you are looking to contribute to the SBA landscape, why continue development on one of these WEAK A$$ED half supported (NON SUPPORTED) forks?? If you have enhancements that allow EP4 to work with SBA (which I THINK is what you are saying you have been working on) then add those to the effort potteryhouse has put into SBA because in MY OPINION he's trying to improve the clusterf*ck wasteland that SBA had become..
IJS:blink:
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Why doesn't someone ask me to rebuild the SBA... so it works... like it should?
Better yet, why hasn't the core development team done it for say version 1.51 or 1.52 or 1.60... ?
These are essential functions an e-commerce platform should have period.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
twitchtoo
Why doesn't someone ask me to rebuild the SBA... so it works... like it should?
Better yet, why hasn't the core development team done it for say version 1.51 or 1.52 or 1.60... ?
These are essential functions an e-commerce platform should have period.
the SBA core has always been available for improvement.. potteryhouse is the first maintainer who has been working hard to make SBA usable and unified.. you wouldn't consider collaborating with him??
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
DivaVocals
ALL of what I wrote is of course my opinion..:smile: I've had strong opinions about SBA and these silly forks of SBA for YEARS.. I liked the ORIGINAL version Kuroi developed, but I knew it ad flaws, and I never like the fact that ther was no way to exclude attributes from a product inventory variant. So I paid a developer to update the ORIGINAL Kuroi version of SBA so that my ONE client who uses it could use it while I continued to watch and wait for the SBA scene to improve.
(and before anyone asks.. why didn't I share this version of SBA?? I didn't because my client would NOT sign off on contributing it --she had paid for these improvements and didn't want to share-- and I didn't want to submit something I had NO PLANS to support..)
I am FIRMLY of the opinion that all this forking of SBA was unnecessary and made SBA a USELESS and WEAK add-on for the community as a whole.. It's great that some folks are able to use some of these forked versions in their stores, but others are not.. The MANY ad-hoc SBA threads is proof of this.. the fact that Numinix developed a commercial product variant module is proof of this, the fact that the late Conor Kerr was developing a HIGHLY anticipated product variants module is further proof of the fact that all this SBA forking has not resulted in a universally USEFUL add-on and a GAP in this kind of functionality still exists..
This all only serves to illustrate my point that these forks only served to dilute the whole by creating multiple WEAK versions of SBA. potteryhouse at LEAST is trying to create ONE functioning version of SBA by bringing together features from these MANY forks.. If you are looking to contribute to the SBA landscape, why continue development on one of these WEAK A$$ED half supported (NON SUPPORTED) forks?? If you have enhancements that allow EP4 to work with SBA (which I THINK is what you are saying you have been working on) then add those to the effort potteryhouse has put into SBA because in MY OPINION he's trying to improve the clusterf*ck wasteland that SBA had become..
IJS:blink:
Sorry for the "delayed" response, but no argument from me. :) I actually halted some development because I didn't want to make a bigger mess of things. The recent developer of ep4 has indicated that a zc ready version would be coming "soon" and with all the variations of sba I wanted to focus on the aspect of sba/ep that seemed most valuable. Updating in stock quantities of sba tracked products. That task was done for a particularly lain out sba table.
Having the next suggested version of sba I should be able to look at the tables used there and make the mods to accomodate restock of existing sba tracked products. And do so without losing existing functionality, but I plan on providing a note to guide towards the "preferred" sba.
SBA, while probably one of the most useful of setups for an online store, HAS unfortunately been ##############ized it certainly also unfortunately can be one of the more complex plugins because of how many different facits that are affected by it/it affects. I'm looking to finish some touchups to another plugin I am merging with a convenient tool which also needs to have/get an autoinstaller tied to it and then I'll switch back over to the improvements for SBA/EP4 through potteryhouse's version. That part shouldn't be as difficult after I play with his version a little.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Sorry for the "delayed" response, but no argument from me. :) I actually halted some development because I didn't want to make a bigger mess of things. The recent developer of ep4 has indicated that a zc ready version would be coming "soon" and with all the variations of sba I wanted to focus on the aspect of sba/ep that seemed most valuable. Updating in stock quantities of sba tracked products. That task was done for a particularly lain out sba table.
Having the next suggested version of sba I should be able to look at the tables used there and make the mods to accomodate restock of existing sba tracked products. And do so without losing existing functionality, but I plan on providing a note to guide towards the "preferred" sba.
SBA, while probably one of the most useful of setups for an online store, HAS unfortunately been ##############ized it certainly also unfortunately can be one of the more complex plugins because of how many different facits that are affected by it/it affects. I'm looking to finish some touchups to another plugin I am merging with a convenient tool which also needs to have/get an autoinstaller tied to it and then I'll switch back over to the improvements for SBA/EP4 through potteryhouse's version. That part shouldn't be as difficult after I play with his version a little.
Yep.. Because HONESTLY the BEST WAY to improve the SBA module and have a version of SBA "so it works... like it should" is to start by just letting these other half baked SBA forks DIE.. potteryhouse has integrated their features into the SBA version he has been maintaining anyway so IMHO, there is no need to continue development of these forks.. Additionally I like the way potteryhouse seems to be working to ACTIVELY improve SBA's features.. Some of the features he's adding appear to rival the features that were supposed to be a part of the late Conor Kerr's Products Variants add-on. (unfortunately, in the year since Conor's passing I have seen no signs from the folks at JS Web that Conor Kerr's Products Variants add-on will be released anytime soon..)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
I did a search but came up empty. Is there a way to report sales that includes the attribute? My client, a non-profit fog rescue, sells t-shirts and tracks inventory by size. The plugin is great for the site, but they need a report on sales to update inventory. The Sales Report plugin does not include attribute data.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
jeking
I did a search but came up empty. Is there a way to report sales that includes the attribute? My client, a non-profit fog rescue, sells t-shirts and tracks inventory by size. The plugin is great for the site, but they need a report on sales to update inventory. The Sales Report plugin does not include attribute data.
You probably should open a new thread to get this discussion going.. SBA doesn't have any reporting mechanism..
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
jeking
I did a search but came up empty. Is there a way to report sales that includes the attribute? My client, a non-profit fog rescue, sells t-shirts and tracks inventory by size. The plugin is great for the site, but they need a report on sales to update inventory. The Sales Report plugin does not include attribute data.
I came up with a solution for this that involves only php changes and no database additions. I am reluctant to share it because it's queries are very intensive and a product with 100+ attributes can take several minutes to return results. For our business this data was essential, so it was worth the cost for us. I modified the stats_products_purchased.php file to add the following code:
PHP Code:
<!-- BOF FGB Attribute Sales Report -->
<table border="0" width="80%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="80%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo "Best Attributes Purchased"; ?></td>
<td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
<td class="smallText" align="right">
<?php
// field for user to enter two order numbers to search between
echo zen_draw_form('search', FILENAME_STATS_PRODUCTS_PURCHASED, '', 'get', '', true);
echo "Enter two order numbers seperated by a comma:" . ' ' . zen_draw_input_field('order_numbers') . zen_hide_session_id();
echo '<br/ >' . "Enter one product ID number:". ' ' . zen_draw_input_field('product_id') . zen_hide_session_id();
?><input type="submit"><?php
echo '</form>';
?>
</td>
</tr>
</table></td>
</tr>
<?php
echo $_GET["order_numbers"]; ?><br><?php
echo $_GET["product_id"]; ?><br><?php
// create orders_id_array to hold all orders_products_id arrays
$orders_id_array = array();
$our_product_number = 7;
$our_beginning_order_number = 20500;
$our_ending_order_number = 30000;
// if the user has entered and submitted some order numbers, use those
if (!(is_null($_GET["order_numbers"]))) {
$order_numbers = explode(",", $_GET["order_numbers"]);
$our_beginning_order_number = $order_numbers[0];
$our_ending_order_number = $order_numbers[1];
}
// if the user has entered and submitted an item number, use that
if (!(is_null($_GET["product_id"]))) {
$our_product_number = $_GET["product_id"];
}
// building query from orders_products table for product quantity, id, name, and orders_products_id
// need to add user input fields for order range and product id
$attributes_query_raw=
"select op.products_quantity, op.orders_products_id, op.products_name, op.products_id
from ".TABLE_ORDERS_PRODUCTS." op
where (op.orders_id BETWEEN $our_beginning_order_number AND $our_ending_order_number) AND op.products_id = $our_product_number";
// fire off this query
$attributes = $db->Execute($attributes_query_raw);
// loop though all returned records
while(!$attributes->EOF) {
// create orders_products_id_array to hold the fields for each purchase
$orders_products_id_array = array();
// push these onto our orders_id array
array_push($orders_products_id_array, $attributes->fields['products_id'],
$attributes->fields['orders_products_id'],
$attributes->fields['products_quantity'],
$attributes->fields['products_name']);
// grab orders_products_id to use when filtering variants query
$var_opi = $attributes->fields['orders_products_id'];
// building query from orders_products_attributes table for product options values and orders_products_id
$variants_query_raw=
"select products_options_values, orders_products_id
from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
where orders_products_id=$var_opi";
// fire off this query
$variants = $db->Execute($variants_query_raw);
// loop though all returned records
while(!$variants->EOF) {
// push this attribute to the end of our orders_id array
$orders_products_id_array[] = $variants->fields['products_options_values'];
// move on to the next attribute option value if there is one
$variants->MoveNext();
} // while loop completed; orders_products_id array completed
// push this completed orders_products_id array onto the larger products_id array
$orders_id_array[] = $orders_products_id_array;
// move on to the next orders_products_id if there is one
$attributes->MoveNext();
} // while loop completed; orders_id array completed
// funtion to sort on the first attribute (e.g. tip size)
function cmp_first_attribute($a, $b) {
if ($a[4] == $b[4]) {
return strcmp($a[5], $b[5]);
}
return strcmp($a[4], $b[4]);
}
// function to sort on the second attribute (e.g. color)
function cmp_second_attribute($a, $b) {
return strcmp($a[5], $b[5]);
}
// function to sort on the quantity
function cmp_quantity($a, $b) {
if ($a[2] == $b[2]) {
return 0;
}
return ($a[2] > $b[2]) ? -1 : 1;
}
// sort the orders_id array so that all the matching products are adjacent
usort($orders_id_array, "cmp_first_attribute");
// we should check if this index exists before sorting, this might break on single attribute products
//usort($orders_id_array, "cmp_second_attribute");
// create new array to hold summed quantitys of attributes purchased
$summed_quantities = array();
// create tokens to hold our summed array index and product attribute options while traversing orders_id array
$summed_quantities_index = -1;
$product_name_token = array(4=>'',5=>'');
// create loop that pulls each unique combination of attributes out of orders_id array` and summs their quantities
foreach ($orders_id_array as $orders_id_line) {
// if we are starting on a new set of attribtues, set the name token and incriment the summed array index
if (($orders_id_line[4] != $product_name_token[4]) || ($orders_id_line[5] != $product_name_token[5])) {
$product_name_token[4] = $orders_id_line[4];
$product_name_token[5] = $orders_id_line[5];
$summed_quantities_index++;
// since we are on a new set of attributes, populate the next array in summmed_quantities with
// our new info, and set quantity to zero
$summed_quantities[$summed_quantities_index] = $orders_id_line;
$summed_quantities[$summed_quantities_index][2] = 0;
}
// if this is another instance of the same set of attributes wer were already working with,
// add the quanitity of this new instance to our running total
$summed_quantities[$summed_quantities_index][2] = $summed_quantities[$summed_quantities_index][2] + $orders_id_line[2];
}
// sort our summed list in descending order by quantity
usort($summed_quantities, "cmp_quantity");
// build table header row for Best Attributes Table
?>
<tr>
<td><table border="0" width="80%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="80%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php echo "Product Name"; ?></td>
<td class="dataTableHeadingContent"><?php echo "Attribute"; ?></td>
<td class="dataTableHeadingContent"><?php echo "Attribute"; ?></td>
<td class="dataTableHeadingContent"><?php echo "Quantity"; ?></td>
</tr>
<?php
if (isset($_GET['page']) && ($_GET['page'] > 1)) $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS;
$rows = 0;
foreach ($summed_quantities as $summed_quantity) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}?>
<tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
<td class="dataTableContent"><?php echo $summed_quantity[3]; ?> </td>
<td class="dataTableContent"><?php echo $summed_quantity[4]; ?></td>
<td class="dataTableContent"><?php echo $summed_quantity[5]; ?></td>
<td class="dataTableContent"><?php echo $summed_quantity[2]; ?></td>
</tr><?php
}
?>
</table></td>
</tr>
<tr>
<td colspan="3"><table border="0" width="80%" cellspacing="0" cellpadding="2">
<tr>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<!-- EOF FGB Attribute Sales Report -->
I hope this helps.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Every six months or so I get fed up of avoiding this huge hole in Zen Cart, look at other carts and come back to look over the state of SBA and discount this mess and go back to avoiding it. A great example of the worst case scenario of the basically uncontrolled "plugins" mechanism.
I know that if I got involved with it I would spend too much time fixing it before adding it to my shop.
Thanks to divavocals for the summary of the current state of affairs.
Quote:
Better yet, why hasn't the core development team done it for say version 1.51 or 1.52 or 1.60... ?
These are essential functions an e-commerce platform should have period.
I think it is evident this functionality is essential but the SBA band-aid attempt only serves to illustrate that it requires too many changes to core code to work, wasted development time in the 1.x branch which cannot be carried to the 2.x framework.
The few people I knew using ZC (in Spain) have long since jumped ship for Prestashop due to this and I don't recommend ZC to new users for the same reason.
And yes, knowing that Conor's Product Variants (which I believe was complete bar documentation) is still apparently gathering dust at JSweb is something that does not bear thinking about...
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
It is necessary to have a way of showing stock by attributes.If you have a garment in three sizes you have to be able to show customers you are out of stock in one size and have stock in the others.
But I've never had a problem with this add-on. The Pottery House version has always given me errors . I've just updated to version 1.5.3. and it works fine. You do need to make a couple of changes that are in this thread somewhere.
You do have to update stock manually but you just type the product code in and SBA brings it up no problem.
If you only sell a few things a day you really don't need anything else. If you sell hundreds of items a day that all have attributes then,yes ,you probably do.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
jeking
I did a search but came up empty. Is there a way to report sales that includes the attribute? My client, a non-profit fog rescue, sells t-shirts and tracks inventory by size. The plugin is great for the site, but they need a report on sales to update inventory. The Sales Report plugin does not include attribute data.
Quote:
Originally Posted by
DivaVocals
You probably should open a new thread to get this discussion going.. SBA doesn't have any reporting mechanism..
Would like to provide input on this "discussion" where did the thread get started?
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
mc12345678
Would like to provide input on this "discussion" where did the thread get started?
I never actually did start a new thread.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
jeking
I never actually did start a new thread.
I believe this is the thread for creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0 .
It doesn't need a new thread.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
I have started to look at a report of OOS by Attributes. I got close to a Query that returns all Products that have Stock By Attributes that are ZERO (ie, they are out of stock). Basically, this is a query to report on all Out Of Stock Products by Attribute level.
However, I'm not able to translate the STOCK_ID or the STOCK_ATTRIBUTE Fields from table PRODUCTS_WITH_ATTRIBUTES_STOCK to their meaning full names of OPTION NAME and OPTION VALUE.
Any ideas?
****** SQL *****
Select T5.categories_name, m.manufacturers_name, T1.products_id,
T1.products_price, T2.products_name, products_with_attributes_stock.stock_attributes,
products_with_attributes_stock.quantity, products_with_attributes_stock.stock_id
From products T1
Left Join manufacturers m On T1.manufacturers_id = m.manufacturers_id
Inner Join products_description T2 On T2.products_id = T1.products_id
Inner Join products_to_categories T3 On T3.products_id = T2.products_id
Inner Join categories T4 On T3.categories_id = T4.categories_id
Inner Join categories_description T5 On T5.categories_id = T4.categories_id
Inner Join products_with_attributes_stock On T1.products_id = products_with_attributes_stock.products_id
Group By T5.categories_name, T1.products_id, T1.products_price, T2.products_name, products_with_attributes_stock.stock_attributes, products_with_attributes_stock.quantity, T2.products_id, T2.products_description, products_with_attributes_stock.products_id, products_with_attributes_stock.stock_id
Having products_with_attributes_stock.quantity = 0
Order By T5.categories_name
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
cefyn
I believe this is the thread for creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0 .
It doesn't need a new thread.
But a discussion on a sales report DOES require a new thread.. (which is what was being referred to..)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Is this module the same as http://www.zen-cart.com/downloads.php?do=file&id=202
Is it possible to use this to bulk revise attributes? For example, disable some sizes of 1000 products.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
waterbender
They are not the same. If you have a question about the 'Stock by Attributes', best to post your question in that thread. I can't say about this one, I've never used it.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Zen v1.54
SBA v1.54
Zen Magnific v1.5
DPU v3.0.2
I been attempting to debug the 'second SBA dropdown not working' on my site. Looking at the thread I can see that a couple of things have been tried i.e. validating the page to sort problems with broken tags etc - done. Incorporating an edit by mc12345678 into pad_sba_sequenced_dropdowns - done I'm using the latest from github.
I think I've now isolated the problem to a conflict with Dynamic Price Updater, if I turn it off then the SBA dropdowns work. As there are no common files between the two mods I think it might be a jscript issue. I've been looking for conflicts as much as I'm able but still no joy.
It's time to ask for help. Has anyone had this conflict between the two mods?
I have it on a test site if it helps and would rather PM you the link if you don't mind.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
It now appears that it is not the conflict I described above. The two mods work together under the classic template, at least this makes it easier to debug - so still a bit of work to do.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Scrub that, the classic template reverts the attribute selection to non-dynamic dropdown hence why it worked
(not sure why I keep posting in the wrong thread)
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Installed "creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0" on cart version 1.5.5e. The module appears to have installed properly in that it shows the admin section as well as drop-downs in the front end. However, when I try to add in the quantities in "Products with Attributes Stock" in the admin I get the following: WARNING: An Error occurred, please refresh the page and try again.
Here is what my debug says:
Code:
[15-Mar-2017 15:38:32 UTC]
Request URI: /PersonalAdmin/products_with_attributes_stock.php?products_id=18&quantity=10&attributes=33&add_edit=add&action=execute,
#1 trigger_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/REDACTED/public_html/PersonalAdmin/products_with_attributes_stock.php:250]
PHP Fatal error: 1364:Field 'sort' doesn't have a default value :: insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (18,"33",10) ==> (as called by) /home/REDACTED/public_html/PersonalAdmin/products_with_attributes_stock.php on line 250 <== in /home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php on line 167
Thank you for your help.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Hmm. Edit about the below: perhaps I've posted here thinking it was the thread associated with a different version of SBA (I'm on list for several). Sorry for toe stepping. Running out of time to edit. But still able to possibly answer questions related to the solution.
A lot going on here, 1) using a very old as far as I know no longer maintained version of SBA, 2) looks like you could use at least three options to move forwards, either alter the database, so that every new item has a default value that is a constant (all new items would have the same sort value), you could modify the database field to autonumber such that each would be assigned a new/unique likely unchangeable sort value. You could modify the query to add a value to the table for that field and that value could be a constant (to be changed later) or it could be determined by the last sort number and incremented in a way applicable to the desired outcome. The drastic action would be to delete the field from the table and any other place that the sort field is used/accessed, but that doesn't seem like a worthwhile venture.
So, it would depend on how you wish to move forward with the issue of that software which doesn't occur with the version that has primarily been discussed, tested, and used on the more recent versions of ZC.
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
So, it would depend on how you wish to move forward with the issue of that software which doesn't occur with the version that has primarily been discussed, tested, and used on the more recent versions of ZC.
Hmmm. I guess I missed a module. What is the link to the new version that matches 1.5.5? I did not mean to use a version that was outdated.
Thanks again for your input!
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Quote:
Originally Posted by
maxmarketing
[/B]
Hmmm. I guess I missed a module. What is the link to the new version that matches 1.5.5? I did not mean to use a version that was outdated.
Thanks again for your input!
So, don't be alarmed about the thread title. I suggest going to the end of the thread and reading back even just a couple of pages to get the lay of the land.
https://www.zen-cart.com/showthread....tock+attribute
-
Re: Stock by Attributes 5.0 Beta (for v1.5.0)
Thank you for your rapid response. The title of that thread is why I did not proceed with it when I was looking for a module. Good to have clarification.
