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.
This plugin only works correct with a default nopCommerce. To ensure the plugin will work ok for your customized website please contact us neha.raswant@tmotions.com
- Download plugin.
- Unzip the downloaded file.
- In your nopCommerce web folder, you will see a Plugins folder, in it...
- Create a sub folder with plugin name (TMotions.Sql queries).
- Copy all the files from the zip download into the subfolder.
- Either
- restart the nopCommerce application, or
- login as Administrator, goto Administration > Configuration > Plugins > click the button "Reload list of Plugins".
- after the list reloads, scroll down to the line with new plugin name (i.e. get a quote), and click the "Install" link.
- When you install the plugin, "Display Data" will show under the plugin tab and once you click on Display Data
- You can run SQL queries by using by using insert, create, update, delete, alter, drop, into and truncate.