your approach to the problem is somewhat alien to me.
do you have 3 brands with the same code.
you need some method to check if item is list before entry to prevent duplicates.
this appears a typical stock control excerise, first establish your stock descriptions, codes etc.
then apply a stock in/out/balance procedure.