Data Conv Inventory Convert Attributes Report overview

Data Conversion > Reports > DCR Reports > DCICT

Function acronym: DCICT

Use this report to import product attributes from a CSV, XLS, or TXT file. The first step is to upload the file to the File Transfer Administrator screen, with the Target Type set to Data Conversion. The next step is to generate this report.

When this report is generated, the attributes and the attribute values from the CSV file are imported to the Attributes Setup screen. The attributes and products from the import file are linked based on these conditions:

  • If the isFromAI column value is set to True in the import file:

    • If the product already has an attribute name and value in application, the attribute value is not copied from the import file.
    • If the product does not have an attribute name or value in application, the values from the import file are created and linked to the product.

  • If the isFromAI column value is set to No in the import file:

    • If the product has one or more attribute values, the last value in the application is replaced by the attribute value from the import file.

The import file must include these columns:

  • Product ID: The ID of the product. This value must exist on the Product Setup screen.
  • AttributeName: The name of the attribute to be associated with the product. For example, Color.
  • AttributeNameDescription: The description for the attribute.
  • AttributeValue: The value to be assigned to the attribute. For example, Red, Green, Yellow, or Violet.
  • AttributeValueDescription: The description for the attribute value.
  • Type: The valid data type for the attribute values such as Text, Number, or Boolean.
  • Sequence: The order of processing an attribute for the product.
  • SelectedUom: The Unit of Measure (UOM) to be associated with the attribute. The UOM must exist on the SA Table Code Value Setup - Unit Conversion screen.
  • UomRequired: Indicate whether a UOM is required for the attribute during sales order creation.

  • AllowFreeFormValues: Indicate whether the attribute values can be created in free form. Possible values:

    • Yes: Allows new attribute values from the import file and adds to the Product Attributes Setup screen as new values.
    • No: Allows the attribute values from the import file, only if the value exists in the application.

  • AttributeGroup: The attribute group to which the attribute must be linked.

    Note: The specified attribute group must exist on the Attribute Group Setup screen.

  • isFromAI: Indicate whether the Gen AI tool can create the attributes. Possible values:

    • Yes: The attributes are created by the Gen AI tool, based on the product parameters, such as description, category, model, manufacturer, and brand.
    • No: The attributes are added to the Product Attributes Setup screen from the import file, based on the AllowFreeFormValues column value in the import file.
Note: The CSV template can be exported, using the IC Export Product Attributes Report screen.

Prerequisites to include AI-generated attributes in the report:

  • Procure Gen AI license.
  • Install all Gen AI services in the specific tenant.

  • Ensure that the bulk-export-attributes prompt is defined on the SA Table Code Value Setup - GenAI screen.

    Note: The prompt can be modified based on the requirement.