Import products using Affiliated Distributors (AD) data feed

  • Updated

Affiliated Distributors (AD) provides an easy and cost-effective way to support distributors with consumerized product data through a data feed. If you are importing data that you received from a feed, such as the Affiliated Distributors or Trade Service feeds, you may encounter data with name/value pairs. 

If you are not an Optimizely Product Information Management (PIM) customer, follow the Connectors for the Affiliated Distributors (AD) Data Feed article to set up your AD Data Feed to work with Optimizely Configured Commerce.

Name/value pairs

Name/value pairs refer to data stored in two columns, one entitled [name] and the other called [value]. The [name] column holds property names, while the [value] column holds property values. This differs from a standard spreadsheet format where each column header indicates the property name with the values in the cells below it.

The name/value format reduces the number of columns necessary in spreadsheets with thousands of products with hundreds of attributes. The name/value pair mechanic in PIM lets you identify the name/value pair columns, map the values from the name columns, and import the data properly. 

For example, you have a table that looks like this:

Product Number Color Size Location
0001 Blue Small United States

Using the standard mapping during the import, these column headers will map to PIM properties you have defined. 

Another example is a table that looks like this:

Product Number Attribute Name 1 Attribute Value 1
0001 Color Blue
0001 Size Small
0001 Location United States

You would not want the column header Attribute Name to map to a property; you would want the property to map to the values in the Attribute Name column. The name/value pair mechanic will help you map the values in the Attribute Name column to properties in PIM.

In the AD feed in particular, you may see data that looks similar to this:

Product Number Attribute Name 1 Attribute Value 1 Attribute Unit of Measure 1
0001 Color Blue  
0001 Size 24 in
0001 Location United States  

When you import this feed using the name/value pair mechanic, PIM concatenates the Attribute Value and Attribute Unit of Measure column so the "inches" identifier is automatically paired with the value for the Size attribute.

Work with name/value pairs in the import process

On the second step of the typical import process, an option indicates that your file has name/value pairs. From this point, your import proceeds slightly differently. See Import products to complete a standard import.

  1. Click Imports.
  2. Click the New Import icon.
  3. Select the file with name/value pairs you want to import. 
  4. Complete the first step of the import as you would a typical import. When finished, click Continue.
  5. In the next step, select the File includes name/value pairs option.
  6. Choose the first name field and value field from the drop-down lists.
  7. The name/value pair preview table will display below the drop-down lists. If there is no name/value pair match for those combinations, you will not see a table.
  8. If the spreadsheet includes a Unit of Measure column for each name/value pair, click the plus icon next to the value drop-down and choose the first UOM column from the second value drop-down.
  9. Click Save. The unique values from the name columns will display in the Selected Fields column with an NV appended to the beginning of their name. 
  10. Complete the rest of the second step of the import as you would in a standard import and click Continue.
  11. In the next step, map your pre-created PIM properties to the name/value results from the previous step and any other column headers you need to map. This works in the same way as mapping properties with a standard import. 
  12. Complete the rest of the import as you would a standard import.
When the value and unit of measure are imported, the import will place a space between the value and the unit of measure (such as 24 in.). This may affect certain name/value pair imports (such as 80 %). These issues are caught during import validation. If only a few issues exist, they can be resolved using the import error resolution process. If this causes many issues, work with your partner to adjust the source data before importing.
When importing multiple Name/Value pairs, you should add additional columns for the attribute name/value pairs so that each product has a single row.

Be sure to validate your results when the import is complete. Ensure that the correct values have mapped to the right properties in your site by reviewing several products added with your import.