Customize XML file from a large csv file for wordpress

Experience with XML wordpress and data integrity extremely important. large data file 100 mb and contains hotel and their booking information The job: creating one xml file to be uploaded to our site that has the correct information to display hotels, rooms, [login to view URL] links to the referring source as appropriate for finalizing of booking. Release of escrow review this entire job see end of job for release of escrow details Preparing source csv 1.) Review and clean columns to ensure source data is prepared. current csv file has data in wrong columns (CSV SOURCE)this data needs to be prepared to ensure uniform and accurate information 2.) download our website wordpress xml file to understand format. (master format to be used when uploading final data) 3.) review both xml and csv file. 4.) Using the xml file to understand what fields we need to display on our website add the appropriate data from the csv file to the xml file. NOTE: The source data (CSV) has more fields available for display than we need in the final XML file. AS we are having a hyperlink to the hotel listing where further hotel details can be found as well as booking we do not need every field from the source (CSV) added to the final XML file 5.) Provide hyperlink from our site to the added listings from the csv file. 6.) Test that xml file is loaded to allow for hotel and room data to appear and link to referring site for follow up booking. 7.) Ensure our(affiliate identifiers) are included in hyperlinks opened to the csv sourced listings source csv file provided by request. It is a large file 1 milestone paid only after xml file uploaded and confirmed to be working 100% correct. We ask that you provide 5 working listings from the csv sourced data prior to start of job as not to waste anyone's time. We need absolute confirmation that you can create the correct format from the source data, can be uploaded and functional. We only release escrow when job 100% complete by bidding on this job you agree and understand that you have read the requirements and are capable of completing the job. The 5 test data is part of confirming your abilities an not part of escrow. 100% correct data xml file uploaded and functional to our website when hotels listed in that xml file are visible in our google map and advanced search section. Links to our csv sourced lisings are active and provide the appropriate affiliate identifiers are completed