-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
karinvd
I had a problem with combination of zen-colorbox2 and SBA. When i used an attribute with a drop down menu, the image did not load. On line 42 of includes\functions\extra_functions\products_with_attributes.php i found the next code which showed on a product page when i used a drop down menu, if i used a check box or a radio button it did not show and zen-colorbox2 worked fine. So i comment this line out.
Wil i get problems with?
Code:
$field = '<script src="'.DIR_WS_TEMPLATES . $template_dir . '/jscript/jquery-1.10.2.min.js"></script>
<script type="text/javascript">
$(function(){
$("#attrib-'.$tmp_attribID.'").on("click", function(){
$("#SBA_ProductImage").attr("src", $(this).find(":selected").attr("data-src"));
});
});
</script>';
It may be that the code for zen-colorbox (assuming the one available from http://www.zen-cart.com/downloads.php?do=file&id=1322) and the SBA code should be brought into line (Thinking that #SBA_ProductImage above might need to be modified to account for this) Of course it would impact multiple locations of the code, but at least then SBA would be more in line with colorbox and possibly other image managing code... Also assuming that the version being applied to the ZC 1.5.4 development site is what is referenced above, and if so an issue should be opened on github to address this aspect for tracking and development. As far as commenting the line/section out, well, in review of the code snippet it appears the "problem" would be that when using a dropdown that the image will not change respective to the dropdown selection. That aspect actually is an additional "feature" anyways.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
It may be that the code for zen-colorbox (assuming the one available from
http://www.zen-cart.com/downloads.php?do=file&id=1322) and the SBA code should be brought into line (Thinking that #SBA_ProductImage above might need to be modified to account for this) Of course it would impact multiple locations of the code, but at least then SBA would be more in line with colorbox and possibly other image managing code... Also assuming that the version being applied to the ZC 1.5.4 development site is what is referenced above, and if so an issue should be opened on github to address this aspect for tracking and development. As far as commenting the line/section out, well, in review of the code snippet it appears the "problem" would be that when using a dropdown that the image will not change respective to the dropdown selection. That aspect actually is an additional "feature" anyways.
If I had to hazzard a guess, I'd say that this part:
Code:
<script src="'.DIR_WS_TEMPLATES . $template_dir . '/jscript/jquery-1.10.2.min.js"></script>
is the issue.. Not sure why there would be a need to load jQuery HERE.. But I'll certainly bet that this is conflicting with the jQuery loaded from Zen Colorbox..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Thank you both :-) Divavocals you are right. I removed
Code:
<script src="'.DIR_WS_TEMPLATES . $template_dir . '/jscript/jquery-1.10.2.min.js"></script>
it now looks like:
Code:
$field = '<script type="text/javascript">
$(function(){
$("#attrib-'.$tmp_attribID.'").on("click", function(){
$("#SBA_ProductImage").attr("src", $(this).find(":selected").attr("data-src"));
});
});
</script>';
And is still worked.
mc12345678 thanks for telling me wat the snippet actually does.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
jeking
All code on GitHub should be considered as BETA. You're welcome to use it and provide any feedback. Take the necessary precautions, backup or install on a development cart first.
Hey Jeking - with the upcoming PHP5.5 upgrade, anything below 1.5.4 will not work. Will SBA be ready by the time March 15th rolls around?
Thank you!
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Christian_Wagner
Hey Jeking - with the upcoming PHP5.5 upgrade, anything below 1.5.4 will not work. Will SBA be ready by the time March 15th rolls around?
Thank you!
Free plugins like this are written and updated voluntarily, as time allows. I am just one of the contributors to this plugin. The final decision is up to DivaVocals.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
jeking
Free plugins like this are written and updated voluntarily, as time allows. I am just one of the contributors to this plugin. The final decision is up to DivaVocals.
Awesome. Thanks for the quick response!
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
jeking
Free plugins like this are written and updated voluntarily, as time allows. I am just one of the contributors to this plugin. The final decision is up to DivaVocals.
For SBA????????????????????? Oh no.. not me..:laugh: I haven't used this forked to death module in quite some time..
I kept hoping that someone would wrangle ALL the many SBA forks into one WORKING module, but that's NEVER happened.. Every fork seems focused ONLY on single dropdown attributes, and not attribute combos.. No support for "optional" non-stock bearing attributes.. None of these forks ever worked for my clients, and I do have ONE client using a version I paid to have modified for her needs, but underneath, it's still SBA and all it's faults.. So I now use a commercial stock by attributes management module by Vinos de Frutas Tropicales and POOF problem gone
vinosdefrutastropicales(dot)com/index(dot)php?main_page=product_info&cPath=2_7&products_id=46
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
The version discussed being worked on github is to handle multiple attributes shortly, there is a branch under review that will accommodate single and multiple attributes. One of the files a part of dynamic dropdowns has also just been added with modification so that all product with attributes does not require SBA tracking. Further modification is being considered to support display of out-of-stock combinations of items, though that does require a bit of an overhaul to create an applicable dynamic dropdown class in addition to what was provided by dynamic dropdowns.
While I might agree that the goal seems to have been single attribute related, there has been a push to support multi-attributes, and the next "major" step is to support attributes that are not stock dependent. (Ie. Gift wrap, etc.) As well as porting over to ZC 1.5.4. Other aspects of incorporation are to merge in data from SBA into existing reporting tools such as products purchased. Certainly there are things to be done, but it does seem like with the backbone of attributes in ZC as they are, a lot of progress has been made to do exactly as Diva has pointed out, merge the functionality of the various versions into a single tool. Comment and suggestions are certainly welcome as without identification of issues, the problem(s) may not be found or corrected...
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
The version discussed being worked on github is to handle multiple attributes shortly, there is a branch under review that will accommodate single and multiple attributes. One of the files a part of dynamic dropdowns has also just been added with modification so that all product with attributes does not require SBA tracking. Further modification is being considered to support display of out-of-stock combinations of items, though that does require a bit of an overhaul to create an applicable dynamic dropdown class in addition to what was provided by dynamic dropdowns.
While I might agree that the goal seems to have been single attribute related, there has been a push to support multi-attributes, and the next "major" step is to support attributes that are not stock dependent. (Ie. Gift wrap, etc.) As well as porting over to ZC 1.5.4. Other aspects of incorporation are to merge in data from SBA into existing reporting tools such as products purchased. Certainly there are things to be done, but it does seem like with the backbone of attributes in ZC as they are, a lot of progress has been made to do exactly as Diva has pointed out, merge the functionality of the various versions into a single tool. Comment and suggestions are certainly welcome as without identification of issues, the problem(s) may not be found or corrected...
So does this NOW include WORKING sequenced attributes?? ie: I select on option and any options which in combination with the option I selected would be out of stock are not presented..
For example I am looking a womans shoe which comes
in the following sizes: 6, 7, 8, 9, & 10
in the following colors: Black, Red, Forrest Green, Tan, Dark Brown, Blue
Black is out of stock in ANY size
Forrect Green is out of stock in sizes 6 & 10
I expect that if I choose size 6 that the color options for Black and Forrest Green will, depending on the admin settings, either NOT show at all or IF they display, they will clearly display the words "Out of Stock" next to the option value.
Is this NOW a feature of the project in progress on Github??????
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
For SBA????????????????????? Oh no.. not me..:laugh: I haven't used this forked to death module in quite some time..
My mistake, I *meant* to say potteryhouse I was confusing plugins ;-)
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
So does this NOW include WORKING sequenced attributes?? ie: I select on option and any options which in combination with the option I selected would be out of stock are not presented..
For example I am looking a womans shoe which comes
in the following sizes: 6, 7, 8, 9, & 10
in the following colors: Black, Red, Forrest Green, Tan, Dark Brown, Blue
Black is out of stock in ANY size
Forrect Green is out of stock in sizes 6 & 10
I expect that if I choose size 6 that the color options for Black and Forrest Green will, depending on the admin settings, either NOT show at all or IF they display, they will clearly display the words "Out of Stock" next to the option value.
Is this NOW a feature of the project in progress on Github??????
I'm awaiting confirmation that the code provides exactly the "hide" of out-of-stock options of a multi-attribute product by independent review, but yes with Dynamic dropdown installed as is (don't use the template file provided with that plugin) then only instock items are displayed. A further effort is being taken to provide the out-of-stock options for multiple attribute product which is a revision of the dynamic dropdowns sequenced dropdown, to allow/support use of the dynamic dropdowns plugin. (Pretty cool little mix of code, just missed out on some of the implementation as SBA was written/adapted/etc.)
Just to state again, the code that supports multi (as well as single attribute) product is still in a separate branch but is to be merged soon.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
I'm awaiting confirmation that the code provides exactly the "hide" of out-of-stock options of a multi-attribute product by independent review, but yes with Dynamic dropdown installed as is (don't use the template file provided with that plugin) then only instock items are displayed. A further effort is being taken to provide the out-of-stock options for multiple attribute product which is a revision of the dynamic dropdowns sequenced dropdown, to allow/support use of the dynamic dropdowns plugin. (Pretty cool little mix of code, just missed out on some of the implementation as SBA was written/adapted/etc.)
Just to state again, the code that supports multi (as well as single attribute) product is still in a separate branch but is to be merged soon.
Will be interesting to see how this shakes out.. Until then I will use the commercial option for my clients who need this functionality..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
I kept hoping that someone would wrangle ALL the many SBA forks into one WORKING module, but that's NEVER happened..
So I stand corrected on this statement.. it would appear that all but one of the SBA forks in the downloads section have disappeared.. IMHO, this move is LONG overdue, and all those forks should have never seen the light of day AT ALL.. Though in my opinion this module has improved with a focused development effort, and consolidation of the BEST of those many forks, it is still a LONG ways from something I can consider using on a client site yet.. However, I am glad to see a SINGULAR effort moving forward on this module, and I am looking forward to the day when once again it reliably has all the feature my clients ask for..
Quote:
Originally Posted by
jeking
My mistake, I *meant* to say potteryhouse I was confusing plugins ;-)
:laugh: I understand..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
So I stand corrected on this statement.. it would appear that all but one of the SBA forks in the downloads section have disappeared.. IMHO, this move is LONG overdue, and all those forks should have never seen the light of day AT ALL.. Though in my opinion this module has improved with a focused development effort, and consolidation of the BEST of those many forks, it is still a LONG ways from something I can consider using on a client site yet.. However, I am glad to see a SINGULAR effort moving forward on this module, and I am looking forward to the day when once again it reliably has all the feature my clients ask for..
:laugh: I understand..
Interested to know, what features are missing that are so strongly desired/needed? Or shall we read minds? :P (*bbbzzztttt* mind machine trying to read... :) )
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
Interested to know, what features are missing that are so strongly desired/needed? Or shall we read minds? :P (*bbbzzztttt* mind machine trying to read... :) )
Well.. I think I already stated in previous posts what features I would be looking for/think are lacking in SBA.. Do you NEED me to re-state or quote my previous posts???
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Regarding this previously referenced code... I'd like to make a suggestion...
Quote:
Originally Posted by
karinvd
I had a problem with combination of zen-colorbox2 and SBA. When i used an attribute with a drop down menu, the image did not load. On line 42 of includes\functions\extra_functions\products_with_attributes.php i found the next code which showed on a product page when i used a drop down menu, if i used a check box or a radio button it did not show and zen-colorbox2 worked fine. So i comment this line out.
Wil i get problems with?
Code:
$field = '<script src="'.DIR_WS_TEMPLATES . $template_dir . '/jscript/jquery-1.10.2.min.js"></script>
<script type="text/javascript">
$(function(){
$("#attrib-'.$tmp_attribID.'").on("click", function(){
$("#SBA_ProductImage").attr("src", $(this).find(":selected").attr("data-src"));
});
});
</script>';
In the Zen Colorbox code, we will be doing the following in the next release:
Code:
<?php
//Load jQuery ONLY if jQuery has not been loaded. This is to support versions of Zen Cart prior to v1.5.4 because jQuery was not part of core code
//Also want to prevent jQuery from loading again if bundled with a plugin or template package
?>
<script type="text/javascript">
if (typeof jQuery == 'undefined') {
document.write('script type="text/javascript" src="//code.jquery.com/jquery-1.11.1.min.js"><\/script>');
}
</script>
May I suggest that SBA do something similar if it ABSOLUTELY has to make a jQuery call within it's code...
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
Regarding this previously referenced code... I'd like to make a suggestion...
In the Zen Colorbox code, we will be doing the following in the next release:
Code:
<?php
//Load jQuery ONLY if jQuery has not been loaded. This is to support versions of Zen Cart prior to v1.5.4 because jQuery was not part of core code
//Also want to prevent jQuery from loading again if bundled with a plugin or template package
?>
<script type="text/javascript">
if (typeof jQuery == 'undefined') {
document.write('script type="text/javascript" src="//code.jquery.com/jquery-1.11.1.min.js"><\/script>');
}
</script>
May I suggest that SBA do something similar if it ABSOLUTELY has to make a jQuery call within it's code...
In the effort to make SBA compatible with zC 1.5.4, the calls to jquery are being reworked, and any/all methods of not duplicating loading of jquery are being considered, with that or similar being considered especially that one.
So summary of known issues to incorporate: identification/presentation of out-of-stock items for all styles of attributes, products being able to have attributes that are not stock dependent (popular comparison is gift wrapping), obviously multiple attribute capability in addition to single attribute, possibly multiple attribute without the need for sequenced selection.
Those are the features that I can recall that are not yet fully incorporated, but are in design consideration. What's missing from that list?
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
In the effort to make SBA compatible with zC 1.5.4, the calls to jquery are being reworked, and any/all methods of not duplicating loading of jquery are being considered, with that or similar being considered especially that one.
So summary of known issues to incorporate: identification/presentation of out-of-stock items for all styles of attributes, products being able to have attributes that are not stock dependent (popular comparison is gift wrapping), obviously multiple attribute capability in addition to single attribute, possibly multiple attribute without the need for sequenced selection.
Those are the features that I can recall that are not yet fully incorporated, but are in design consideration. What's missing from that list?
Okay... Soooo.. In order to answer your question, I guess I DO have to quote what I've posted before.. :smile:
Quote:
Originally Posted by
DivaVocals
Every fork seems focused ONLY on single dropdown attributes, and not attribute combos.. No support for "optional" non-stock bearing attributes..
Quote:
Originally Posted by
DivaVocals
So does this NOW include WORKING sequenced attributes?? ie: I select on option and any options which in combination with the option I selected would be out of stock are not presented..
For example I am looking a womans shoe which comes
in the following sizes: 6, 7, 8, 9, & 10
in the following colors: Black, Red, Forrest Green, Tan, Dark Brown, Blue
Black is out of stock in ANY size
Forrect Green is out of stock in sizes 6 & 10
I expect that if I choose size 6 that the color options for Black and Forrest Green will, depending on the admin settings, either NOT show at all or IF they display, they will clearly display the words "Out of Stock" next to the option value.
If your list covers this and more (it appears that this is the case), then I'll await to see what the next release offers..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
I am having an issue with SBA 1.5.3 in Zen Cart 1.5.4.
I have 2 nearly identical websites. Both are hosted by BlueHost on Linux. Both are run by PHP 5.4. Both were, up until mid-January, running Zen Cart 1.5.0 and SBA with no problem. I upgraded both to 1.5.4. The only difference between the 2 sites is one of them uses the template "Andover Modern" by Picaflor-Azul, the other "A Modern Zen" by Jamie Cairney rainbow-designs.co.uk.
After upgrading to Zen Cart 1.5.4, the website using the Jamie Cairney template is working fine, with SBA 1.5.3. The website running the Picaflor-Azul template is having the problem. After several tries at upgrading the site, I had to uninstall SBA then upgrade to 1.5.4. Once upgraded, I then installed the files, pointed the browser to my site and the SBA install file. The result is a blank screen in admin. It won't even show the login screen.
Any help would be appreciated. If any additional info is needed, please let me know. Thanks!
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
The result is a blank screen in admin. It won't even show the login screen.
A blank page usually results in something being written to the error logs. Have you checked them for any clues?
Cheers
RodG
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
RodG
A blank page usually results in something being written to the error logs. Have you checked them for any clues?
Cheers
RodG
Have not. When the blank screen came up, I deleted all and reinstalled.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
Have not. When the blank screen came up, I deleted all and reinstalled.
Is it working for you now? It's helpful to post the answer so others with the same problem will know.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
Have not. When the blank screen came up, I deleted all and reinstalled.
Quote:
Originally Posted by
jeking
Is it working for you now? It's helpful to post the answer so others with the same problem will know.
Btw, there is a version of SBA (version 1.5.4) that is compatible with ZC 1.5.3 that with minor modification is compatible with ZC 1.5.4.
Work is being performed to make this compatible with ZC 1.5.4. Specific compatibility files have been identified, but work is still needed to ensure no jquey conflict with what is provided in ZC 1.5.4.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
jeking
Is it working for you now? It's helpful to post the answer so others with the same problem will know.
I reinstalled without SBA installed. Have tried a number of times to install SBA... All with same result.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
mc12345678
Btw, there is a version of SBA (version 1.5.4) that is compatible with ZC 1.5.3 that with minor modification is compatible with ZC 1.5.4.
Work is being performed to make this compatible with ZC 1.5.4. Specific compatibility files have been identified, but work is still needed to ensure no jquey conflict with what is provided in ZC 1.5.4.
The only version of SBA i saw was SBA 1.5.3. That works with ZC1.5.3. Where do I find the SBA 1.5.4 and what are the fixes please.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
The only version of SBA i saw was SBA 1.5.3. That works with ZC1.5.3. Where do I find the SBA 1.5.4 and what are the fixes please.
The version for Zen Cart 1.5.4 is still in beta being tested. If you want to test it, that's one thing. But it should not be used on a live site.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
RodG
A blank page usually results in something being written to the error logs. Have you checked them for any clues?
Cheers
RodG
Quote:
Originally Posted by
Rick29690
Have not. When the blank screen came up, I deleted all and reinstalled.
Quote:
Originally Posted by
Rick29690
The only version of SBA i saw was SBA 1.5.3. That works with ZC1.5.3. Where do I find the SBA 1.5.4 and what are the fixes please.
Quote:
Originally Posted by
Rick29690
I reinstalled without SBA installed. Have tried a number of times to install SBA... All with same result.
As pointed out earlier a blank screen means an error occurred.. Look for this error log record and POST YOUR ERROR LOGS.. We get you get a blank screen.. we can HELP you get past that if you post the error logs.. Nevermind if YOU don't know what the error means.. Chances are someone here DOES know the answer and can help get you back on your feet..
Quote:
Originally Posted by
jeking
The version for Zen Cart 1.5.4 is still in beta being tested. If you want to test it, that's one thing. But it should not be used on a live site.
**nods in agreement**
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Guess I'll just wait for the new version then. Thanks!
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
I am curious though... looking back to my original question...Why would SBA 1.5.3 work on one site with ZC 1.5.4 and not another? Both sites identical except for the templates and, of course, name. Both running on the same host , same platform, same php level.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
RodG
A blank page usually results in something being written to the error logs. Have you checked them for any clues?
Cheers
RodG
Quote:
Originally Posted by
Rick29690
Have not. When the blank screen came up, I deleted all and reinstalled.
Quote:
Originally Posted by
Rick29690
I am curious though... looking back to my original question...Why would SBA 1.5.3 work on one site with ZC 1.5.4 and not another? Both sites identical except for the templates and, of course, name. Both running on the same host , same platform, same php level.
We can't answer that.. because we don't KNOW what went wrong.. and we don't know what went wrong because you have yet to post your error log messages so we can SEE what happened on that store.. Post the error logs that are created when you get the blank page, and we can get you a better answer your question.. (and probably help you resolve your issue) Without that information, this will just be one of life's little mysteries:smile:..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
DivaVocals
We can't answer that.. because we don't KNOW what went wrong.. and we don't know what went wrong because you have yet to post your error log messages so we can SEE what happened on that store.. Post the error logs that are created when you get the blank page, and we can get you a better answer your question.. (and probably help you resolve your issue) Without that information, this will just be one of life's little mysteries:smile:..
The only error entrys are as follows:
[01-Feb-2012 15:54:45] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:45] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
I just uploaded SBA and again I'm getting blank screen on admin page login. What else can I supply?
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
I also get a myDEBUG message in the logs folder:
[04-Feb-2015 13:12:38 America/Denver] PHP Fatal error: Call to undefined function zen_get_ip_address() in /home2/nutsand1/public_html/newnuts_admin/includes/init_includes/init_sessions.php on line 34
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
I also get a myDEBUG message in the logs folder:
[04-Feb-2015 13:12:38 America/Denver] PHP Fatal error: Call to undefined function zen_get_ip_address() in /home2/nutsand1/public_html/newnuts_admin/includes/init_includes/init_sessions.php on line 34
First, change your admin directory! When posting error logs, or anything else, remember to remove/rename your actual admin folder.
Second, the errors are not related to this plugin in. Sounds like you maybe missed something in your upgrade. The undefined function is in /public_html/YOUR-ADMIN/includes/functions/general.php
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Did change admin. Sorry was in a hurry and hit enter before I realized hadn't changed. Thanks!
The upgrade works fine until I add in the SBA though. That's what doesn't make sense.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Rick29690
Did change admin. Sorry was in a hurry and hit enter before I realized hadn't changed. Thanks!
The upgrade works fine until I add in the SBA though. That's what doesn't make sense.
Nevermind, I confused two plugins again. ;-) See DivaVocals post below to a correct reply.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
AT LAST!! Some information...:shocking:
Quote:
Originally Posted by
Rick29690
The only error entrys are as follows:
[01-Feb-2012 15:54:45] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:45] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home2/nutsand1/public_html/index.php on line 26
[01-Feb-2012 15:54:57] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home2/nutsand1/public_html/index.php on line 26
I just uploaded SBA and again I'm getting blank screen on admin page login. What else can I supply?
Ummmm if you look at the date, I'd say it's SAFE to assume that these are not the error logs for today's issue (hint: the date is TWO THOUSAND TWELVE..)
Quote:
Originally Posted by
Rick29690
I also get a myDEBUG message in the logs folder:
[04-Feb-2015 13:12:38 America/Denver] PHP Fatal error: Call to undefined function zen_get_ip_address() in /home2/nutsand1/public_html/newnuts_admin/includes/init_includes/init_sessions.php on line 34
It is the ZEN CART error log that is needed when troubleshooting ZNE CART issues..:smile: That said you need to compare the following files to the ones in the Zen Cart install package to see what changed:
/public_html/YOUR-ADMIN/includes/init_includes/init_sessions.php
/public_html/YOUR-ADMIN/includes/functions/general.php
Can't remember off the top of my head if these are modified by SBA, but if these files ARE modified by SBA and I had to hazard a guess, I'd say you ignored/overlooked MERGING the SBA files with your existing store files and instead OVERWROTE them, and probably OBLITERATED something Zen Cart needs in v1.5.4..
You can figure this out rather quickly by comparing what's in your store to the defaults for these files.. HOPEFULLY the SBA changes are CLEARLY commented so that you can distiguish fairly easily the changes that come from SBA from the differences due to Zen Cart core code changes..
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Hello,
It seems I am working with SBA 1.4.12 in ZenCart 1.5.1. Never had a problem. Works like a charm.
I am working at an update of my website. I changed the layout for attributes with stock in radiobuttons instead of dropdownfield.
Now sold out attributes are showing. Back to dropdown mode everything works fine again.
How can I fix this?
Wim
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Datax
Hello,
It seems I am working with SBA 1.4.12 in ZenCart 1.5.1. Never had a problem. Works like a charm.
I am working at an update of my website. I changed the layout for attributes with stock in radiobuttons instead of dropdownfield.
Now sold out attributes are showing. Back to dropdown mode everything works fine again.
How can I fix this?
Wim
Problem solved. Found a solution.
https://www.zen-cart.com/showthread....ibutes/page103
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Datax
Thanks for sharing the solution. For others, the post is #1029 on that page.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Zen Cart v.1.5.4
SBA is in beta for 1.5.4?
Though some know how to make it work?
Any help on getting it up and running on 1.5.4.
When I get to the http://YOUR_DOMAIN/YOUR_ADMIN/stock_by_attr_install.php
and run the installer nothing happens.
So new at ZC its crazy, but any help would be great.
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Daba_do
Zen Cart v.1.5.4
SBA is in beta for 1.5.4?
Though some know how to make it work?
Any help on getting it up and running on 1.5.4.
When I get to the
http://YOUR_DOMAIN/YOUR_ADMIN/stock_by_attr_install.php
and run the installer nothing happens.
So new at ZC its crazy, but any help would be great.
When you say nothing happens, can you explain a little further? White screen? Just another menu? Error message?
Did you happen to try the version made available about 6 hours ago that has been briefly tested on ZC 1.5.4 and should be backwards compatible to ZC 1.5.3 found at: https://github.com/potteryhouse/stoc...12345678_ZC154
zip available at: https://github.com/potteryhouse/stoc...5678_ZC154.zip
-
Re: Stock by Attribute v1.5.3 addon for Zen-Cart v1.5.1
Quote:
Originally Posted by
Daba_do
Zen Cart v.1.5.4
SBA is in beta for 1.5.4?
Though some know how to make it work?
Any help on getting it up and running on 1.5.4.
When I get to the
http://YOUR_DOMAIN/YOUR_ADMIN/stock_by_attr_install.php
and run the installer nothing happens.
So new at ZC its crazy, but any help would be great.
Since you're installing a plugin not designed for your version of Zen Cart, why would you expect it to work? At your experience lever, no offense, probably better to wait for the new version which will work correctly.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Hi, new to ZC so on a learning curve here, but managing. However, a question re this plugin (v 1.5.3 for ZC 1.5.1). Is there an up-to-date instruction guide on how to use it? or can someone explain what the 'Custom ID' field is all about?
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Hi, new to ZC so on a learning curve here, but managing. However, a question re this plugin (v 1.5.3 for ZC 1.5.1). Is there an up-to-date instruction guide on how to use it? or can someone explain what the 'Custom ID' field is all about?
Mike
The CustomID allows you to assign an ID to each attribute. Think of it like the 'Products Model' you assign to a product.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
jeking
The CustomID allows you to assign an ID to each attribute. Think of it like the 'Products Model' you assign to a product.
If I may clarify a little further based on the current implementation.
The custom ID is something self entered (there is no requirement to have use it)
For a product that has a single option name, a customid could be applied to a single option value. (Quantity of product is available in 1, 2, 4, and 8 pieces then each of those options could have its own customid, none, or a mixture of one provided for some and none for the others.)
For a product that has multiple option names for a product (typical example is a shoe that is available in a color and a size) then the current implementation allows a custom ID to be applied to each such pairing of color and size (blue-9, green-10). For a product with three option names, then the combination of three option values would be used to which a single customid could be provided... Assume a shirt that is available in adult and child (two option values for a single option name) that is available in three colors (white, blue, black), and in four different sizes (S, M, L, XL) then some of the combinations available to which each has a customid available would be:
Adult-white-S : shirt1
Child-Blue-M: shirt2
Adult-Black-XL: shirt3
Where shirt1, shirt2 and shirt3 could be the customid that is entered.
With a total of 24 combinations available to be assigned in the above example.
The data (value of the customid) currently is then provided on the invoice, the email, in the order history, etc. (areas where the selected attributes are presented) in some cases in replacement of the model# while the model# is generally still available as well... Where a customid is not provided but the desire is to display customids then the model # is provided instead (whether that be blank or some data).
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
If I may clarify a little further based on the current implementation.
The custom ID is something self entered (there is no requirement to have use it)
For a product that has a single option name, a customid could be applied to a single option value. (Quantity of product is available in 1, 2, 4, and 8 pieces then each of those options could have its own customid, none, or a mixture of one provided for some and none for the others.)
For a product that has multiple option names for a product (typical example is a shoe that is available in a color and a size) then the current implementation allows a custom ID to be applied to each such pairing of color and size (blue-9, green-10). For a product with three option names, then the combination of three option values would be used to which a single customid could be provided... Assume a shirt that is available in adult and child (two option values for a single option name) that is available in three colors (white, blue, black), and in four different sizes (S, M, L, XL) then some of the combinations available to which each has a customid available would be:
Adult-white-S : shirt1
Child-Blue-M: shirt2
Adult-Black-XL: shirt3
Where shirt1, shirt2 and shirt3 could be the customid that is entered.
With a total of 24 combinations available to be assigned in the above example.
The data (value of the customid) currently is then provided on the invoice, the email, in the order history, etc. (areas where the selected attributes are presented) in some cases in replacement of the model# while the model# is generally still available as well... Where a customid is not provided but the desire is to display customids then the model # is provided instead (whether that be blank or some data).
Many thanks for that, now understand. I think in my implementation I will not need to use it.
Another question, this is probably a setting I have missed somewhere. The plugin is working OK and I have 'SBA Show Stock Level on Product Info Page' selected true and the quantities are showing against the various variants. However, for variants where there is no stock, it is showing the 'Quantity of all variants' instead of 0. If I try to add an out-of-stock item to the Cart it comes up as out-of-stock, so it's just this displayed figure that is wrong. Any suggestions ?
TIA ... Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Many thanks for that, now understand. I think in my implementation I will not need to use it.
Another question, this is probably a setting I have missed somewhere. The plugin is working OK and I have 'SBA Show Stock Level on Product Info Page' selected true and the quantities are showing against the various variants. However, for variants where there is no stock, it is showing the 'Quantity of all variants' instead of 0. If I try to add an out-of-stock item to the Cart it comes up as out-of-stock, so it's just this displayed figure that is wrong. Any suggestions ?
TIA ... Mike
To clarify, when you say variants with no stock, does that mean the variant is listed in the admin table and the value is zero or is the variant not present at all for that product?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
To clarify, when you say variants with no stock, does that mean the variant is listed in the admin table and the value is zero or is the variant not present at all for that product?
Just been playing around and found a fix. If I enter a quantity of 0 against a variant it does not show up in the table. If I set a quantity >0 then it does. If I then edit the quantity in the table to 0 it remains visible and works correctly in the cart
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Just been playing around and found a fix. If I enter a quantity of 0 against a variant it does not show up in the table. If I set a quantity >0 then it does. If I then edit the quantity in the table to 0 it remains visible and works correctly in the cart
Mike
What I understand is, addition of a variant with 0 quantity to start does not add the variant to the list.
How many attributes (option names) are associated with the product? What was the selection adjacent to the option name(s) when trying to add a quantity of 0?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
What I understand is, addition of a variant with 0 quantity to start does not add the variant to the list.
How many attributes (option names) are associated with the product? What was the selection adjacent to the option name(s) when trying to add a quantity of 0?
I was adding them all in exactly the same way, entering the actual true stock levels. However, as you say, a quantity of 0 will not add the variant, so a quantity of 1 has to be entered to start with and then edited in the table.
No problem, as long as I know the sequence :smile:
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
I was adding them all in exactly the same way, entering the actual true stock levels. However, as you say, a quantity of 0 will not add the variant, so a quantity of 1 has to be entered to start with and then edited in the table.
No problem, as long as I know the sequence :smile:
Mike
Understand that it is no problem for you, and if you were the only one to ever use the software, that would also be fine. But one goal is to be sure that it works as "most" people would expect. Adding a product as being stocked to then turn around and make it out-of-stock doesn't make sense. Imagine as a customer if the product were viewed at that point, and heaven forbid purchased when in fact no stock existed for it.
So, the questions were asked in a fairly specific way. The code has more than one method of processing the data entered based on the selections made to create a variant... Ideally, like all issues identified, reproducing the problem helps to find the solution. Unfortunately I don't know what your "normal way of entering product" is, until recently my normal way was through phpmyadmin as I could get it right everytime...
Now that I've added sequenced dropdowns with the ability to show product that is out-of-stock and the admin page works for a large majority of it's actions, including the product being presented in a page by page fashion instead of all at once, I'm finding it much more convenient to use, although I would probably still use EP4 to control SBA variant inventory if I had a lot of product.
So if you could please take a moment to answer the questions, it would be appreciated by all.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Apologies if I was sounding flippant, my site using Zen is still under construction, thus nothing seen live by customers, etc.
The reason I want to add variants with 0 stock level is so that customers will be able to see all variants that can be available, whereas if not shown on the product screen, then that variant is not obviously available.
As I said above, still very much under construction as I am working my way through learning the package. If you want to see what the result of the above is on my product screen is have a look at:
http://dracocrafts.com/dcshop/index....&products_id=1
and look at the Size drop-down box.
Entering a stock level of 1 to get the variant into the product table and the subsequently editing it back to 0 would have no consequences on a live site either. Until the 'Sync Quantities' tab is selected (or Sync All Quantities) then the live database is not updated and consequently the new variants/quantities are not available to customers.
If there is a 'fix' for this then I would be happy to incorporate it. Personally I am not a smart enough coder to know how to fix it myself, so this work-around will be fine for my implementation in my store.
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Apologies if I was sounding flippant, my site using Zen is still under construction, thus nothing seen live by customers, etc.
The reason I want to add variants with 0 stock level is so that customers will be able to see all variants that can be available, whereas if not shown on the product screen, then that variant is not obviously available.
As I said above, still very much under construction as I am working my way through learning the package. If you want to see what the result of the above is on my product screen is have a look at:
http://dracocrafts.com/dcshop/index....&products_id=1
and look at the Size drop-down box.
Entering a stock level of 1 to get the variant into the product table and the subsequently editing it back to 0 would have no consequences on a live site either. Until the 'Sync Quantities' tab is selected (or Sync All Quantities) then the live database is not updated and consequently the new variants/quantities are not available to customers.
If there is a 'fix' for this then I would be happy to incorporate it. Personally I am not a smart enough coder to know how to fix it myself, so this work-around will be fine for my implementation in my store.
Mike
It's no problem afterall like you said you're working on your own store to get it ready to go full-time live. Still trying to identify which of the couple of methods were used to populate the stock with zero quantity; however, seeing the example is a single attribute product, the two options that come to mind are identifying a single attribute and providing a quantity of zero, or populating all variants with a single value of zero. While the question still wasn't directly answered the situation can be inferred to either/both of those methods do not successfully populate the potential variants when a quantity of zero is identified for the stock quantity.
On the issue of having to wait for quantity synchronization before a product can be purchased is not correct at least on the version that I am testing... I have a synchronized quantity of 31 product, but 12 variants (three option names, 2 for the first, 3 for the second, and 2 for the third). All but 2 of the variants have a quantity of 10, the other 2 variants both fall in the absence of the third option name. I was just able to add to my cart a quantity of 40. (Haven't "purchased" them yet, but if there is a problem expected down the line, then there really should be something identified at the cart level, even if it is a potential of something being changed/different.)
So, is this a problem? Still not sure what the purpose of the quantity synchronization is (left over from some old code) at least in multiple attribute type product, but it has not necessarily been programmed in to cause some sort of alert... It does have some usefulness in single attribute product, but more of a total of a product can not exceed the total available which the synchronized quantity for a single attribute is basically the sum of all the different "styles" and makes more sense than when compared to multiple attributes. That said, I just tried a product that had single attributes, 61 synchronized in quantity, three option values each with 30 applied, and was able to add all 90 to the cart...
Did discover that the reported quantity in cart is not correct, which is something else that will need to be addressed... But at least up to the point of adding to the cart, there is nothing preventing adding quantity that were designated for a variant even if the total variant quantity exceeded the synchronized quantity. (That said, there also is no "edit" for the synchronized quantity, either it is the total of all the variants or it is off because the variants have been manipulated outside of the cart's "normal" process.)
There will be a fix for the inability to add a variant or combination of variants with a quantity of zero, just have to find the correct coding for when the value is zero as I remember there is a "trick" to get around the result that is being seen, but I can't remember what it is off the top of my head.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Sorry, to answer your specific question, I was populating one variant at a time. Eventually there will be 2/3 variants per item in this category, but not got that far yet.
With another template issue I am having I have been advised to upgrade from 1.5.1 to 1.5.4 and I understand that this plug-in may not work with the latest version anyway ?
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Sorry, to answer your specific question, I was populating one variant at a time. Eventually there will be 2/3 variants per item in this category, but not got that far yet.
With another template issue I am having I have been advised to upgrade from 1.5.1 to 1.5.4 and I understand that this plug-in may not work with the latest version anyway ?
Mike
Don't know the source of dissinformation, but that's no matter. The specific version that you are using (1.5.3 I assume) may not work straight out of the box without some "knowledgeable merging", but yes there is a version that works with ZC 1.5.4. It is in some final assembly to ensure maximum functionality, but it works on 1.5.4. If it doesn't then I've wasted time in rewriting and postingmy changes to github. :)
As for multiple attributes with the version you're using, without Dynamic Dropdowns (which needs a little work as well straight out of the box) or some tweaking of the sql in attributes.php things won't look too good to the customer.
I've worked a few ways around the issues with multiple attributes, want to have confirmation that it works/didnt break something else, but as I said I tested with three attributes, will have to try with four to see if the sequenced dropdowns works correctly/as desired for products shown as out of stock and for those products not shown (original design of Dynamic Dropdowns).
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Thank you very much indeed for your help, information and advice. I am very interested in trying the updated plug-ins you are working on, so will keep my eye on things. Do you have any time frame on their release?
I take it you recommend I use both Stock by Attribute and Dynamic Dropdowns?
Thanks again Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Thank you very much indeed for your help, information and advice. I am very interested in trying the updated plug-ins you are working on, so will keep my eye on things. Do you have any time frame on their release?
I take it you recommend I use both Stock by Attribute and Dynamic Dropdowns?
Thanks again Mike
So based on some discussion about how to make SBA provide the widest range of operation, Dynamic Dropdowns is being incorporated into SBA. Currently instead of replacing the existing code a new class (sba_sequenced_dropdown) has been created to provide the widest functionality that has been considered for SBA with switches to adjust response including not using DD. Already have received some feedback related to how attributes are sorted for display, which generally confirms that headed in the right direction but a few internal fixes necessary. If not mistaken the goal was to have this ready early part of this month. The work that I did over the weekend certainly moved things along quickly, laying some groundwork to move to the next offering of a non-sequenced "free-for-all" possibility. The logic behind this one and system response will be a bit "touchy", but hopefully the easiest options will be made available rather than succumbing to the "it's too hard" response.
In developing the additional functionality I have also been working on an update to Dynamic Dropdowns to incorporate updates to the basic functionality and plan to package up those changes for submission in case others use DD for programs other than SBA or the version that is being pulled together. Also, would like to back fit the operation into the version that supports ZC 1.5.1, but attention was put into the more recent version of ZC to push things further forward a little faster rather than dwelling on the past. :)
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Understood and many thanks again
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Just installed this plugin on a new install of Zen Cart and every page I try to pull up is blank.
versions:
Zen Cart 1.5.3 (had .4 on, but realized that this might be the problem so installed .3 over top)
Stock by attribute 1.5.3
error message:
[Fri Mar 06 11:11:03 2015] [error] [client 69.163.128.115] client denied by server configuration: /home/bmdavis/boundlessmotion.com/shop/includes/filenames.php
[Fri Mar 06 11:11:03 2015] [error] [client 69.163.128.115] File does not exist: /home/bmdavis/boundlessmotion.com/forbidden.html
Any suggestions?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
st.bobo
Just installed this plugin on a new install of Zen Cart and every page I try to pull up is blank.
versions:
Zen Cart 1.5.3 (had .4 on, but realized that this might be the problem so installed .3 over top)
Stock by attribute 1.5.3
error message:
[Fri Mar 06 11:11:03 2015] [error] [client 69.163.128.115] client denied by server configuration: /home/bmdavis/boundlessmotion.com/shop/includes/filenames.php
[Fri Mar 06 11:11:03 2015] [error] [client 69.163.128.115] File does not exist: /home/bmdavis/boundlessmotion.com/forbidden.html
Any suggestions?
SSA 1.5.3 is for ZC 1.5.1...
Need to use SBA 1.5.4, and recommend the branch mc12345678_zc154 that is still in beta, but is compatible with ZC 1.5.3 and ZC 1.5.4. Look back in the postings of this thread to find the actual path/link
-
2 Attachment(s)
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Hi all, I'm back with a couple more questions...... I am now using Zen Cart 1.5.4. and have installed the above version of SBA (https://github.com/potteryhouse/stoc...12345678_ZC154). Everything is working as far as the setting of attributes is concerned and even the glitch I had with the previous version has been resolved regarding zero quantities. However, I do have a couple of issues, both of which may well be down to me missing some settings I am sure, but I seem unable to resolve either.
The first issue, is that although I have the setting in 'Configuration/Stock/SBA Show Stock Level on Product Info Page' set to 'true', the quantities are not showing in the drop-down list, as shown on the screen dump attached.
Secondly, on the product info screen, even though some of the options have stock (and in this case there is only one option anyway) the following text is permanently displayed: 'The combination of options you have selected is currently out of stock. Please select another combination.', as shown on the second attached screen dump.
Any advice, help or even just telling me I am twit and change this and that setting, will be gladly received :P
Mike
Attachment 15045
Attachment 15046
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
I need to modify the default installation script a little, but if you goto configuration-> Dynamic Dropdowns and turn of the single attribute option, the issue described (for single attributes) will go away. :)
Ie, the default programming you are used to seeing will return.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
I need to modify the default installation script a little, but if you goto configuration-> Dynamic Dropdowns and turn of the single attribute option, the issue described (for single attributes) will go away. :)
Ie, the default programming you are used to seeing will return.
Great, thank you, sorted that one. I guess the modification you noted is for the missing quantities ?
Another question I have, the answer may be obvious but I have not seen it. Can options have sub-options? To try and explain, we have products in multiple colours and multiple sizes, so the customer would select the colour first and then size, but of course all sizes may not currently be in stock for all colours. Thus the size stock quantities will be different for differing colours.
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Great, thank you, sorted that one. I guess the modification you noted is for the missing quantities ?
Mike
Two fold actually. Until the single attribute dropdown of dynamic dropdowns is "fixed", it should be turned off from the start (ie, installed with it off). Priority was to find a way to display multiple attributes, which does work as reprogrammed...
While still a little "patchy" trying to ensure a functioning product, a plan in place to make improvements, and that is relatively easy to install/use. :)
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Two fold actually. Until the single attribute dropdown of dynamic dropdowns is "fixed", it should be turned off from the start (ie, installed with it off). Priority was to find a way to display multiple attributes, which does work as reprogrammed...
While still a little "patchy" trying to ensure a functioning product, a plan in place to make improvements, and that is relatively easy to install/use. :)
I think it is quite easy to use, just need to reprogram myself from the way it is done in the package we are currently using (x-cart). It was working fine, but they turned off the multiple attribute feature from the free version and want to charge me $500 per year to use it.....
BTW, I edited my last post adding another question, in case you have not noticed :smile:
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Another question I have, the answer may be obvious but I have not seen it. Can options have sub-options? To try and explain, we have products in multiple colours and multiple sizes, so the customer would select the colour first and then size, but of course all sizes may not currently be in stock for all colours. Thus the size stock quantities will be different for differing colours.
Mike
Hadn't noticed, thanks for pointing out. That is the part that has been specifically modified/created using Dynamic Dropdowns to create an additional choice above the original four of the oob DD. Yes, but at the moment there is a bit of a caveat in it's operation. It is possible to identify the quantity and out-of-stock condition for all attribute options. What you describe is the mutliple attribute condition (multiple option names technically.)
The caveat is this: if in your example, if sizes 5, 7, and 9 are only fabricated for blue, but 5, 6, 7, 8, and 9 (or the European equivalents) are offered for all other colours, then when making a selection of blue will indicate that 6 and 8 are out of stock... Technically never available... This is something that is on the platter to fix... Also though, at the moment I believe that a variant must be entered for all options otherwise a stock quantity of the total available sum of all combinations is shown for those options not entered as a variant... Also to be corrected or rather will self correct when the first issue is addressed.
Stock will not be displayed until at the last option of choices, and depending on what stock is missing, an out-of-stock message may appear at a point early in the selection, if all sub-selections are unavailable... More of a thing when three or more attributes are applied to a product...
Quote:
Originally Posted by
Mikeondraco
I think it is quite easy to use, just need to reprogram myself from the way it is done in the package we are currently using (x-cart). It was working fine, but they turned off the multiple attribute feature from the free version and want to charge me $500 per year to use it.....
BTW, I edited my last post adding another question, in case you have not noticed :smile:
Mike
Glad that found that SBA is easy to use. What you saw was Dynamic Dropdowns applied out of the box as directed by the instructions: multiple dropdown used for a single attribute product... For some reason the out of stock message gets hard set. Haven't fixed it yet because potteryhouse and jeking had worked out a single attribute option that works just fine, so back to priorities... :) There are a number of other UI tweaks on the admin side also that I am sure you will come across since you are a previous user of SBA...
Could always apply that to *ahhmm* something else. :P
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Hadn't noticed, thanks for pointing out. That is the part that has been specifically modified/created using Dynamic Dropdowns to create an additional choice above the original four of the oob DD. Yes, but at the moment there is a bit of a caveat in it's operation. It is possible to identify the quantity and out-of-stock condition for all attribute options. What you describe is the mutliple attribute condition (multiple option names technically.)
The caveat is this: if in your example, if sizes 5, 7, and 9 are only fabricated for blue, but 5, 6, 7, 8, and 9 (or the European equivalents) are offered for all other colours, then when making a selection of blue will indicate that 6 and 8 are out of stock... Technically never available... This is something that is on the platter to fix... Also though, at the moment I believe that a variant must be entered for all options otherwise a stock quantity of the total available sum of all combinations is shown for those options not entered as a variant... Also to be corrected or rather will self correct when the first issue is addressed.
Stock will not be displayed until at the last option of choices, and depending on what stock is missing, an out-of-stock message may appear at a point early in the selection, if all sub-selections are unavailable... More of a thing when three or more attributes are applied to a product...
Glad that found that SBA is easy to use. What you saw was Dynamic Dropdowns applied out of the box as directed by the instructions: multiple dropdown used for a single attribute product... For some reason the out of stock message gets hard set. Haven't fixed it yet because potteryhouse and jeking had worked out a single attribute option that works just fine, so back to priorities... :) There are a number of other UI tweaks on the admin side also that I am sure you will come across since you are a previous user of SBA...
Could always apply that to *ahhmm* something else. :P
Aha, if I could afford it I probably wouldn't be giving myself (and you....) all this grief :D
To try and clarify it in my mind, it seems that the only way I can do this (at the moment maybe) is, as I think you are saying, that I create a variant for each product type (i.e. white size S, black size S, pink size S, etc., etc.) so that there is a specific stock quantity for each possible variant? This would result in a single drop down choice rather than a multiple drop down though .... I think
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Aha, if I could afford it I probably wouldn't be giving myself (and you....) all this grief :D
To try and clarify it in my mind, it seems that the only way I can do this (at the moment maybe) is, as I think you are saying, that I create a variant for each product type (i.e. white size S, black size S, pink size S, etc., etc.) so that there is a specific stock quantity for each possible variant? This would result in a single drop down choice rather than a multiple drop down though .... I think
Mike
Ahh yes, I see the confusion... Thinking "old school".
So let's get familiar with some terms...
Option names: the type of object to be selected, colour and size.
Option values: the values (number, text, whatever) that describes the option name: blue, green for colour, 5, 6, 7, 8, etc. For size
Variant, the cobination of option values of each option name that uniquely identifies the product... This aspect is captured/controlled by SBA. The other two are inherent to ZC.
So, when creating the SBA variants, adjacent to each option name select the dropdown All-Attribute-Combo.. Every variant type will be populated with the quantity entered at the bottom (including 0 as that got fixed recently).
Then with DD for multiple attributes active and sba_sequenced_dropdown applied, that product will display multiple attributes for selection with the option names display according to their sort order. Upon making the first selection (two option names applied) view of the second option name option will display the quantity available or out-of-stock. Swith to another first selection and the second selection will be updated...
So, that should help wrap your mind around it a little more. :)
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Ahh yes, I see the confusion... Thinking "old school".
So let's get familiar with some terms...
Option names: the type of object to be selected, colour and size.
Option values: the values (number, text, whatever) that describes the option name: blue, green for colour, 5, 6, 7, 8, etc. For size
Variant, the cobination of option values of each option name that uniquely identifies the product... This aspect is captured/controlled by SBA. The other two are inherent to ZC.
So, when creating the SBA variants, adjacent to each option name select the dropdown All-Attribute-Combo.. Every variant type will be populated with the quantity entered at the bottom (including 0 as that got fixed recently).
Then with DD for multiple attributes active and sba_sequenced_dropdown applied, that product will display multiple attributes for selection with the option names display according to their sort order. Upon making the first selection (two option names applied) view of the second option name option will display the quantity available or out-of-stock. Swith to another first selection and the second selection will be updated...
So, that should help wrap your mind around it a little more. :)
Ok, something to wrap my mind around tomorrow I think. Need, as you say, to approach it from a different angle.
BTW, defo old school here :wink:
Thanks again for your time, patience and answers - really appreciated.
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Ok, something to wrap my mind around tomorrow I think. Need, as you say, to approach it from a different angle.
BTW, defo old school here :wink:
Thanks again for your time, patience and answers - really appreciated.
Mike
No problem, you'll see just how easy it is once you try it/think about it.
In this forum related to SBA, old school is building attributes using way too much time and effort to type in an option value of each combination, so that it looked like this:
Shoe: colour1 and size1
Colour2 and size1
Colour1 and size2
Colour2 and size2
Etc....
Now, type in all the colors (ZC has some default entries if not mistaken)
Type in the sizes (can modify one of the default option names to accomplish)
The in sba admin, assign combinations of those manually (blah) or using the combo option (yeah potteryhouse and jeking for providing the option that got modified to allow greater than 6 option names, though if that many are needed might have issues... ) :)
Anyways, get some rest and think about it later.:)
-
1 Attachment(s)
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Ahh yes, I see the confusion... Thinking "old school".
So let's get familiar with some terms...
Option names: the type of object to be selected, colour and size.
Option values: the values (number, text, whatever) that describes the option name: blue, green for colour, 5, 6, 7, 8, etc. For size
Variant, the cobination of option values of each option name that uniquely identifies the product... This aspect is captured/controlled by SBA. The other two are inherent to ZC.
So, when creating the SBA variants, adjacent to each option name select the dropdown All-Attribute-Combo.. Every variant type will be populated with the quantity entered at the bottom (including 0 as that got fixed recently).
Then with DD for multiple attributes active and sba_sequenced_dropdown applied, that product will display multiple attributes for selection with the option names display according to their sort order. Upon making the first selection (two option names applied) view of the second option name option will display the quantity available or out-of-stock. Swith to another first selection and the second selection will be updated...
So, that should help wrap your mind around it a little more. :)
Ok, been playing with it tonight, but do not seem able to get the correct results.
The example is Colour: Pink and White, Size S & L. I have 1 each colour in S, but only white in L.
I added the two variants to the product checking the All-Attribute-Combo and quantity 1 for each Option Name. In the table presented I have four variants shown all with qty 1 as I entered. However, there is no way (that I can see) that I can input that I only have the L size available in White, I can either have qty 1 or 0 in the table against that value, which shows up in the catalogue as 1 each colour or out-of-stock in both ?
Attachment 15052
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
Ok, been playing with it tonight, but do not seem able to get the correct results.
The example is Colour: Pink and White, Size S & L. I have 1 each colour in S, but only white in L.
I added the two variants to the product checking the All-Attribute-Combo and quantity 1 for each Option Name. In the table presented I have four variants shown all with qty 1 as I entered. However, there is no way (that I can see) that I can input that I only have the L size available in White, I can either have qty 1 or 0 in the table against that value, which shows up in the catalogue as 1 each colour or out-of-stock in both ?
Attachment 15052
Yup, incorrectly entered...
On the screen for entering new variants, should see something like:
Colour: (dropdown)
Size: (dropdown)
Both dropdowns need to be identified as All-Attribute-Combo at one time...
So would see:
Colour: All-Attribute-Combo
Size: All-Attribute-Combo
Then in quantity, enter the desired quantity (0 is a start so that nothing can be purchased of these).
The result on the screen you show should be similar to below where I have shown a single variant that has multiple attributes applied:
X | 5-50-52| colour: Pink (next line) Size: 12-13 | 0 | 0 | blank | blank | Edit Quantity | Delete Variant
You'll also need to delete those four variants... They are incorrect for the purpose of multiple attributes and will likely provide unusual results...
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Yup, incorrectly entered...
On the screen for entering new variants, should see something like:
Colour: (dropdown)
Size: (dropdown)
Both dropdowns need to be identified as All-Attribute-Combo at one time...
So would see:
Colour: All-Attribute-Combo
Size: All-Attribute-Combo
Then in quantity, enter the desired quantity (0 is a start so that nothing can be purchased of these).
The result on the screen you show should be similar to below where I have shown a single variant that has multiple attributes applied:
X | 5-50-52| colour: Pink (next line) Size: 12-13 | 0 | 0 | blank | blank | Edit Quantity | Delete Variant
You'll also need to delete those four variants... They are incorrect for the purpose of multiple attributes and will likely provide unusual results...
That's it ! - I need leading by the nose you see :blink:
Many thanks yet again ... Mike
P.S. - I may of course be back .....
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
That's it ! - I need leading by the nose you see :blink:
Many thanks yet again ... Mike
P.S. - I may of course be back .....
BTW, as I said about the caveat situation. If indication of Large not being available in any other color is one where you just happen to be out-of-stock, then the out-of-stock notification will serve you properly... If Large is only ever fabricated in White, then the out-of-stock message (for now) will be misleading to customers... You will never have that type of product as it is not fabricated... Am working to resolve that, but again... Priorities.. :) Want to incorporate the presentation of single attributes into the multiple attribute side, then can continue on with making sure only the "proper" instock/out-of-stock items are displayed.
We'll have to make sure that the instructions provide such an example so that it is clear to the next person that isn't familiar with the way SBA was supposed to work... :)
There are some other issues to work out as well, I like to call it the gift-wrap attribute... Quantity of gift wrap is not tracked, but it is an attribute that can be chosen along all the other attributes... Will require a bit of rework/inclusion in the background, but one step at a time. Also there is the desire to be able to show information possibly with other variants of Dynamic Dropdowns... (radio buttons etc...) And I think there is still a text box issue, but again.... :) Priorities... :) Certainly more functionality in this than previous SBA variants.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
BTW, as I said about the caveat situation. If indication of Large not being available in any other color is one where you just happen to be out-of-stock, then the out-of-stock notification will serve you properly... If Large is only ever fabricated in White, then the out-of-stock message (for now) will be misleading to customers... You will never have that type of product as it is not fabricated... Am working to resolve that, but again... Priorities.. :) Want to incorporate the presentation of single attributes into the multiple attribute side, then can continue on with making sure only the "proper" instock/out-of-stock items are displayed.
We'll have to make sure that the instructions provide such an example so that it is clear to the next person that isn't familiar with the way SBA was supposed to work... :)
There are some other issues to work out as well, I like to call it the gift-wrap attribute... Quantity of gift wrap is not tracked, but it is an attribute that can be chosen along all the other attributes... Will require a bit of rework/inclusion in the background, but one step at a time. Also there is the desire to be able to show information possibly with other variants of Dynamic Dropdowns... (radio buttons etc...) And I think there is still a text box issue, but again.... :) Priorities... :) Certainly more functionality in this than previous SBA variants.
I appreciate what you mean about the out-of-stock notification being, in some case, misleading. At present that will not be a problem for us, as that situation is restricted to product types, not models.
I have no problem with being a guinea-pig for you re formulating the instructions - that would be a kinder description than the one you probably have in mind :smile:
Mike
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Mikeondraco
I appreciate what you mean about the out-of-stock notification being, in some case, misleading. At present that will not be a problem for us, as that situation is restricted to product types, not models.
I have no problem with being a guinea-pig for you re formulating the instructions - that would be a kinder description than the one you probably have in mind :smile:
Mike
I'm not yet sure how public the documentation is yet, but certainly would not be bad to get a cold read as it is more finalized I think. Potteryhouse and jeking I think thought they were done with the instructions until I was allowed to start adding additional features... :P Ideally the new information/options could be somewhat generalized so that the instructions could stand on their own, the forum could provide some assistance and the code can continue to be reworked without needing too much change in the instructions... :) (Pipe-dream? Dunno.. :) )
A work-around to the current "caveat" though somewhat less desirable is to only show product that is in stock (default Dynamic Dropdown functionality), but at least the option is there if it is business critical... The way the template file has been reworked also, it could be possible to custom code so that each product is displayed with its own version of the dynamic dropdown class and with whatever settings are desired for display of out-of-stock etc... Just have to be a little creative in incorporation... :) That's what coders are for... :P
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
I'm here if you want a proof-reader then. All noted re your other comments, once I get to grips with things as is I may start experimenting....
Mike :unsure:
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
I installed the SBA files and I quickly got a blank page for admin....
so I put my backup 'general.php' to overwrite the 'general.php' that comes with SBA
and my admin page came back...
but now..I can't get the installation script to work.......... to install the SBA stuff under Configuration | Stock..
what am I missing?
zencart 1.5.4
thanks.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
lrfowler
I installed the SBA files and I quickly got a blank page for admin....
so I put my backup 'general.php' to overwrite the 'general.php' that comes with SBA
and my admin page came back...
but now..I can't get the installation script to work.......... to install the SBA stuff under Configuration | Stock..
what am I missing?
zencart 1.5.4
thanks.
Try downloading from: https://github.com/potteryhouse/stoc...2345678_ZC154?
The main branch I think still has an error in it. I know at one point I was asked to merge the branches together, but then some more issues were found so the merge was delayed.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
In my version of SBA; deleting a product from catalogue does NOT delete the records belonging to that product in the SBA table. Is there a preferred method of cleaning up / deleting product attribute from SBA table?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Kevin205
In my version of SBA; deleting a product from catalogue does NOT delete the records belonging to that product in the SBA table. Is there a preferred method of cleaning up / deleting product attribute from SBA table?
That functionality has not yet been ported into the version of SBA for Zc 1.5.1. Which is the version of ZC identified in your signature as your current version. The functionality however is in the version applicable to ZC 1.5.3 and 1.5.4 available at: https://github.com/potteryhouse/stoc...12345678_ZC154
Remember this is still beta software. The admin/includes/classes/observers/class.products_with_attributes_stock.php file found in that folder contains the actions necessary to accomplish what you are describing (as well as other functions that would require code changes elsewhere in your system or they could be commented out so as not to throw errors.) To use this file the applicable auto_loaders file would also be necessary to kick ZC off to use the above admin class file.
Otherwise, the method I would suggest to remove all attributes applicable to a given product would be to delete all sba table entries for that product using a sql query after backing up the database... Yes, backup the database before deleting...
The expected sql would be:
Code:
delete from products_with_attributes_stock where products_id = '20'
Where 20 would be the product number for the product being deleted... Remember BACKUP before executing.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
That functionality has not yet been ported into the version of SBA for Zc 1.5.1. Which is the version of ZC identified in your signature as your current version. The functionality however is in the version applicable to ZC 1.5.3 and 1.5.4 available at:
https://github.com/potteryhouse/stoc...12345678_ZC154
Remember this is still beta software. The admin/includes/classes/observers/class.products_with_attributes_stock.php file found in that folder contains the actions necessary to accomplish what you are describing (as well as other functions that would require code changes elsewhere in your system or they could be commented out so as not to throw errors.) To use this file the applicable auto_loaders file would also be necessary to kick ZC off to use the above admin class file.
Otherwise, the method I would suggest to remove all attributes applicable to a given product would be to delete all sba table entries for that product using a sql query after backing up the database... Yes, backup the database before deleting...
The expected sql would be:
Code:
delete from products_with_attributes_stock where products_id = '20'
Where 20 would be the product number for the product being deleted... Remember BACKUP before executing.
Got it and thank you mc12345678.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Is it possible to write a query to display the following in one pass?
products_id
products_model
customid
products_attributes_id
options_id
options_values_id
products_options_values_name
I have been trying to get a query to work, but have not been successful.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
I got kicked out while typing!
I have this query working, but only for one product id (52). I need to retrieve all data.
PHP Code:
select
p.products_id,
p.products_model,
pa.products_attributes_id,
pa.options_values_id,
pov.products_options_values_name,
sba.customid,
sba.quantity
from
zen_products as p
left join
zen_products_attributes as pa ON p.products_id = pa.products_id
left join
zen_products_with_attributes_stock as sba ON pa.products_attributes_id = sba.stock_attributes
left join
zen_products_options_values as pov ON pa.options_values_id = pov.products_options_values_id
where
p.products_id = 52;
This question might not belong here; but since it performs a query on the SBA table, I thought it could be OK?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Assuming that you use only single option names with each productit seems that if you removed the where clause, that the results for all products would be returned with null I thought in the fields where a product was not tracked by SBA, if wanted to return only sBA tracked product information, then would change from p.products_id to sba.products_id so that results only included sba tracked product.
If however product includes multiple option names (multiple attributes) then unfortunately, the query becomes a bit more complex if even possible with the current data structure of SBA. (Stock_attributes contains combinations of attribute information separated by commas instead of an additional table from which to pull the attributes... This has been one of the issues of SBA in times past and why it has been so difficult to overcome some aspects of SBA.
Ideally though that aspect will be resolved as well as additional capability is added... That said, it also can be worked around in it's current state but requires on occasion additional queries based on the product information.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
That did it
Code:
replaced
p.products_id = 52
with
p.products_id = sba.products_id
It accomplished what I needed. It now display all SBA related data, Thank you mc12345678
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Kevin205
That did it
Code:
replaced
p.products_id = 52
with
p.products_id = sba.products_id
It accomplished what I needed. It now display all SBA related data, Thank you mc12345678
Welcome, still could be made easier (assuming no loss of index power) by swapping the first returned value of p.products_id with sba.products_id and omitting the where statement, but it works.
If I may ask, what's the usage of this query? Also as stated, not all data will be provided by that one query if the store has multiple attributes for a product.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Welcome, still could be made easier (assuming no loss of index power) by swapping the first returned value of p.products_id with sba.products_id and omitting the where statement, but it works.
If I may ask, what's the usage of this query? Also as stated, not all data will be provided by that one query if the store has multiple attributes for a product.
Sorry for the late reply.
While trying to eliminate the discontinued items from the SBA table, I could not find a comprehensive report with all of SBA data needed in one report. That is why I tried to generate the report via SQL.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Can customid data be place in e-mails to clients?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Kevin205
Can customid data be place in e-mails to clients?
Unfortunately the same answer as before basically applies. Currently supported in the version available from the link above, but not yet ported to version 1.5.3 in support of ZC 1.5.1.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
Kevin205
Can customid data be place in e-mails to clients?
Gotcha', was trying to see if there was a need for a function to provide that data on a "routine" basis.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
mc12345678
Unfortunately the same answer as before basically applies. Currently supported in the version available from the link above, but not yet ported to version 1.5.3 in support of ZC 1.5.1.
Thank you
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
I am not real familiar with SBA - so will start this off by saying... pardon me if I ask a really STUPID question! LOL
I have a customer that has a very old version of zen cart that we are trying to upgrade. She uses SBA, Dynamic Dropdown, and an Atrribute Image swap.
I have done the upgrade to 1.5.4 using the latest SBA code on github. The latest SBA code appears to have Dynamic Dropdown built in from what I can see.
My problem is that on her current site, if you click the first dropdown, Say... Long Sleeve Tshirt, then click on the next dropdown, EG: Color, it will only show the long sleeve options. This, to me, would be the "Dynamic Dropdown" function.
In the NEW build, it shows ALL the attributes for the "product", instead of just the Long Sleeve T-shirt.
Here is a link to the new build:
Here is a link to the original site
I have gone at this every way I know how... merging code, not merging code, and it just doesn't work. :ohmy:
Is there something that I am missing? Or does Dynamic Dropdowns just not work "out of the box" with the new version of SBA?
Thanks so much for any assistance you can give me!!
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
stellarweb
I am not real familiar with SBA - so will start this off by saying... pardon me if I ask a really STUPID question! LOL
I have a customer that has a very old version of zen cart that we are trying to upgrade. She uses SBA, Dynamic Dropdown, and an Atrribute Image swap.
I have done the upgrade to 1.5.4 using the latest SBA code on github. The latest SBA code appears to have Dynamic Dropdown built in from what I can see.
My problem is that on her current site, if you click the first dropdown, Say... Long Sleeve Tshirt, then click on the next dropdown, EG: Color, it will only show the long sleeve options. This, to me, would be the "Dynamic Dropdown" function.
In the NEW build, it shows ALL the attributes for the "product", instead of just the Long Sleeve T-shirt.
Here is a link to the new build:
Here is a link to the original site
I have gone at this every way I know how... merging code, not merging code, and it just doesn't work. :ohmy:
Is there something that I am missing? Or does Dynamic Dropdowns just not work "out of the box" with the new version of SBA?
Thanks so much for any assistance you can give me!!
Correct, the version that is in the branch mc12345678_sba154 has dynamic dropdowns incorporated as provided via download from this site. There is a new selection available in the admin that was not a part of the original code that was put together to specifically work with this version of SBA. That said the new site does not appear to have the sequenced dynamic aspect active...
There are a few things though that need to go together to get the desired result(s).
The code that was a part of your previous version likely could be ported to this one and continue working; however, to use the version created here and active upon installation requires the product variants to be entered as discussed over the few previous pages where each entry of a variant contains all attributes applicable to that stock tracked quantity.
To best try to resolve, would help to know what the settings were/are for the old site in the dynamic dropdown configuration area. Both for multiple attributes as well as single attributes.
Then to also know how the variants are setup for example on the product presented above.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
In looking at the current admin (version 1.3.8a) and the new build (1.5.4), I do not see anything that says anything about Dynamic Dropdowns either under Configuration or Catalog menus.
When I use the Search Configuration on the new build, I see
Enable Dynamic Dropdowns 2
Product Info Single Attribute Display Plugin multiple_dropdowns
Show Out of Stock Attributes True
Product Info Multiple Attribute Display Plugin sba_sequenced_dropdowns
Mark Out of Stock Attributes Right
Display Out of Stock Message Line True
Prevent Adding Out of Stock to Cart True
SBA Number of Records to Displayed 25
Enable Dynamic Dropdowns
On for Multi-Attribute Only
Does that help any?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
To add to this..... the Image swap mod has 2 files in common with SBA
admin/options_name_manager.php
includes/modules/custom/attributes.php
I merged the coding - but the attributes.php file removes the image swap functionality, even though it is merged correctly. It also makes the different dropdowns go wonky, so I have to use the Image swap attributes.php file.
Also, I cannot use the includes/templates/custom/templates/tpl_modules_attributes.php file because it causes the image swap not to work.
Quote:
Originally Posted by
stellarweb
In looking at the current admin (version 1.3.8a) and the new build (1.5.4), I do not see anything that says anything about Dynamic Dropdowns either under Configuration or Catalog menus.
When I use the Search Configuration on the new build, I see
Enable Dynamic Dropdowns 2
Product Info Single Attribute Display Plugin multiple_dropdowns
Show Out of Stock Attributes True
Product Info Multiple Attribute Display Plugin sba_sequenced_dropdowns
Mark Out of Stock Attributes Right
Display Out of Stock Message Line True
Prevent Adding Out of Stock to Cart True
SBA Number of Records to Displayed 25
Enable Dynamic Dropdowns
On for Multi-Attribute Only
Does that help any?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
stellarweb
In looking at the current admin (version 1.3.8a) and the new build (1.5.4), I do not see anything that says anything about Dynamic Dropdowns either under Configuration or Catalog menus.
When I use the Search Configuration on the new build, I see
Enable Dynamic Dropdowns 2
Product Info Single Attribute Display Plugin multiple_dropdowns
Show Out of Stock Attributes True
Product Info Multiple Attribute Display Plugin sba_sequenced_dropdowns
Mark Out of Stock Attributes Right
Display Out of Stock Message Line True
Prevent Adding Out of Stock to Cart True
SBA Number of Records to Displayed 25
Enable Dynamic Dropdowns
On for Multi-Attribute Only
Does that help any?
So, it looks like the sequenced aspect of dynamic dropdowns is activated (by the usage of Enable Dynamic Dropdowns 2 and Product Info Multiple Attribute Display Plugin sba_sequenced_dropdowns
But what seems to be the case is that the variants are not populated to support that option or one of the other settings/code is not carrying the sequencing forward.
Strange as well is that you don't have an option in your configuration list for dynamic dropdowns... My guess is that there is probably two or more database entries for the record as part of the upgrade from the previous version... Obviously not easily accessible, but the list of options can still be modified if you get to know what gID is applicable for all of those on your system. Will have to provide a way to remove the duplicate record information via separate correspondence unless someone else can jump in with that solution in the interim.
So the next thing would be to understand how this product is setup in the variants section for this one product. Able to do a screen capture or copy and paste of a row or series of rows for that product?
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Quote:
Originally Posted by
stellarweb
To add to this..... the Image swap mod has 2 files in common with SBA
admin/options_name_manager.php
includes/modules/custom/attributes.php
I merged the coding - but the attributes.php file removes the image swap functionality, even though it is merged correctly. It also makes the different dropdowns go wonky, so I have to use the Image swap attributes.php file.
Also, I cannot use the includes/templates/custom/templates/tpl_modules_attributes.php file because it causes the image swap not to work.
Ahhh, well... Not sure what version of the includes/templates/custom/templates/tpl_modules_attributes.php file is used on your current site, but that is the one file that actually engages dynamic dropdowns... Without it or a version of the original, no dynamic dropdown functionality is provided...
As for the image swap... The base version of this version of SBA supports image swapping for product that has one attribute... I've asked for feedback on it's functionality when using the multiple attribute option(s)... Again, technically you may be able to use your old stores versions of the template file and may also be able to use the old stores version of the dynamic dropdown classes. The version that is available for download of Dynamic Dropdowns though out-of-the-box does not work in it's entirety with SBA as written. It may just be the javascript side that is an issue, but when tested it did not function as written and is why an additional class was created written for this version in the event someone had written/rewritten the previous versions and continued to want to use them. Again trying to take the route of adding to the overall operation, not remove or be overly controlling. Maybe down the line different changes will be made, but it is still being developed with existing functionality to remain in place.
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Would it be easier if I PM you with access to the admins?
Thanks so much for your willingness to help! I have been pulling my hair out trying to figure this out! LOL
-
Re: Stock by Attribute v4.0 for Zen Cart 1.3.5
Hey guys, there are 101 and one pages in response to this thread so I can't page through all these to find my answer. I am trying to add the SQL patch (I guess?) and can't figure out what is going wrong. I'm trying to upload but keep getting this error:
Error Failed: 4
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table products_with_attributes_stock does not exist. CHECK PREFIXES!
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.
I'm using ZC v1.5.1 if that helps...