I have a master spreadsheet where all the products and related barcodes are stored. This is my distributor’s app. Next, I have customer apps where each customer has its own data, but the products, barcodes, and prices are the same as the distribution app. If I use importrange to sync the data, I can not set the barcode column as key and if the barcode column is not set as key then the scanner function doesn’t work. I have to have separate data sheet for customers because there are additional columns there such as their own selling price which each customer would have a different price.
What would be a work around for this. As I have to copy and paste to each customer’s data every time we add new product or change prices or images on the distributor’s spreadsheet