With their added flexibility, automatic rules open up a world of possibilities to online retailers when it comes to adjusting their product catalogue. The goal is to make them the best retailers with a complete, personalised, and optimised feed.
To perfect your product catalogue whilst still adhering to the requirements of your chosen channels, automatic rules allow you to programme and automate a number of recurring tasks, saving you precious time. At Lengow, automatic rules are one of the major features of our platform. To help you set up these rules for your products, here are some examples of how to use them.
Automatic rules allow you to modify and update your product pages. You can add a number of conditions, starting with the values entered in your catalogue (titles, descriptions, etc).
By creating a rule, you can edit the brand name of the products you sell, with a rule that changes, for example, the brand ‘HP’ to ‘Hewlett Packard’. The description column of your product catalogue can also be updated or even filled from other fields of your product catalogue, if it has not already been filled in.
Example: You’re selling a lamp. If the ‘shade’, ‘power’ and ‘bulb type’ fields are separate in your product catalogue, you could set up a rule that will group them to create a custom description.
With automatic rules, you can also change the characters in your fields to uppercase or lowercase. So you can put all the characters in the ‘Title’ field in lowercase with the LOWER syntax ($ field_textual), or in uppercase with UPPER ($ field_textual). To do this, go into the product attribute matching area and add LOWER or UPPER. Once this step is completed, make sure that your changes have gone through by previewing your catalogue.
1: The title ‘lengow t-shirt – m size’ is in lowercase:
2: by changing the field, the title is now in uppercase:
To avoid stock shortages and disappointing your customers, you can put a rule in place to make sure items that are low in stock aren’t sent. If you have low stock or you’re a “just-in-time” business, this rule is an essential!
Example: You want to remove your product when it has only 5 items left. I set a rule that says that if my stock level reaches 5, then my stock automatically becomes 0 and is removed.
If you’re selling on a marketplace, it’s important to make sure that your stock management is impeccable, otherwise you could be temporarily or permanently excluded by these platforms.
See also: Amazon: How Can I Reactivate My Seller Account After Suspension?
With mathematical functions, you can round up or perform different types of calculations (additions, multiplications, divisions or subtractions) to apply updates to your product catalogue.
Example: You want to highlight a product by offering free shipping, and to do this, you want to reduce your selling price by 15% and add a delivery fee of 5% within the price of the product. The calculation needed will be: CALC (($ PRICE * 0.85) + ($FDP*1.05)).
Note: You can also use mathematical functions to include the marketplace commission in the price of your product directly.
If you’re distributing your products internationally, you can also use this feature to adjust the exchange rate of your products and thus convert a product into another international currency. For Euros, for example, the will be: CURRENCYCONV($PRICE,EUR).
As each channel has its own specificities, the rules will be really useful for managing requests on a case-by-case basis for different channels.
Take Amazon, for example. Managing product attributes is compulsory, but it quickly becomes complex without automatic rules. These rules allow you to differentiate parent products from child products, and to add the types of attributes you want to include (size, colour, etc).
If you distribute your products on Google Shopping or Spartoo, you can match your product categories with the requested genres (Men = M for example). To do this, you will need to use conversion lists to change the values of a field in your catalogue and match it to the values required by the channel.
After setting up your automatic rules, you will be able to choose their activation date. This is especially useful during promotional periods, like during a flash sale for example, as you will have the opportunity to change your prices by products or by category. Once the period has passed, your rules will automatically turn off.
Example: If my ‘name’ is ‘sticker’, then my ‘price’ drops by 10% for a week.
You can set up automatic rules in Lengow during the matching stage for your product attributes. Here, you can control the number of products targeted by your rule in real time, thanks to a counter that automatically updates as soon as you change your conditions.
Example: You want to lower the price of certain products during a private sale. You can lower their prices by 10% first, then add a second rule that cancels the 10% if the price after promotion is less than £10.
To find out more about the rules, discover our video dedicated to this feature:
Are you already a Lengow client and want to learn more about automatic rules? Find out more in the Help Center.
Not a customer yet? Don’t hesitate to ask us for a free demo!
Your e-commerce library
By submitting this form you authorize Lengow to process your data for the purpose of sending you Lengow newsletters . You have the right to access, rectify and delete this data, to oppose its processing, to limit its use, to render it portable and to define the guidelines relating to its fate in the event of death. You can exercise these rights at any time by writing to firstname.lastname@example.org
We now live in the Commerce Everywhere era. Purchases can be made anywhere and at any time - and an…
These days, consumers have numerous platforms at their fingertips (e-commerce sites, marketplaces, mobile apps with integrated sales solutions) for buying…
E-commerce in Europe
Brexit means exporting goods to sell online through European marketplaces has become a whole lot more complicated. So, how do…
The e-commerce ecosystem knows no boundaries. Within the EU, retailers have seen record growth in cross-border online sales, led by…
Previously, football clubs business models were based on sponsorship, TV rights and ticket sales. This model has now evolved with…