Magento Interface

We wish to upload products and associated images from a MS SQL Server 2008 Database on Windows Server (source) to our Magento website hosted on a separate remote Linux server (destination) automatically on a periodic basis using the fastest practicable means without risking the security of our data. The number of products involved is initially around 30,000 but will rise significantly to upwards of 250k once operational. Under normal operating circumstances, the system will be expected to transfer & upload all new, changed or deleted records once a day, with provision to increase the frequency as required. In the event of a recovery situation, all products would be uploaded in one go. Error handling will need to be built-in to ensure that read/write clashes and timing issues do not occur, failed transmissions are re-tried (eg 3 times) and user alerts/emails are sent out. The solution should include the minimum number of separate communications between the source and destination.

The interface should be configurable to extract data based on customisable rules. Initially we only want to extract products from one vendor where multiple vendors have the same product based on pricing and availability. As we evolve, we need to be able to adjust that to upload multiple vendors with the same product.

The interface should be built so that additional modules can be added with future projects. An example of an additional module would be importing customer data and sales from Magento back into the MS SQl database.

Compétences : .NET, Programmation C#, Microsoft, MySQL, PHP

en voir plus : write on communications, interface security, ensure data security, upload magento products, operating system projects, magento product upload, emails handling, windows server magento, magento associated, read write server using, magento website customer, database error linux server, magento error solution, magento associated product, Magento website built, magento server linux, magento data error, data upload magento, remote windows server 2008, extract records, magento system interface, extract data sql server, frequency data, customer interface, magento additional

Concernant l'employeur :
( 22 commentaires ) Balmain, Singapore

Nº du projet : #2339776

Décerné à:


Hired by the Employer

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 20 jours
(35 Commentaires)