I have read a few topics on this in the forum and cant find a clear direction for what i need to do. Basically I am extending the ecommerce functionality as my client has custom products (that the user generates themselves via a form) < this bit is all working and ready, what i need to do is once the custom product has been generated - insert this product into the SiteTree and Product tables (both Normal and Live) without any manual intervention, this should be seemless for the user, once i have inserted the product (pages) then it will be added to the users basket, and the admin will have a reference for it in the backend (custom products will be hidden to users).
So far i have all this functionality down, appart from automatically inserting into the database.
the way i see it is i could insert into SiteTree, SiteTree_Live, Product and Product_Live, but I've found posts that are contrary to this method, suggesting that we should use Dataobject or even just insert into the non live versions and then publishall (the latter of which isnt appropriate in this case unless i can execute publish all without being logged in).
Could you please advise as to the best course of action to acheive the above?
Cheers and thanks in advance.