Data Source Syncing

After setting up a Data Source and a syncing schedule, the data will automatically be imported into Creative Force. Along the way, there might be cases where you would need to make updates or changes to the source file. This article will explain the logic behind the syncing process and what actions should be taken.

To check the mapping columns, go to Studio Settings -> Data Source. Hover over the Data Source you want to check and click Actions -> Mapping Column.

When you have unmapped columns on a running Data Source, you can remap those and click ‘Save’. You will then see further sync options; the logic for these will be explained in the ‘Sync Options’ section of this article.

If your Data Source is using one of the following methods: FTP, Google Cloud Storage, Amazon S3, Brandquad, Akeneo, Airtable, or Feed URL, you can fetch new columns and sync to Creative Force.

Before adding new columns, you must ensure those columns are present in your main Data Source file as well as the latest delta file.

In the Data Source Mapping menu, you will see the ‘Fetch Columns’ button in the top right corner.

Clicking ‘Fetch Columns’ will populate new columns in the mapping setup. You can then adjust the column mappings as needed and click ‘Save’.

You will then see further syncing options, which will be explained in the ‘Sync Options’ section.

When you go to the Data Source Mapping menu, you will see the 'Add New’ button.

Enter the column name and select a corresponding property in Creative Force to map, then ‘Save’. You will then see further sync options, which will be explained in the ‘Sync Options’ section.

After saving the updated column mapping using the steps above, you will be prompted to select one of the following options:

By selecting this option, the updated column mapping will be automatically applied to all Data Source syncs or updates moving forward. Existing product records from previous syncs will remain unchanged.

Existing product records will not be retroactively updated to the changed mapping.

This works best if you are planning to capture a new data point moving forward and do not want to affect the existing product data.

By selecting this option, the updated column mapping will be synced to all existing Data Source records, including delta files, if applicable.

Once the sync is completed and the Data Source status returns to “Data Ready,” then products and samples can be manually updated via a Manual Update process.
​

There are two options to perform a manual update, and each is described below.

Head to the Product View → Find the Product you would like to update with information in your Data Source → Then, select the 3-dot menu → and 'Update from Data Source.'

Head to the Job View → Find a Job under a Workspace assigned to your Data Source → Then, select the 'Actions' button → and 'Update from Data Source.'