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

Member since: 2009

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
  • Member since: 2016

    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
  • Member since: 2011

    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