Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Jul 2012
    Posts
    14,475
    Plugin Contributions
    17

    Default Re: Problem with decimal places in Sort Order field

    Would suggest reverting the admin/includes/modules/update_product.php file back to what it was before trying to make these changes which may involve also restoring admin/includes/modules/product/collect_info.php and/or admin/includes/modules/product/preview_info.php.

    The data stored into the database is affected by files such as these during the storage process. May want to also access the database more directly via phpMyAdmin and review products table record information to see what the sort orders are. The field type could have been left at least temporarily as a decimal considering the software was still storing as an integer. But if there were edits made causing the continuous storage of 656.00 that was a difference occurring that should have had nothing to do with changing from an integer to a decimal number... of course there is little detail about what was really done, so hard to explain what needs to be undone. The multiplication sql only needed to be run one time to address all product in the database.
    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

  2. #12
    Join Date
    Oct 2019
    Location
    UK
    Posts
    17
    Plugin Contributions
    0

    Default Re: Problem with decimal places in Sort Order field

    Quote Originally Posted by mc12345678 View Post
    Would suggest reverting the admin/includes/modules/update_product.php file back to what it was before trying to make these changes which may involve also restoring admin/includes/modules/product/collect_info.php and/or admin/includes/modules/product/preview_info.php.

    The data stored into the database is affected by files such as these during the storage process. May want to also access the database more directly via phpMyAdmin and review products table record information to see what the sort orders are. The field type could have been left at least temporarily as a decimal considering the software was still storing as an integer. But if there were edits made causing the continuous storage of 656.00 that was a difference occurring that should have had nothing to do with changing from an integer to a decimal number... of course there is little detail about what was really done, so hard to explain what needs to be undone. The multiplication sql only needed to be run one time to address all product in the database.
    I've come to the same conclusion so taking it forward I am going to create a new copy of v151 in a separate folder so that it is a clean system then copy over the admin config file adjusting to where the new console sits and use the base system to test that we can write the correct value to the database. If that goes well then I can reset the original admin files only making the required layout adjustments.

    Thanks again for all your advice - will let you know how it all goes

  3. #13
    Join Date
    Oct 2019
    Location
    UK
    Posts
    17
    Plugin Contributions
    0

    Default Re: Problem with decimal places in Sort Order field

    Quote Originally Posted by OwenB View Post
    I've come to the same conclusion so taking it forward I am going to create a new copy of v151 in a separate folder so that it is a clean system then copy over the admin config file adjusting to where the new console sits and use the base system to test that we can write the correct value to the database. If that goes well then I can reset the original admin files only making the required layout adjustments.

    Thanks again for all your advice - will let you know how it all goes
    No idea what I have done other than reinstall collect_info.php but whole numbers 100,200 etc appear as 1,2 in the library and 50, 75 appear as 0.5 and 0.75!!!!
    #
    Thanks guys for your time and patience

  4. #14
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,638
    Plugin Contributions
    260

    Default Re: Problem with decimal places in Sort Order field

    sounds like you should:
    a) Make a backup.
    b) multiply these numbers * 100
    c) convert the field back to an integer.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Currency Setting of Decimal Places vs pricing to 5 decimal places?
    By GoldBuckle in forum Customization from the Admin
    Replies: 0
    Last Post: 20 Aug 2013, 05:16 PM
  2. v150 Confirmation Email Order Total displaying three decimal places
    By PMguy2004 in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 14 Sep 2012, 07:50 PM
  3. Decimal Places
    By fredmccay in forum Basic Configuration
    Replies: 0
    Last Post: 27 Jan 2011, 03:19 AM
  4. Decimal Places
    By Davx in forum Customization from the Admin
    Replies: 2
    Last Post: 20 Apr 2010, 04:36 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