CrescoData Rules Builder
Are you needing to modify product information from a source channel, before it is publishing into another channel? Are channels requesting attribute enrichment, so your products are found easier, however you do not want to update the value in your eCommerce platform?
The CrescoData Rules Builder allows you to set up rules against key product attributes, while allowing you to filter on a certain subset of products to allow for bulk updating for current and future products.
Functions include the ability to remove, replace, append, prepend or fix text to values, while also allowing you to exclude the publishing of products to channels.
KEY FEATURES:
- Ability to edit source product values without changing or affecting their current source listings.
- Flexibility to create product rules at a Marketplace level, meaning the potential for different titles, pricing and stock buffers to name a few.
- Conditionals rules - Meaning only a subset of products are enriched with certain rules with one or multiple conditions.
- Multiple rules - Ability to create multiple rules against the same attribute.
- Source Attribute - Ability to create conditions or build a rule based on any source attribute received.
- Transparency at a product level to understand when a rule has enriched an attribute for support and traceability.
- Overwrite mappings - Ability to build your own value for a particular attribute i.e. Multiple source attributes together, appending or prepending text.
- Ability to preview rules at a specific product level before applying.
- Ability to run the rule on existing products and any future products that meet this criteria.
- Ability to prioritise rules within the same attribute, to define which rule should take priority if conditions are met.
- Rules include the ability to “Append”, “prepend”, “add”, “subtract”, “default”, “hard-code”, “search and replace” to name a few.
For every rule available, these are defined - http://cml-dev-docs.crescodata.com
Video Overview
Feature Videos
- Conditions - Filtering products to apply a rule to.
- Text Rules - Common rules specific to text fields.
- Number Rules - Common rules specific to number fields.
- Stock Rules - Common rules specific to stock.
- Date Rules - Common rules specific to date fields.
- Publishing Rules - Common rules to define products not to publish.
- Multiple Attribute Rules - Having multiple rules for the same attribute and how to reorder priority.
- Destination Specific Rules - How to setup rules specific to a destination channel.
- Testing Rules - How to test a rule on a specific product.
- Apply Rules To Products - How to apply a new or updates rule to all products.
- Reviewing Rules Applied To A Product - Visualising all attributes enriched via a rule and the differences between the original and new value(s).
Order Rules
- Replacing an order line SKU - If there is a mismatch between the sale channel SKU and the fulfillment channel SKU,
- Shipping Provider Mapping - If the sales channel only supports specific shipping provider channels that are different to your fulfillment channel values.
- Order Publishing - Defining when to publish an order to a fulfillment channel i.e. Only after an order is paid.
Common Scenarios
Below are some common scenarios with screenshots on the setups for you to review.
1. Adding a Keyword, brand name to product title
2. Adding a keyword to a specific brand. E.g.- add Boots to title if Brand = cresco-demo-test
3. Removing keywords from Product titles
4. Adding text to Descriptions for certain Shopify tags or Brands. Eg- add liquor license number to tags containing “non_returnable” in Shopify or Brand named Jack Daniel's
5. Removing text from Descriptions using Regex
6. Alter prices
7. Add fixed $ amount of prices, e.g. shipping fee
8a. Blocking/ Excluding Products By Keywords in Product Title
8b. Blocking/ Excluding Products By Brand Names
Noting in this action you can copy from a spreadsheet into the first cell if multiple values.
8c. Blocking/ Excluding Products By product_type or tags from Shopify
8d. Blocking/ Excluding Products By Single products that may not fall under any of the above rules
Noting in this action you can copy from a spreadsheet into the first cell if multiple values.
9. Excluding Specific Variants. Eg- If a T-shirt has 3 colours, ability to exclude pink colour SKUs from being sent to Marketplace or Small size.
10. Custom exchange rate - Ability to set custom Exchange rate if a merchant doesn't want to go with fluctuating rate.
11. Stock buffer* Option to add a stock buffer on inventory, eg- if stock buffer = 2, don't send any products that have inventory as 2 or less.
12. Prevent stock from being negative
13. Adding size to the title of single variant products
14. Sending a max stock quantity
