1.

Before you begin, make sure that all changes to the product data have been saved.

2.

On the Admin menu, select System > Import/Export > Dataflow - Profiles.

3.

In the list of profiles, select Export All Products.

4.

In the panel on the left, click  Run Profile.

5.

To begin the process, click the Run Profile in Popup button.

6.

Wait a few moments for the profile to begin execution. The length of time it takes to complete the process depends on the size of the database. Do not close the window.

7.

When the process is complete, you can find the exported CSV file in the following location on the server:

• [magento-install-dir]/var/export/export_all_products.csv

Here’s how the exported data file looks from the command line of the server:

8.

Use an SFTP utility to download the export_all_products.csv file from the server to your desktop.

9.

Then, open the file in any editor that supports UTF-8 encoding, such as Notepad++ or OpenOffice Calc. To open the CSV file in OpenOffice Calc, specify a comma as the separator, and double quotes as the text delimiter.

The CSV data appears in the spreadsheet as rows of product records organized into columns of attributes, with the Attribute Code in the header of each column.

The CSV file contains a path to each product image, but the actual image files must be uploaded to the server. To make the images available to import, place them in the media/import directory.

• [magento-install-dir]/media/import

Use your SFTP utility to copy the product images that you want to import to the media/import folder.

1.

Edit the data as needed.

2.

Save your changes to the CSV file.

For this example, we will add three new images to SKU #hdb005. Because this is the only product record that we’re going to update, the others can be deleted from the CSV file.

Currently, this product has only one image that is used for the base image, small image, and thumbnail. Because we’re going to now offer this product in three colors, we need to upload an image for each color, and replace the image that’s currently assigned to the product. Because this is a simple product, we can later use Custom Options to add an option for each color.

Magento creates a directory structure of product image files that is organized alphabetically. You can see that path before each image file name in the CSV data. However, when you import images, you must never include that path before the file name. The only thing you have to do is to enter a forward slash before the file name of each image that you want to import. Magento takes care of the rest. For this example, we need to add the three image files that were uploaded to the media/import folder.

• /hdb005_HOTP_600.jpg /hdb005_MARM /hdb005_SALM_600.jpg

In the data, we will replace the original image file name, and add the other two image file references on separate blank lines. just below the original row. You must also enter the SKU on each additional line, to associate the images with the product.

1.

On the Admin menu, select System > Import/Export > Dataflow - Profiles.

2.

In the list of profiles, select Import All Products.

This general-purpose profile that can be used to import or update any number or product records.

3.

In the panel on the left, select Upload File.

4.

Because we’re uploading only one file, click the Browse button for File 1. Then, find the file on your computer and click to select it. The path to the file appears in the input box.

5.

Click the Save and Continue Edit button.

6.

In the panel on the left, select Run Profile.

7.

Select the CSV file that you edited. If there are several files in the list, make sure to select the right one. Then, click the Run Profile in Popup button.

8.

Wait a few moments for the profile to begin the import process. Do not close the window or interrupt the process. Look for the “Finished Profile Execution” message at the bottom of the list when the import process is complete. If you receive an error message, correct the problem in the CSV file, and try again.

Usually the index needs to be updated after changes are made to product data. If you receive a message that the indexes are out of date, click the link and update the index.