This wizard lets you export either your whole product catalog or its single category to a CSV file. The modified CSV file can be imported back into the product catalog with the Product Import wizard. This offers a much quicker way to update your product catalog than manual editing.
IMPORTANT! Not every product attribute can be exported to a CSV file. Please see the Product Import help page for the list of supported attributes. Attributes not listed in the table cannot be edited in the way described above.
Step 1 of 3. Select Category to Export
In this step, you should choose a category to export. Select the necessary category using the Category to export box.If you want to export its subcategories as well, select the Include subcategories? checkbox.
The top-level store category is selected by default (usually it is called Home), including all of its subcategories. This implies that the entire products catalog is to be exported.
|Category to export||This is the category whose products will be exported. If you want to export its subcategories as well, select the checkbox "Include subcategories?"|
|Include subcategories?||If this checkbox is selected, all subcategories contained in the category selected to export will also be exported.|
Step 2 of 3. Select Attributes to Export
In this step, select which product attributes should be exported. If you don't need to edit some of the product data, simply clear the checkbox of the corresponding attribute. The resulting CSV file will not contain the corresponding column.
CSV file is a text file, so images are exported separately. If you choose to export images, the system can either copy them to a separate directory on the server or compress them to a TAR file in that directory or let you download it to your local computer. Select the option that is most convenient for you. If you select to put images to a server directory, specify the directory with the browser (the directory must already exist).
The images can then be modified, re-compressed to a TAR file and uploaded back to the server. TAR archives are supported by most compression software. If your compression software doesn't handle TAR archives, you can download the free 7-Zip archiver which can make TAR files. You can also import uncompressed images from a server directory.
To begin exporting, click the Start button.
Step 3 of 3. Export
In Step 3, the actual export process is performed. Depending on the size of your product catalog, the process may take from several seconds to over 10 minutes and more. Typically, exporting 1,000 products on an average server takes about 1-2 minutes.
The Export Log displays additional information about the export process. After the export process completes, the Download CSV button becomes active. If image exporting has been performed to a TAR archive, the Download Images button becomes active as well. Click these buttons to download the exported data to your local computer.