In Progress

Magento Uploader

We wish to upload stock from a MS SQL Server 2008 Database (on WIndows Server) to our magento website (hosted on a separate remote linux server) 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 this could rise significantly in the future (hence the need for speed). Our old SOAP interface is far too slow. Under normal operating circumstances, the system will be expected to transfer & upload all changed records every 15 minutes or so (normally < 20 recs). However, in the event of a recovery situation, we will upload all products 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. Our internet link between the two servers is slow, so the solution should include the minimum number of separate communications between the two.

There are two aspects to this work:-

1) Creating the flat upload table and support tables (eg locking table, failed record transmissions, etc) in SQL Server ready to transmit to MySQL on the Linux box - THis is a separate work package but please feel free to quote for this if you can do this aspect too. For info, each product record contains either one or two top-level categories each with a sub-category. Each product also has up to 15 attributes.

2) Create an equivalent flat upload table in MySQL on the Linux box

3) Create scripts to extract the data from the SQL Server flat upload table and transmit to MySQL tables on the Linux box using a safe/secure method.

4) Create a script to upload our products from MySQL tables into Magento.

NB. Other solutions are not excluded.

Please quote for items 1-4 or 2-4.

Please could you also let me know the approximate time that you would expect your solution to take to transmit and upload 100K records. Also, please can you advise your earliest availability/start date

Many Thanks


Due to some requests, I have attached further requirements and preliminary design information. I hope this helps.
Please note that other deigns will be considered as long as they are just as secure, just as fast and no more expensive.
Best Regards.
Graham

Skills: Magento, MySQL, PHP

See more: magento uploader, write on communications, speed date script, remote support linux, one up communications, lt security, level 3 communications, ensure data security, uploader magento, stock categories, magento go, upload magento products, transfer product data, sql server scripts, speed up magento, periodic, magento support, Magento speed, magento slow, magento server, magento product upload, magento free, magento database, extract tables, emails handling

About the Employer:
( 6 reviews ) Swindon, United Kingdom

Project ID: #1098632

Awarded to:

tejas34

Please check PMB.

£500 GBP in 5 days
(12 Reviews)
5.1

10 freelancers are bidding on average £662 for this job

vietcodepro

Hello, I am very interested your project. Please check your inbox for more details, thanks!

£700 GBP in 5 days
(359 Reviews)
8.0
p4provider

please check pmb for more details,Thanks

£700 GBP in 18 days
(89 Reviews)
7.3
code4ever

We are magento experts, please see our PM for the detail. Thanks

£750 GBP in 15 days
(52 Reviews)
7.2
iclicknetwork

Please check my PMB

£700 GBP in 10 days
(61 Reviews)
6.5
iapple

I can help [url removed, login to view] check PMB for more details

£750 GBP in 20 days
(3 Reviews)
5.3
asheagle

Hi, Please check PMB. Thanks, Ash

£550 GBP in 20 days
(8 Reviews)
5.2
itsabacus

Hello, Please check your PMB for more details.

£650 GBP in 30 days
(4 Reviews)
5.0
stevejohn4

Hi We are web technology company and we feel pleasure to assist you on your project for more detail please see your PMB. Thank you Kind Regards John Steve

£699 GBP in 25 days
(0 Reviews)
0.0
saleemanwer

I hope you will consider me. Thank you Sincerely Yours, Parekh Information Technology

£520 GBP in 10 days
(0 Reviews)
0.0
sagaratseed

we are a software services company with more than 16 years of work ex

£800 GBP in 25 days
(0 Reviews)
0.0