The manual process can be a quite tedious to configure free shipping for all products by going to each product page in admin section one by one. nopCommerce does offer a functionality by which you can update a list of products (at once) for free shipping.
Another way to achieve this is by using sql script. Today, we will discuss both of these options.
Option#1
You can simply go to Administration section > Catalog > Products Manage Products
Here, you can export your products in excel file and simply change the column value "IsFreeShipping" to "True" or "False" accordingly and import it back.
Option#2
Go to your nopCommerce site database and run a SQL query like this
Go to your nopCommerce site database and run a SQL query like this
UPDATE ProductSET IsFreeShipping='0'WHERE ID > 20(Here ID is the product id in the Product table)
Note: In the above query, I am only showing how your query should look like in regard to column names. The where condition needs to be changed according to your requirements.
It could be like this also:
UPDATE ProductSET IsFreeShipping='0'WHERE ProductTypeID = 5OR
UPDATE ProductSET IsFreeShipping='0'WHERE Name = 'Canon Digital SLR Camera'IsFreeShipping
0 = False (not free shipping)
1 = True (free shipping)
Table Name: Product
(Make sure you take backup before making any direct changes to the database)
Hope it helps :)
