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 /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Import Products

Go to End



Community Member, 1 Post

15 December 2009 at 5:01pm


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?