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)
How to Do a Shop Transfer?
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
How to check the performance of product titles during A/B Testing in Google Analytics.
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 New 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
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)
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
Price Watch Overview
Price Watch Pricing
Price Watch Free Trial
Installing Price Watch
Installing Price Watch [sub-accounts]
How to Grant Access to Price Watch to sub-account
Selecting Products for Comparison Updates
Using Price Watch Dashboard
Price Watch Glossary
Uninstalling Price Watch
Feed Analytics Overview
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 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?
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 Lookup table option allows you to replace old values with new ones, if you upload a comma separated CSV (or refer to the article for Google Spreadsheet).
The file must contain 2 columns: one with current values from your shop, and another column with new values. Make sure your file contains only one sheet inside.
To use the Lookup table option, follow the steps below:
- Prepare the relevant file with both columns included
- Save your spreadsheet as comma separated CSV
- On your mapping page (Internal Fields or Map Fields tab), scroll down to a given field (e.g. size)
- From the second drop-down list, select Use lookup table option
- In the next field, select the field to be searched for values from the first spreadsheet column (e.g. size internal field)
- Upload your CSV
- Click IF, select the same field with values (e.g. Size), and is in list from the dropdown adding the same fileThis will let you only change these values if they exist.
- In Else > Rename, choose the same field with values (e.g. Size)The original values will be kept if you add this rule.
- To apply changes, click Save and Proceed
Optimization Case Studies:
Using standard S, M, L sizes instead of other non-standard sizes (like Little, Small, Medium, Large and Big)
Here's a step-by-step animation: