After downloading and extracting the Premmerce ZIP file, please follow the instructions in “PremmerceSetupGuide.pdf” to set up the database and demo data (if needed).
You can also watch the video below for additional guidance.
If you prefer reading, a text version of the setup instructions is provided below as well.

Setup Video

Note: Please ignore the OpenAI API content mentioned in the video, as it is not used in this project.
Important: Do not register the first admin account manually (ignore the related content in the video below) if you plan to insert demo data. Running the PremmerceDemoData.sql script will automatically create the admin account in your database.

Text version:

Download the Project:
- Obtain the project files by downloading them from https://auratheme.gumroad.com/l/aspnet-core-ecommerce-project-source-code
Extract Files:
- Unzip the downloaded file to your desired location.
Open the Project:
- Open the solution file (ECommerce.sln) with Visual Studio 2022.

Replace the placeholder value with your actual database connection string. For example:

"ConnectionStrings": {
    "DefaultConnection": "Server=YourServerName;Database=YourDatabaseName;User Id=YourUsername;Password=YourPassword;"
}

How to get the connection string? You may watch this video: https://youtu.be/WjLV5ccuzaU?si=3adrNcKEMdlj0-oP&t=172. Start from 2.52 to 3.48.

Open the Package Manager Console in Visual Studio:
- Go to Tools > NuGet Package Manager > Package Manager Console.
Run the following command to apply the existing migration and create the database:
```
Update-Database
```
Once the command completes, the database will be created with the necessary tables and structure.

<aside> ⛔

Skip this if you plan to insert demo data with PremmerceDemoData.sql.

</aside>

Click on the User icon located in the top-right corner of the page. Click “Create an Account”.
Fill out the registration form to create the first account.
- Note: The first registered account is automatically assigned the Admin role. It is assumed that the first user is the system administrator.
Log in using the newly created admin account.
Navigate to General Settings from the sidebar menu.
Configure the system by providing the following information:
- SMTP Information for email notifications. Video: How to get SMTP information?
- Time Zone to match your organization’s location.
- Portal Name for branding purposes.
- Logo to personalize the portal.
Save the settings to complete the initial system setup.

Open the PremmerceDemoData.sql file, copy the script, and execute it in your database. This will automatically insert all demo data—including accounts, products, blogs, FAQs, categories and more—into your database.
Once that’s done, go back to Visual Studio 2022, press Ctrl + F5 to build and run the project!

Here are some steps you can take to troubleshoot this issue:

Right-click the solution and select "Clean Solution"
Right-click the solution and select "Rebuild Solution"
The issue should now be resolved. If it still persists, please try the following additional steps.
Restore NuGet Packages:
Clear the NuGet Cache: