Magento Simple EPR Integration

I require magento & Plexis ([url removed, login to view]) integration. At a high level, products should be managed in the ERP but uploaded to magento, orders from the website should be downloaded to Plexis and customers should be sync'ed between the two.

The ERP has two price fields, one of B2B & one for B2C. This should be considered in the design. I suppose a seperate magento webstore will be needed.

The chanllenge would be on how to keep customers sync, I think the downloading of orders and uploading of products should be straightforward.

Basic table structure is as follows:




fields: MTRL_MAIN - the id

MTRL_IMAGENAME - a file path on the local file system

AGRP_MAIN - association with ARTGROUP table (Κατάλογος [Shirt, Trouser etc])

SIZE_MAIN - association with SIZES table (S, L, XL etc)

GLRG_MAIN - association with COLOURGRP_MST table (red, black etc)

MATERIAL_PRICES table holds the differenct prices of a MATERIAL




fields: COMP_NAME - the customer name

COMP_ADDRESSA1 - the customer address

COMP_ADDRESSB1 - delivery address

COMP_ALTNAME - customer's alternative name

COMP_TEL1 - customer's telephone number

...other fields that the website will be needing


Common fields, such as customer, product, price etc.

Plexis run on MSSQL the solution can have direct & full access to the database. Either the Magento WebService API or direct access to MySQL can be used. Alternatively, magento could run on MSSQL with the Plexis database (replication actually)

Please share any experaince you have integrating magento with other applications and what approach you would use.



Compétences : Magento, PHP, Architecture Logicielle

en voir plus : epr magento, simple file database, red red black, red black with, product structure design id, plexis, magento epr, xl, magento integration, magento erp, magento database, magento APi, george, b2b b2c, b2b and b2c, b2c shirt, b2b magento system, integration php api, magento website customer, mysql sync api, b2b system, simple api access, sync erp magento, shirt mysql, magento prices

Concernant l'employeur :
( 12 commentaires ) Athens, Greece

Nº du projet : #1033804

6 freelance font une offre moyenne de $1000 pour ce travail


please check pmb for more [login to view URL]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(138 Commentaires)

Please check my PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(65 Commentaires)

Hi, I am interested to work on this project. Please contact me for more details. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(8 Commentaires)

Hi, My name is Mayank, a technical team leader from E-citius Infotech Pvt Ltd. I’m interested in the position of "Website Developer" you recently posted. During past 5 years we have designed, developed & managed Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(2 Commentaires)

please refer to pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)

cosider it done

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(0 Commentaires)