Can I set all products "Always Free Shipping"?
Hey Guys,
I want to set all products "Always Free Shipping" but it seems I need to edit these products one by one.
Is there any way to complete it all?
I've google it, and I followed one of the instruction:
In my zen cart admin go to Tools -> Install SQL Patches
Copy and pate the sql code with my added category ID number into the box and click on the “send” button.
"UPDATE products SET product_is_always_free_shipping = 1 WHERE master_categories_id = xx;"
But it NOT working for me. Anybody has better idea?
Thanks a lot!
Re: How to set all products "Always Free Shipping"?
If you want ALL Products to be Always Free Shipping, use:
Code:
UPDATE products SET product_is_always_free_shipping = 1;
Re: How to set all products "Always Free Shipping"?
Quote:
Originally Posted by
Ajeh
If you want ALL Products to be Always Free Shipping, use:
Code:
UPDATE products SET product_is_always_free_shipping = 1;
Cool, that works.
Thank you very much.
But what's wrong with previous code? What if I want only one category "Free Shipping"?
Maybe I just need to change the category number?
Re: Can I set all products "Always Free Shipping"?
You needed to change the code for each master_categories_id ... but since you wanted ALL Products changed, you did not need the WHERE statement on it ... :smile:
Thanks for the update that this worked for you ...
Re: How to set all products "Always Free Shipping"?
Quote:
Originally Posted by
Ajeh
If you want ALL Products to be Always Free Shipping, use:
Code:
UPDATE products SET product_is_always_free_shipping = 1;
Where do I put this line of code?
Re: How to set all products "Always Free Shipping"?
Go to the Tools ... Install SQL Patches ... and paste that in there and hit SEND ...