[Skip to main content](#vessel-content) # mySQL Query for Block Products ## - **[eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile")** - [![eileensemporium's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37550-eileensemporium "View eileensemporium's Profile") Topic Author - [ Offline](/forum/user/37550-eileensemporium) Less More - Posts: 54 - Thank you received: 0 - - 9 years 8 months ago [\#263938](#263938) by [eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile") *[mySQL Query for Block Products](/forum/28-shipping-methods/889152-mysql-query-for-block-products#263938 "-- HikaShop version -- : HikaShop Business 2.6.4 [1610121552] -- Joomla version -- : 3.6.5 -- PHP version -- : 5.4 I would like to be able to get all the products that are blocked from shipping using the price per product to block certain products....(as my customer wants to know and I want to export using Navicat to a csv for him) I assume that it is in the #__hikashop_shipping.shipping_params field But I don't know what the parameters for products that have blocked shipping methods would be/look like Thanks")* was created by *[eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile")* -- HikaShop version -- : HikaShop Business 2.6.4 [1610121552] -- Joomla version -- : 3.6.5 -- PHP version -- : 5.4 I would like to be able to get all the products that are blocked from shipping using the price per product to block certain products....(as my customer wants to know and I want to export using Navicat to a csv for him) I assume that it is in the #__hikashop_shipping.shipping_params field But I don't know what the parameters for products that have blocked shipping methods would be/look like Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODg5MTUyLW15c3FsLXF1ZXJ5LWZvci1ibG9jay1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile")** - [![eileensemporium's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37550-eileensemporium "View eileensemporium's Profile") Topic Author - [ Offline](/forum/user/37550-eileensemporium) Less More - Posts: 54 - Thank you received: 0 - - 9 years 8 months ago [\#263945](#263945) by [eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile") Replied by *[eileensemporium](/forum/user/37550-eileensemporium "View eileensemporium's Profile")* on topic *[mySQL Query for Block Products](/forum/28-shipping-methods/889152-mysql-query-for-block-products#263945 "-- HikaShop version -- : HikaShop Business 2.6.4 [1610121552] -- Joomla version -- : 3.6.5 -- PHP version -- : 5.4 I would like to be able to get all the products that are blocked from shipping using the price per product to block certain products....(as my customer wants to know and I want to export using Navicat to a csv for him) I assume that it is in the #__hikashop_shipping.shipping_params field But I don't know what the parameters for products that have blocked shipping methods would be/look like Thanks")* Actually is it any product that has the parameters setup in its linked shipping table? Or is it more complicated than that? This is what I'm running Code: SELECT jos_hikashop_product.product_name, jos_hikashop_shipping.shipping_name, jos_hikashop_product.product_code FROM jos_hikashop_shipping_price INNER JOIN jos_hikashop_product ON jos_hikashop_product.product_id = jos_hikashop_shipping_price.shipping_price_ref_id INNER JOIN jos_hikashop_shipping ON jos_hikashop_shipping.shipping_id = jos_hikashop_shipping_price.shipping_id ORDER BY product_code Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODg5MTUyLW15c3FsLXF1ZXJ5LWZvci1ibG9jay1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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: 86359 - Thank you received: 14296 - - 9 years 8 months ago [\#263949](#263949) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[mySQL Query for Block Products](/forum/28-shipping-methods/889152-mysql-query-for-block-products#263949 "-- HikaShop version -- : HikaShop Business 2.6.4 [1610121552] -- Joomla version -- : 3.6.5 -- PHP version -- : 5.4 I would like to be able to get all the products that are blocked from shipping using the price per product to block certain products....(as my customer wants to know and I want to export using Navicat to a csv for him) I assume that it is in the #__hikashop_shipping.shipping_params field But I don't know what the parameters for products that have blocked shipping methods would be/look like Thanks")* Hi, Yes, something like that should do so that you don't take into account the shipping price entries that are only to set a shipping price per product and not to block product shipping: Code: SELECT jos_hikashop_product.product_name, jos_hikashop_shipping.shipping_name, jos_hikashop_product.product_code FROM jos_hikashop_shipping_price INNER JOIN jos_hikashop_product ON jos_hikashop_product.product_id = jos_hikashop_shipping_price.shipping_price_ref_id INNER JOIN jos_hikashop_shipping ON jos_hikashop_shipping.shipping_id = jos_hikashop_shipping_price.shipping_id WHERE jos_hikashop_shipping_price.shipping_price_value = -1 OR jos_hikashop_shipping_price.shipping_fee_value = -1 ORDER BY product_code Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODg5MTUyLW15c3FsLXF1ZXJ5LWZvci1ibG9jay1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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.045 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)