Really trying to help here. Not just to get through this one time "fix" but to make things easier for the future.
Note that if the existing convention of applying sort order as an integer was used, then wouldn't be trying to find the code change to support a decimal value. As far as existing values, they could all be updated to such a new numbering scheme by the following sql:
Code:
UPDATE products SET products_sort_order = products_sort_order * 100;
This would retain the existing sort order results and assuming that all previous entries had at most 2 decimal places, then they would have become integers.
Anything "uniquely" written to handle the sort order can be modified to divide by the same 100. Considering that code is outside the normal Zen Cart code, in future upgrades, it could be carried over as necessary to retain operation and the core ZC code and database setup need not be updated/modified.
Bookmarks