Announcement

Collapse
No announcement yet.

Need module to post our shipping charges to the basket charges table from OSEL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Need module to post our shipping charges to the basket charges table from OSEL

    We need to integrate our custom shipping charges into the OSEL processing.

    Approach: When our OSEL page is submitted, an synchronous AJAX routine will update our custom shipping table with the shipping charge and carrier selected by the customer. This part has been developed in house.

    What I need is a module that will take that shipping charge and carrier from our shipping table and during OSEL processing apply them to the basket charges table and suppress any shipping charge on the BROKUPS Charges table from being used.

    If interested please reply privately.
    Thanks, Larry
    Larry
    Luce Kanun Web Design
    www.facebook.com/wajake41
    www.plus.google.com/116415026668025242914/posts?hl=en



    #2
    Re: Need module to post our shipping charges to the basket charges table from OSEL

    This is an overview of what we need:
    We have our own table named “shipping” in our database. This table is keyed
    by basket ID and contains the shipping amounts and carrier names from our
    quoting program. It also contains the Viking Coders UPS shipping charge when
    there is a Viking Coders UPS shipping charge calculated.
    When the OSEL page is submitted and prior to any server processing, a column named “selected” on table “shipping” is set to a “Y” by the customer’s response to selecting their shipping method. All other rows for that basket ID on table “shipping” have the “selected” column set to “N”.
    After this processing is completed by our synchronous AJAX processing, the
    page is submitted to the server.

    Here is what we need a module to do:
    We are using the Viking Coders UPS shipping module, therefore the
    server processing obtains it’s shipping information from the BROKUPS Charges
    table and creates the BasketCharges shipping row for the basket. We need a
    change to the server processing that instead of getting the shipping charge from
    the BROKUPSCharge table, it is obtained from our “shipping” table. The shipping
    charge and carrier name to be used will be read from our “shipping” table using
    the basket ID for the order and a “Y” in the “selected” column. Using this
    shipping amount and carrier name from that row, the BasketCharges shipping row will be created.

    Hope someone can help us with this.
    Larry
    Larry
    Luce Kanun Web Design
    www.facebook.com/wajake41
    www.plus.google.com/116415026668025242914/posts?hl=en


    Comment


      #3
      Re: Need module to post our shipping charges to the basket charges table from OSEL

      Oops. The table name should be BROKUPSBaskets not BROKUPS Charges.
      Larry
      Larry
      Luce Kanun Web Design
      www.facebook.com/wajake41
      www.plus.google.com/116415026668025242914/posts?hl=en


      Comment


        #4
        Re: Need module to post our shipping charges to the basket charges table from OSEL

        Update: Kent Multer took this on and after refining the requirement together, came up with an excellent solution.
        Great work on his part. Thanks Kent!
        Larry
        Larry
        Luce Kanun Web Design
        www.facebook.com/wajake41
        www.plus.google.com/116415026668025242914/posts?hl=en


        Comment

        Working...
        X