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:
catalog_product_entity
catalog_product_entity_int
catalog_product_entity_varchar
catalog_product_entity_text
catalog_product_entity_decimal
catalog_product_entity_datetime
catalog_category_product
catalog_category_product_index
catalog_product_entity_media_gallery
catalog_product_entity_media_gallery_value
cataloginventory_stock_item
cataloginventory_stock_status
catalog_product_index_price
catalog_product_index_eav
catalog_product_website
catalog_product_super_attribute
catalog_product_super_attribute_label
catalog_product_super_attribute_pricing
catalog_product_relation
catalog_product_super_link
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!