SQL for getting promos applied to an order
I require an SQL query to retrieve information about the promotions applied to an order from the sales order table. The field “applied_rule_ids” is utilized to obtain all rule IDs. However, a challenge arises when a rule, such as “buy… Read More »SQL for getting promos applied to an order