Versions Compared

Key

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

...

Configure Products Master Table Fields

We recommend to set up the column labels, names and data types according your dataset, as it is the way how it will be used and shown in the solution. Here is an example.

Configure the field Attribute1

  1. To open the field context menu, right-click the label of the Attribute1 column, or click the three dots (this button appears only when you hover over the column label).

    menu rename and customize
  2. Click Rename and Customize Column. A dialog will open.

    dialog rename and customize
  3. Rename the field to "ProductFamily" (no spaces allowed in names).

  4. Set the label to "Product Family", as it was in the data file.

  5. Set the Type to String.

  6. Cclick Click Confirm Changes. A confirmation will come up, so confirm the change.

  7. Repeat the steps above for all the other columns in the CSV file using the following assignments (set both Name and Label for each field, Name still cannot have spaces).

    1. Attribute2 = Business Unit

    2. Attribute3 = Product Category

    3. Attribute4 = Product Group

    4. Attribute5 = Product Type

    5. Attribute6 = Product Class

    6. Attribute7 = Discount Family

    7. Attribute8 = Industry

    8. Attribute9 = Product Group Id

Some of the columns in your data file will be aligned with some of the columns that are provided in the Products master table out-of-the-box. See the previous section about mapping. For such fields you can change only labels.

  1. Change the label of the SKU.

    1. To open the field context menu, right-click the label of the Attribute1 column, or click the three dots​ (this button appears only when you hover over the column label).

    2. Click Rename and Customize Column. A dialog will open.

      dialog rename and customize sku
    3. Change the Label to "Product Id".

    4. Keep the setting of Required as it is (most fields are not required).

    5. Click Confirm Changes. A confirmation will come up, so confirm the change.

  2. Repeat the steps above for all the other columns in the CSV file using the following assignments:

    1. label – set label "Product Name"

    2. unitOfMeasure – set label "UOM"

    3. currency – set label "Product Currency"

...