How to Configure Free Shipping for Products in Bulk in nopCommerce

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.


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.



Go to your nopCommerce site database and run a SQL query like this

UPDATE Product
SET IsFreeShipping='0'

(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


UPDATE Product
SET IsFreeShipping='0'
WHERE Name = 'Canon Digital SLR Camera'

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!

Tags: , , , , , , , , , , | Posted under nopCommerce | RSS 2.0

Author Spotlight

Lavish Kumar

Founder, developer and owner of - By profession, he is a software programmer / web developer, web designer & DBA. He is passionate about technology and electronic gadgets. He enjoys writing tech articles and developing web applications. He is a nopCommerce MVP and author of official nopCommerce Designer's Guide.

Leave a Reply

Your email address will not be published. Required fields are marked *