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)
- Material(Document) is available for the buyer to search
- 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?