You can get applied rule ids of the product item from the Sales Order by order item id.
A customer has applied the shopping cart rule for the order and if any item contains that specific rules, after place order, the sales item persists the shopping cart rule id in the sales_order_item database table for the item level. Continue reading “How to Get Applied rule ids of the item from the Order Magento 2?”