volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 
AI OnAI Offsmart_toy

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

Radek Szymanski
Radek Szymanski
Vote:
expand_less 0 expand_more

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

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

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.