How to Enable Ecommerce Dashboard

Overview of the Ecommerce Dashboard

The E-Commerce Dashboard in our ERP system is an innovative, all-in-one tool designed to give you real-time, actionable insights into your business. With intuitive features like detailed sales and purchase breakdowns for Today, This Week, and This Month, as well as total invoices, profit and loss calculations, and revenue vs. expense graphs, it empowers you to monitor financial performance effortlessly. The dashboard also highlights your Top Products, Low Inventory Levels, and Recent Transactions, enabling you to stay on top of your operations. Its sleek, user-friendly design ensures seamless integration with your workflow, allowing you to make smarter, data-driven decisions for growth and efficiency.

Prerequisites

• Access to SQL Server
• Appropriate permissions to modify the database
• Knowledge of SQL queries

Steps to Enable Ecommerce Dashboard

Step 1: Access SQL Server

1. Open SQL Server Management Studio (SSMS).
2. Connect to the SQL Server instance where your ERP database is hosted.

Step 2: Select the Database

1. In the Object Explorer, locate the database associated with the domain for which you want to enable the Ecommerce Dashboard.
2. Expand the database to view its tables.

Step 3: Delete Existing Dashboard Settings

1. Open a new query window.

2. Execute the following SQL command to delete existing dashboard settings:

   
DELETE FROM settings WHERE category = 'dashboard';

Step 4: Reload the Domain URL

1. Open a web browser and navigate to the domain URL of your ERP system.
2. This action will reload the dashboard settings.

Step 5: Verify Dashboard Settings

1. In the same query window, execute the following SQL command to verify the dashboard settings:

   SELECT * FROM settings WHERE category = 'dashboard';

   

2. Look for the setting with txtKey equal to displayEcommerceDashboard.

Step 6: Update the Ecommerce Dashboard Setting

1. To enable the Ecommerce Dashboard, run the following SQL command:

   UPDATE settings SET txtValue = 's:4:"true";' WHERE txtKey = 'displayEcommerceDashboard';

Step 7: Clear the Cache

1. After updating the settings, you need to clear the cache to apply the changes.
2. Navigate to the ERP system’s menu:
   • Go to Settings -> Security -> Clear Cache.

Step 8: Verify the Dashboard

1. Reload the domain URL again.
2. The Ecommerce Dashboard should now be visible and functional.

   

Example

For demonstration purposes, the following URL was used to enable the Ecommerce Dashboard:

• Domain: anamta.primeerp.top

Conclusion

By following the steps outlined in this guide, developers can successfully enable the Ecommerce Dashboard in the ERP system. If you encounter any issues, please consult your Team Lead or Line Manager.