List Products that have free shipping or set shipping amounts

General
1

I cannot find a way to list those products in my store that have free shipping or a set shipping amount.
We are having an Australia Post price rise, and I need to alter the price of the product or the shipping amount for these products.

Thank you
Juanita

2

For free shipping you can use:
?dispatch=products.manage&free_shipping=Y

I don’t know how you have set shipping amounts set up so I am not sure.

1 Like
3

Thank you so much
Kind Regards
Juanita

4

I use the australia post real time shipping method so it updates automatically. However to answer your question …

if you have set the “shipping freight” field on the product tab then the easiest way would be do a sql back-end e.g. to display products set at $10 do the following


SELECT `product_id`,`product_code`,`status` FROM `cscart_products` WHERE `shipping_freight` = 10

if you want to do a range or similar just feed example above into chatgpt and ask it to modify it to give whatever range you want.

5

Thank you chickentwisty
Unfortunately I cannot use the real time shipping method, 99% of the time people do not just take one item and everything is a different size and weight and with 1000’s of products it makes real time a nightmare.