Integração Service

🔄 🏢 Integração Service application mainly performs the synchronization of the Sankhya ERP with the e-commerce on the VTEX platform.

Main features:

Catalog export (products, SKU, components).
Price list update.
Update of stock availability.
Synchronization of the Lista de Compras (reflects catalog, prices, and stock).
Import orders.
Export of online course requests (Vitrine do Artesanato Digital).
Import and export of subscriptions (Canal do Artesanato).
Order status updates.
Integration with carriers and related services (AVJ/CGE, Mandaê, SIGEP - Correios).
Monitoring and correction of flows in orders (billing, correction of flows, and status).
Correction of NF-e.
Manual stock correction.
Data indexing for Elastic Search for report extraction.
Capture of events from VTEX’s Bridge module.
Capture geolocation by address of partners (customers) via Google Maps API.

About

This application is responsible for the integration between the various systems, platforms, and services used or developed by the Inovação group, such as:

Sankhya (ERP).
VTEX (e-commerce PaaS).
Canal do Artesanato (own platform).
Lista de Compras (own platform).
Vitrine do Artesanato Digital (own platform).
SIGEP - Correios (carrier/couriers).
Mandaê (carrier/courier).
WMW Vendas (CRM).
Postal Net (AGF - Correios reporting system).
CGE - AVJ (CGE - Controle e Gerenciamento de Entregas - Delivery Control and Management).

Organization

The application consists of 26 projects:

Solution

Src
- Hosts
  - Services
    - (workers): Workers who perform tasks in the background (gRPC / RabbitMQ).
  - Application: main application, running as “dispatcher”.
  - ForIntegration: API to receive webhooks and to provide functionalities for the general intranet.
  - Scheduler: NodeJs application that performs scheduled tasks.
  - Installer/Updater: Installs/updates the main application.
- Lib
  - App
    - Core: Library with event handlers
    - GUI: Library with the Windows forms of the main application (authentication, note correction, stock correction, order checking).
    - Products Crawlers: performs data scraping of competing websites to obtain product pricing information
    - Resources: Images and templates used by various projects.
    - TotalIp: PostgreSQL integration with TotalIP (Digital PBX).
    - VTEX: Integration with VTEX. Migrate to VTEX-SDK-DotNet
    - WMWVendas: SQL integration with WMW Vendas.
  - Doman & Infra
    - Integrations: Wrappers of integrations that don’t need their own project.
  - Utilities
    - Commons: Basic features, utilities, shared.
    - Commons Utils: Some integrations that should be migrated to Integrations.
    - Configuration: Application configuration classes.
    - Databases: Communications classes with RDBMS (Microsoft SQL Server, PostgreSQL, MariaDB/MySQL).
    - Infrastructure: Infrastructure classes.
    - Logging: Log adapters.
    - Notifications: Notification adapters.
    - Plugins: Plugins for some utilities like plugins to add a screenshot to email, add an attachment, use the Windows progress bar, etc.
    - Shared: Shared constants and classes.
Tests
- Unit Tests: unit tests
- Integration Tests: integration tests
- Tests: tests in the old pattern.
Tools
- Log Monitor: Console application that receives logs sent to RabbitMQ.
- Logging & Tracing: Experimental log & tracing library

Architecture

Stack

Containers

Development

To carry out application development, troubleshooting, or maintenance, the following software is required:

Microsoft Visual Studio 2022 (IDE) or JetBrains Rider (IDE).
- .NET Framework SDK - version 4.8.
- .NET Standard SDK - version 2.0 and 2.1.
- .NET SDK - version 7.
GIT client.
NuGet Client.
Docker (not mandatory, but recommended).
Infrastructure (available over the network, via docker-compose, or locally installed as a standalone):
- Elastic Search
- Microsoft SQL Server
- Microsoft SQL Server Management Studio.
- RabbitMQ.
- Redis.

Developed by Guilherme Branco Stracini for Editora Inovação.