CS-Cart SQL Report Builder

Banner

CS-Cart SQL Report Builder Addon

CS-Cart SQL Report Builder is an addon. This addon makes reports easy with the SQL Report Builder extension. Save and run SQL queries directly from the admin panel with a simple click.

This addon allows users to create a custom report within the CS-Cart e-commerce platform. This addon enables users to extract and analyze specific data from their store database. This flexibility ensures that the reports show exactly what users want, giving a detailed look at their e-commerce operations.

Features:

  • Custom Reports: Build personalized reports based on your specific needs.
  • One Click Execution: Run your SQL queries and generate a report with a single click.
  • Save Queries: Save your frequently used queries for quick report generation in the future.
  • No Coding Required: Create reports without the need for advanced coding skills.
  • Real-Time Results: Obtain up-to-the-minute information for timely decision-making.
  • User-friendly interface: Enjoy an easy-to-use design for creating reports without technical expertise.

Installation:-

How To Install SQL Report Builder Addon

How to Upload  Zip file 

On the Downloaded Addons page, click on >> Gear button then go to Manual installation. A pop window will be displayed You can install an add-on by picking a tgz,gz,zip format archive and clicking Upload & Install.     

Add-on installed.

installed page

After Successfully installing the add-on Goto >Add-on on the administration panel Add-on>Manage Add-on>Ecarter Technology Pvt. ltd. You see no. of installed add-ons or newly installed add-ons and add-ons must be Active/On status if the addon is Off it is not working.

installed page2></p>
<h3>Configuration</h3>
<h3>Let's check how the add-on Settings works</h3>
<ol><li>Open the SQL Report Builder addon.</li><li>Go to the general tab.</li><li><b>Items for the menu: </b>you can directly access the SQL report builder and admin table privileges are part of SQL Report Builder in the order menu through this link.</li><li>Switch on the settings tab.</li><li><b>Export file type: </b>Choose the type of file you want to export based on your preference.</li></ol>
<h3><img src=

builder addon

SQL report builder

How to work this addon

1. Go to the order menu.

2. Select the SQL Report Builder.

3. Choose Sql report builder.

4. Sql report builder page will be open.

5. Admin can add new sql report.

6. Click on the (+) icon.

7. Report title:  Enter the Report title name.

8. Sql query: Enter the query.

9. Click on the Execute Sql Query.

10. After executing the query, you can see the sql report here.

order menu

SQL report builder

SQL query
query
query

11. Now choose the Admin table privileges.

12. The Admin table privileges page will be open.

13. Go to the customer menu.

14. Click on the Administrators.

15. Admin can add the sub-Admin profile.

16. Click on the (+) icon.

17. The new profile Administrator page will be open

18. And then fill in all the information.

19. Click on the Create button.

20. Admin selects execute report table in the restricted table in the table privileges page on the order menu.   

21. And then click on the gear button.

22. And then click on the login as user.

23. and login will be done from any sub-admin profile.

24. Here you see a restricted report table in the SQL report builder.

admin table privileges

admin profile

fill in all information

gear button

login as user

login will be done from any sub admin profile
restricted report table in the SQL report builder ></figure>
<p><img src=

Addon-Version:

Version-1.0

Supported Versions:

CS-Cart, CS-Cart Multivendor 4.8.x, 4.9.x,4.10x,4.11x,4.12,4.13x, 4.14x, 4.15x, 4.16x, 4.17x

Support:

This app is developed and published by Ecarter Technologies Pvt. Ltd., a CS-Cart developer. You are guaranteed quality add-ons.