shipping method restrictions for products

-- url of the page with the problem --
-- HikaShop version -- : 3.2.0
-- Joomla version -- : 3.8
-- PHP version -- : 7

Hi Hikashop Team,

My client have different products in their webshop and they sent only to their own country (Netherlands) and Germany. But some of the product categories may not shipped to Germany. How can we prevent these products from being shipped to Germany. But unfortunately
I see no restrictions in the manual shipping methods for products or product categories.

Is there another way we can handle this?

Hope to hear from you.

Kind regards,
Lumiga

P.S. It would be nice if we could have such a sort of options like Woocommerce where product categories and product classes would be very helpful or the Product-level Rules. See:
https://docs.woocommerce.com/document/woocommerce-conditional-shipping-and-payments/#section-9

Thanks Nicolas,

But that's a lot of work to block 7 shipping methods for every product characteristic.
That's more than 2.000 clicks for me.

So I was looking for the Mass Actions and hoped that it will help to do this job for me.
But I can't find a table where this is stored in the database. Also when I do an export from a product with several shipping prices blocked I can't find the table either.

Hope you can give me a hint to find out how to automate this for all products in certain categories.

Kind regards,
Lumiga

Thanks Nicolas,

I will try to do the CSV trick

You don't need to do it for each variant of a product. You can do it for the main product and it will apply to all the variants of the product.

Hi,

Same issue here, tried to change this code in helper.php. Didn't work, there seems to be a codeproblem, the site freezes in step 3.

kind regards,
Michel

Hi Jerome,

Well, I changed the code:

$product_ids = array_keys($shipping_price->products);
JArrayHelper::toInteger($product_ids);
to:
$product_ids = array();
foreach($shipping_price->products as $product){
$product_ids[] = (int)$product->product_id;
}

as Nicolas suggested in the file helper.php. There must be an error in the code as the screen turns blank on the checkoutstep where the shippingmethod is presented. Obviously I restored the code to have the site work properly. URL therefore is not usefull, as the helper.php file is again the original one.

Joomla 3.8.1
Hikashop 3.2.0
PHP 7.0

Hi,

Sorry, but the code from Nicolas doesn't fixed the issue. I still have to do all the variants one by one after I set the main product.

I get no freezes or errors like michelpouli when I walk through the checkout process.

Kind regards,
Lumiga

Hi Jerome,

Yes this seems to work. But now there's a warningmessage: "There are items in your shoppingcart that can't be shipped to you."

And there's one more thing: I have a paymentmethods connected to the shippingmethods and they still show when the shippingmethod doesn't.

Hello,

In that case, we'll need more information through some screenshots for example about how you configured your :
- Products
- Shipping method(s)
- Payment method(s)

Hi Jerome,

I changed this code in the file administrator/components/com_hikashop/helpers/helper.php

$product_ids = array_keys($shipping_price->products);
				JArrayHelper::toInteger($product_ids);

foreach($order->shipping_prices as $key => $shipping_price) {
	if(empty($shipping_price->price_per_product) || empty($shipping_price->products))
		continue;

	$shipping_ids = array_keys($shipping_price->price_per_product);
	JArrayHelper::toInteger($shipping_ids);

	$product_ids = array_keys($shipping_price->products);
	$query = 'SELECT a.shipping_id, a.shipping_price_ref_id as `ref_id`, a.shipping_price_min_quantity as `min_quantity`, a.shipping_price_value as `price`, a.shipping_fee_value as `fee` '.
		' FROM ' . hikashop_table('shipping_price') . ' AS a '.
		' WHERE a.shipping_id IN (' . implode(',', $shipping_ids) . ') '.
		' AND a.shipping_price_ref_id IN (' . implode(',', $product_ids) . ') AND a.shipping_price_ref_type = \'product\' '.
		' ORDER BY a.shipping_id, a.shipping_price_ref_id, a.shipping_price_min_quantity';
	$db = JFactory::getDBO();
	$db->setQuery($query);
	$ret = $db->loadObjectList();
	if(empty($ret))
		continue;

	$products_qty = $shipping_price->products;
	foreach($order->products as $ordered_product) {
		if($ordered_product->product_parent_id == 0)
			continue;
		foreach($ret as $ship) {
			if($ordered_product->product_id == $ship->ref_id) {
				$products_qty[ (int)$ordered_product->product_parent_id ] -= $products_qty[ (int)$ordered_product->product_id ];
			}
		}
	}
	foreach($ret as $ship) {
		if($products_qty[$ship->ref_id] > 0 && $ship->min_quantity <= $products_qty[$ship->ref_id]) {
			$order->shipping_prices[$key]->price_per_product[$ship->shipping_id]['products'][$ship->ref_id] = ($ship->price * $products_qty[$ship->ref_id]) + $ship->fee;
		}
	}
	unset($products_qty);
}