How to add/edit/remove products using the import/export tool

Last modified by Pokerspullen on Thu, June 24, 2010 16:18
Source|Old Revisions  

This is an old revision of the document!

The import/export tool is very useful within magento. Being that there is limited documentation on the topic, I thought I would add my .02.

Basically you can use the import/export tool to do mass imports of products. It makes it much easier if you would like to add 50 products all at once, you would just create a csv or xml file with the matching fields for the database, add your information and then use the import tool to import the products. You can retrieve a sample csv or xml file, but doing an export.

Doing an export is very easy, and allows you to export all of your products out of your website. You might want to do this, if you are moving your website or need to reinstall or upgrade your website, and need to get the products out.

How to export

In the Magento Admin, go to System > Import/Export > Profiles. The name may seem a little confusing at first, but once you realize you can import/export everything, you see why there’s nothing like “Export products” in the menu.

Something you might want to do is export the products that were added on a development server to an actual production server (or vice-versa). Luckily, a profile for exactly that is present in the standard install of Magento, and it’s called Export all products. Click on Edit to open it.

Two things that are important are the Filename and the Path, because this tells you where Magento saves the .csv file. If Excel (or another spreadsheet editor) uses a different delimiter character, you can also set this in Data Format.

After you’ve checked everything in the Profile Wizard, go to Run Profile. Click the “Run profile in pop-up” button and wait. Magento now starts the procedure, and in the meantime you can open you FTP client and navigate to the folder (the folder for this profile is /var/export). You’ll see a CSV file appear; when Magento is finished, download the CSV file to your computer.

How to import

In the default installation, there’s also a profile called “Import all products”. To get there, just go to System > Import/Export > Profiles. Click “Edit” for the profile called “Import all products” (again, this should be present in the default install).

Go to the Upload File tab and select the CSV file you’ve downloaded from the FTP after exporting. Make sure you have the right one - if they don’t match, you’ll get errors.

Click Save and Continue Editing. This uploads the CSV file. Then, go to the Run Profile tab, choose the CSV file in the dropdown and click “Run Profile in pop-up”.