This would fit nicely into an ETL (Extract, Transform, Load) process. ETL is a mature domain in computing with extensible tools. I have a free, open source ETL tool that I use for these types of projects.
For example, my latest ETL project was to take data from Magento, modify it to suit the DHL (shipper) format, then publish it to the DHL site. This is just one simple example of how ETL excels at data processing and provides a much more robust solution than custom code. Most freelancers will quote you based on custom code which is hard to maintain and adapt as you grow your solution.
Here are some standard ETL functions we would use.
- Scheduling
- Retrieve your provider's files from the source (FTP, file directory, email, etc.)
- Transformation steps to generate new products, identify disabled products
- Generate output CSV files
ETL technology is very flexible. We could add other steps incrementally. For example, read provider data directly from a data feed (if available), generate email and/or reports to summarize changes, verify additional database content, etc.-
I am located in Alberta, Canada and have worked with clients worldwide for twenty years. I am an English speaking freelancer and can bring creativity, dedication, and a wealth of experience in the computing industry to your project.
Thank you for your consideration. Please contact me to discuss my bid further.
Best regards,
Jay