Fermé

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:

Products:

table:

MATERIAL

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

Customers:

table:

COMPANY

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

Orders:

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.

Thanks,

George.

Compétences : Magento, PHP, Architecture Logicielle

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

p4provider

please check pmb for more [url removed, login to view]

1500 $ USD en 15 jours
(138 Commentaires)
7.7
iclicknetwork

Please check my PMB

950 $ USD en 10 jours
(65 Commentaires)
6.6
asheagle

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

750 $ USD en 25 jours
(8 Commentaires)
5.2
ecitius

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

450 $ USD en 20 jours
(2 Commentaires)
3.4
Cyberdesignz

please refer to pmb

850 $ USD en 30 jours
(0 Commentaires)
0.0
dipeshjain

cosider it done

1500 $ USD en 14 jours
(0 Commentaires)
0.0