Simphony developer

Integration

Overview

Command-line tool for integrating the ODOO erp with external marketplaces, in particular with tradebite

Aims

products: personal data integration from erp ODOO to external marketplace, tradebite. The update can be done at any time even in overwriting

orders: integration of orders from external marketplace to erp ODOO. The inclusion of new orders is permitted; status update. The same order can not be entered twice

warehouse: update quantities produced by erp ODOO to external marketplace. The update can be done at any time even in overwriting

Specifications

Development of two ETL tools - also called Extract Transform Load - for system integration.

The development will be based on the Symfony framework

The server that will host the tools will be specific

The tools must adapt to different marketplaces, having in any case a part of common logic:

management of transmission channels

log

The mapping, the mapping rules, will be channel-specific

The tools will be operational via command line and job scheduling

The tools must always write the input and output channels and the transmitted data and any errors

The first development will concern the integration with Tradebite

Intermediate stages

Development of the channel management component

Channel management must have:

name of the channel, which will correspond to the service to be called

connection type: web service; ftp

user for the connection

pw for the connection

connection string

Depending on the type of connection it must provide a std interface for the management of reading or writing data.

If there are any call problems, the error must be entered in a special log

Development of the flow manager

The flow manager deals with managing, by combining, the two channels, one in output and one in input, and the part of the ETL for data mapping

The manager must be configurable

name of the manager (for example the name of the integration), which will correspond to the service to be called

channel for data reading

channel for writing data

etl for mapping

Any manager management errors must be entered in a special log

Development of the specific ETL for the marketplace

The ETL allows to map data from data input and allows data to be sent to the external system

Through the manager reads the data from the input channel and makes the output in the output channel

The ETL must be able to be configrable:

mapping name: (for example the name of the mapping integration), which will correspond to the service to be called

...

If there are any mapping problems, the errors must be entered in a special log

Development of the flow management command

The mapping and integration flows must be started via the shell command in order to obtain the maximum performance from the processing of the machine and also for a schedule.

Flows to be implemented

sending personal data to new products: ...

sending quantity and status update of existing products: ...

import new orders: ...

import status of orders entered: ...

sending update status received: ...

Implementation notes

Odoo must remain passive regarding orders

For products, the current procedure for sending orders to PrestaShop is used

For missing data on Odoo and required by marketplaces, for example the "product name", to be decided with the lowest user cost and the lowest management cost

ERP MySQL Odoo PHP Αρχιτεκτονική Λογισμικού

Ταυτότητα Εργασίας: #17623066

Σχετικά με την εργασία