[Skip to main content](#vessel-content) # New shipping method ## - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 7 months ago - 2 years 7 months ago [\#359707](#359707) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#359707 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* was created by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* -- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks Last edit: 2 years 7 months ago by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 2 years 7 months ago [\#359709](#359709) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#359709 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* Hi, It's not possible to do it via the interfaces provided by HikaShop. What you can you can do is to run a MySQL query via your PHPMyAdmin. Something like this: Code: INSERT INTO #__hikashop_shipping_price (shipping_id, shipping_price_ref_id, shipping_price_ref_type, shipping_price_min_quantity, shipping_price_value, shipping_fee_value, shipping_blocked) SELECT XX, shipping_price_ref_id, shipping_price_ref_type, shipping_price_min_quantity, shipping_price_value, shipping_fee_value, shipping_blocked FROM #__hikashop_shipping_price WHERE shipping_id = YY AND shipping_blocked = 1 where #__ is to be replaced with your tables prefix, XX with the id of the new courier shipping method, and YY with the id of the home delivery shipping method. Note that this is not tested. I would recommend testing this first on a copy of the website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 7 months ago [\#360014](#360014) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") Replied by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360014 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* Just had time to try it...looks good for first sight. Thanks Would be a great feature in the future to do it with 1 click. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 6 months ago [\#360364](#360364) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") Replied by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360364 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* Can you help me with one more query? Or maybe two. So I have one more delivery method with id 21 which should be exactly the opposite of the id 2 delivery method. So where is id 2 blocked there will be id 21 available. If this helps, id 2 is blocked where the product custom field named "prescription" is set to "yes". Also I need to block the existing id 1 method for the same products where id 2 is blocked. At the moment I have a collect in person delivery method, which is payable with COD, wiretransfer or card, but I need to block the wiretransfer and card payments where prescription needed, but I didn't find any way for this just an another delivery method. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 2 years 6 months ago [\#360374](#360374) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360374 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* Hi, This should add the new shipping price rules to block the shipping method with the id 21 for the products which don't have a blocking shipping price rule for the shipping method with the id 2: Code: INSERT INTO #__hikashop_shipping_price (shipping_id, shipping_price_ref_id, shipping_price_ref_type, shipping_price_min_quantity, shipping_price_value, shipping_fee_value, shipping_blocked) SELECT 21, product_id, 'product', 1, 0, 0, 1 FROM #__hikashop_product WHERE product_id NOT IN (SELECT shipping_price_ref_id FROM #__hikashop_shipping_price WHERE shipping_id = 2 AND shipping_blocked = 1) As previously, note that this is not tested. I would recommend testing this first on a copy of the website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 6 months ago [\#360378](#360378) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") Replied by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360378 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* This one doesn't work unfortunately Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 2 years 6 months ago [\#360379](#360379) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360379 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* What error do you get ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 6 months ago [\#360384](#360384) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") Replied by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360384 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* No error, but it looks like it's not blocked/active where it should be Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 2 years 6 months ago [\#360386](#360386) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360386 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* Hi, Then, I don't know why it wouldn't work. It would require an access to the backend, and the PHPMyAdmin of the website. Also, please understand that we're outside normal user support here. If you want us to look into it, we'll have to charge for the time we spend. If you're interested, please go through our contact form : [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")** - [![Petike1007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12229-petike1007 "View Petike1007's Profile") Topic Author - [ Offline](/forum/user/12229-petike1007) Less More - Posts: 75 - Thank you received: 4 - - 2 years 6 months ago [\#360430](#360430) by [Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile") Replied by *[Petike1007](/forum/user/12229-petike1007 "View Petike1007's Profile")* on topic *[New shipping method](/forum/28-shipping-methods/907886-new-shipping-method#360430 "-- HikaShop version -- : 5.0.3 -- Joomla version -- : 5.0.2 I have 2 shipping methods at the moment: Both of them using the the Hikashop manual shipping method. One for collect in person, the other one is home delivery. There are some products which is not available for delivery, so we blocked the home delivery option for these products. Works great. Now I have to add one more courier option which will be exactly the same like the previouse home delivery option, just different price. How can I block this new courier option for the products where the original courier is blocked already? There are abou 1000 products where this option should be block and I don't want to block it one by one. Thanks")* I will try to have a look on a demo site first Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvOTA3ODg2LW5ldy1zaGlwcGluZy1tZXRob2Q/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.123 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)