This Project will run alongside another project (1098632 - Magento Uploader).
The overall aim of BOTH projects is to extract a list of products (normally just changed products) along with all the various categories and attributes from our stock control database, transmit them to our web server and upload them into Magento. We expect an upload cycle of every 15 minutes and we need some error handling to detect, report and retry records that fail to transmit and/or upload. We have already done some design work and the relevent documentation is attached
This particular project is concerned with the SQL server elements...
- create the relevant tables (Mage_flat_product, Mage_Lock, Mage_errors_log, Mage_success_log, Mage_Update_Index)
- create the relevant triggers to populate the tables and perform other required actions (eg handle tranmission failures)
- create the relevant stored procedures to populate/empty the tables
- ensure appropriate permissions/security are set to protect our data and servers (external processes or scripts from project 1098632 will need to read and extract product data and will need to write a few records such as the table lock and the success/failed flag.
This project will also need to collaborate with the Magento Uploader project for end-to-end testing and cover any fixes or adjustments resulting from the end-to-end testing.
More detailed information is contained within the attached documentation
This project should take no longer than 5 days (excluding end to end testing as we may need to wait a little while for project 1098632 to be ready) and start as soon as possible.
5 freelancers are bidding on average $500 for this job
Hi! I have 11 years exp in MS SQL. I understand what do you need, but not all of it. I can create information migration between 2 MS SQL servers. But you need Mysql and MS SQL? Regards.