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.

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.

nopexportimportfreeshipping

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!

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

Author Spotlight

Lavish Kumar

Founder, developer and owner of StrivingProgrammers.com - 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 *