Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

[11.2] SQL Query/ SP to get Shipping form and lineitems based on Cart id

Radek Szymanski
Radek Szymanski
Vote:
 

I do not have the access to customer episerver UI but the DB in read only mode.

Does anyone have a SQL script or StoreProd for getting the shippment Form and its line items based on a cart id?

#185234
Nov 13, 2017 11:35
Joel Yourstone
Joel Yourstone
Vote:
 

What do you want to do with them? What data are you interested in getting? You can always use a tool like Sql Server Management Studio to browse your database tables.

#185238
Nov 13, 2017 12:40
Quan Mai
Quan Mai
Vote:
 

Exec ecf_Load_ShoppingCart_OrderGroupId @OrderGroupId = @cartId should work for you.

However using SP directly is not something we recommend. 

#185241
Nov 13, 2017 14:00
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.