Syncing the Data Source

When you click the ‘Sync’ button (highlighted in the image below) to sync the customer/product Master to the customer/product Data Source, the following applies:

• The entire structure of the Master table (i.e. data types and names) is copied from the Master table to the Data Source.

• All fields that have had their name changed in the Master table (i.e. are not called “attributeX”) are copied to the Data Source along with their data types.

• Any labels that are changed in the customer/product Data Source will be replaced by the labels in the Master table in order to maintain consistency between the two tables.

Every time you make a structural change to the Master table, you must sync the corresponding Data Source to keep the tables consistent. Therefore, it is important to make label and data type changes in the Master table rather than the Data Source because if you change something in the Data Source and sync it to the Master, those changes will be overwritten.

You can see which Master table attribute a Data Source field is connected to in the “Source Field” column:

Open

Running the Data Load

When you do a Customers/Products Data Load, only the data gets copied from the Master table to the Data Source, while the structure of the Data Source remains unchanged.

It can happen that there is a mismatch between the Master and Data Source where a field in the Data Source is defined with a data type that is not compatible with the data type of the attribute it is linked to in the Master table. In such case, the entire field will not be populated in the Data Source when you run the Customers/Products Data Load. This can be fixed either by syncing the Data Source, or manually fixing that field’s data type in the Data Source.