For a client i need a solution to import 10.000 products (daily).

He gets a CSV or XML (both available) through FTP on a daily base.

The CSV file has custom headers.

There a no Magento default row names, “sku” for example is called “Productid” and rows needed for a product import like “status” and “website” are not there at all.

What would be the best workaround to import these products?

  • 1
    If this has to be done on daily basis, create a custom cron process to read the file from FTP, interpret it as per requirements, set some default parameters like status, store etc and then update products programmatically.
    – Prateek
    Nov 9 '15 at 13:04

You will need to grab the file from your vendor, then transform the file to meet the basic requirements for the Magento import.

Then via a night cron job you can import your file to Magento. You should report errors via an email alert or alert in the Magento admin section to warn the administrator of the issue.

  • The file get send to a location in the Magento root folder. How to transform the file and set default parameters that don't get provided in the CSV / XML?
    – RoRo
    Nov 9 '15 at 13:26
  • You will have to create a custom module that imports, then transforms your csv or xml Nov 9 '15 at 13:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.