SQL plugin allows viewing record from SQL by using selected queries. You can use any of these queries: Create, Insert, Alter, Drop, Truncate, Delete, Update, Into.
1 Download plugin.
2 Unzip the downloaded file.
3 In your nopCommerce web folder, you will see a Plugins folder, in it...
4 Create a sub folder with plugin name (TMotions.Sql queries).
5 Copy all the files from the zip download into the subfolder.
6 Either a) restart the nopCommerce application, or b) login as Administrator, goto Administration > Configuration > Plugins > click the button "Reload list of Plugins".
7 after the list reloads, scroll down to the line with new plugin name, and click the "Install" link.
8 When you install the plugin, "Display Data" will show under the plugin tab and once you click on Display Data
9. You can run SQL queries by using by using insert, create, update, delete, alter, drop, into and truncate..