The problem is each company has about 500 plus different items in the Tables. We have prices that change on a regular basis as we import from the UK and we have to do a manual stock check as we have a retail store that sells using the same stock. Thus it will not be possible to have only one Table as I will search for hours to be able to get the product that I am looking for.
Is there no way to have the Wish List check the original Item to see if the price has changed or if the product is still in stock? I mean a company like Amazon or Ebay cant work with just one table and all the data is in there. That will cause things to become very slow when working with a database.