Common issues with importing/exporting
You can learn how to import your products in Magento by following the corresponding part of our tutorial:
How to Import Products in Magento
However, during the import and the export procedures different issues can occur.
The most common ones are as follows:
• Incorrect CSV file formatting - A bad formatting of a CSV file can cause a failed data import or missing rows after the import. The issue occurs more often with CSV files created with MS Excel since CSV is more prone to data failures due to bad formatting.
• Issues with short descriptions - Although you can use a custom size for short descriptions in Magento, it is recommended that you limit them to 255 characters.• Issues with import/export paths - The import/export paths should be writable. Otherwise, the corresponding procedures will fail. More details on how to set the files and folders permissions can be found in our cPanel tutorial.
• Problems with images locations - If we import images with the products, they should be stored in the /media/import folder. Otherwise error messages will be displayed and the images will not be imported. For example, if the value of the image collumn is /image_subfolder/image.jpg then the correct path will be /media/import/image_subfolder/image.jpg.
• Problems with multiple images import - The import of multiple images through CSV and MS Excel image, small image and thumbnail image columns is causing problems.
Advice on doing a bulk import of 2000+ products to my magento CE store
Looking for advice on doing a bulk import of 2000+ products to my magento CE store. The store already has over 1000 products loaded. Looking to add several thousands more products from 2-4 different vendor companies.
Q. Do the .csv files that I would use for the import, need to have the exact same column heading names as the database that the site is already using for the products already loaded?
Or put another way, can the column heading names for the .csv files from the new vendor companies, be different from the column headings being used by the product database that the site is currently using..?? Thank you to anyone that can help educate me on this.