Domain Import Export File Structure & Layout

Prev Next

Domains in the Product Content Cloud (PCC) are represented as a set of structured files, each capturing a specific aspect of domain configuration. When exporting domains, PCC generates these files based on the structure and layout outlined below. Similarly, when importing domain data, PCC expects input files to adhere to these definitions.

Following is the complete list of domain-related files along with their purpose:

  • Domain- This is the file that represents the domain’s master data.

Example:  A domain name could be Brand.

  • Domain Property- This file contains the list of all properties (i.e., characteristics) associated with a domain.

Example: For the Brand domain, properties might include Brand Name, Brand Manufacturer, etc.

  • Domain Header Value- This file contains the list of possible values under each domain.  

Example: For the Brand domain, values could include Acme, Zeta, etc.

  • Domain Value Relationship- Describes relationships between header values across different domains using defined verbiage.

Example: The My Company Inc. value in the Manufacturer domain may be defined as the creator of Acme in the Brand domain.

  • Domain Digital Asset- Lists digital assets associated with domain master entity.

  • Domain Header Value Digital Asset- Lists digital assets linked to specific domain master header values.

All files are generated in a vertical format and, collectively, they provide a complete representation of each domain.

Note (for export): If a domain configuration lacks data for specific file types (for example, no digital assets or relationships), the corresponding files will not be included in the export.

While some files are optional based on the data available, the core four—Domain, Domain Property, Domain Header Value, and Domain Value Relationship—will always be generated during a full export if the data exists.

File structure: Domain

No.

Column Heading

Required?

Description

Domain Name

Required

Name of the domain, for example: Brand.

The name must be unique and case sensitive.

Delete flag

Optional

This column is relevant for imports only.

Valid values are:

  • A -> Indicates that the domain should be added or updated in PCC using the data provided in the file.

  • D -> indicates that the domain should be deleted from the catalog into which it is being imported. PCC will verify that the domain is not associated with any SKUs before allowing deletion. If the domain is in use, it will not be deleted.

  • Blank -> A blank or empty value is interpreted by the system as value “A”.

Is Restricted Value List

Required

Indicates whether the domain restricts entries to a predefined list of values.
Following are the accepted values which are case insensitive:

  • Y (Yes) or N (No)

  • 1 or 0

  • true or false

Product 360 Display Tab

Optional

Determines how the domain is displayed in Product 360 view.

Accepted values (case-insensitive): Individual or Common.

If left blank, the default value is Common.

File structure: Domain Property

No.

Column Heading

Required?

Description

Domain Name

Required

Must match an existing domain name either within the same import file set or in the database. This value is case sensitive.

Property Name

Required

Name of the property, for example: Tagline, Country of Origin. Must be unique within the domain.

Property Datatype

Optional

The following is the list of valid values:

  • String

  • Decimal

  • Integer

  • DateTime

A blank or empty value is interpreted by the system as String. All the values are case insensitive.

Is Required

Required

Indicates if the property is mandatory. Following are the accepted values (case-insensitive):

  • Y (Yes) or N (No)

  • 1 or 0

  • true or false

Is Enforce LOV

Required

Specifies whether the property must use a predefined list of values.

Following are the accepted values (case-insensitive):

  • Y (Yes) or N (No)

  • 1 or 0

  • true or false

Allow Multivalues

Required

Indicates whether the property supports multiple values.

Following are the accepted values (case-insensitive):

  • Y (Yes) or N (No)

  • 1 or 0

  • true or false

Is Enforce Datatype

Required

Determines if the property value must match the specified datatype.

Following are the accepted values (case-insensitive):

  • Y (Yes) or N (No)

  • 1 or 0

  • true or false

Minimum Value or Length

Optional

This field serves a dual purpose.

If “Property Datatype” (field #3) is String, then this field should be a positive integer indicating the minimum character length restriction.

If “Property Datatype” (field #3) is Decimal or Integer, then this field can be any valid number indicating the minimum numeric value restriction.

Leave this field blank if no minimum value restriction is needed. A value of 0 (zero) is not acceptable.

Maximum Value or Length

Optional

This field serves a dual purpose.

If “Property Datatype” (field #3) is String, then this field should be a positive integer indicating the maximum character length restriction.

If “Property Datatype” (field #3) is Decimal or Integer, then this field can be any valid number indicating the maximum numeric value restriction.

Leave this field blank if no maximum value restriction is needed. A value of 0 (zero) is not acceptable.

List of Values

Conditional

Required only if Is Enforce LOV = Y.

This column should contain a list of allowed values for the property, separated by double pipes (||).

Example: Red||Blue||Green defines three valid values for the property.

File structure: Domain Header Value

No.

Column Heading

Required?

Description

Domain Name

Required

Must match domain name either in the same import vertical file set or in database.

The entered value is case sensitive.

Domain Header Value

Required

A specific data value for this domain. For example, if the domain is Brand, valid header values could be Nike, Apple, or Zara.

Value Effective Start Date

Optional

The effective start date for the header value. This can be a future date. The date must be in the format YYYY-MM-DD.

Example: 2025-12-05.

Defaults to today (current date) if the value is blank.

Value Effective End Date

Optional

The effective end date for the header value. This must be a future date. The date must be in the format YYYY-MM-DD.

Example: 2027-01-15.

Defaults to 2099-12-31, if the value is blank.

Property Name

Required

Must match a property defined for this domain either in the same import vertical file set or in database. The entered value is case sensitive.

Property Value

Optional

This is actual value in this property for this header value.

Example: For domain name Location, assume there is a property named Address City. For header value Head Office, this field can contain Chicago.

File structure: Domain Value Relationship

No.

Column Heading

Required?

Description

Domain Name 1

Required

First domain in the relationship. Must exist in the same import vertical file set or in database. Example: Manufacturer.

The value entered is case sensitive.

Domain Header Value 1

Required

Must match domain header value under Domain Name 1, either within the same import vertical file set or in database.

Example: My Company Inc. under Manufacturer.

The value entered is case sensitive.

Domain Name 2

Required

The name of the second domain in the relationship. Example: Brand.

Must match domain name either in the same import vertical file set or in database.

The value entered is case sensitive.

Domain Header Value 2

Required

Must match domain header value under domain name 2, either within the same import vertical file set or in database. For example, Acme under the Brand domain.

Please note the domain name and value combination for “2” (field #s 3 & 4) cannot be the same the domain name and value combination for “1” (field #s 1 & 2).

Relationship Verbiage 1 to 2

Required

Descriptive text for the relationship from Header Value 1 to Header Value 2 (max 200 characters).

Relationship Verbiage 2 to 1

Required

Descriptive text for the relationship from Header Value 2 to Header Value 1 (max 200 characters).

File structure: Domain Digital Asset

No.

Column Heading

Required?

Description

Domain Name

Required

Must match domain name either in the same import vertical file set or in database.

The entered value is case sensitive.

2.

Delete flag

Optional

Valid values are:

A -> Link this asset to this domain.

D -> Delink this asset from the domain.

Blank -> Treated as A.

3.

Digital Asset URL

Required

A publicly accessible URL pointing to the digital asset such as image, video, file, etc.

File structure: Domain Header Value Digital Asset

No.

Column Heading

Required?

Description

1.

Domain Name

Required

Must match domain name either in the same import vertical file set or in database.

The entered value is case sensitive.

Domain Header Value

Required

A specific data value for this domain. Must match domain name either in the same import vertical file set or in database.

For example, if the domain is Brand, valid header values could be Nike, Apple, or Zara.

3.

Delete flag

Optional

Valid values are:

A -> Link this asset to this domain header value.

D -> Delink this asset from the domain header value.

Blank -> Treated as A.

4.

Digital Asset URL

Required

A publicly accessible URL pointing to digital assets such as image, file, etc.