Solution to import product data from remotely hosted CSV files into Magento

Budget N/A
Bids 10
Average Bid $12

We use a third party solution to perform this task at present but we would like to expand the functionality with a solution of our own. Here are the basics -

Ecommerce platform: Magento

Product Data files: CSV accessed via FTP

Do all CSV columns have the same name: No

How many different files: Right now 20

What type of product data do you wish to import: Product data for the purpose of creating new products and inventory data to update our 'on hand quantity' which is displayed on our live web store

How often do you need to update the store: Every 24 hours

Ideally, we'd like a solution that performs as follows. We'll call the solution ProductImport (PIMP!) for this case scenario.

1. We create a vendor in Magento
2. We create an attribute set relating to this vendor in Magento
3. We create the vendor in PIMP and confirm the attribute set from Magento to be used with this vendor
4. We specify the location of the vendors CSV files (generally there are two) for both product data and inventory updates and provide the credentials in PIMP
5. PIMP confirms it can access the remote file and returns the columns headers in the CSV file
6. In PIMP, we map the headers in the CSV file to the attributes contained in the attribute set for this vendor
7. PIMP imports the data and pushes it into Magento
8. Same occurs for the vendors inventory file although an attribute set will not need to be assigned as the fields in Magento for inventory quantity and so on are the same for any vendor

Considerations -

1. What happens if the product has been updated directly in Magtento. Should we overwrite?

For product data - no. For inventory related info - yes.

2. What happens if the product is no longer in the CSV file and still present in Magento?

PIMP should delete the product record from Magento.

3. What if PIMP fails to connect to the supplier or Magento? Be good to see an error report or some sort of failure notification.

4. What if you no longer do business with the supplier? They need to be removed from PIMP.

We are open to suggestions as to how this should be built - externally hosted solution or an extension in Magento. You MUST have experience with Magento and flat file extraction. Its a pretty common practise but I don't want to be someones guinea pig project =)

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • StoreManager Profile Picture

    StoreManager

    Ternopil,  Ukraine

    Store Manager for Magento developers team is the company with more than 6-years experience that has grown and built-up lots of solutions for Magento and other platforms. At the moment we've got the community of over 10 000 active users.

    XML, Joomla, Shopping Carts, and Magento

  • SEOSEARCHTEAM Profile Picture

    SEOSEARCHTEAM

    JAIPUR,  India

    OUTSTRIP Info Tech Private Limited have a dedicated team of 100+ professional’s designers, developers for Mobile Application development, website design & development, software development,, e-commerce development, Social Networking websites and portal development; we thrive on the idea that design makes a difference.At OUTSTRIP Info Tech, we have accumulated a brilliant team of digital strategists, designers, developers, marketers, communications specialists, project managers and business developers to work in a combined manner on our client projects. We build on each other's expertise, working together in teams to generate great outcomes for projects. What makes our company great? The team members at Outstrip are some of the most innovative, interesting and devoted people you'll ever meet, exactly the kind of people you'd love to work with. We Highlights: - More than 4 Year, Best Mobile and Web development Company. - 500+ Satisfied Client Around the Globe. - 900 + Web & Mobile project delivered. - 35% Repeat Client - We Build Brands with 360° Solutions - Creative Ideas That Perform, Our achievement is measured by outcomes Our Services - Web Development - Mobile Apps Development - Web Identity Development - Rich Internet Application - Open Source Development - Open Source Customization - Community Portal Development - Custom E-commerce Development Specialized In 1. Web Development - Ecommerce Development - Marketplace - Dating Sites - Job Sites - Community & Networking Sites - Social Networking Sites - Classified Sites - CMS based Sites - Corporate Site for IT Services Company Web Technologies - PHP - AJAX - JQuery - JavaScript - XML/XSL Open Sources - Drupal - WordPress - Joomla - Magento - Prestashop - OsCommerce - ZenCart Graphics & Multimedia - Adobe Photoshop - Adobe Flash - Adobe Illustrator - Adobe After-Effects Programming Language Support - C - C++ - Objective-C - JAVA - VB - PHP - Android - iOS - Ruby on Rails - Python Database Tools - MS SQL Server - MySQL - MS Access - Oracle - NOSQL Frameworks - Codeigniter - Yii - CakePHP 2. Mobile Apps Development - Ecommerce Apps - Dating Apps - Job Searching Apps - Social Networking Apps - Classified Apps - CMS based Backend System Language - Java - C - C++ - Objective C - jQuery - Java Script - HTML 5.0 - CSS 3 Environment and Platform - Mac OS, - Android SDK - iPhone SDK 5 and later - iOS - Windows - Phone Gap - Titanium - JSON Parsing - Angular.JS - Node.JS - Android Networking - Restful APIs Development Frameworks - Cocoa - OpenGL ES Database - MySQL - SQL Lite - Core Data - Rest Kit We are a Team of Web Designers, PHP Programmers, HTML Developers, iPhone - iPad and Android Apps Developers, specialized open source Developers, Team Leaders, Project Managers, Quality Assurance engineers, SEO Experts, and Business Analysts. The philosophy of our Outstrip infotech is centered in the satisfaction of our clients and maintain long term beneficial business relationship. We insisted on exceeding its expectations at any moment, working close to them to obtain a solution according to its tastes and necessities. We have defined development processes that assure quality in end products. Our main competitive advantage consists in offering products with an excellent relation quality and price.

    PHP, Java, .NET, and Website Design

  • p4provider Profile Picture

    p4provider

    Islamabad,  Pakistan

    We are a software and web development company, established in 2010 with the aim to provide high quality services in all major open source technologies (i.e. Magento, Prestashop, Wordpress, Joomla, Drupal and Php/MySql ) and as well mobile technologies such as iOS ans Android. Our expert services ranges from small to medium and large scale businesses. We have successfully completed 170+ projects for small to medium and large scale organizations/ businesses at freelancer.com with great feedback and ratings. We are top the magento developers among thousands of developers We have dedicated developers and designers for the said technologies. We use core coding/designing standards & techniques and provide 100% quality and productivity work within specified time-frame accordingly. Our consultation services shape an efficient, effective and scalable online presence for eCommerce.

    PHP, Java, Python, and Script Install

  • codehard Profile Picture

    codehard

    DOHA,  Qatar

    We are Team of 30+ Coders and Designers who are Experts in Magento , Joomla , Wordpress , Drupal , HTHML 5 . We have more then 9 years experience under our belt . Rest Assured you are in good hands once we are Hired . Our key clientele includes companies from US, UK, Australia, Singapore and Denmark etc.. almost from all over the globe hence capturing international market. Our rates are very cheap in comparison to other outsourcing companies but it doesn't mean that we compromise on quality. After sales service is one of the strongest offering at CodeHard., which includes regular follow-ups and continuing online support to our clients.

    PHP, Perl, Javascript, and Cold Fusion

  • vinoj90 Profile Picture

    vinoj90

    Ja-Ela,  Sri Lanka

    I would like to develop E commerce Web Applications using Magento

    PHP, Java, XML, and AJAX

  • bistanil98 Profile Picture

    bistanil98

    Dehradun,  India

    We are a team of freelancer,in our team we have more than 11 year of experience professionals. we are expertise in web development and mobile application development.

    Java, JSP, Javascript, and J2EE

  • iclicknetwork Profile Picture

    iclicknetwork

    HCMC,  Vietnam

    Hi, Magento guru is here, i work and bid only in magento task, so please have a fair compare on reviews number, looking for long term work with magento, i can start work immediately, daily report working progress by email, skype.. No modified core files even in espacial case, 100% compatible with magento convention. Free conflict on next magento updates list of latest magento project i've done: http://elit.no/ http://www.soundgarden.no/ http://interiorkupp.no/ http://www.bixbyandball.com http://www.blueskyfun.com/ (Magento Enterprise) http://www.ewell.com.au/ http://mywineaffair.com/ (Multiple store based on Magento Pro ) http://www.asiawinesociety.com/ http://dirtbag.biz/ http://coolest-gadgets-shop.com/ http://listpornhd.com/ (Porn site) http://taw9eel.com http://phimsac.net/ http://tattoo-bodysuits.com/ http://www.sneakertraffic.com/ So i think this job will be solved soon and smooth. If you feel interest, please PM for full list of magento jobs i've done, OR simply we can go straight to talk how to start your project list detail of lastest magento projects: - http://elit.no + Create quote/order feature on checkout step + Multiple store view, product have different price on different store view + - http://www.soundgarden.no/ + Create CRESCO payment gateway and integrate it into Magento + Customize shipping method + Update product price and stock via a remote webservice + Customize product gallery and product detail view - http://interiorkupp.no/ + Develope shipping method based on product shipping setting: package / roll / unit per package/roll etc... + Update product price and stock via a remote webservice + Customize product gallery and product detail view -http://www.blueskyfun.com/ (Magento Enterprise) + Build extension amazon fulfillment service for magento + Build extension allow and calculate shipping methods from amazon full fillment service + Customize product themes, install gallery extension + Customize new cart promotion rule to work with specific coupon codes - http://mywineaffair.com/ (Multiple stores based on Magento Pro): - http://www.asiawinesociety.com.sg (sub website) + Private sales with special price for customer + Invited customer only + Integrate calendar event for special events/campaign + New system price based on customer group (Membership / Normal customer) http://listpornhd.com/ - Auto import product script - over 3000 products video - Improve magento speed http://coolest-gadgets-shop.com/ - Multiple product currency - Over 2000 products in phone accessory and hightech stuff - Extension installed: Ajax add to cart - http://deb.iclicknetwork.com/home.html + Design the site + Integrate new design to magento + Customize product properties (3 properties can be filtered in left navigator block ) + Customize price list (Must login to see price) + Multi tier prices for product + Setup promotions: Add new catalog price rules + Huge import product (1014 products in 6 categories) + Customize left shoping navigator + Setup Payment gateway (Google Checkout, Paypal Bussiness pro, Purchase order) + Setup Shipping rule (shipping cost based on weight of cart items), and Shipping methods (DHL, USPS) + Customize order email templates - http://dirtbag.biz/ + Intergrated new theme design to magento + Customized the one page checkout (Add alternative shipping address in some specific cases, ) + Developed new Payment gateway for magento (TCLLink) + Developed product export feature in backend with speacial requires. + Setuped product tax + Setuped promotions: Add new catalog price rules + Customize shipping rules (shipping cost based on weight of cart items and free in some specific cases) + Setup Shipping methods + Customize order email templates

    PHP, Java, Javascript, and XML

  • alqurancity Profile Picture

    alqurancity

    Edinburgh,  Pakistan

    I have confident that I will do your work very well. I hope you would like my work and you will give me a good feedback which is very important for my future carrier here.

    PHP, Java, Script Install, and Website Design