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.