How to create formula attributes in Plytix to automate operations
⚠️ This is a beta feature and is not available in all accounts yet. If you own a Plytix paid account and would like to test this feature, please contact our team to get started.
With formula attributes, you can create and store formula operations for data transformations directly in Plytix. You can use them for various cases, ranging from price discounts and currency conversions to text transformation and data concatenation. In this article you will learn how to create and manage formula attributes in Plytix.
Uses Cases for Formula Attributes
*Skip to any section in this article by clicking on the links above
Use Cases for Formula Attributes
There are various use cases for formula attributes.
- Calculate pricing and tax: apply tax costs based on your marketplace's requirements
- Convert currencies: automatically set up your price conversions across different currencies
- Set conditioned sale prices: apply discounts to products automatically based on stock levels, sales performance, or seasonal promotions.
- Add or change tags: customize your tags to optimize your product search across different sales channels
- Calculate date estimations: compute estimated delivery dates or product lifecycle stages based on manufacturing or shipping dates.
- Derive complex attributes: Automatically derive complex product attributes like environmental impact scores from multiple data points (e.g., materials used, production methods).
💡 This is not an exhaustive list. If you're looking for ways to apply formula attributes for your own use case, feel free to contact our team
Creating a Formula Attribute
To create a new formula attribute directly in Plytix:
1. Head over to the Settings tab and click on "Attributes" in the side menu. Then, click "+ Create attribute."
2. Name your attribute, personalize the label, and add a description (this last field is optional).
3. Select the "Formula" attribute type.
4. In the Formula Editor, add your formula. You can refer to our Formula Cheat Sheet for a guide on how to write formulas in Plytix, as well as a list of operations available to work with.
In my example, I am using a simple CONCAT formula to concatenate my product SKU and Label.
5. You can validate it by clicking "Validate Formula" to make sure it works by adding mockup values for the attributes you selected.
6. Then, click "Run Test."
To view your formula attribute in your products:
Head to a product's detail page. You'll notice that your attribute will be automatically assigned to your products.
ℹ️ Note that formula attributes can't be added to Product Families. If you wish to group your formulas, you can do so by adding them to attribute groups.
You can also view it in the Product Overview.
ℹ️ To choose which attributes you'd like to see in the Product View, click "Edit columns" to remove or add attributes from the display.
If you have referenced other attributes in your formula, the formula value will update every time the referenced attributes change. In my example formula above (insert formula here), the value will update whenever my Label or SKU changes.
What's Next?
- Find a full list of all the formula operations that are available in Plytix
- Learn how to use and set up advanced webhooks to receive updates about your products
- Learn how to create and manage Plytix channels for data syndication