Adding Users: User and Admin Type
Adding Users: Access Rights to Shops
Adding Users: Access Rights to Channels
Adding Product Files (CSV/TXT, XML, JSON)
Adding Product Files from Google Sheets
Merge Your JSON data feed with other sources
Configuring Inheritance Settings in Magento 2 or Later
Refreshing Your Token in the Magento Admin Panel
Upgrading the Magento 1 DataFeedWatch Extension to the Latest Version
Choosing Magento Product Types
Adding Magento 2
Adding PrestaShop (Module)
Adding Magento 1 Multiple Store View
Adding Magento 2 Mutiple Store Views
Adding Cart Storefront to DataFeedWatch
Adding Another Feed (Merging)
Shop Statuses Overview
Shop Options Overview
Adding a Shop (Shopping Cart or Feed File)
Using Shop Products
Adding Feed from Other Sources to Your Shopping Cart Main Feed
Internal Fields Overview
Creating Internal Fields
Using Internal Fields in Channel Mappings
Copying All Internal Fields between Shops
Creating New Custom Internal Fields
Saving Rules as Internal Fields
Input field or internal field? What is the difference?
Copying Single Internal Field
Adding Product Title Variants for A/B Testing
Checking Performance of Product Titles in A/B Testing (Landing Pages Report)
Channel Mapping (Map Fields Tab)
Choosing the Advertised Products (Include/Exclude Products Tab)
Excluding Associated Variants (Include/Exclude Products Tab)
Adding Categories (Categorize Products Tab)
Comments on Mapping 💬
How to Create a Custom Channel
Uploading Data Feeds to Facebook
Facebook: Merging Product Variants
How to find feed URL in Facebook Business Manager?
Uploading Data Feeds to Google Shopping (FTP)
Uploading Data Feeds to Google Shopping (HTTP)
Uploading Data Feeds to Google Shopping (from Local Drive)
Uploading Data Feeds
Uploading Data Feeds from Local Drive
Uploading Data Feeds via FTP
Uploading Data Feeds via HTTP
Adding a Channel
Main Mapping Types: Rename
Main Mapping Types: Add static value
Main Mapping Types: Combine
Main Mapping Types: Lookup table (Google Sheets)
Main Mapping Types: Lookup table (Local Drive, CSV)
Main Mapping Types: Extract from (Google Sheets)
Main Mapping Types: Extract from (Local Drive)
Main Mapping Types: Leave empty
Edit Values: Overwrite
Edit Values: Replace single value
Edit Values: Replace multiple values (Google Sheets)
Edit Values: Replace multiple values (Local Drive)
Edit Values: Remove single value
Edit Values: Remove multiple values (Google Sheets)
Edit Values: Remove multiple values (Local Drive)
Edit Values: Remove duplicates
Edit Values: Add prefix
Edit Values: Add suffix
Edit Values: Recalculate
Edit Values: Recapitalize
Edit Values: Round
Conditions: is equal to / is not equal to
Conditions: includes / doesn't include
Conditions: is blank / is not blank
Conditions: starts with / doesn't start with / ends with / doesn't end with
Conditions: is greater than / is greater or equal to / is less than / is less or equal to
Conditions: is between / is not between
How to add currency code in DataFeedWatch
Conditions: is in list / is not in list
Conditions: is longer than / is shorter than
Mapping Types Overview
Empty Field Error in Feed Review
Identifier Not Unique Error in Feed Review
Feed Quality Score in DataFeedWatch
UPI Missing Error in Feed Review
Invalid Value Error in Feed Review
Invalid GTIN Error in Feed Review
Using Feed Review
Configuring Feed Review: Settings
Configuring Feed Review: Validators
Amazon (Legacy Integration): How to Create New ASINs
Amazon (Legacy Integration): Creating ASINs on Amazon Seller Central (via a File Upload)
Amazon (Legacy Integration): Creating ASINs on Amazon Seller Central (via Web Interface)
Amazon (Legacy Integration): Creating ASINs using DataFeedWatch
Amazon (Legacy Integration): Troubleshooting Uploads with the Processing Report
Amazon (Legacy Integration): Adding Amazon Channel
Amazon (Legacy Integration): Why some products can't be matched with ASINs?
Amazon (Legacy Integration): Adding Amazon Marketplace Template
Amazon (Legacy Integration): Processing Report Settings
Amazon (Legacy Integration): ASIN Numbers Settings
Amazon Integrations Overview
Bol.com: Adding Bol.com Content Feed
Bol.com: Adding Bol.com Offers Feed
Bol.com: Adding Bol.com Order Management
Bol.com Offers Feed: Adding Bundle Prices
Ebay Marketplace MIP: Overview
Ebay Marketplace MIP: Adding Marketplace & Settings
Ebay Marketplace MIP: Choosing a Template
Ebay Marketplace MIP: Mapping a Template
Ebay Marketplace MIP: Business Policies (Payment, Return, and Shipping)
Analytics FAQ: Why do I get insufficient permissions error?
Analytics FAQ: Why DataFeedWatch Tag doesn't work properly in Google Analytics?
Analytics FAQ: Why do I get Maximum number of custom dimensions reached error?
Analytics FAQ: Why Analytics shows me different numbers than my Google Analytics?
Analytics FAQ: What about security of data in my Google Analytics account?
Analytics FAQ: Why do I need to wait for the data to appear in Analytics?
Analytics FAQ: Can analytics parameter damage my landing page reports?
Analytics: Adding Tracker to Gtag.js and Analytics.js
Analytics: Adding Tracker to BigCommerce
Analytics: Adding Tracker to Magento 1
Analytics: Adding Tracker to Volusion
Analytics: Installing Analytics
Google Text Ads: Why do I still see old data in my campaign?
Google Text Ads: Can I automate my existing, manual campaigns with Google Text Ads?
Google Text Ads: Can I combine my existing manual campaigns with Google Text Ads?
Google Text Ads: How to create better text ads?
Google Text Ads: What is Permutations & how does it help?
Google Text Ads: Can I combine different fields into keywords?
Google Text Ads: Can I set a CPA per product and use that in my Google Search campaign?
Google Text Ads: What are the campaign limitations?
Google Text Ads: What are the DSA campaigns based on?
Google Text Ads: How can I use my pre-existing landing pages in a campaign?
Google Text Ads: What is the maximum size of the source feed for Google Text Ads?
Google Text Ads: How does truncating work?
Google Text Ads: Will Google Text Ads service overwrite manual changes that I make in AdWords?
Google Text Ads: Can I add other fields to create keywords?
Google Text Ads: Are there limitations as to the number of ad patterns?
Google Text Ads: What if I don’t want to lose the history of my existing campaigns?
Google Text Ads: Can I set a State, Province or Region as a territory?
Google Text Ads: What happens if the price changes?
Google Text Ads: What happens if my campaign is split into multiple campaigns?
Google Text Ads: What happens with an ad group when a product goes out of stock?
Google Text Ads: How can I unsubscribe from Google Text Ads in DataFeedWatch?
Google Text Ads: Can I add & use keywords from a separate file?
Google Text Ads: Why are not all my products in my campaign?
Google Text Ads: How often are my campaigns synced with my Google AdWords account?
Google Text Ads: What if certain fields are no longer in my feed?
Google Text Ads: Why are some products not eligible?
Google Text Ads: Can I use a 3rd-party tool to optimize the campaigns?
Google Text Ads: Why does my template not work for 100% of my ads?
Google Text Ads: How to add size & color as negatives to the group campaign?
Google Text Ads: How does Per Partes work?
Google Text Ads: How to link one shop in the DataFeedWatch App to multiple AdWords Accounts?
Google Text Ads: Signing Up for Google Text Ads
Google Text Ads: Setting Up a Google Text Ads Feed
Google Text Ads: Connecting Your Google Ads Account
Google Text Ads: Creating Campaigns (Product Campaign)
Google Text Ads: Creating Brand and Product Type Campaigns (BPT)
Google Text Ads: Creating Group Campaigns and DSA Campaigns
Google Text Ads: Creating Landing Page Campaigns
Google Text Ads: Bad words
Google Text Ads: Best Practices
Google Text Ads: Overview
Google Text Ads: Quick Start Guide
Google Text Ads: Feed Optimization Checklist
Google Text Ads Does Not Open in DataFeedWatch
How to Download My Invoices?
What is the Number of Products That I Will be Charged For?
How can I cancel my subscription, so that I am not charged by DataFeedWatch?
How do I update or add credit card details?
Where can I check the pricing of DataFeedWatch?
Is there any agency or umbrella account dedicated to manage many shops?
Should I use HTTP or FTP connection for my shop?
What Is GTIN?
How Can I Find the GTINs of My Products?
What are the XML files requirements when adding a shop?
How to enter the correct Volusion credentials in my DataFeedWatch account?
BigCommerce Upgrade – Why and how do I upgrade my BigCommerce shops?
How to open incorrectly displayed CSV files in Microsoft Excel?
What is the influence of ID on other functionalities?
What is the influence of Item_Group_ID on other functionalities?
How to Find the Token in My BigCommerce Store?
How to pause the connection between your shop and DataFeedWatch?
How does Products Drop Protection work?
Can I add a single Google Sheets tab?
What does Attention required: Unmapped internal fields error mean?
How to Remove 'myshopify' From the Links?
Missing or Stray Quote
Not a Regular File
504 Gateway Timeout
503 The Server Is Currently Unavailable
500 Internal Server Error
404 Not Found
502 Bad Gateway
Will DataFeedWatch Manage My Shopping Channel Account?
What are the unique product identifiers (GTIN, MPN, UPC, EAN, JAN, ISBN)?
How to add new or alternative images to my products?
How Can I Check My Input Feed?
How can I check my Output Feed for a channel?
How to Remove Content API Connection from Shopify in Google Merchant Center?
How to Contact Support at Google Merchant Center?
How to create Merchant Promotions using DataFeedWatch?
How can I fix price errors in my Google Merchant Center?
How to repair shipping-related errors appearing in Google Merchant Center?
How to repair tax-related errors appearing in Google Merchant Center?
How to Find Feed URL in Google Merchant Center?
How to grant DataFeedWatch access to my Google Merchant Center?
Table of Contents
- Using DataFeedWatch
- Mapping Types
Conditions: is in list / is not in list
Conditions: is in list / is not in list
Updated by Paweł
If you're not sure how to proceed, or the function does not produce the right effects, please contact our Support Team.
The following conditions:
will allow you to add conditions based on the list of values, if you paste the link to your Google Spreadsheet.
The file must contain all the values in one column. Make sure your file contains only one sheet inside.
To use the is in list / is not in list options, follow the steps below:
- Log in to Google Spreadsheets, and prepare the relevant file with the values in one column only
- In the upper-right corner, click Share > Get shareable link
- On your mapping page (Internal Fields or Map Fields tab), scroll down to a given field
- Select the Main Mapping Type (e.g. Rename)
- Click IF
- Select the field to be searched for values from the spreadsheet (e.g. ID input field)
- From the second drop-down list, select the is in list or is not in list option
- Click on the arrow next to Add from drive, and select Add from url
- Now, paste the shareable link to your Google Spreadsheet file
Optimization Case Studies:
Excluding a list of products from your data feed
You can use this functionality also to exclude products from your feed. All you need to do is prepare such list with the IDs or other values, and add the is in list condition with such file.