Blog posts tagged with 'sql query'

In this article, you will learn about some more time-saving nopCommerce SQL query snippets you wish you knew earlier.
I hope you got some good usage out of my 1st installment of "Time-saving nopCommerce SQL query snippets you wish you knew earlier" series. In case you missed it, you can find the "Part -1"  of this series HERE.

nopCommerce is driven by Microsoft SQL database and every single scrap of information is stored in that SQL database. Information like products, orders, customers, plugins, blog posts, comments, product reviews, pages etc; everything is stored in that SQL database.

Sometimes you may need a quick fix for a specific problem or need to change some information (or data) across the board in nopCommerce. When you are dealing with a ton of information (or data), it is not feasible to go through each and every record because it can be a very tedious process. By running a few SQL queries against your nopCommerce database, you can easily make necessary changes without any kind of manual effort.

In this article, we will go over 3 time-saving nopCommerce SQL query snippets.

We all know that managing an online store is not an easy task. Especially when your store site includes CMS (content management system) features like blog, forums and news etc; maintaining the site is a big undertaking. 

If your store site is getting a lot of online traffic there is always a possibility that you will have to deal with "spam". For example: There will be times when you will see spam comments in your blog post. What can you do about it? Well, you can certainly go to administration section and delete those comments. But, what if you are getting thousands of spam comments? Is it really feasible to go to administration section and delete those spam comments one by one?

As of now, nopCommerce does not offer any option to perform a mass delete on blog comment. Today, we will discuss, how to delete blog comments "in mass" directly from the database.