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
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 =)
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
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.
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.
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.
Ja-Ela, Sri Lanka
I would like to develop E commerce Web Applications using Magento
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.
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
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.