Several times, I have seen many nopCommerce users asking this question on the forums i.e. How to configure free shipping for products in bulk?

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

UPDATE Product
SET 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 Product
SET IsFreeShipping='0'
WHERE ProductTypeID = 5

OR

UPDATE Product
SET 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)

Looking for quality nopCommerce Web Hosting? Look no further than Arvixe Web Hosting!