Akash Kumar
03/20/2026, 11:41 AMFanis Tharropoulos
03/20/2026, 11:58 AMAkash Kumar
03/20/2026, 12:03 PMranking field using sold_qty (e.g., ranking = sold_qty * 5). After this initial setup, the ranking should be adjusted dynamically based on analytics events such as clicks, cart additions, and purchases.Fanis Tharropoulos
03/20/2026, 12:33 PMranking = sold_qty * 5 as the base value. After that, analytics events can increment the same field. The problem is that if your regular sync later uses upsert without sending ranking, that base + analytics value can be overwritten or removed.
So the flow would be:
1. First, run a one-time bulk update to set the initial ranking.
2. Configure analytics rules to increment ranking for clicks / cart / purchase events.
3. Make sure future upserts also include ranking, or avoid overwriting that field in the regular sync.
Otherwise the analytics adjustments will not persist correctly.Akash Kumar
03/20/2026, 12:40 PMFanis Tharropoulos
03/20/2026, 4:17 PM