I'd like to import products from a quickbooks .IIF file, basically a tab delimited file. I've created a script using ORM but it is very inconsistant meaning it breaks at different places. My server may not be able to handle such a task so I'd like to take a different approach and just process via myql inserts and deletes if necessary.
When inserting a product I insert data into the Product, Product_Live, and Product_versions tables to simulate a publish. Same for SiteTree, SiteTree_Live, and SiteTree_versions. Then when i go to the live site i can see categories but when i click on them, i get "Sorry, it seems you were trying to access a page that doesn't exist." It's not until i view the product or category in the backend and hit save and publish that it actually displays in the frontend. Why? What step of the publish am I missing with mysql inserts?