This discussion is archived
2 Replies Latest reply: Sep 20, 2012 8:02 PM by L S P.. RSS

Active shopping cart detail and status in istore

L S P.. Explorer
Currently Being Moderated
Hi all,
I have the following issues in istore.

1)I will working on istore implementation process in R12. Can u please tell , where the active shopping cart will stored , and what is the status for that cart.

2)I will login in to istore add one item to shopping cart and i click log out . After that i will again login to istore and click cart link means , it will retried the existing cart details to the shopping cart. My question is how it will retrieves the all cart details.

Please help me on this..

Thanks
  • 1. Re: Active shopping cart detail and status in istore
    Pradeep Kalyan Journeyer
    Currently Being Moderated
    Prab,

    Once you add an item to a cart, the line level and header level details get created in the Order Capture tables.

    ASO_QUOTE_HEADERS_ALL
    ASO_QUOTE_LINES_ALL

    As the DB table holds the value even if you log out, you would be able to retrieve it anytime u login.

    Please check the article about Order Capture
    http://www.oracleappstips.com/2011/06/oracle-order-capture-overview.html

    When an Item is added to the cart, Cart will be created in ASO_QUOTE_HEADERS_ALL table with status_code as 'iStore Draft'
    When a Cart is converted Quote,cart will be updated in ASO_QUOTE_HEADERS_ALL with status_code 'Draft'

    Please let me know if it is still not clear to you.

    Thanks
    Pradeep

    Edited by: Pradeep Kalyan on Sep 20, 2012 4:20 AM
  • 2. Re: Active shopping cart detail and status in istore
    L S P.. Explorer
    Currently Being Moderated
    Now its clear for me.

    Thanks,
    Prab

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points