In one of the latest update Google Chrome browser removed the option to automatically run flash files (.SWF) and currently tutorials can NOT be opened through Google Chrome. In order to use tutorials at this moment we're suggest you to use Mozilla Firefox browser.


Part 1: Simple Product Imports




 

Part 2: Configurable Product Imports




Basics



  • File name must end in 'csv or .txt

  • Comma and tab delimited files are supported. 

  • There are 2 kinds of Import Actions - Create new products or update existing products - you can only do 1 at a time.

  • You can only use 1 attribute set per file. So the same file cannot reference multiple attribute sets.

  • Import function is accessed in Manage Catalog Products >> More Options 


Caution!



  • There is no undo and no mass delete of imported products - use caution

  • Always try a small sample file first to see if you have the settings and field mapping correct.


Import Options





  • Use Saved Mapping - once your settings and field mappings are completed you can save your mapping and use it again to save time. If you have a saved mapping you can select it here and all the settings and mappings will be set in one step!

  • File Import Action - whether you will create new products or update existing ones on import

  • Do Some Items have Variants - configurable products are more complicated to import so there are a number of settings to assist you in accomplishing this task. If all your products are 'simple' set this to no, otherwise set it to yes.

  • Each Record in my File - Describe whether your file contains only simple products, only configurable products  or both.

  • Product Variants - for configurable imports describes how the configurable product and the variants are 'matched' during import. Options are described in more detail in Configurable Imports help.

  • Product Class - Inventory Products only can be imported at this time.

  • Attribute Set - Select an attribute set

  • Stores - stores included in the product scope (only these stores will see the product - for most folks the default of all stores is fine).


Advanced Settings



  • File Fields - this tells you how many fields the file parser thinks is in your file. You can use this to spot problems like extra or missing fields

  • File Separator - whether the file is comma or tab separated

  • Array Enclosed by - whether an array is noted in a field using quotes or brackets. Quotes are not allowed as an array delimiter in a comma delimited file.

  • Array Delimiter - how array fields are organised e.g. {Red|Blue|Green} would have a Pipe delimiter

  • Attribute Options - whether to skip new options as errors or add them to the list of valid options.

  • Append Options to Description - this describes the behavior of the description field being saved - If the file contains Fuzzy Sweater as a description you will want the 'Blue' and 'Extra Small' options visible set this to yes. If the file already contains a description like 'Blue Fuzzy Sweater - XS' you can set this to no.


Terms

·         Attribute – A user or system defined field that appears on a product record – like Brand, UPC, Season, Weight.

·         Configurable Attribute – an attribute used to list the configurable options of a configurable product. Usually size or color, so a size option could be Small, Medium, Large or 250ml, 500ml, 750ml.

·         Attribute Set – group of attributes used to create products. Some retailers only need 1 or 2 some need more. Best practice is make it easy for your staff to work – so if that means separate attribute sets for Footwear and Surfboards so be it!

·         Attribute Option Value – For configurable attributes and other dropdown type attributes this is the predefined list of values like ’28,30,32,34,36,38’

·         Configurable Product  - product that has configurable options such as a Shirt that comes Small, medium Large. The Shirt is a configurable product – the Small, Medium and Large product records are the simple variants.

·         Simple Variant – variations on the configurable product form which the customer can choose such as Red, Blue, Green thermos or Small, Medium, Large shirt.

·         Array – Single file import field with multiple values. Consider a product for import called ‘750ml Coffee Thermos’ which comes in Red, Blue, Green – if the color options are all in one import field it’s referred to as an array.

750ml Coffee Thermos,{Red|Green|Blue},49.95,26.75,Camping Gear

·         Comma or Tab separated – whether file fields are separated with a comma or a tab.

Basic Steps



  1. Make sure delimiter matches your file (comma or tab)

  2. Set your import options

  3. select your file

  4. Map your fields (use +Add Mapping to add more fields)

  5. Save your Mapping (optional)

  6. Click Import


Field Mapping



  • Not all fields in the file need to be mapped unmapped fields are ignored

  • Not all data has to be in the file - you can add a field and set it to a default value. This comes in handy for supplier field is the supplier is not in the file. 

  • Fields can be mapped more than once - so the same file field can be used to update description and short description or supplier and brand etc.