ACF text field with prices filter

Anonymous

#274954

Hi there,

On a website we use an ACF text field where product prices are added in the following format: 1.000 (1000 euro’s with a dot as thousands separator).

This field is added to the filter as a range – slider input type, but search and filter doesn’t auto detect the right min-max values and i cannot figure out why that happens. Also when i put the slider on specific from/to values, it doesn’t filter properly. Can you help us out with this issue?

Anonymous

#274955

This reply has been marked as private.

Trevor

#274958

With a dot in the data (as the thousands separator), it will be seen as a decimal point, so 1.000 will actually be seen as 1. You must not use the dot for a thousands separator for data storage. You can format data when displaying it to add that separator instead.

If you had 1.000.10 it would be seen as a text string, and thus not searchable as a number at all.

Maybe this is the problem?

Anonymous

#275032

This reply has been marked as private.

Trevor

#275036

Thanks for getting back to me. I will close this thread for now.

[Author]

Posts