Rule boxes cheat sheet
Use the rule boxes cheat sheet to get a glimpse of which rule boxes are available, most popular, and to understand why or how they're used. in Productsup.
Introduction
View the rule boxes cheat sheet to see which rule boxes are available, most popular, and to understand why or how they're used.
Add or overwrite your data with static values
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Static Value | Appends, prepends, or assigns a predefined value to the column. | Yes | Set, Append | All | ||||||||
Append/Prepend Column | Appends or prepends a dynamic value based on a column to the column. | Yes | Append | All | ||||||||
Append/Prepend Value | Appends or prepends a predefined value to the column. | Yes | Append | All | ||||||||
Append/Prepend Value if not Empty | Appends or prepends a predefined value to the column, but only if the column is not empty. | Yes | Append | Not empty | All |
Clean and format your data
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Manage whitespace | Remove Consecutive Whitespace | Removes consecutive instances of whitespaces and replaces them with a single whitespace. | Yes | Remove | Static, Best Practice | All | ||||||
Separate Words | Adds whitespace between StickyWords. | Add | ||||||||||
Remove Spaces At Beginning And End (Trim) | Removes any whitespaces found directly at the beginning or at the end of the column. | Remove | Static, Best Practice | All | ||||||||
Remove text | Remove Terms in Brackets | Removes all words found in rounded parentheses. | Remove | |||||||||
Remove Duplicate Words | Removes all duplicate words in a column, leaving only the first-mentioned one. | Remove | Static, Best Practice | |||||||||
Spellcheck | Spellcheck | Checks for misspellings and offers suggestions in brackets. | Check for possible misspellings and show suggestions in brackets |
|
| Analyze and Correct Value | Detect, Replace |
| ||||
Capitalization | Lowercase | Converts letters to lowercase. | Remove all uppercase |
|
| Text Normalization Boxes | Replace, Convert |
| ||||
Uppercase | Converts each letter within the column to uppercase. | Replace | Static | |||||||||
Uppercase to human | Converts upper-cased words greater than three characters and leaves only the first letter in uppercase. | Yes | Replace | Static | ||||||||
Capitalize Words | Eliminates sticky words by capitalizing each word and applying lowercase letters in a word. Includes option to include words entirely in caps. | Make every first letter uppercase |
|
| Text Normalization Boxes | Must include a space before the first letter | Capitalize | Static | ||||
Invalid GTINs | Filter GTINs | Analyzes the GTIN in the given column and removes it if it is not a valid GTIN. | Replace | Static | GTIN (Amazon) | Data Service - ASIN Fetch | ||||||
Decode HTML and remove HTML tags | Remove HTML Tags | Removes HTML tags from the column. |
|
| Yes | Remove | Static, best practice | All | Data Service - Crawlers | |||
Fix and Decode HTML | Fixes and decodes special characters encoded in HTML. | Remove broken HTML Tags |
|
| Analyze and Correct Value | Yes | Replace | Static, best practice | All | Data Service - Crawlers | ||
HTML getElementById | Analyzes an HTML code and retrieves the value based on the given HTML ID. | Detect, Set | Data Service - Crawlers | |||||||||
HTML getElementByTagName | Analyzes an HTML code and retrieves the value based on the given HTML tag name. | Detect, Set | Data Service - Crawlers | |||||||||
HTML getElementByXpath | Analyzes an HTML code and retrieves the value based on the given tag name and its use. | Detect, Set | Data Service - Crawlers | |||||||||
Sanitize HTML | Frees the column of complex HTML tags and only leaves standard formatting tags. | Replace | Static, best practice | All | Data Service - Crawlers |
Combine attributes from different columns to create dynamic values
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Stock/availability | Set Availability | Provides a static value of Google accepted availability statuses. | Set | Best practice | availability | |||||||
Set Availability by Stock | Sets a positive availability status if the stock given is larger than 0. | Set | Best practice | availability | ||||||||
Set Column by Column Compare | Compares two columns and sets a column as a dynamic value when the comparison is true. | Set, Compare | All | |||||||||
Set Column by Time | Assesses if a time column is in the future or the past and, accordingly, appends, prepends, or assigns a column. | Set | Time | |||||||||
Set Column if Contains | Assesses if a defined column contains a certain value and appends, prepends, or assigns another column or value. | Yes | Set | All | ||||||||
Set Column if Empty | Applies a different column if the column is empty. | Set | All | |||||||||
Set Column if not Empty | Applies a different column if the column is not empty. | Set | All | |||||||||
Append/Prepend Column | Appends or prepends a dynamic value based on a column to the column. | |||||||||||
Append/Prepend Value | Appends or prepends a predefined value to the column. | |||||||||||
Append/Prepend Column if Value Not Present | Appends or prepends a value in the selected column only if this value is not present in the column. | |||||||||||
Compare Columns | Lets you define a value if two other columns match or don't match each other. | Compare | ||||||||||
Contains String | Searches a column for a string and sets a value based on its presence. | Set |
Count the number of characters and words in your data
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Word count | Counts the number of words in a given column. | Count | Static | All | ||||||||
Trim to 150 characters | Trims characters in the column down to 150 characters. | Trim | Static |
| ||||||||
Trim to 70 characters | Trims characters in the column down to 70 characters. | Trim | Static |
| ||||||||
Character count | Counts the characters in a column. | Count | Static | All | ||||||||
Cut first characters | Deletes a defined number of characters at the beginning. | Cut | All | |||||||||
Cut last characters | Deletes the last characters if the length exceeds a specific value. | Cut | All | |||||||||
Cut last words | Deletes the last words if the length exceeds a specific value. | Cut |
|
Transform data with regular expressions and split strings
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
RegEx | Preg Match | Uses a regular expression to match a term in the column and only shows this term. | Detect, Set | All | ||||||||
Preg Replace | ||||||||||||
Set Value if Match | ||||||||||||
Preg Match All | ||||||||||||
Split string | Split String | Uses the defined delimiter to split the string depending on where to start splitting and how many items to show. | Extract the value "Tires" |
| Split String | Split |
| |||||
Split String & Filter | Uses the defined delimiter to split the string depending on where to start splitting and how many items to show, as well as the maximum length | The Split String & Filter rule box works similar to the Split String rule box but the filter function is included. | Split String | The filter detects if something is wrong and skips it and does not list the error. | Split |
| ||||||
Split String for PLA | Similar to Split String | Split | Best practice |
| ||||||||
Split Group evenly | Assesses identical strings and appends a random number after the string. The range depends on the number of defined subgroups. | Split | Best practice |
GMC optimization
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Translate Google Category | Translates Google categories into another language or replaces them with the category IDs. | Translate | Best practice |
| ||||||||
Set Gender | Provides a static value of Google accepted genders. | Set | Best practice |
| ||||||||
Set Gender by Regex | Uses regular expressions to indicate which product gender Google has. | Set | Best practice |
| ||||||||
Set Identifier Exists | Analyzes the intermediate column's brand, manufacturer part number (MPN), Global Trade Item Number (GTIN), and the export column category to assess whether the Google | Set | Best practice |
| ||||||||
Set Size System | Provides a static value of the accepted Google size systems. | Set | Best practice |
| ||||||||
Set Size Type | Provides a static value of Google accepted size types. | Set | Best practice |
| ||||||||
Set Size Type by Regex | Uses regular expressions to indicate which Google size type the product has. | Set | Best practice |
| ||||||||
Set Age Group | Provides a static value of accepted Google age groups. | Set | Best practice |
| ||||||||
Set Age Group by Regex | Uses regular expressions to indicate which Google age group the product has. | Set | Best practice |
| ||||||||
Set Availability | Provides a static value of accepted Google availability statuses. | Set | Best practice |
| ||||||||
Set Condition | Provides a static value of accepted Google conditions. | Set | Best practice |
| ||||||||
Set Condition by Regex | Uses regular expressions to indicate which Google condition the product has. | Set | Best practice |
|
Images or image links
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Add Image From Column | Only appends or prepends a column if it is an image link. | Add |
| |||||||||
Add Logo To Image | Adds a predefined logo on the image. | Add |
| |||||||||
Add Text To Image | Adds text to the image. | Add |
| |||||||||
Separate Link and Take First Image | Takes multiple comma-separated images and only keeps the first image. | Separate, Replace |
| |||||||||
Separate Link and Take Last Image | Takes multiple comma-separated images and excludes the first image. | Separate, Replace |
| |||||||||
Add / Change Link Parameter | Changes a parameter within a link to the static or dynamically-defined value or adds if not present |
|
| Edit Link | ||||||||
Add / Change Link-Param | Add |
| Edit Link | |||||||||
Trim Image Border | Analyzes an image and removes excess border. | Trim |
|
Lists
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Blacklist | Uses a Standard Inclusion/Exclusion list to skip specific items. | Skip | All (ID mostly) | Lists | ||||||||
Taxonomy Mapping (formerly Category Mapping) | Uses a Partner Taxonomy Mapping List to search for terms in the column and replace them with the provided terms on the list. | Yes | Replace |
| Lists | |||||||
Detect and Extract Value | Uses a Replacement List to search for the entire text of a given single term and appends, prepends, or assigns a value to the listed term. | Detect | Lists | |||||||||
Mapping | Takes a list of search terms and replaces them with a defined value if the entire string has an exact match. | Detect, Replace | Lists | |||||||||
Negative Blacklist | Uses a Standard Inclusion/Exclusion list and skips all products that do not contain a listed term on the list. | Skip | ID | Lists | ||||||||
Replacement (formerly Normalization) | Uses a Standard Replacement List to replace only the part of the string that exactly matches the Replacement List values. | Yes | Replace |
| Lists | |||||||
Replacement Sensitive (formerly Normalization Sensitive) | Uses a Standard Replacement List to replace only a part (as the Replacement rule bos) or the entire string (as the Taxonomy Mapping rule box) depending on the selected option. | Yes | Replace |
| Lists | |||||||
Whitelist | Uses a Standard Inclusion/Exclusion list to white-list specific items, even if you added a skip rule to these items. | Skip | Lists | |||||||||
Whitelist Row If Value In | Uses a Standard Inclusion/Exclusion list to white-list specific items, even if you added a skip rule to these items. | Skip | ||||||||||
Whitelist Row If Value Not In | Uses a Standard Inclusion/Exclusion list to white-list specific items, even if you added a skip rule to these items. | Skip | ||||||||||
Classification Mapping | Uses a list containing classification standards for products. For example, ETIM classifications. |
Make valid prices
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Make Valid Price | Provides a price column with a valid format. | Change | Static, Best practice |
|
Manage the date and time in your feed
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Set Timestamp | Sets a timestamp with a defined date and time format. | Set | Time | |||||||||
Set Value by Datetime | Compares a date or time to a number of days and sets a static value if the statement is true. | Set | Time | |||||||||
Convert to Timestamp | ||||||||||||
Convert Datetime Format | Uses the PHP time format to transform how you present your date. |
|
| Date/Time | The date format in this rule box is not the same as in Limited Time Only. For example, use | |||||||
Set Value by Datetime | ||||||||||||
Set Column by Time | ||||||||||||
Set Datetime | Sets a timestamp with a defined date and time format. | Set | Time | |||||||||
Set Expiration Date | Adds | Set | Best practice, Time |
Miscellaneous
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Comment | Lets you leave a comment in your boxes. The Data Flow section also displays your comment. | All | ||||||||||
Custom Product_type | Only shows the category branch, as separated by a comma, which has the longest length. | Split | Static |
| ||||||||
Delta Update/New Date | Sets a product-specific timestamp based on its delta status. | Set | Time | |||||||||
ePro Tracking | Lets you set your parameter values for ePro redirect tracking. | Set | Static |
| ||||||||
Extend Text | Extends a sequence of characters until a set maximum length is achieved. | Add | ||||||||||
Ignore IDs | Skips products based on the exactly defined value. | Skip |
| |||||||||
Set Property Value | Uses the site or export tags to define a value. This is useful for changing values in copied sites without having to change any boxes. | Set | Static | |||||||||
Set To Site ID | Sets the value to the Productsup site ID. | Set | ||||||||||
Trim Category Tree | Uses the delimiter | Trim |
| |||||||||
XML Key Value Mapping | Maps the given Key and Value according to the desired structure. |
Search and replace data
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Detect and extract info from a column | Detect and Extract Value | Uses a Standard Replacement list to search the entire text for given single terms and appends, prepends, or assigns a value in the list. | Detect | Lists | ||||||||
Detect Brand | Uses a Productsup database for brands to detect a brand within a column and only extract a brand for another. | Extract a brand and add it to the title |
|
| Analyze and Correct Value | Yes | Detect | brand | ||||
Detect Color | Uses a Productsup database for color names to detect the color within a column and only extract the color for another. This means that it recognizes the color in all languages stored in your database. | extract the color and add it to the title |
|
| Analyze and Correct Value | Yes | Detect | color | ||||
Search and replace static text | Text Replace | Searches for a term in the column and replaces it with a static value. | Yes | Replace | All | |||||||
Map-Replace | Takes a list of search terms and replaces them with the defined value within a string. | Yes | Detect, Replace | All | ||||||||
Mapping | Takes a list of search terms and replaces them with the defined value if the entire string is an exact match. | Detect, Replace | Lists | |||||||||
Dynamically search and replace text based on a condition | Replace Dynamic Value | Searches the column for terms found in another column. Once there is a match, it replaces them with a static or dynamic value from another column. | Replace | All | ||||||||
Preg Replace | Uses a regular expression as a search term to replace values within the column. | Detect, Replace | All | |||||||||
Replace if Column Contains | Searches another column for a specific string. For those rows that contain a match, it then performs a search and replaces a function for those products only. | Replace | All | |||||||||
Replace In Between | Uses defined strings for search criteria and replaces the value between these strings with a static value. | Replace | All | |||||||||
Text Replace if Column Contains | Searches for a term in a column and replaces it with a static value if specific columns contain a specific static value. | Replace | All | |||||||||
Replace dynamic value | Searches a column for terms found in another column. When a match is made, it replaces them with a static or a dynamic value from another column. | Replace | ||||||||||
Text Template | Links several columns together with static placeholder text. |
|
|
Set a value based on an "if" condition
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Add a static value if another column meets a condition | Set Value if Contains | Compares a column if it contains a value. Whether the condition is true or not a value is assigned, appended, prepend, or left unchanged. | Set | All | ||||||||
Set Value if Empty | Sets a static value if the column is empty. | Extract the brand and add it to the title |
|
| Analyze and Correct Value | Yes | Set | All | ||||
Set Value if Greater Than | Replaces all values that are greater than the value you enter in the box, either by the word or number you chose for output. If you work with prices, you may have to use the Make Valid Price- Box before this box. | Extract the color and add it to the title |
|
| Analyze and Correct Value | Set | Math | |||||
Set Value if Match (RegEx) | Searches for expressions in columns and replaces them with other values. If you work with prices, you may have to use the Make Valid Price-Box before this box. | Set | ||||||||||
Set Value If Value In | Compares a column if it contains one or more values. When it makes a match, a static value is set. If you work with prices, you may have to use the Make Valid Price-Box before this box. | Set | All | |||||||||
Set Value if Value Not in | ||||||||||||
Set Value if Column Contains | Searches a column for various terms and appends, prepends, or assigns the corresponding assigned term. | Yes | Set | All | ||||||||
Add a dynamic value based on the attribute of another column | Add Column if Fits | It only adds the column and optional text if the maximum length of the column isn't exceeded. | Add | |||||||||
Add Column if Value Not Present | Only adds the selected column value if this value isn't already present in the column. | Add | Not present | |||||||||
Add Value if Fits | Only adds a value to the column if the maximum length of the column isn't exceeded. | Add | ||||||||||
Set Value by Column Compare ( Multi-condition ) | ||||||||||||
Set Value if Empty ( Conditional ) | ||||||||||||
Set Condition | Provides a static value of accepted conditions by Google. | |||||||||||
Set Condition by Regex | Uses regular expressions to indicate the Google condition that the product has. | |||||||||||
Compare data across columns and set values based on the outcome | Set Value by Column Compare | Compares one or two columns and sets another column or static value when a match is made. | Set, Compare | All | ||||||||
Set Value by Compare | Compares a column to a static value and appends, prepends, or assigns a static value when a match is made. | Set, Compare | All |
Skip products with conditions
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Skip Row By Content Length | Skips all rows depending on the number of characters within the column. | Skip | All | |||||||||
Skip Row If Empty | Skips all rows where the value of the column is empty. | Skip | All | |||||||||
Skip Row If Isn't URL | Skips all rows where the value of the column isn't a valid URL. | Skip | link | |||||||||
Skip Row If Match | Uses a regular expression and skip all rows where the regular expression finds a match. | Skip | All | |||||||||
Skip Row If Value In | Skips a row if one of the defined values is in a column. | Skip | All | |||||||||
Skip Row If Value Not In | Skips a row if one of the defined values is not in a column. |
Sort your data within an attribute
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Sort Values | Separates items in a cell based on a delimiter and sorts them alphabetically. | Sort | ||||||||||
Sort Values in Cell | Separates items in a cell based on a delimiter and sorts them alphabetically or by using a defined sorting system. | Sort |
Translate your data into another language
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Translate Colors | Searches the colors database and if available it translates the colors into the language you selected. | translate English colors into German |
|
| Analyze and Correct Value | Also other languages | Translate |
|
Work with numbers and math functions
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Generate random numbers | Generate MD5 Hash | Creates an MD5 hash out of the given value. | Generate | |||||||||
Generate Random Number | Creates a random number. | Generate | Static | |||||||||
Generate Unique ID | Creates a unique ID based on a selection of given columns. | Generate |
| |||||||||
Add VAT to prices | Add VAT | Adds a given VAT percentage to your price column. | Adds 19% or another rate of VAT to the price |
|
| Correct price/Math | default is 19% | Yes | Add | Math |
| |
Discount | Discount | Sets a reduced price if specific or multiple columns contain specific terms. | Discount | Math |
| |||||||
Discount Percentage | Calculates the difference in percentage between to prices. | Discount | Math |
| ||||||||
Limited Time Only | Sets a value or discounted number based on the current date. | Set | Time | |||||||||
Perform mathematical equations | Math | Performs mathematical operations on a numeric value. | Convert | Math | ||||||||
Numeric Compare | Compares two dynamic sets of numbers and sets a value based on the comparison. | Compare, Set |
| |||||||||
In-Row Math | Adds, divides, or multiplies a sequence of numbers separated by a delimiter. | Use operator ( | 2,3,6 | 11 | Correct price/Math | Convert | Math | |||||
Round Numeric Values | Takes a numeric value and rounds it according to the defined decimal points. | Replace | Math |
Work with URLs
Purpose | Box name | Definition | Typical use | Example: Before | Example: Result | Category | Notes | Popular | Functions | Type | Applied to? (suggestions) | Works with |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Adding and changing URL parameters or fragments | Add / Change Link Parameter | Changes a parameter already within a link to the static or dynamic value that you defined. It adds a value if it is not yet present. | Add |
| ||||||||
Add Column URL-Encoded | Adds a column and encodes it in the process. | Add | ||||||||||
Add URL Fragment | Adds a fragment (#) to the URL. | Add |
| |||||||||
Get Filename from URL | Extracts a filename and its type from an URL. | Get Filename from URL takes just the filename out of the URL |
|
| Edit link | Detect, Set | ||||||
Encoding and decoding URLs | URL Decode | Decodes a column. | Decode URL |
|
| Edit link | Replace | Static | ALL | |||
URL Encode | Encodes a column. | Encode URL |
|
| Edit link | Replace | Static | ALL | ||||
Shorten URL | ||||||||||||
Raw URL Encode |