In general I'd recommend not altering the "products" table directly, if at all possible, mostly to make things easier for upgrades.
Then adapt the search code to include your additional tables' relevant fields if search is a required component to specific fields you're adding.