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.
In past, some nopCommercer users have accidentally removed administrator role from the main admin account and lost the access to administration section. If you are not a programmers or database admin, it can be quite difficult for you to get back the access to the administrator section without anybody's help.
Today, we will go over the process of assigning administration role to any user via SQL script.