CRE Loaded: Upload Inventory via Product Data Feed, Update Inventory via PHP Scraping - Creloaded -osCommerce

I am using CRE Loaded. It is version CRE Loaded v 6.2[13.1 (SP1)] In need of a CRE Loaded Inventory Updater script. I have a CRE Loaded store that is based off of drop shipped products from other stores. Drop shipping - My store sells an item, send the order to the distributor, and they ship it out. One of our distributor's offers a Product data feed as a Excel file or a .txt data feed. I usually have to convert to an easy populate file and upload it. It takes a long time to manually create the easy populate file. (Moving fields around, changing filed names, Dividing Category fields, etc.) Part of this project is to create a script that will automatically convert the Manufacturer's Provided Data Feed to either a Easy Populate file, or automatically upload the provided data feed into my CreLoaded store to update the inventory. Everything to be done: 1. Take URLs from mySQL Inventory database (4 different tables, probably around 1000-1500 items), check URLs (probably by PHP Scraping) to see if item is still in stock. Products that are not in stock, delete those products from mySQL database and the CRE Loaded Store. Inventory database has the SKU matching the URL's product and my CreLoaded Store's product. 2. Create a script that will allow me to upload a Product Data Feed (from manufacturer), upload the products to a CRE Loaded store, convert it to a Easy populate file, check the Distributor URLs in the Product data feed (by PHP scraping) and check to see if Product is in stock. If product is in stock then properly add the Product to the CRE Loaded store. If Product is not in stock, delete from CRELoaded store (or do not upload the product). 3. Fix easy_populate on my CRE Loaded store so it works properly. Update Easy_populate to latest version. 4. Unfortunately the Product data feed does not say how many items come per product. The distributor page (the URLs from the data feed) has these items per product. While checking URLs, scrape the items per order and change the product name to from 'Product Name' to 'Product Name - Set of 3' for example. Not all products will have multiple items in a set. If no items then do nothing. CODER MUST HAVE HISTORY WITH CRELOADED ## Deliverables I am using CRE Loaded. It is version CRE Loaded v 6.2[13.1 (SP1)]. **Looking for a CRE Loaded / OsCommerce Expert. Must have worked with CRE Loaded and understand it well.** In need of a CRE Loaded Inventory Updater script. I have a CRE Loaded store that is based off of drop shipped products from other stores. Drop shipping - My store sells an item, send the order to the distributor, and they ship it out. One of our distributor's offers a Product data feed as a Excel file or a .txt data feed. I usually have to convert to an easy populate file and upload it. It takes a long time to manually create the easy populate file. (Moving fields around, changing filed names, Dividing Category fields, etc.) Part of this project is to create a script that will automatically convert the Manufacturer's Provided Data Feed to either a Easy Populate file, or automatically upload the provided data feed into my CRE Loaded store to update the inventory. Everything to be done: 1. Take URLs from mySQL Inventory database (4 different tables, probably around 1000-1500 items), check URLs (probably by PHP Scraping) to see if item is still in stock. Products that are not in stock, delete those products from mySQL database and the CRE Loaded Store. Inventory database has the SKU matching the URL's product and my CRE Loaded Store's product. 2. Create a script that will allow me to upload a Product Data Feed (from manufacturer), upload the products to a CRE Loaded store, convert it to a Easy populate file, check the Distributor URLs in the Product data feed (by PHP scraping) and check to see if Product is in stock. If product is in stock then properly add the Product to the CRE Loaded store. If Product is not in stock, delete from CRE Loaded store (or do not upload the product). 3. Fix easy_populate on my CRE Loaded store so it works properly. Update Easy_populate to latest version. 4. Unfortunately the Product data feed does not say how many items come per product. The distributor page (the URLs from the data feed) has these items per product. While checking URLs, scrape the items per order and change the product name to from 'Product Name' to 'Product Name - Set of 3' for example. Not all products will have multiple items in a set. If no items then do nothing. Things to know: - Data feed files have about 3000-4000 products. Should just be able to upload file, let it run, and it convert, scrape, and update CRE Loaded store w/ products in stock. - Product Data Feed categories must be altered. Should be divided into separated categories. For expample feeds that look like this should be changed: EX. root > Gifts of Faith > Baby / Children > Children's Jewelry root > Gifts of Faith > Baby / Children > Children's Rosaries Should be altered to: Category1 | Category2 | Category3 | Category4 Gifts of Faith | Baby / Children | Children's Jewelry Gifts of Faith | Baby / Children | Children's Rosaries Here is an example of the product data feed. It is just a few lines of the data feed.