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

[wajake41]

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

[wajake41]

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

[wajake41]

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

[wajake41]

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