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.