Q. Can you add products to a category called BRANDS based on the brand name field?

Yes - this can be done when a file is sent with a brand name added to the product file. The product would be added to the main category as normal, using the data entry and then the item can be added to the BRANDS category by looking up the Brand name and transforming this into the new BRANDS category in addition to the main category.