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!