I have a need to populate my Magento site with products using a Data Feed provided by my supplier and product photos provided in a zip file. Then I need those products to be updated for price, quantity, etc. on a daily basis. Then, as new products are added to my Suppliers Data Feed, those products will need to be added to my site (and also deleted when they are no longer in the Data Feed). I have provided details of my requirements broken down into 2 Sections below.
First, I need you to load products to my site using the Data Feed provided by my supplier. The Data Feed is available in XML, CSV, or Tab Delimited format.
You will also need to load product images to site. Images are provided in a .zip file by my supplier.
The product price will be determined as a percentage of Cost. You will need to create a section in the backend under “Catalog” or “Sales” to have customizable price brackets as a percentage of cost. I want it to be something like this:
If Cost is between $0.01 and $9.99, then Price is 1.20 x Cost
If Cost is between $10.00 and $19.99, then Price is 1.18 x Cost
If Cost is between $20.00 and $39.99, then Price is 1.16 x Cost
If Cost is between $40.00 and $74.99, then Price is 1.15 x Cost
If Cost is between $75.00 and $99.99, then Price is 1.14 x Cost
If Cost is between $100.00 and $149.99, then Price is 1.13 x Cost
If Cost is between $150.00 and $199.99, then Price is 1.12 x Cost
The values underlined will need to be customizable and I need 20 brackets setup instead of only 7 as shown in the example above. This price calculation will need to work for any products that I manually add to the site as well and not only for the Data Feed products. So, you will need to create some kind of executable button so that if pressed, all of the site’s product will be recalculated.
You will need to set up 3 flat rate shipping costs:
$8.95 for Ground shipping
$25.95 for Overnight shipping (non-oversized products)
$49.95 for Overnight shipping (only applies to oversized products, products in the Data Feed that have value=1)
2) Once all the products and photos are initially loaded to my site, I need the following automatic updates created:
Hourly updates for quantity available (maybe less frequent if cheaper to code).
Daily updates for Cost, Price, MAP Price
Weekly updates for new products, delete old products, update photos
If you want to see more specific detailed step by step requirements/instructions as well as my suppliers Data Feed info, please let me know and I’ll send to you before you bid.
Please provide your best offer and time to complete the job. I also need to know what forms of communication you have available for us to communicate. If you have any questions about my requirements, please let me know. Since this is a new store my budget is low. The project will most likely be awarded to lowest bidder that has a decent feedback rating so if you want to be competitive I urge you to quote a fair/competitive price.