Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Populate an Excel spreadsheet with Master codes and attribute data (no header row), as detailed below.
  2. Enter data in a tab-delimited format in columns A-C as:
    1. ProductCode[tab] - Master product code from PRONTO
    2. HasAttributes[tab] - Y = Yes, N = No
    3. AttributeList - The list of attributes expressed as AttributeTitle(AttributeListType{D/R}):AttributeValue,AttributeValue;AttributeTitle(AttributeListType{D/R}):AttributeValue,AttributeValue
       
    Info
    titleAttribute List Types

    D = Drop-down list
    R = Radio buttons

    Example Product Attribute Import file

  3. Save the file as 'Text (Tab delimited) (*.txt)'.
  4. Login to Customer Self Service as an Administrator.
  5. Navigate to 'Content' --> 'Product Attribute' (ProductAttributemaintenance.aspx)
  6. Click the 'Attribute import' tab.
  7. In the 'Product attributes' window, click the 'Choose File' button.
  8. Browse to the saved .txt file.
  9. Click 'Upload product attribute details'. A confirmation message will be displayed on screen after import.

...

  1. Populate an Excel spreadsheet with Master codes and attribute combinations (no header row), as detailed below.
  2. Enter data in a tab-delimited format in colums A-D as:
    1. ProductCode[tab] - Master product code from PRONTO
    2. AttributeTitleValueSeq[tab] - AttributeTitle:AttributeValue;AttributeTitle:AttributeValue
    3. AttributedProductCode[tab] - Final product code from PRONTO (this is what goes on the sales order and determines pricing and availability)
    4. CreateLineNote - Y/N - If no attributed product code has been set up, but the attribute combination is available, a 'Y' in this field will prompt the system to add the Master code to the sales order with a Line Note detailing attribute values.
  3. Save the file as 'Text (Tab delimited) (*.txt)'.
  4. Login to Customer Self Service as an Administrator.
  5. Navigate to 'Content' --> 'Product Attribute' (ProductAttributemaintenance.aspx).
  6. Click the 'Attribute import' tab.
  7. In the 'Product attribute configuration / SKU' window, click the 'Choose File' button.
  8. Browse to the saved .txt file.
  9. Click 'Upload product attribute SKU details'. A confirmation message will be displayed on screen after import.

 

Example Product Attribute SKU Details spreadsheet

Attribute Import - SKU Configuration - success messageImage Added

 

Content by Label
showLabelsfalse
max5
spacesDRAFTKB
sortmodified
showSpacefalse
reversetrue
typepage
labelsimport attributes