How to insert a uCommerce purchase order with T-SQL

322 views Asked by At

I've had a rare case where I have a uCommerce order, which is payed, but doesn't exist anywhere in the db.

So, I have to remake the order from scratch. I do have an existing orderID which I have to use. and I know the different products, I also have the data of the client.

My initial thought was to make a SQL insert query. But after some research I found out that I will have to make an order, orderlines, shipment, client, basket... All this has Guid's and more which I don't know if I can just make them up, or I have to create them with a specific method.

Or if their is another way to do this, that would also be fine.

In short: I want to know how to insert a uCommerce order from SQL.

0

There are 0 answers