Simple products in Magento store are always showing as "Out of Stock", with no add to cart button on product page. There is an add to cart button on the category page, and you can add the product to the cart.
Inventory settings are correct and products are enabled and "in stock" in backend.
Recently, I switched suppliers so I had to delete all products. To do that I emptied (TRUNCATED) some databases and then I uploaded all my new products from my new supplier. Ever since then, all my products show as out of stock, even though they are in fact in stock.
I am not sure if this is happening because of me emptying those DBs or not.
If we have to, we can take out all product and sales information and start from new DB and import all products again.
*I need you to make my products show in stock and have the add to cart button on the product page. I also need for you to show me what you did to fix this because if it happens again, I need to know how to fix it.
*Also, another part of this job is a small task. On the product page, the related items do not show properly. They sometimes line up in a nice grid in 2 rows, but other times they are all over the place not lined up properly.