I have a script that mass creates products from a remote database to my Magento database. I'm sure I have created entries into every table required for the product to exist in Magento, but when I go to view the product, I can see the product page, but the product options like Color, Size, and the price do not display, along with the Add to cart button. When I go in the backend and save the product manually and go back to the product page everything appears like it should and works fine. I then created a php script to go through and save each dynamically added product using magento's save function, it loops through and saves the products, but this doesn't work, they still will not display correctly unless saved through the website.
Tables inserted into to create a product:
When I compare values to a dynamically created product and one that is already in Magento and works they are both the same, I'm just unsure of why it won't show up unless saved through the website. Any help would be appreciated, thanks!