Free shipping image help required.....

[sexantics]

Anyone know of a way to show the free-shipping-icon on any product over x amount? (obviously without going through each individual product as ther is over 3000 products in my cart)

[balihr]

admin->Tools->Install SQL Patches

UPDATE `products` SET `product_is_always_free_shipping` = '1' WHERE `products`.`products_price` >150;

Of course, you need to set your own price (marked in red). Keep in mind this is price without tax. You might also need to enable Free Shipping module (freeshipper) and enable the icon to display (admin->Catalog->Product Types->Product-General->Edit Layout->Product Free Shipping Image Status - Catalog->Yes.

Make sure you BACKUP your database before running this SQL statement!!!

[Ajeh]

Be careful ... are you wanting to make these Products actually Always Free Shipping for *everyone* or just "show" the Free Shipping icon for these Products?

[balihr]

Uhm, Linda, now you got me confused...

Since the OP stated

without going through each individual product

I assumed that the requirement was what I described because - what else can you do from admin by going through each individual product?

And, what's the difference? The question was "If a product is over x amount" and not cart total or anything else meaning that the OP wants that product to always have free shipping, no matter what other settings.

Or am I missing something obvious here?

[Ajeh]

The difference is ... is the OP settings other conditions to make the Free Shipping that are not related to Always Free Shipping ...

As I was not sure, that is why I posted that to ensure that the OP asking actually means, they are trying to mark all Products over a certain amount to be Always Free Shipping for everyone ...

[sexantics]

Perfect.......thank you both. I already set the free shipping on all orders over £30 so I wanted to set free shipping on all individual products over £30 - the logic being if someone purchases anything over £30 then they get free shipping anyway.

Sql worked perfect - just wondering if everytime I update the stock through my xml feed I may have to run the statement again?