Skip to main content
Question

Blacklisted Customers

  • Nov 19, 2026 8:10 PM UTC
  • 3 replies
  • 11 views
  • Translate All

Hello,

 

I am looking for help and ideas on how to black list a customer from buying certain brands. Some of our suppliers have recently provided me with a list of customers whom we are no longer allowed to sell those brands products too. All the avenues that I have ventured down tend to rely too much on manual maintenance. I have 3000 plus customers and 100,000 plus SKUs to manually update discount codes with. I am open to any and all ideas. 

The criteria:

Customer A can purchase everything from us.
Customer B cannot purchase anything from brand B (10,000 Skus)
Customer C Cannot purchase anything from Brand B or C (15,000 skus)

How do I prevent customers B & C from purchasing while still allowing A to do so. 

3 replies

MichaelShirk
Captain II
Forum|alt.badge.img+8
  • Captain II
  • Nov 19, 2026 8:23 PM UTC

How often do these lists change? 
My first thought would be a simple customization that adds a tab to the Stock Items screen, with a list of Customers who are not allowed to purchase the product. Customers can be added or removed using an Import scenario to make it easy to do in bulk. 
Then some simple logic that runs when the customer is updated on an order, or when an item is added to an order to block anything that would match between the item and its blacklisted customers. 

Translate

  • Author
  • Freshman I
  • Nov 19, 2026 8:44 PM UTC

Thank you for the response Michael. The blacklisted customer list would change monthly with any new additions the vendor provides us, usually 1 or 2. The bigger problem is managing to the new parts, when a supplier sends us a new parts list it could be 100+ parts long and to manually update the restricted customers on every part would be a nightmare.

Translate

MichaelShirk
Captain II
Forum|alt.badge.img+8

Maybe I’m missing something. It would seems like a simple matter to do this in Excel, then import it with a few clicks using and Import Scenario. 

I don’t know how many customers the blacklisting applies to, but Claude in Excel is super powerful. It could probably take whatever format your vendor sends to you with the blacklist details and turn it into the data structure you need for the import scenario once you give it an example file that you’ve created one time to demonstrate the data structure.

Translate