Page 306 of 306 FirstFirst ... 206256296304305306
Results 3,051 to 3,053 of 3053
  1. #3051
    Join Date
    Nov 2011
    Location
    Brisbane, Australia
    Posts
    19
    Plugin Contributions
    0

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

    Excellent! Yes, the above worked. There were also some problems when doing Admin creations of products and I'll need to test that as well. But thanks very much for the below. Really looking forward to this module becoming more permanent in future ZenCart releases... it always makes me nervous at upgrade and patching time!

    Quote Originally Posted by mc12345678 View Post
    I can confirm that setting the db mode to ONLY_FULL_GROUP_BY and incorporating the above modification fixes that issue. Please let me know if other such issues arise so that they may be addressed.

    As to the complexity of the query, well, some of that is because of how the SBA table has more information in a field than it should for trying to have a normalized database. There is a plan to split the data out a little more but is a bit of an overhaul of the underlying system.

  2. #3052
    Join Date
    Jan 2014
    Posts
    148
    Plugin Contributions
    0

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

    So a new puzzle. I have some of my decals that are family. SO I need to use SBA for picking the vinyl color, but then non SBA attributes for picking family members. When I add that attribute they are coming in as SBA How do I keep them out of SBA.

  3. #3053
    Join Date
    Jul 2012
    Posts
    13,099
    Plugin Contributions
    16

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

    Quote Originally Posted by cubmanky View Post
    So a new puzzle. I have some of my decals that are family. SO I need to use SBA for picking the vinyl color, but then non SBA attributes for picking family members. When I add that attribute they are coming in as SBA How do I keep them out of SBA.
    I think I somewhat understand what is desired, but I don't understand what problem is being seen.

    What I understand is that there are two attributes with the product:
    Stock dependent color
    Non-stock dependent "person"

    The attributes associated with the person should be added to the non-stock table.
    The colors should be assigned stock quantities.
    If not mistaken that is all that is needed to then support selecting each of the options and stock getting reduced for the vinyl/color. Right now, I very well could be mistaken.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

 

 

Similar Threads

  1. Problems with addon: Dynamic Drop Downs for Stock By Attribute
    By Dunk in forum All Other Contributions/Addons
    Replies: 56
    Last Post: 30 Apr 2014, 07:55 PM
  2. MySQL Problem with Product with Attribute Stock addon
    By rtwingfield in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 20 Sep 2011, 03:35 PM
  3. Hide Zero Quantity Attributes with attribute-stock addon
    By leevil123 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 11 Feb 2010, 05:06 PM
  4. Replies: 4
    Last Post: 22 Jan 2010, 10:43 PM
  5. Price Products in the grid by 'Stock by Attribute' addon?
    By Salixia in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 27 Oct 2009, 06:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR