Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

Import Products




15 December 2009 at 5:01pm Community Member, 1 Post


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?