Filter Product by Authorized user

I would like to allow our buyers to view and purchase only authorized products. This authorization is controlled at ERP system

restriction applied at material level (material to reseller combination)

  1. Material(Document) is available for the buyer to search
  2. Material is available for the buyer, but not allowed to purchase

Right now i store them as Array attribute and filter based on that. but it takes too long to inject data in that pattern
i tried grouping database level and used aggregate filter to create a array

(group material ---buyer1, buyer2,3..n) both are taking more than 6-8hrs to process million combination

is there a optimized way to do this?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.