London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

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

Radek Szymanski
Radek Szymanski
Vote:
0

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:
0

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:
0

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.