---
title: Create a Product Attributes Refresh integration job
slug: configured-commerce/docs/create-a-product-attributes-refresh-integration-job
docTags: 
createdAt: 2026-08-13T10:46:20.000Z
---

You can create a Product Attributes Refresh integration job with Optimizely Configured Commerce. Because many refresh jobs query an ERP database directly, you should know where to find the required data in the ERP database. If you are unfamiliar, consult with somebody who knows the ERP data structure. Refresh jobs usually use the same types of processors:

1. SqlQuery
2. SqlQuery, OleDbQuery, or OdbcQuery
3. FieldMap

The first SqlQuery processor constructs a SQL query statement. The second query processor runs the query to extract data from the ERP database. The FieldMap processor takes the data extracted from the ERP database and inserts it into the Configured Commerce database through **field mapping**. 

This job uses multiple steps to sequence importing data for separate Configured Commerce objects. This ensures all appropriate data exists before forming the necessary relationships between the objects.

:::hint{type="info"}
**Note**

If you have completed the [Product Refresh walk-through](docId\:MdzcKWjga-U_3m9P-aFUR), go to [Create the Integration Job](docId\:N0Lk3cXKt4TzJ9Mav9pXp).
:::

## Prerequisites

Complete the following tasks before you start:

- Install SQL Server on your local computer.
- [Install the WIS](docId:4PqdlDkzvJxniR2fZt8GF) on your local computer.
- Download and execute the SQL Server scripts.
  - These scripts assume you have already created a database named *FakeERP*.
  - These scripts create the table and insert seed data into that table.

## Create the integration connection

The integration connection specifies the pieces of the connection string used to connect to the SQL Server instance.

1. Go to **Administration > Connections**.
2. Click **Add Integration Connection**.
3. Name the integration *FakeERP.* This name must be the same in the WIS configuration.
4. Select **SqlServer** for the **Type Name**.
5. Select the appropriate time zone.
6. Enter the **SqlServer Name**. This example uses SQL Server Express, so the value is *.\\\sqlexpress*.
7. Name the **Database** *FakeERP*.
8. Use the **Integrated Security**, **Log On**, and **Password** fields to specify the account for the integration. The account should have read access to the tables in the ERP database. This example uses the default server administrator account, which should not be used in a production environment.
9. Click **Save**.

![B2B\_NewIntegration.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/PYiZMgmJxCNzyFpZnrz3_-20260720-144715.png)

## Configure the WIS

[Configure the WIS](docId\:HGJhS6SWsPPnG-z7ZRMJx) with the connection you created to select an integration processor for the integration job and allow the job to be executed.

## Create the integration job

This integration job uses standard processors and multiple job steps responsible for refreshing certain pieces of the product-attributes relationship.

### Specify the job details

1. Go to **Administration** **> Job Definitions**.
2. Click **Add Job Definition**.
3. Enter a **Job Name**. This example uses *Product Attributes Refresh* to indicate what type of job it is and what Configured Commerce object it affects.
4. Select **Refresh** for the **Job Type**.
5. Select the **Connection** you created previously. This lets the integration processor connect to the database specified in the integration connection.

![B2B\_NewJobDefinition.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/WBrIBJ9CinA6IVyroeG0Q-20260720-144715.png)

**Preprocessor**, **Integration Processor**, and **Post Processor** indicate what type of work the integration job completes and operates in the order they display in the form. First, the preprocessor does any preprocessing required for the job, including aggregating data or constructing a query for the integration processor. The integration processor then adds to the work, usually operating on the data or objects retrieved or constructed by the preprocessor. The post processor processes the response from the integration processor. This can include consuming data retrieved from the ERP by the integration processor.

1. Set the **Preprocessor** to **SqlQuery** to construct an SQL query. The specific query will be configured in a later section.
2. Set the **Integration Processor** to **SqlQuery**. Even though this is the same value, this processor executes the query constructed by the SqlQuery preprocessor against the ERP database specified in the integration connection. The post processor receives the query results.
3. Set the **Post Processor** to **FieldMap** to map data between the ERP data set and the Configured Commerce database. The ERP data set will be inserted into the Configured Commerce database. You will configure the field mapping later.
4. Click **Save**.

![B2B\_NewJobDefinition\_Processors.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/bQQhaoXLD6VaNeQ1ApKGM-20260720-144715.png)

### Create the job steps

Create the job steps to specify what data should be extracted from the ERP database and where that data is inserted into the Configured Commerce database. Integration job steps are each executed once according to the **Job Sequence** number. The Product Attributes Refresh job uses three steps to pull in the attribute types, attribute values, and product-to-attribute value relationships to ensure the attribute types and values data are present before creating relationships between that data and the product data.

### Create the attribute types job step

1. Select **Steps**.
2. Click **Add Job Definition Step**.
3. Set the **Sequence** to **1**. This field orders the execution of the job steps.
4. Name the step *Attribute Types*.
5. Select **Attribute Type** for the **Target Object**. Data from the ERP maps to this object.
6. Set the **Delete Behavior** to **Ignore**.

![B2B\_AttributeTypesStep.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/QMv72iqXJVrIyuTLhXD8G-20260720-144715.png)

The **Select Clause**, **From Clause**, and **Where Clause** fields form the SQL query. The preprocesser uses these fields to construct a SQL statement to query the ERP database for product data.

1. Enter *Name* into the **Select Clause** field.
2. Enter *dbo.vw\_AttributeTypes* into the **From Clause** field.
3. Click **Save**.

![B2B\_SelectClauseFromClause.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/Zs0nL93LPgkGVvO8KdSdG-20260720-144715.png)

**Configure the field mappings**

The field mappings tell the FieldMap post processor where the ERP data should be inserted into the Configured Commerce database. Each field mapping has a **From Property** and **To Property**. The From Property often corresponds to the data set retrieved from the ERP database, and the To Property corresponds to properties on the Target Object specified earlier.

1. Select **Field Mapping**.
2. Click **Add Job Step Field Mapping**.
3. Select **Field** for the **Field Type**.
4. Select **Name** for the **From Property**. Note that it matches one of the columns specified in the **Select Clause** field.
5. Select **Name** for the **To Property**. The Name values from the ERP data are inserted into the Name values on the Attribute Type object.
6. Set the **Can Overwrite** to **No**. The ERP data value is inserted in the Configured Commerce database on the first run of this job. However, any subsequent runs of this job do not overwrite that data if it already exists. If this toggle is set to **Yes**, the Configured Commerce object is updated on each run, whether or not the new value is different. For example, some ERPs may have products with abbreviated descriptions that would not make sense to a user. Setting the Can Overwrite value to **No** would insert the abbreviations into Configured Commerce and let the marketing department update them after the integration jobs completes the first run.
7. Set the **Is Dataset Key** to **Yes** to indicate that this column in the ERP data set is a unique key. The To Property value is a natural key field of the Configured Commerce object (such as Name is a natural key of Attribute Type).
8. Click **Save**.
9. Repeat steps 2-8 for the remaining field mappings below in the table.

| Field Type  | From Property | To Property | Lookup Error Handling | Can Overwrite | Is Dataset?Key | Comments                                                           |
| ----------- | ------------- | ----------- | --------------------- | ------------- | -------------- | ------------------------------------------------------------------ |
| StaticValue | 1             | Active      | n/a                   | No            | No             | You can read tolearn more about StaticValue and other field types. |
| Field       | Name          | Label       | n/a                   | Yes           | No             | ?                                                                  |

After you add the field mappings, create the step that pulls in the attribute values for each attribute type.

Before continuing, you should run the Product Attributes Refresh job manually to verify it is working correctly. At this point, the job should be importing only the attribute types.

### Create the attribute values job step

1. Select **Steps**.
2. Click **Add Job Definition Step**.
3. Set the **Sequence** to **2**.
4. Name the step **Attribute Values**.
5. Set **Attribute Value** for the **Target Object**. Data from the ERP is mapped into this object.
6. Select **Ignore** for **Delete Behavior**.
7. Use the clause fields to construct the query. 
   1. Set **Select Clause** to `DISTINCT attr_type AS AttributeType, attr_val AS AttributeValue`.
   2. Set **From Clause** to `dbo.vw_AttributeValues`.
   3. Set **Where Clause** to `status = 'Active' AND ISNULL(attr_val, '') <> ''`.
8. Click **Save**.

![B2B\_AttributesValueClauses.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/DDdau9T-xjy0sF4yDQ_JI-20260720-144715.png)

**Configure the field mappings**

Select **Field Mapping**, and use the following table to configure them.

| Field Type  | From Property  | To Property    | Lookup Error Handling | Can Overwrite | Is Dataset Key | Comments                                                                                                                                                                                                                                                                                                                         |
| ----------- | -------------- | -------------- | --------------------- | ------------- | -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| StaticValue | 1              | Active         | n/a                   | No            | No             |                                                                                                                                                                                                                                                                                                                                  |
| Field       | AttributeValue | Value          | n/a                   | No            | Yes            |                                                                                                                                                                                                                                                                                                                                  |
| Lookup      | AttributeType  | Attribute Type | Warning               | No            | Yes            | A Lookup field type handles mapping a many-to-one relationship, where the Target Object is on the many sides of the relationship and the Lookup object is on the one side. In this case, an Attribute Value has an Attribute Type. The Attribute Type name is returned in this property, so the mapping can occur based on name. |

After you add the field mappings, create the step that maps attribute values to products.

Before continuing, you should run the **Product Attributes Refresh** job manually to verify that it is working correctly. The job should import the attribute types and values and assign the attribute values to the appropriate attribute types.

### Create the product attribute values job step

1. Select **Steps**.
2. Click **Add Job Definition Step**.
3. Set the **Sequence** to **3**.
4. Name the step **Product Attribute Values**.
5. Select **Product** **Attribute Value** for the **Target Object**.
6. Set the **Delete Behavior** to **Ignore**.
7. Use the **clause** fields to construct the query. This query includes the **part\_id** to map the attribute values to the products.
   1. Set **Select Clause** to `part_id, attr_type AS AttributeType, attr_val AS AttributeValue`.
   2. Set **From Clause** to `dbo.vw_AttributeValues`.
   3. Set **Where Clause** to `status = 'Active' AND ISNULL(attr_val, '') <> ''`.
8. Click **Save**.

**Configure the field mappings**

Select **Field Mapping**, and use the following table to configure them.

| Field Type | From Property                 | To Property     | Lookup Error Handling | Can Overwrite | Is Dataset Key | Comments                                                                                                                                                                                                                                                                                                                                                               |
| ---------- | ----------------------------- | --------------- | --------------------- | ------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| LookUp     | part\_id                      | Product         | Warning               | Yes           | Yes            | A LookUp field type is used when populating a property that is a foreign key to a "child" object of the target object. A child collection requires a "From Property" with a natural key value of the Target Object in the "To Property". In this case, "part\_id" is the natural key of Product, which is the relationship defined here (Attribute Value to Product).  |
| Lookup     | AttributeType,Attribute Value | Attribute Value | Warning               | No            | Yes            |                                                                                                                                                                                                                                                                                                                                                                        |

Now that you have added and configured all the job steps, the integration job should be completely configured and ready to execute.

## Run the integration job

You should manually run the [Product Attributes Refresh](docId\:hkjR2DftmRjPbPmFDp6Ew) job to ensure it works correctly. If the job fails, you can view the log that was created during the execution to track down any errors.

1. Go to the **Product Attributes Job Definition**.
2. Select **History** to see a list of past executions of this job.
3. Find the most recent execution and click **View**. You can see the execution's status, the job's parameters, and the job logs.
4. Select **Job Logs**. If you notice an error log, you can click **View** to see the error description.

If the job still fails, follow the steps to ensure you configured the job correctly. If the job is configured correctly but still fails, you can read about[ advanced troubleshooting steps](docId\:XYKDWG4tDopOZBvwluIjb) to diagnose the problem.

If the job succeeds, you should verify that the product attribute data was imported correctly.

- Go to **Catalog** > **Attribute Types** to verify attribute types and values.
- Go to **Catalog** > **Products** to verify attribute value relationships. Each product has an Attributes tab.

## Link to the product refresh job

This product attributes refresh job should only execute if the products refresh job was already successfully executed. You can ensure this and the execution order by linking the two jobs. You can also stagger the workload for external systems. Linked jobs only run one at a time and under the conditions you specify. 

1. Go to **Administration** > **Jobs** > **Job Definitions** > **Product Refresh**.
2. Select **Product Attributes Refresh** for the **Linked Job**. 
3. Select **Success Only** for the **Link Condition**.
4. Click **Save**.

The Product Attributes Refresh job now only runs when the Product Refresh job is executed and results in success. You schedule the Product Refresh job, and the other scheduling is done automatically.