Affiliated Distributors (AD) data feed connectors

  • Updated

Affiliated Distributors (AD) provides an easy and cost-effective way to support distributors with product data via a data feed. If you subscribe to the AD Data Feed, you must enable the connector in the Admin Console. Enabling the setting creates the default job for the AD Data Feed to work with Optimizely Configured Commerce.

If you are an Optimizely Product Information Management (PIM) customer, you do not need to follow these steps. See the Import Products into Optimizely PIM Using the Affiliated Distributors (AD) Data Feed article for more information on importing your AD Data Feed files into PIM.

The AD Data Feed Refresh job processes the .xlsx files received from AD as a part of their data feed. The ADDataFeed processor converts the files into data mapped to Configured Commerce fields. The job completes the following steps:

  1. Refresh Variant Types
  2. Refresh Variant Traits
  3. Refresh Variant Trait Values
  4. Refresh Products
  5. Refresh Product Variant Trait Values
  6. Refresh Attribute Types
  7. Refresh Attribute Values
  8. Refresh Product Attribute Values
  9. Refresh Product Specifications
  10. Refresh Product Images
  11. Refresh Documents
  12. Refresh Categories
  13. Refresh Category Product Mapping
  14. Refresh Product 360 Degree Image
  15. Refresh Category Attributes
  16. Refresh Category Images
  17. Refresh Brands

Configure the AD data feed

You need to set an SFTP or other storage location for your feed files before completing the steps below. Because AD does not provide a storage location, you must provision this separately.

Enable the AD feed connector

  1. Go to Administration > System > Settings in the Admin Console.
  2. Search for Enable AD Feed Integration.
  3. Set the Enable AD Feed Integration toggle to YES. This enables the AD Feed integration connector and creates the job definition. Default value: No. This is a global setting.
  4. Click Save.
  5. Click YES and Save when the message appears to install the Integration Job Definition for the Affiliated Distributors connector.

Create the connection

  1. Go to Administration > Jobs > Connections.
  2. Click Add Integration Connection.
  3. Enter a name for your connection (Flat File or AD Feed) in the Name field.
  4. Select the connection type from the Type Name dropdown (SFTP or FlatFile).
  5. Fill in the information for the type of connection you selected. See Create an Integration Connection for more details.
  6. Click Save.

Set the connection on the AD data feed refresh job

  1. Go to Administration > Jobs > Job Definitions.
  2. Click the Edit icon next to the AD Data Feed Refresh job.
  3. Select your connection from the Connection dropdown.
  4. Click Save. See Creating and Editing Integration Jobs for more options on scheduling and configuring your job.

Required and optional files

You must include certain files from the AD PIM in a separate storage location for the AD Data Feed connector to work.

The following table outlines the required and optional files for the connector and how the connector consumes/configures the files.

AD Pim File Data Feed Step/Job Required
AD CatAttMetadata file (Category Attribute Metadata) AD Data Feed Refresh Job. Step 1: Refresh Variant Types Yes
AD Item/Product Data file AD Data Feed Refresh Job. Step 4: Refresh Products Yes
AD Taxonomy file AD Data Feed Refresh Job. Step 16: Refresh Category Images No

You need additional file considerations for multi-language support. See the Multi-Language Product Data section for more information.

Import category images

The connector maps category images from the AD Taxonomy file IMAGE_NAME field into Configured Commerce’s Category.LargeImagePath using the NumericCode to find the correct category.

Work with your implementation partner to ensure the required AD taxonomy file is in the same location as the AD product data file. Verify that the Configured Commerce import process knows the taxonomy file name. Import category images as follows:

  1. Go to Administration > Job Definitions.
  2. Click Edit for AD Data Feed Refresh. Ensure that you have refreshed this job definition after upgrade.
  3. Go to Steps > Refresh Category Images > Edit.
  4. Find the From Clause section and update the file mask to match the name for the taxonomy file.
  5. Click Save.

Product variants

Use this feature to import the category attributes data from EnterWorks and create variant types and products in Configured Commerce.

Along with the existing AD feed product data file, you must include the AD Category Attributes feed file. This file defines which attributes signify a product variant with the IsDifferentiator field, as well as the trait data.

The Category Attribute Metadata export is a separate export that you must configure and run. You can reach out to AD’s Account Management team or email for assistance.

Multi-language product data

Use this feature to import certain product data fields from EnterWorks via separate files in multiple languages into the Configured Commerce translation fields. This feature uses the AD Data Feed Translations Refresh job, which you must run after the initial data feed refresh.

Along with the existing AD feed product data file, include the same file in the desired language. It must be a language supported by Configured Commerce translations. Insert this file into the file drop and use a name that separates it from the initial data file. See below for masking info.

The translation refresh job must contain both a reference to the original product data file and the file mask for the translated data file. Enter the appropriate file mask for both files under Translations Refresh Job > Refresh Products > Flat File Options > File Masks. Use the following format:

  • {Secondary language file mask},{Base language file mask}

The secondary language file is the file that provides the translated data, such as French product data. The base language file is the regular product data refresh job file, such as English product data.

All product data in the secondary language file is considered the actual translation and is mapped for the language code specified in Job Parameters.

Attribute types and attribute values in the base language file must match those already set in Configured Commerce for the product to be translated. If an attribute type/value translation is different, it is recorded as a warning, and the job processes the last received value as the translation. For example, if the attribute type Color: Red comes first as Ruge then as Rouge, the translation is Rouge.

As part of the job configuration, you must set the job parameter BaseLanguageFileName to the regular product data refresh file name.

To set the language of the import, provide the LanguageCode job parameter when running the job to define which language to associate the data.

The language code is empty so that you must select the correct language code when running the job. If you are running the job in an automated fashion, then change the default value of the job parameter.

The AD Data Feed Translations Refresh Job currently supports the following Configured Commerce product fields for translation:

  • Meta Keywords (from AD Keywords field)
  • Product Number (from AD MY_PART_NUMBER field)
  • Product Description (from AD SKU_Long_Description_1 field)
  • Meta Description (from AD SKU_Short_Description field)
  • Product Title (from AD SKU_Short_Description field)
  • Product Specifications (from AD Features fields)
  • Attribute Values
  • Attribute Types
  • Meta Description (from AD SKU_Long_Description_1 field)
  • Product Content (from AD Marketing_Description field)
  • “Standards” Product Specification (from AD Standards_Approvals field)
  • “Application” Product Specification (from AD Application field)
  • “Includes” Product Specification (from AD Includes field)
  • “Warranty” Product Specification (from AD Warranty field)

Configured Commerce does not support translation of column names from the AD product data file. For example, Manufacturer Name shows as such in Configured Commerce (as an attribute type). Column names should always be the same values, even on a non-base language version of the file, because the connector relies on these remaining unchanged.

Supported columns and mappings

Column name Field(s) mapped to in Configured Commerce Targeted object
AttributeName Name, Description Variant Trait
DisplaySequence Sort Order Variant Trait
StyleTraitValue Value Variant Trait Value
Keywords Meta Keywords Product
Part_Number_Keywords Meta Keywords Product
Alternative_Part_Number Meta Keywords Product



Meta Keywords Product



Meta Keywords Product


Meta Keywords Product


Meta Keywords Product


Meta Keywords Product


Attribute Product


Attribute Product


Manufacturer Item Product


Product Description Product


Meta Description Product


Meta Description Product


Meta Description Product



Product Number, URL Segment Product


Product Title Product

Member SKU ID

Sku Product


PackDescription Product


ShippingHeight Product


ShippingLength Product


ShippingWeight Product


ShippingWidth Product


Unspsc Product


UpcCode Product


UpcCode (If no UPC is provided) Product


Basic List Price Product

Attribute Name {x}

Name, Label Attribute Type

Value UOM {x}

Value Attribute Value




Name Document


Document Type Document



Caption Document


Large Image/Medium Image/Small Image Product Image


Medium Image Product Image


Name Brand




Category Code Category




Category Name Category


New product specification Product


New product specification Product


New product specification Product


New product specification Product

Video Links

New product specification Product


Name of the new price matrix Price Matrix


Start Date Price Matrix


End Date Price Matrix

Due to technical limitations, you cannot delete product specification additions once added to Configured Commerce via the import process from the AD PIM. The data updates if changed, but Configured Commerce retains the previously populated data when deleted from the PIM.