[Skip to main content](#vessel-content)

#   Using Curso Filter on Retail Price

##

- **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")**
- [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author
- [ Offline](/forum/user/51903-karendunne)

Less More

- Posts: 112
- Thank you received: 7
-
-

8 years 11 months ago [\#283313](#283313) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile")  *[Using Curso Filter on Retail Price](/forum/45-filters-search/892943-using-curso-filter-on-retail-price#283313 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.0.21 -- Browser(s) name and version -- : Firefox  Hi there!! We are using Retail Price in our site instead of regular Price.  Is there a way to use the filter with Retail Price instead of with regular Pricing?  Thanks!! Carlos.")* was created by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")*

-- HikaShop version -- : 3.2.1
-- Joomla version -- : 3.8.2
-- PHP version -- : 7.0.21
-- Browser(s) name and version -- : Firefox

Hi there!!
We are using Retail Price in our site instead of regular Price.

Is there a way to use the filter with Retail Price instead of with regular Pricing?

Thanks!!
Carlos.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg5Mjk0My11c2luZy1jdXJzby1maWx0ZXItb24tcmV0YWlsLXByaWNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

8 years 11 months ago [\#283321](#283321) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Using Curso Filter on Retail Price](/forum/45-filters-search/892943-using-curso-filter-on-retail-price#283321 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.0.21 -- Browser(s) name and version -- : Firefox  Hi there!! We are using Retail Price in our site instead of regular Price.  Is there a way to use the filter with Retail Price instead of with regular Pricing?  Thanks!! Carlos.")*

Hi,

We didn't thought about that.
So there is no option to use the retail price in filters.
What you could do is use a custom product field instead of the retail price field.
You can even copy all the product_msrp to your custom field with a mass action if you have a lot of products to change.
Then, you can use the custom field in a filter.
That might require some adjusting on the product page but it will be way easier than trying to add the retail price to the filter system.

The following user(s) said Thank You: [karendunne](/forum/user/51903-karendunne "View karendunne's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg5Mjk0My11c2luZy1jdXJzby1maWx0ZXItb24tcmV0YWlsLXByaWNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")**
- [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author
- [ Offline](/forum/user/51903-karendunne)

Less More

- Posts: 112
- Thank you received: 7
-
-

8 years 11 months ago [\#283585](#283585) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile")  Replied by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* on topic *[Using Curso Filter on Retail Price](/forum/45-filters-search/892943-using-curso-filter-on-retail-price#283585 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.0.21 -- Browser(s) name and version -- : Firefox  Hi there!! We are using Retail Price in our site instead of regular Price.  Is there a way to use the filter with Retail Price instead of with regular Pricing?  Thanks!! Carlos.")*

Hi Nicolas,
thank you very much for your reply. I'm considering this approach and I would like to easily migrate the prices from retail price to this new field, but I cannot find where you store the relationship between products and fields (I was looking for a table called product_fields or similar). Can you please let me know were do you store fields values for each product?

Thank you!!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg5Mjk0My11c2luZy1jdXJzby1maWx0ZXItb24tcmV0YWlsLXByaWNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

8 years 11 months ago [\#283599](#283599) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Using Curso Filter on Retail Price](/forum/45-filters-search/892943-using-curso-filter-on-retail-price#283599 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.0.21 -- Browser(s) name and version -- : Firefox  Hi there!! We are using Retail Price in our site instead of regular Price.  Is there a way to use the filter with Retail Price instead of with regular Pricing?  Thanks!! Carlos.")*

Hi,

When you create a custom product field, a new column is added to the table hikashop_product. So the value is directly saved together with the product.
And you have the settings of the fields in the hikashop_field table.

The following user(s) said Thank You: [karendunne](/forum/user/51903-karendunne "View karendunne's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg5Mjk0My11c2luZy1jdXJzby1maWx0ZXItb24tcmV0YWlsLXByaWNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")**
- [![karendunne's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/51903-karendunne "View karendunne's Profile") Topic Author
- [ Offline](/forum/user/51903-karendunne)

Less More

- Posts: 112
- Thank you received: 7
-
-

8 years 11 months ago [\#283748](#283748) by [karendunne](/forum/user/51903-karendunne "View karendunne's Profile")  Replied by *[karendunne](/forum/user/51903-karendunne "View karendunne's Profile")* on topic *[Using Curso Filter on Retail Price](/forum/45-filters-search/892943-using-curso-filter-on-retail-price#283748 "-- HikaShop version -- : 3.2.1 -- Joomla version -- : 3.8.2 -- PHP version -- : 7.0.21 -- Browser(s) name and version -- : Firefox  Hi there!! We are using Retail Price in our site instead of regular Price.  Is there a way to use the filter with Retail Price instead of with regular Pricing?  Thanks!! Carlos.")*

Great!! that made the query even easier!!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg5Mjk0My11c2luZy1jdXJzby1maWx0ZXItb24tcmV0YWlsLXByaWNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.067 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
