Joomla Extensions Club 20,483 posts

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1031628

Hello,

I created a custom field for the price.

But when I want to filter on the price it does not work because
I have informed all my prices in this way : 1 000.

It works if I do not separate: 1000.

Do you have a trick to fix this and to avoid redo all the prices
of my online catalog (made with K2)

Thank you

[thesdhotel Friend thesdhotelJoin date: March 2017Posts: 90Downloads:25Uploads:1 Thanks: 31 Thanked: 22 times in 20 posts]

#1031672

You can do a search-replace in the database for the mysql column where the price is, where you replace ‘ ‘ with ” (with nothing). So all space separators are removed in one step.

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1031673

Can not be done in a K2 database

And it is a shame that the filter does not recognize a digit with separator. It’s more elegant

See my screenshot

---

Attachments:

1. 

[thesdhotel Friend thesdhotelJoin date: March 2017Posts: 90Downloads:25Uploads:1 Thanks: 31 Thanked: 22 times in 20 posts]

#1031676

Ah that sucks. I’m sure the JoomlArt guys can do something and implement a way to ignore spaces

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1031682

ça y est j’ai trouvé mais je n’arrive pas à régler ça.
(google translate)

See my screenshot

---

Attachments:

1. 

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#1031907

Hi,

Try go to backend >> Component >> JA K2 Filter >> Option >> Search Configuration >> Part Extra Field Values Sorting Mode >> Find for the Extra Field for Price change option value to Numberic.

If it doesn’t work, share your site URL here, so I check it further.

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1032961

Hello,

It’s hard to explain because I do not speak English (google translate).

I have set everything in the poster of the numbers of JA K2 Filter, that’s good.

My problem is that I have entered all the prices of my catalog this way:

4246,80 the filter works

4 246,80 € I want this display in my product listings but the filter no longer works
Is it possible to have this display and the filter works?

thank you

See my screenshot

---

Attachments:

1. 

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1033146

Hi,
I noticed that when you fill in the fields:

Ex:
1 500,50 € with space and the symbol € it does not work

On the other hand if I inform in this way:
$ 1500.50 it works!

So your application does not like € and the space between 1 and 500.50

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1033526

Hi,

By purchasing this module, I thought I had a support.
There for a simple question, I have been blocked for a week.

Could I have a simple answer: yes or no to my last question?

Thank you

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#1033637

Hi,
Our developer is checking your issue. At this time, JA K2 filter doesn’t support for space in number.
We’re try to find a solution for your issue, will anwser you in next few days.

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1033644

Hi,

thank you
But the character € is not supported either, while $ is accepted.
"Kw" also, it is therefore the special European character that is not recognized.
I think it’s just an oversight.

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1036944

Hi,

15 days and still no answer?

I started my project with your filter more than 3 months ago and I still can not put it into production !!!

Your filter again behaves strangely:
When a filter is selected, the page drops down for no reason.
When I want to select a second filter I am forced to go up in order to select it, and the page goes down again … so on …

I regroup my worries on this mail because your answers are too long …
I use joomshaper Helix and SP Builder Pro and I hesitate to migrate your templates and page constructor because at home the support is fast and there is less problem.

thank you

Abdel

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1037183

Hi.

The problem relates to the currency symbol, the team has plan to update to new version but still not found the best solution for it yet. About the problem on your site, you can post your db and dev team would convert your currency to one would work.

For the strange behaviour, it’s because the ajax filter and auto filter is ON. So it’s auto filter and scroll to the results after you choose an option.

[adjaout Friend adjaoutJoin date: February 2017Posts: 21Downloads:81Uploads:7 Thanks: 2 Thanked: 2 times in 2 posts]

#1037262

Hello

thank you for your reply.

The translation is very hard. I do not understand your solution or what I need to do to replace $ by €.

thank you

Abdel

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1037614

Hi,

It’s not because the currency symbol cause the error.

It due to the white space between numbers instead as number has never had white space between them.

I’ll remove all the white space so it could function normally.

[Author]

Posts