I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing how can I import it in Magento 2. Do you have any idea?


You should read the doc about import process.

This link can be usefull too to know wich fields must be set for your usecase : https://docs.magento.com/m2/ce/user_guide/system/data-attributes-product.html

| improve this answer | |
  • Thanks for your suggestion, but I know how to import, My problem is the csv file quite complex and different structure by default Magento. and I need to know how to solve it. – MichaelHa Oct 3 '19 at 9:05
  • You must rename your csv columns and apply data transformations in order to import it into Magento. If you don't want to do it manually, or if there is too many rows, you can do it programmaticaly by reading your file, parsing/sanitizing data and print in a new well formated. I recently built a cli tool in php for this purpose, since a client needed to include thousands of products from different csv files, but you'd better to know php if you want to use it. You can find it on my github : github.com/AriartWt/csvCompiler – Ariart Oct 3 '19 at 10:05
  • Thank you, you said exactly what I need, I will try your way. Can you show me how to use your tool? – MichaelHa Oct 3 '19 at 10:08
  • I wrote a detailed documentation that can be found on the repo ( github.com/AriartWt/csvCompiler#presentation ). If you encounter a bug, or have some trouble with it, you can post an issue and i will try my best to help you. – Ariart Oct 3 '19 at 10:26
  • I have a question in my csv file there are many fields that don't exist in Magento, can your tool automatically generate it? – MichaelHa Oct 3 '19 at 10:33

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.