Jump to:

3373 Posts in 998 Topics by 712 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Import Products

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

Page: 1
Go to End
Author Topic: 876 Views
  • ozzierod
    Avatar
    Community Member
    1 Post

    Import Products Link to this post

    Hi,

    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?

    876 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.