When using feed rules in Google Merchant Center, it’s essential to know that not all operators are readily accessible. In addition, the available operators will vary depending on the attribute you select to apply the feed rules to. For instance, if you choose to use the feed rules to the price attribute, the available operators will differ from those accessible when applying feed rules to the product title. However, this article will reveal a hidden gem that will unlock all operator options for you.

Example Problem:
A common obstacle many face is the calculation of margins, for example, checking if the margin is less than $5 exclude the product within Google Merchant Center. Unfortunately, the calculate function is not accessible when selecting custom labels, which makes it challenging to assign custom labels to products that require numeric calculations.
Solution:
Fortunately, there is a way to solve this problem by creating a custom attribute. This involves creating a custom attribute in the feed rules, which will allow you to calculate a numeric value of your products and assign a custom label to them.
Step-by-Step Guide: (for the above example, and assuming you have assigned cost of goods sold)
- Go to Feed rules and click on the plus icon.
- First, we need to check which value to use, the price or sale price. Create a custom attribute, such as price or sale price value. An asterisk will appear in front of your custom attribute when you type it, signifying it’s a custom attribute name.

- Now set the data source to sale price if it has a value and default to price otherwise.
- Save as draft

- Create another custom attribute and now set the data source to price or sale price value and set the modification to calculate and subtract cost of goods sold
- Save as draft

- Now create a rule for excluded destinations, if the margin is less than 5, exclude.

Don’t Forget:
It’s important to note that Feed rules won’t automatically apply immediately. To ensure they take effect, head to the processing tab and manually click on re-process. If the re-process option isn’t visible, you can use a supplement feed to reprocess instead.
Conclusion:
By following these steps, you can effectively calculate the unit price of your products and assign custom labels to those with a low unit price. Stay ahead of the competition and make the most impact in the online marketplace by utilizing the full potential of custom attributes in Google Merchant Center.
I want to add multiple value to the title contains. should I just add a comma and a space? or do i need to add the multiple titles one by one?
You can add multiple values, by adding another modification rule.
Hello! This very useful! I just want to ask, for the part where we can exclude showing up the products on ads when the margin is less than $5, how does this works? How would Google know that the margin that they were about to show up on ads is less than $5?
Also is there a way to set the value as a percentage? Do I still set it as a value? For example, I want to exclude showing up on ads when the margin is less than 35%, in that case I will set the value as 0.35?
Thank you,
Tammy =)
By adding cost_of_goods in the feed, mroe info: https://support.google.com/merchants/answer/9017895
If you want to calculate percent, you need to use the basic mathematics, so 0.35 is correct.
How can i remove the google merchant center suspension policy violation and misspresentation. After fixing some issues the suspension still active. Can you please help me with this.
Hello Abdus, feel free to email me at [email protected] for personal assistance.