Rule Editor
Rule Validator
Job Status
Product Editor
Property Mapping
Rule Validator
Current Rules
Export Rules
Import Rules
Clear Rules
Refresh Rules
Loading rules...
Rule-Based Validation
Validation Scope:
Single Product
Segment
TEA Group (spgID)
Product ID:
Segment ID:
TEA Group ID (spgID):
Validate with Rules
SQL-Based Validation
Runs all SQL validations:
Dictionary validation (all dictionaries)
Date format validation (yyyy.mm.dd)
Decimal validation
Length validation (Min/Max)
Integer validation
Validation Scope:
Segment
TEA Group (spgID)
Segment ID:
TEA Group ID (spgID):
Run All SQL Validations
Import Validation
Validate products from import tables:
BrandBank Products
IceCat Products
ID Property (for update):
-- Select a property --
Select a TEA property that uniquely identifies products (e.g., GTIN, Product ID). Only properties that are mapped from import sources are shown.
Update products
When enabled, products that pass validation will be updated in the TEA database. New products will be created if they don't exist.
Validate Import Products
File-Based Validation
Validate File (column headers = property names, rows = products):
Update database for products with no errors
When enabled, products that pass all validation rules will have their properties updated in the database with values from the file.
Validate CSV with Rules
Validate XLSX with Rules