Understanding Data Layers & Data Clean Up Steps

[CommunityMod_WM]

This article details how Data Layer hierarchy works and ways to clean up existing data that needs to be removed to push enabled mappings to their target attributes.  

Article Contents:  

• How Data Layers work
• Steps for Clearing Data for Mapped Values
  • Method 1: Single Edit
  • Method 2: Bulk Edit  
  • Method 3: Spreadsheet Method
• Recovering from Mistakes

How Data Layers Work

When you publish product data to retailers, multiple sources can provide values for the same attribute. The hierarchy below determines which value "wins" and gets sent to the recipient. Values higher on the list take precedence over those below them. 

zw.png

The data is prioritized in the following order, from highest to lowest priority:

1. Recipient Specific Manual Override
   • An Override value you enter directly for a specific retailer.
   • This has the highest priority. It takes precedence over ALL other values for that recipient.
2. Recipient Specific Mapping
   • A mapping you create for a specific retailer.
   • This takes precedence over a universal mapping and verified data.
3. Manually Entered Public Value
   • A value you input directly into the product records.
   • This takes precedence over all applied mappings to that target attribute.
   • Syndigo Verified values will still take precedence over Public values.
4. Applied Universal Mapping
   • A mapping you create that applies to all recipients.
   • This value will take precedence over verified data.
5. Syndigo Verified Data
   • This is your base level, trusted product data verified by Syndigo.
   • Applied mappings will take precedence over this data. 

Steps for Clearing Data for Mapped Values

If a target attribute already has an existing universal or recipient override applied, mapped data cannot be pushed to that attribute. You must clear the existing value first.

Below are the three ways to clear data.

Method 1: Single Edit Screen

1. Go directly to a Product Details page
2. Find the target attribute
3. Delete the universal value and/or remove the applied override value
   image - 2026-06-16T162905.773.png
4. Once the data is removed, the mapped data will automatically populate
5. Save changes to confirm 
   2.png

Method 2: Bulk Edit

1. Go to the Products tab
2. Select the products that need data cleared
3. Click Bulk Edit 
   m2.png
4. De lete the universal values and/or applied override values
5. Once cleared, the mapped data will push through
6. Click Save changes 
   m2x.png

Method 3: Spreadsheet Method

This method gives you more control over large batches.

Step 1: Export

1. Go to the Products tab and select the affected products
2. Click Export from the toolbar
3. Choose your preferred delivery method
4. Select the correct spreadsheet option:
   • Clearing Universal Values (applied universal overrides or manually entered universal data) → Choose Attribute Spreadsheet – Typical Product Data Flow
   • Clearing Recipient Specific Overrides → Choose Attribute Value Override Spreadsheet
     image - 2026-06-16T163252.416.png
5. Select the requirement set that contains your target data
6. If the affected target attribute is a category attribute, select Yes at the bottom so your export includes category attributes
7. Review your spreadsheets and deselect anything you don't need
8. Click Export

Step 2: Edit

1. Open the spreadsheet
2. Delete the target data values from the spreadsheet
3. Save your changes

image - 2026-06-16T163343.618.png

Step 3: Import

1. Click Import from the Products tab
2. Select the same spreadsheet option you chose during export
3. Select the recipient name from the menu
   image - 2026-06-16T163454.727.png
4. Expand the Additional import options menu
5. Scroll to the bottom and find If uploading a blank value
6. Select the second option: Delete existing data in that field
   image - 2026-06-16T163747.984.png
   image - 2026-06-16T163818.952.png
7. Click Confirm and Import

   This ensures the existing value is deleted from the system, giving the mapped data space to map successfully to your target attributes.

   image - 2026-06-16T163857.657.png

Recovering from Mistakes

If you make a mistake and remove too much data, you can redownload any of your exported spreadsheets from the Activity Log tab:

1. Within the Activity Log tab, click the Product subtab under the Exports section
2. Click the arrow under Actions on the right
3. Retrieve your product export data

Want to Learn More?

Click the links below to learn more about Mapping and Transformation functionality.

• Mappings User Guide
• Introduction to Mappings
• Create a Data View
• Applying Transformations