Mass Block Products From Shipping Types Using PPP

PPP = Price per product

I have 250 products that I want to block from some shipping methods. I have enabled the price per product in the shipping methods, and I can successfully is this to block shipping.

Is there a way, say using the mass actions, to be able to block these products from shipping methods or could you tell me what table this information is stored in please? This is so I don't have to go through all the 250 products maulally.

Thanks

Hi,

There is no way of doing that via the mass actions, but via a MySQL request it is possible.
The table in question is "#__hikashop_shipping_price", so you can fill it with the correct values, to set "blocked" your have to set "shipping_price_value" and "shipping_fee_value" to "-1".

Thanks so is shipping_ref_id the id of the product?