Missing log of product items in a cart on checkout

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
2/19/2009 4:52:13 PM
OneScreen
Gravatar
Total Posts 4
View Posts

Missing log of product items in a cart on checkout

Scenario: Through the Store Manager, I define a few Products and link them to Offers available on the WebStore. Now as a buyer of products, I select some products (varying quantities) and proceed to checkout. Upon successful (dev env.) payment, I notice that a corresponding row is added to the mp_AuthorizeNetLog table for that transaction. It even has a Cart Guid column field populated.

Issue: However, I am unable to find any logs in either ws_Cart or ws_CartOffers or ws_CartOrderInfo (in fact, there are no entries in these tables). Although I did notice corresponding stored procedures, I don't think they are being used. In essence, I am looking for a log of individual line items (Products/Offers) in a cart with the quantity and amount information upon checkout/payment.

So,

        (a) Is this feature available and

        (b) what would I need to do to get this working?

Thanks in advance!

2/19/2009 5:00:17 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing log of product items in a cart on checkout

Hi,

Once an order in WebStore is placed and paid for things move from the ws_Cart, ws_CartOffer, ws_CartOrderInfo into ws_Order, ws_OrderOffers, ws_OrderOfferProduct tables and the previous rows in the cart tables are removed.

Also now in svn, order information is pushed into reporting tables and reports are available under Administration Menu > Commerce Reports. vThe same data populates the user order history in the profile/my account page.

Hope it helps,

Joe

2/19/2009 5:08:55 PM
OneScreen
Gravatar
Total Posts 4
View Posts

Re: Missing log of product items in a cart on checkout

Great!

Thanks Joe.

You must sign in to post in the forums. This thread is closed to new posts.