"Sorting and filtering B2B prices" (#3356960) / KingsPlugins

5 Tickets 5

Dimitris started the conversation 3 years ago on April 26, 2023 at 10:13am

Hello, this is the first time I use your plugin and I have a question about sorting and filtering the products, when a product's price is different for a specific group.

In my following example, I have set a different price for a specific B2B group -> https://prnt.sc/X9foiqBuePoK

Sorting

When I sort the list by price, then the product stays in the previous position, using the old price for sorting -> https://prnt.sc/NSz1W0IhGJXL

Filter by Price

1. Old price is used also for filtering. I selected to see the price range from 135 to 178, and the product appears, even if the price for this user group is 80. -> https://prnt.sc/mnfueM8PVvUM

2. If I use a tax examption rule to show the prices exVat only for this specific group ( https://prnt.sc/X3E-8z2rqu51 ), then the price filter still shows the incVat prices -> https://prnt.sc/Gn94DX5-kkzF and filters according to regular incVat price

Is there a solution for this? Or it is impossible to make this work for B2B prices? Especially the problem n.1 makes the price filter and sorting useless for all B2B clients

Thank you

2,762

KingsPlugins replied 3 years ago on April 27, 2023 at 10:04pm

Hi Dimitris,

We have looked into this in-depth in the past, but unfortunately we did not find any way to achieve this technically (to make custom prices be applied to filters).

Technically these filters use WooCommerce lookup tables in the database, and these have no way to be 'filtered' by plugins.

We even tried looking at other role-based pricing / wholesale pricing plugins to see if any of them can apply it to filters, but we did not see any. If you know of any plugin that can do this, feel free to let us know which one and I'd be happy to look into it - we'd love to add this feature if there's a way to do it.

Kind regards,

Stefan