You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Divesh Dutta (JIRA)" <ji...@apache.org> on 2009/11/30 05:53:20 UTC

[jira] Created: (OFBIZ-3275) Saving more information when Cart gets abandon in ecommerce

Saving more information when Cart gets abandon in ecommerce
-----------------------------------------------------------

                 Key: OFBIZ-3275
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3275
             Project: OFBiz
          Issue Type: Improvement
          Components: order, specialpurpose/ecommerce
            Reporter: Divesh Dutta
             Fix For: SVN trunk


Saving more information when Cart gets abandon in ecommerce

1) Save information like Grant Total, Total Discount, total sales tax, total shipping, in database when cart gets abandon .

2) Also save information related to Promotion and Promo codes which were applied in the cart 

Solution: 

1) For #1  Create new entity called CartAbandoned and save cart specific information in this entity.  

2) Also related this entity with CartAbandonedLine entity.

3) Create new entity CartAbandonedProductPromoUse which will save Promotion related information.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OFBIZ-3275) Saving more information when Cart gets abandon in ecommerce

Posted by "Divesh Dutta (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-3275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Divesh Dutta updated OFBIZ-3275:
--------------------------------

    Attachment: OFBIZ-3275.patch

Here is the new patch with length of "foreign key name less" than 18 as this shows warning on start up. 

> Saving more information when Cart gets abandon in ecommerce
> -----------------------------------------------------------
>
>                 Key: OFBIZ-3275
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3275
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: order, specialpurpose/ecommerce
>            Reporter: Divesh Dutta
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-3275.patch, OFBIZ-3275.patch
>
>
> Saving more information when Cart gets abandon in ecommerce
> 1) Save information like Grant Total, Total Discount, total sales tax, total shipping, in database when cart gets abandon .
> 2) Also save information related to Promotion and Promo codes which were applied in the cart 
> Solution: 
> 1) For #1  Create new entity called CartAbandoned and save cart specific information in this entity.  
> 2) Also related this entity with CartAbandonedLine entity.
> 3) Create new entity CartAbandonedProductPromoUse which will save Promotion related information.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OFBIZ-3275) Saving more information when Cart gets abandon in ecommerce

Posted by "Divesh Dutta (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-3275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Divesh Dutta updated OFBIZ-3275:
--------------------------------

    Attachment: OFBIZ-3275.patch

Here is the patch which will save Cart specific information in CartAbandoned entity and promotion applied in cart will be saved in CartAbandonedProductPromoUse entity when cart gets abandoned.

Steps to test this functionality:

1) Go demo.ofbiz.org/ecommerce

2) Add any products into the cart and apply any of the promotion with the help of promo code 

3) Then login with DemoCustomer/ofbiz

4) Then logout from the application. 

5) Session will be destroyed and all the information will be saved in CartAbandoned, CartAbandonedLine and CartAbandonedProductPromoUse entity. 

> Saving more information when Cart gets abandon in ecommerce
> -----------------------------------------------------------
>
>                 Key: OFBIZ-3275
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3275
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: order, specialpurpose/ecommerce
>            Reporter: Divesh Dutta
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-3275.patch
>
>
> Saving more information when Cart gets abandon in ecommerce
> 1) Save information like Grant Total, Total Discount, total sales tax, total shipping, in database when cart gets abandon .
> 2) Also save information related to Promotion and Promo codes which were applied in the cart 
> Solution: 
> 1) For #1  Create new entity called CartAbandoned and save cart specific information in this entity.  
> 2) Also related this entity with CartAbandonedLine entity.
> 3) Create new entity CartAbandonedProductPromoUse which will save Promotion related information.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (OFBIZ-3275) Saving more information when Cart gets abandon in ecommerce

Posted by "Scott Gray (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OFBIZ-3275?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12783850#action_12783850 ] 

Scott Gray commented on OFBIZ-3275:
-----------------------------------

For both of these entities I have not seen the requirements that resulted in them being created so it is difficult to review them without knowing why they exist.

I'm not sure about the CartAbandoned entity, I'll explain why for each field:
partyId - The partyId is already retrievable via the Visit->UserLogin relationship, storing it here would just be duplicating data
createdDate - This is already available in Visit.thruDate
totalSalesTax, totalShipping, grandTotal, displayGrandTotal - What are these going to be used for?  Some (if not most) abandoned carts will never have reached the stage where these can be accurately calculated, so if they are to be used for reporting purposes I'm not sure how they will help?

For CartAbandonedProductPromoUse, as above I'm not sure of the need for partyId and it is difficult to review further without understanding what we are trying to achieve.

> Saving more information when Cart gets abandon in ecommerce
> -----------------------------------------------------------
>
>                 Key: OFBIZ-3275
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3275
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: order, specialpurpose/ecommerce
>            Reporter: Divesh Dutta
>             Fix For: SVN trunk
>
>         Attachments: OFBIZ-3275.patch, OFBIZ-3275.patch
>
>
> Saving more information when Cart gets abandon in ecommerce
> 1) Save information like Grant Total, Total Discount, total sales tax, total shipping, in database when cart gets abandon .
> 2) Also save information related to Promotion and Promo codes which were applied in the cart 
> Solution: 
> 1) For #1  Create new entity called CartAbandoned and save cart specific information in this entity.  
> 2) Also related this entity with CartAbandonedLine entity.
> 3) Create new entity CartAbandonedProductPromoUse which will save Promotion related information.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.