Magneto Integration, Daily Import of Content

DO NOT BID UNLESS YOU SEND ME A MESSAGE FOR ADDITIONAL INFORMATION. I HAVE ONE DOCUMENT PREPARED THAT YOU WILL NEED TO UNDERSTAND THE PROJECT. AUTOMATIC BIDS WILL BE IGNORED!!! I am about to begin a project for a fairly large Magento installation where we would use a CRON job to import price, inventory, images, and product information every morning from a single source (a distributor). This will include about 35,000 products. I would need this to seamlessly integrate into the Magento installation with all of the data points mapped correctly and run every morning and a pre-determined time (for example, 5:30 a.m.). I have a zip file that has some sample documents include file structure, attribute list, category hierarchy, etc. These are very indicative of what the live feed will be and are provided by the distributor for integration purposes before the live feed is sent out. THIS IS THE DOCUMENT THAT YOU NEED TO GET FROM ME PRIOR TO BIDDING! NOTE: in some of the documentation, you may see a reference to an XML service that the distributor offers in which we would automatically pass the orders back to the distributors for fulfillment. We will NOT be using this service. What we need: • Automatic Import of information from data feeds: - Product Images (not all products have images, some might have more than one) - Product Descriptions, content, (all applicable fields that are sent over) - Product attributes (mapped correctly) - Inventory for each Product (updated daily by CRON) - Category information and hierarchy - Category image should be the same as the first product image in that category We need the ability to markup the prices in three ways via a Control Panel in Magento’s Admin area: - Global markup - Manufacturer Override - Category/Sub-Category override • The logic for the override hierarchy would be as follows: - IF Cat/Sub-Cat has an override, ignore the manufacturer and global markup and apply the category markup - ELSE IF Cat/Sub-Cat is empty and manufacturer has an override, ignore the global markup and apply the manufacturer markup - ELSE IF Cat/Sub-Cat AND Manufacturer Overrides are empty, apply global markup to the imported cost. • This logic should be applied during import and NOT during page load. • Assuming that the pricing table needs to be re-indexed after the import and logic is applied, the CRON job needs to end with a command that will re-index that table - Standard Magento functionality should not be disrupted Requirements: • Must be able to begin work within a week • Must have extensive knowledge of PHP, Magento, XML, CRON tasks, and other applicable skills • Must provide an estimated time of completion • Must be willing to assist recommendations of server configuration changes if needed (ex: increase PHP memory, etc.) If you have any questions, please let me know PRIOR TO BIDDING!!!