Problem with decimal places in Sort Order field

[OwenB]

Hi

I need to be able to store numbers with decimal places in the Sort Order field for products (this will also be the case with the V1.5.6 system we are currently modifying).

I have ensured that the field in the database can store numbers to decimal places.

Our situation is that a book series can have books that rung (for instance): 1, 1.5, 1.75, 2 etc,

Please can some one advise how I may achieve this.

At the moment if we enter 1.5 then it is stored as 1.00

Thanks in advance

[mc12345678]

Doesn't directly answer the question, but why not use say multiples of 100 or some value that will ensure all the decimals are addressed?

[OwenB]

I did have this working once before our server crashed so I'm guessing it is the same route as adding product prices? Just cannot get my head round it at the moment!!!!

[swguy]

The sort order field is an integer field. Even if you modified the database to make them decimal, the software still converts them to integer before storing them. You're way better off to follow @MC's advice and multiply by 100 so you can use integer values.

[OwenB]

The sort order field is an integer field. Even if you modified the database to make them decimal, the software still converts them to integer before storing them. You're way better off to follow @MC's advice and multiply by 100 so you can use integer values.

I have changed the sort order field to decimal (15,2)

[OwenB]

How do the product prices get stored as decimal places please?

[mc12345678]

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:

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.

[OwenB]

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:

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.

OK thanks .. I will try that out with v.1.5.6. Because we managed it somehow previously we do have sot orders stored as 2.50 etc so this change may screw a little with what we have already done but can be fixed as the point 5 books are few and far between

[OwenB]

I did try to replicate the way that prices are handled in update_product.php but no matter what you enter returns as 656.00 !!!!!

[OwenB]

I did try to replicate the way that prices are handled in update_product.php but no matter what you enter returns as 656.00 !!!!!

I have performed the * 100 update to the database and reset it to Integer but when I edit a record it saves as '0'. Obviously something wrong now in the Admin console????