Data Transfer Guidelines
To improve the efficiency of the process and avoid potential problems, take a moment to review the following guidelines for exporting data from your store.
Step 1: Optimize Your Attributes
Make sure to remove any attributes from the Export list that do not need to be updated. You can speed up the process by exporting only the data that needs to be updated, and then importing it back into your catalog.
Step 2: Export and Edit
After you have optimized your attributes, export the product information. Then, open the file in your favorite spreadsheet or text editor.
- If you’re editing in a text editor, you must include each new product on a new line. The attributes that you define must be separated with commas, and must be in the same order as the first row.
- If you’re editing the data in a spreadsheet, products are organized by row, and attributes by column. The attributes associated with a product are listed below the product row.
When saving changes to the CSV file from Excel, select "Yes" when prompted to leave out incompatible features.
Step 3: Import and Refresh Index
When you have completed editing the product data, the product data can be imported back into your Magento Go store.
- The request is put in the import queue. You can check the status of the operation by pressing F5 to refresh the page.
- When the task is complete, refresh the search index. From the Admin panel, select Catalog > Search Indexing. Then, click the Refresh Index button.
Missing or Incorrect Values
The most common problem encountered when importing CSV data is missing or incorrect values. During the import process, Magento Go checks the data to make sure it is correct, and reports any items that are missing or incorrect. Be sure fix the issues and try again.
If you import a product that already exists in your catalog, it will create a duplicate product record. To avoid this, you can either import to an empty catalog, or make sure that you aren’t re-importing products which already exist in the catalog.
Custom attributes are any attributes that you create yourself. Attributes can be created for organization and product management, as well as to be used for comparing certain types of products. To learn more, see: Exporting Custom Options.