Dynamic Rules: Get Sale Products

Hi Ilya,

Thanks for reaching out.

To point you in the right direction, could you please share more about what you're actually building? The best approach really depends on the use case.

For example:
- If your goal is just to get an array of on-sale products for the currently logged-in user, the simplest way is to use wc_get_products() and then loop through them checking $product->is_on_sale(). With B2BKing active, sale status already takes dynamic rules into account for the logged-in user.
- If you're building something like an admin portal where the admin can see which rules apply to each specific user, that would need a very different approach.
Also:
- Do you only need the list of products on sale, or do you also need the exact discount amount / percentage per product?
- Approx. how many products and rules will the site have? (just rough numbers, is it more than 1000? more than 100,000?)

Once I understand what you're trying to achieve, I'd be happy to go into the details, including the meaning of those keys you mentioned.

Kind regards,
Stefan

Hi Ilya,

Thanks for the follow-up.

For your use case, I'd recommend the following approach:

1. Get all products (or the products of the current category) using wc_get_products().
2. Loop through them and check $product->is_on_sale(). With B2BKing active, this already takes dynamic rules into account for the logged-in user.
3. Cache the results in a transient whose name starts with b2bking_. That way our system will automatically clear it when rules or products change.

Here's an example shortcode that lists on-sale products and works with B2BKing: https://pastecode.io/s/pz5qh37a

I recommend the same approach for the product filter: get all products first, then filter by is_on_sale().

Regarding the internal keys you found: I'd recommend against going that route unless you really need maximum performance and are prepared to spend some time working on it and testing. Those keys are only an intermediate stage in the calculation, not a final list of sale products. If you really wanted to go that way, the logic would roughly be:

(A) Read b2bking_have_discount_everywhere_rules_list_ids_elements, this contains info such as: "user_234" has a discount rule applicable to products 100, 250, 356 ; "all_registered" has discount rules applicable to products 300, 400, etc. We refer to these kind of notation "user_234", "all_registered", "group_123" etc as "elements".
(B) Calculate the current user's applicable elements. Each user will have (user_123, group_456, all_registered, everyone_registered_b2b or everyone_registered_b2c) and compare the elements of the user against that key.
(C) Merge those candidate IDs with wc_get_product_ids_on_sale() to also catch regular on sale products, not just those from B2BKing
(D) Finally, run $product->is_on_sale() only on that merged candidate set. This is still needed because the rules also have conditions, so we need this final safety check. Therefore this way you are still checking $product->is_on_sale(), just starting with a smaller list, not from wc_get_products().

Kind regards,
Stefan