Exporting Product or Customer Information

If you want to make changes to multiple product or customer records, it is often more efficient to do so in a tabular interface, such as a spreadsheet. With Magento Go’s Export and Import tools, you can do just that. First, you export the data from your store to a spreadsheet file. After you add or update the records in the spreadsheet, you can re-import the data back to your store.

Exporting Customer Information

To export customers, do the following:

1. In the Admin Panel, click System > Import/Export > Export.
2. Select Customers from the Entity Type drop-down menu. The system generates entity attributes that are relevant to customers.
3. Click Continue to export your customer data to a comma-separated values (CSV) file type.
4. Open the saved file in your favorite spreadsheet application and edit as needed.

Exporting Product Information

To export product information, do the following:

1. In the Admin Panel, click System > Import/Export > Export
2. Select Products from the Entity Type drop-down menu. The system generates a list of entity attributes that are relevant to your products.
3. By default, all attributes are exported to the CSV file. In the Entity Attributes list, select the Skip check box for any attributes that you want to exclude from the CSV file.
4. By default, all records are exported to the CSV file. Use the controls in the Filter column to limit the records that are exported.
5. Click Continue to export your selected product information to a CSV file.
6. Open the saved file in your favorite spreadsheet application and edit as needed.

TIP: The Macintosh version of Microsoft Office supports multiple CSV file formats. When saving your CSV file, be sure to save it as a CSV (MS Windows) file type.