A comma-separated value file is a text data file with each field separated by a comma. Magento Go uses the CSV file format to import and export product and customer information. The basic steps include:
To optimize the selection of attributes, include only those which contain data that you need to import or export.
System attributes are product attributes that are required by Magento Go for functionality and product management. These attributes cannot be deleted. They include the following:
|name||The name of the product. This name is visible on your product description page as well as anywhere this product is listed. It is used by customers to identify the product.||Text||Yes|
|description||Description of the product. This is an important field, especially as a selling tool, because it is the main way customers learn about the product.||String||Yes|
|short_description||A shorter description of the product that customers will immediately see when viewing the product description page.||Text||Yes|
|sku||The Stock-Keeping Unit. This is the unique alphanumeric identifier that you use to track this product and its quantity in your inventory system.
Note: SKU supports up to 64 alphanumeric characters. Import will fail if it encounters SKU values that are more than 64 characters.
|_type||Specifies the type of product. This field indicates whether this product is a simple or complex product—complex products being those that require additional configuration. Product types include:
|weight||The product weight in ounces.||Numeric value||Yes|
|news_from_date||This field specifies the “from” date that the product is considered new, and would be featured in your “new products” listings.||Date and Time||No|
|news_to_date||This field specifies the “to” date that the product is considered new, and would be featured in your “new products” listings.||Date and Time||No|
|_product_websites||Refers to the Main Website in the Manage Stores section.||base||Yes|
|status||If set to “enabled (1),” the product will be available for sale in your store. If set to “disabled (2),” the product will not appear in your catalog.||1, 2||Yes|
|url_key||The URL key (or the product identifying portion) of the product’s web address. For example, if the URL key is “my-sample-product,“ then the address might be: “example.gostorego.com/category/my-sample-product.html”||Text||No|
|visibility||Specify whether this product is visible from the catalog, search, both, or neither.||1 = Not visible individually
2 = Catalog
3 = Search
4 = Catalog, Search
|gift_message_available||Determines if a message can be included with the product purchase. If left blank, the default configuration is used. Options include 0=Yes / 1=No. (See: System > Configuration > Sales > Gift Option )||Yes/No
[blank]= (uses default)
|is_imported||Determines if the product can be included in RSS feeds. Options include 0=Yes / 1=No.||Yes/No
|price||The price the product is on sale for.||Numeric value||Yes|
|special_price||The special sale price for the product during the special sale period.||Numeric value||No|
|special_from_date||This field specifies the “from” date that the product will be on sale for the special sale price.||Date and Time||No|
|special_to_date||This field specifies the &ldquop;to” date that the product will be on sale for the special sale price.||Date and Time||No|
|tax_class_id||Specify the tax class ID, which will determine which tax rules to apply to the product.||Integer based on id # next to each product tax class. (Admin > Sales > Tax > Product Tax Class)||Yes|
|enable_googlecheckout||Determines whether the product can be purchased using Google Checkout. Options include 0=Yes / 1=No||0=Yes / 1=No
|meta_title||The meta title of the product. This meta title is not visible on your web store, only to search engines.||Text||No|
|meta_keyword||The meta keywords of the product. These keywords are not visible on your web store, only to search engines.||Text||No|
|meta_description||The meta description of the product . This description is not visible on your web store, only to search engines.||Text||No|
|image||The URL (address) of the base image, or the main image of the product that is displayed when customer clicks the image in the description page.||URL||No|
|thumbnail||The URL (address) of the thumbnail image, or the product image that is shown in product listings.||URL||No|
|small_image||The URL (address) of the small image, or the image that will be displayed in the product description page.||URL||No|
|custom_design||If you want to use a custom design for the product description page, specify it in this field.||No||No|
|custom_design_from||The date to begin using the custom design for the product description page.||Date and Time||No|
|custom_design_to||The date to stop using the custom design for the product description page.||Date and Time||No|
|custom_layout_update||Use custom XML to modify the product description page layout.||XML||No|
|page_layout||Specify the layout of the product description page using a predefined layout.||No layout updates
2 columns with left bar
2 columns with right bar
|options_container||If this product has options, this field specifies whether these options will be displayed in the product information column or in the block below the price.||Product Info Column, Block After Info Column||No|
|allow_open_amount||Specify whether the dollar vale of the gift card can be specified by the customer.||Text||Yes|
|open_amount_min||The minimum gift card amount if the gift card allows open amounts.||Numeric value||No|
|open_amount_max||The maximum gift card amount if the gift card allows open amounts.||Numeric value||No|
Preloaded attributes are product attributes that are not required by Magento Go, but are included by default. These attributes can be deleted. They include the following:
|color||The color of the product. This is especially useful for identification and description when you have multiple colors of the same product.||Text||No|
|cost||The cost of the product. For internal purposes only.||Numeric value||No|
|manufacturer||The name of the manufacturer of the product. This field can be used by customers to narrow search results to specific manufacturers.||Text||No|
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. For example, a store carrying electronics, including hard drives, would certainly want to create a disk space attribute that would be used to define and compare hard drive storage sizes.
To learn more about creating attributes, read Defining Attributes.
After you have optimized your attributes, export your product information. Directions for how to do this can be found by reading Exporting Product or Customer Information. Once exported, open this file in a Microsoft Excel or a simple text editor.
If you’re editing the 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 in Excel, each product will be on a new line. The attributes that you define will fall into the column of the attribute that is listed in the first row. When saving changes to the CSV file that you edit in Excel, it is absolutely critical that when Excel asks you what format you wish to save, select Yes to leave out incompatible features.
Finally, after you have defined and saved your products in the CSV file, import them back into your Magento Go store. To learn how to do this step-by-step, read Importing Product or Customer Information.
After you have imported your new products, it will be queued to import. This may take a little while, so be patient. You can check the status of this by refreshing the page. Once the Import products task has finished, you must refresh the search index. To do this, go to Catalog > Search Indexing and click Refresh Index.