Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

How to build a database of product SKUs, each customer assigned specific SKUs?

I've tried searching but cant figure out the best setup. Any help would be appreciated.

Lets say I have 5 product SKUs. And I have 10 customers. Each customer is assigned specific SKUs. Example, customer 1 is assigned SKUs A and B. Customer 2 only assigned SKU A. Customer 3 assigned all SKUs A to E. An order form would display only their assigned SKUs.

I understand creating tables for customers and table for SKUs. But how would I assign the SKUs to the customer and create an order form that displays those assigned?

0 6 1,321
6 REPLIES 6
Top Labels in this Space