Store Data Synchronization

StoreDataSync project is for synchronization store data from ERP, and 3rd party e-commerce content provider to Nopcommerce based shopping sites such as Product, Category, Price, Warranty, and so on.

Deployment Tools

1. Download and install Python 3.9.10

2. Download and install Git SCM

3. Download and install ODBC Driver 17 for SQL Server

4. Install Easysoft ODBC-ODBC Bridge 2.3.10

How to Deploy

After the above deployment tools were installed on the Sync server then you can clone this repository main branch in {User}/source/ folder. And open cmd window and run following commands.

cd source\StoreDataSync\
python -m pip install --upgrade pip
python -m pip install virtualenv
python -m virtualenv venv
venv\Scripts\activate
python -m pip install -r requirements.txt
cd src
copy settings_local.py settings.py
python win_task_****.py

Development Tools

1. Download and install MS-SQL server developer version
https://go.microsoft.com/fwlink/?linkid=866662

2. Download and install SQL Server Management Studio (SSMS)
https://aka.ms/ssmsfullsetup

3. Download and install Visual Studio 2022 version
https://visualstudio.microsoft.com/vs/ (edited) 

4. Download and install Git
https://git-scm.com/downloads

Getting Started

Download project source. Open cmd window and run following commands.

• cd source/repos
• git clone {git repository url}

After you downloaded all project files you can start python environment. (If you first use python on your machine you need to register the python path to windows environment variable)

Virtualenv Installation: python -m pip install --user virtualenv

Create virtual environment for Project: python -m virtualenv venv

Activate python virtual environment: venv\Scripts\activate

Install required python packages: pip install -r requirements.txt

Project Organization

├── README.md          <- The top-level README for developers using this project.
├
├── StoreDataSync.sln  Vistual Studio Solution file to open the project in Visutal Studio.
│
├── requirements.txt   <- The requirements file for reproducing the analysis environment
│
└── src         <- Source code for use in this project.
    │
    ├── pynop           <- py-nop api packages
    │   └── core                   <- python data management system codebase
    │
    ├── sync            <- staging erp, rws data and import it into store
    │   └── erp                     <- staging erp data from erp db to mssql
    │   └── rws                     <- staging rws data from rws api to mssql
    │   └── shop                    <- import data from staging db to nop db
    │   └── sot                     <- now disabled sot feature
    │   └── staging                 <- defined staging data
    │
    ├── tests         <- all test files
    │
    └── {other}

---

Git Commit Rules

Commit Message (#Issue Id)

Project based on the Mike Zeen's. python framework, codebase, concept and design patterns