New shipping method

  • Posts: 63
  • Thank you received: 2
1 month 3 days ago #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

Last edit: 1 month 3 days ago by Petike1007.

Please Log in or Create an account to join the conversation.

  • Posts: 81428
  • Thank you received: 13058
  • MODERATOR
1 month 3 days ago #359709

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:

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 or Create an account to join the conversation.

  • Posts: 63
  • Thank you received: 2
2 weeks 6 days ago #360014

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.042 seconds
Powered by Kunena Forum