OFBiz
  1. OFBiz
  2. OFBIZ-3275

Saving more information when Cart gets abandon in ecommerce

    Details

      Description

      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.

      1. OFBIZ-3275.patch
        13 kB
        Divesh Dutta
      2. OFBIZ-3275.patch
        13 kB
        Divesh Dutta

        Activity

        Hide
        Jacques Le Roux added a comment -

        Should we not close this?

        Show
        Jacques Le Roux added a comment - Should we not close this?
        Hide
        Scott Gray added a comment -

        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.

        Show
        Scott Gray added a comment - 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.
        Hide
        Divesh Dutta added a comment -

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

        Show
        Divesh Dutta added a comment - Here is the new patch with length of "foreign key name less" than 18 as this shows warning on start up.
        Hide
        Divesh Dutta added a comment -

        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.

        Show
        Divesh Dutta added a comment - 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.

          People

          • Assignee:
            Unassigned
            Reporter:
            Divesh Dutta
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development