indexing

Step 5: Update the Index

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.

dataflow-import-all-products

Step 4: Import the Products

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 …

update-the-csv-file-with-the-import-data

Step 3: Edit the CSV File

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 …

dataflow-import-images-sftp

Step 2: Copy the Product Images to the Server

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.

dataflow-run-profile

Step 1: Export All Products

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 …

dataflow-profiles

Dataflow

Magento Dataflow is a data exchange framework that can be used by both merchants and developers. The basic Dataflow tool includes preconfigured profiles that make it easy to import and export product and customer data. The profiles can be used as they are, or be modified to meet your needs. You can create additional profiles for operations that are performed …

data-export-entity-attributes

Exporting Data

The best way to become familiar with the structure of your database is to export the data and open it in a spreadsheet. Once you become familiar with the process, you’ll find that it is an efficient way to manage large amounts of information. To export customer or product data: 1. On the Admin menu, select System > Import/Export > …

default-magento-product-importer

Importing Product Images

Multiple product images of each type can be imported into Magento, and associated with a specific product. The path and file name of each product image is entered in the CSV file, and the image files to be imported are uploaded to the corresponding path on the Magento server or external server, or uploaded to Media Storage. Magento creates its …

import-settings

Importing Data

Data for all product types can be imported into the store, with the exception of bundle and downloadable products. In addition, you can import customer data, and product images. During the validation process, all items are verified, including: To import customer or product data: 1. On the Admin menu, select System > Import/Export > Import. Then, do the following: a. …

uploading_products_to_magento_with_a_product_csv_excel_file_cover_image

Working with CSV Files

CSV files have a specific structure that must match the database. Each column heading must exactly match the Attribute Code of the attribute that is represented by the column. To ensure that the column headings can be read by Magento, first export the data from your store as a CSV file. You can then edit the data and re-import it …