Difference between revisions of "Import Products"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 3: Line 3:
To import [[Products]]:
To import [[Products]]:
#Click '''Settings > Data Management > Import Data > Products'''
#Click '''Settings > Data Management > Import Data > Products'''
#In the Import Products page, Upload CSV File tab, click the [Browse] button to locate the product file you want to upload
#In the Upload CSV File tab, click the '''[Browse]''' button to locate the product file you want to upload
#If you have created a map profile previously that maps the columns in the imported file to the fields in product records, select it from the Mapping Profile list
#If you have created a Mapping Profile previously, select it from the Mapping Profile list.<br>(A ''Mapping Profile'' maps the columns in the imported file to the fields in product records.)
#Click the Next button. If you selected a Mapping Profile, it automatically maps the columns in the selected file to fields in the product record, and displays the association in the Map Columns tab.  
#Click '''[Next]'''.<br>If you selected a Mapping Profile, it automatically maps the columns in the selected file to fields in the product record, and displays the association in the Map Columns tab.  
#If your file contains additional columns that you can map to existing fields, select them
#If your file contains additional columns that you can map to existing fields, select them
#Click the [Next] button, and click OK to confirm that the mapping options you selected are correct
#Click '''[Next]'''.<br>.
#Click '''[OK]''' to confirm that the mapping options you selected are correct
#In the Set Attributes tab, select the option to merge the new record with an existing record if you are updating your database and don't want to create duplicate records
#In the Set Attributes tab, select the option to merge the new record with an existing record if you are updating your database and don't want to create duplicate records
#To save the profile under a new name, enter the Mapping Profile Name and enter a new Mapping Profile Description
#To save the profile under a new name, enter the Mapping Profile Name and enter a new Mapping Profile Description
#Click the [Start Import] button to import the data into the platform, or click the [Save Profile & Exit] button to save this mapping profile and import the file later.  
#Click the '''[Start Import]''' button to import the data into the platform.
#Alternatively, click '''[Save Profile & Exit]''' to save this mapping profile for later use.  


If you import the file now, the progress appears in the import processing queue in the Products tab.
If you import the file now, the progress appears in the import processing queue.

Revision as of 21:55, 18 July 2011

The products must be imported as a CSV (comma-separate value file).

To import Products:

  1. Click Settings > Data Management > Import Data > Products
  2. In the Upload CSV File tab, click the [Browse] button to locate the product file you want to upload
  3. If you have created a Mapping Profile previously, select it from the Mapping Profile list.
    (A Mapping Profile maps the columns in the imported file to the fields in product records.)
  4. Click [Next].
    If you selected a Mapping Profile, it automatically maps the columns in the selected file to fields in the product record, and displays the association in the Map Columns tab.
  5. If your file contains additional columns that you can map to existing fields, select them
  6. Click [Next].
    .
  7. Click [OK] to confirm that the mapping options you selected are correct
  8. In the Set Attributes tab, select the option to merge the new record with an existing record if you are updating your database and don't want to create duplicate records
  9. To save the profile under a new name, enter the Mapping Profile Name and enter a new Mapping Profile Description
  10. Click the [Start Import] button to import the data into the platform.
  11. Alternatively, click [Save Profile & Exit] to save this mapping profile for later use.

If you import the file now, the progress appears in the import processing queue.