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

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 =)

Skills: Magento, PHP, Visual Basic, XML

See more: xml use case, vendor product, use case map, use case extension, the data supplier, purpose of use case, new pig, a solution, magento ftp import, i want to do own business, how to create product, xml supplier, xml file to csv for magento import, remotely, product vendors, product data, pig, pig on a, php remotely, magento update 18 to 2, Magento product import, import two, flat map, ecommerce solution, ecommerce product data

About the Employer:
( 150 reviews ) Los Angeles, Mexico

Project ID: #4124264

8 freelancers are bidding on average $13/hour for this job


Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

$15 USD / hour
(81 Reviews)

Hi, I'm Magento guru, just check my reviews about magento works, i've check your requirement, please check my PMB for further details

$25 USD / hour
(61 Reviews)

For more details please check PMB... Thanks

$8 USD / hour
(22 Reviews)

PHP expert with Magento API.. check pm pls!

$10 USD / hour
(58 Reviews)

Please check in PM.

$15 USD / hour
(9 Reviews)

We are Magento Experts and are in business since 2006 and have developed more then 300+ Magento Projects . Lets get this Magento project done and you will not be disappointed . Please check your PMB

$8 USD / hour
(7 Reviews)

please check latest magento work done Thanks

$8 USD / hour
(2 Reviews)

I am interested to perform this job. You can select me for a good result. I will work until you get 100% satisfaction. This project is best match with my profession and experience.

$8 USD / hour
(1 Review)

We are interested in your projects. We have been had more than 6 years experiences in developing HTML5/CSS3, Magento

$10 USD / hour
(0 Reviews)

We are the company with more then 6 years experience in Magneto. How we see that you can check in your PM, where we described everything in details.

$15 USD / hour
(0 Reviews)