Import Export Products

  • Magento 1- Troubleshooting Import Export Products extension's errors

    • Q-1: I am getting “Unable to open file!” error?

      Ans: This error comes because of your magento setup not having “import” and “export” folder in var directory. This both folder recommended for run extension. So please create it.

    • Q-2: I am not able to see your extension in admin menu bar.

      Ans: Please clear cache once and re-login to your admin once. If you still not getting extension menu bar in admin panel then please Disable compilation/recompile.

    • Q-3: Products import working fine but QTY showing blank. How i can solve?

      Ans: This is caused by improper CSV format. Please use openoffice.org calc spreadsheet application and saving in UTF-8 format. OR Please use Google Doc for Convert Your CSV in UTF-8 format.

    • Q-4: What I do when products import going correctly with no single errors but they don't show on font-end until I re-edit and save it?

      Ans: It’s because you are missing the “options_container” column in your csv and its values. These are required and it’s recommended not to change or remove columns or remove it.

    • Q-5: How to create or manage parent and child category?

      Ans: Here some string mention for category column. Explained bellow.

      Category Column String : Parent Category, Parent Category/Child Category, Parent Category/Child Category/ Sub Child Category

      Parent Category: If you use this string then it will create Parent Category.

      Parent Category/Child Category: If you use this string then it will create Parent Category first, then it will create Child Category.

      Parent Category/Child Category/ Sub Child Category: If you use this string then it will create Parent Category first, then it will create Child Category and then create Sub Child Category.

      Note: You can also define category ids if you already created categories. But for that you need to change header from categories to category_ids.

    • Q-6: Import Screen Showing” Fatal error: Call to a member function getId() on a non-object” ?

      Ans: This error comes because of you not created attribute which you mentioned in CSV. OR attribute is not assigned to attribute set.

    • Q-7: Import Screen Showing” Fatal error: Call to a member function getAttributeCode() on a non-object” ?

      Ans: This error comes because of you not created attribute which you mentioned in CSV. OR attribute is not assigned to attribute set.

    • Q-8: How many validation log and import log , can I see ?

      Ans: You can just see last validation and import log. If want to keep validation/import log , then you can export it from validation or import tab in CSV format.

    • Q-9: I am getting max execution time error, what I have to do?

      Ans: If you getting time out error then you have to increase your server max execution time. For that you have to consult you hosting support team.

    • Q-10: I am getting “ 'var/export' directory does not exist !” error?

      Ans: This error comes due to var/export directory does not exists or not having write permission.

    • Q-11: I am getting “ 'var/import' directory does not exist !” error?

      Ans: This error comes due to var/import directory does not exists or not having write permission.

    • Q-12: I am getting below error while try to import the products.

      Ans: This error occur becasuse of your csv file is not properly created or converted in UTF-8 Format. So you have to convert your csv file in UTF-8 format for resolve this error. For Convert your file in UTF-8 please follow below steps.

      Using Google Sheets:

      • Go to https://www.google.co.in/sheets/about/ login using your gmail account. Click on Blank.
      • Go to File -> Open and upload your file.
      • After upload your file File -> Download as -> Comma-seperated values (.csv, current sheet)
      • Your file will be start downloading.

      Note: Don't forget to remove space from file name.

    • Q-13: Image not importing when path propely define in CSV image fields.

      Ans: For import or update images properly you have to define four image related columns in your csv file. "image" , "small_image" , "thumbnail" and "gallery". No matter there is value in gallery column or not but you have to define it.

    • Q-14: I am getting below error while try to import the products.

      Ans: This error occur when you deleted default Magento store and our extension not able to find out your store code. When you get this error then please contact our support team regarding this issue.

1 Item(s)