[Skip to main content](#vessel-content) # Do not show Free products ## - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 9 months ago [\#84766](#84766) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") *[Do not show Free products](/forum/4-how-to/77323-do-not-show-free-products#84766 "Hello, Is it possible without hard coding to disable showing of products where the price is 0.00 ? As our client does a 9000 item import and but some of them are their own references etc and therefore a price of 0.00. Now we do not want to show these. If not, can you tell me what files need modifying? Many thanks Tony")* was created by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* Hello, Is it possible without hard coding to disable showing of products where the price is 0.00 ? As our client does a 9000 item import and but some of them are their own references etc and therefore a price of 0.00. Now we do not want to show these. If not, can you tell me what files need modifying? Many thanks Tony Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3MzIzLWRvLW5vdC1zaG93LWZyZWUtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 9 months ago - 13 years 9 months ago [\#84804](#84804) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Do not show Free products](/forum/4-how-to/77323-do-not-show-free-products#84804 "Hello, Is it possible without hard coding to disable showing of products where the price is 0.00 ? As our client does a 9000 item import and but some of them are their own references etc and therefore a price of 0.00. Now we do not want to show these. If not, can you tell me what files need modifying? Many thanks Tony")* Hi Tony, My solution would be do it through your database with an SQL request where you'll unpublish all your free products. Hope this will help you. Last edit: 13 years 9 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3MzIzLWRvLW5vdC1zaG93LWZyZWUtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")** - [![mad-q's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4784-mad-q "View mad-q's Profile") - [ Offline](/forum/user/4784-mad-q) Less More - Posts: 234 - Thank you received: 4 - - 13 years 9 months ago [\#84808](#84808) by [mad-q](/forum/user/4784-mad-q "View mad-q's Profile") Replied by *[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")* on topic *[Do not show Free products](/forum/4-how-to/77323-do-not-show-free-products#84808 "Hello, Is it possible without hard coding to disable showing of products where the price is 0.00 ? As our client does a 9000 item import and but some of them are their own references etc and therefore a price of 0.00. Now we do not want to show these. If not, can you tell me what files need modifying? Many thanks Tony")* What I have done to find the correct column and formatting is to make a test product which meets the same criteria as the ones in the 9000 list, so Test Discription, £0.00, partnumber=001 and manually change it to not show on website. Then export this as an csv and it will show you the field name that makes the part not shown. Then going through the 9000 list make a new column with that same code in it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3MzIzLWRvLW5vdC1zaG93LWZyZWUtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")** - [![stephmor74's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12328-stephmor74 "View stephmor74's Profile") Topic Author - [ Offline](/forum/user/12328-stephmor74) Less More - Posts: 17 - Thank you received: 1 - - 13 years 9 months ago - 13 years 9 months ago [\#86609](#86609) by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile") Replied by *[stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile")* on topic *[Do not show Free products](/forum/4-how-to/77323-do-not-show-free-products#86609 "Hello, Is it possible without hard coding to disable showing of products where the price is 0.00 ? As our client does a 9000 item import and but some of them are their own references etc and therefore a price of 0.00. Now we do not want to show these. If not, can you tell me what files need modifying? Many thanks Tony")* Thanks guys, I was hoping I could do a template override and unset all free products from being listed. But instead, I created a MySQL Event to run every 3 minutes. That un-publishes all products where the price = 0. Regards Tony Last edit: 13 years 9 months ago by [stephmor74](/forum/user/12328-stephmor74 "View stephmor74's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc3MzIzLWRvLW5vdC1zaG93LWZyZWUtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.117 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)