Creating new Product orders

[DaveK]

I'm trying to create an import script for a proprietary system, which has each order listed as an individual package. I was wondering how to automatically add a product, and set it's recurring payment to a unique amount per product, per client (clients registered at different times have different prices due to promotions)

 

Edit:

It seems like the sql table "tblhosting" has most of this info, however I was unsure how to link this to an orderid.

Edited July 8, 2009 by DaveK
more info added

[Matt]

Hi,

 

You will need to add your clients to the tblclients table, and their services to tblhosting where the relations are tblhosting.userid=tblhosting.id and tblhosting.packageid=tblproducts.id. You can set the tblhosting.amount field on a per user basis to overide the product default and don't need to worry about creating order entries for the items you manually add.

 

Matt