Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 313 subscribers
  • Views 1780 views
  • Users 0 members are here
Related content from around SugarClub

Product Bundles changing order on Quotes

Brady Clark

Hi all,

Intermittently, Product Bundles appear to be changing the order in which they are displayed on the quote. After doing some digging I have determined the cause of this is on the quotes in question the bundle_index field is the same for multiple records of the same quote_id in the product_bundle_quote table. 

Has anybody come across this before? It only seems to be happening to a small percentage of quotes but this appears to be happening on multiple sites.

Thanks

Brady

Parents
  • 0

    Hi Andre,

    Not on a consistent manner no, it seems sporadic. The 3 with 0 were on a test site but it is not always 0. If you see in the second screenshot there are two 12s. 

    I have had a look at the teams thought, but unfortunately all of the products on the sites have global team only. 

    The sugar bug quoted is one I have reported previously and appears to still have a few issues. However that is separate so I won't go into details with that on this post. I can confirm though it is not what I am raising here (We are on 12.0.3)

    I have written a script to fix bundles that have this issue so we can at least provide customers with a temporary fix for now

    Thanks

    Brady

  • 0 Sugar Employee Badge in reply to Brady Clark

    HI , 

    Are all the QLI's being created via graphic user interface ? or do you have any other processes creating QLI's ? 
    import, scheduler, integration? 

    Maybe would be good to have a look if the issue is for a specific create action. 

Reply Children
  • 0 in reply to Andre Serrazina

    Hi Andre,

    All created via the front end on quotes. I have done some testing in various scenarios on our non customised test site and have managed to create both the duplicate 0 scenario and a duplicate of a certain number 

    If I create a quote and save, then start adding groups in edit mode, the following happens:

    If I add 4 groups without adding any products - it all works correctly and I end up with 0,1,2,3 as indexes. However if I then add a product to the quote and then create another group, I end up with 0,1,2,3,3

    If I add a product first and then add 4 bundles, I end up with 0,0,0,0

    If I create a quote and add groups in create mode then the following happens:

    Regardless of if I have a product or not the product bundles in Create mode assign the indexes 0,1,3,6,10

    Almost like instead of assigning the next increment up it is adding what the increment should be to the existing number. 

    Having found all this the pessimist in me assumes this might be something specific to our sites. However if you are able to recreate any of the above I will be very happy Smiley

    Thanks

    Brady