What happens when the recalculate button is clicked

General ShopSite user discussion

What happens when the recalculate button is clicked

Postby extragear » Wed Jul 15, 2009 12:11 pm

Hello:

I am curious as to what processes occur when the shopper clicks recalculate on the cart.

Also, what if anything can be made to happen in addition to whats built into shopsite. For example, could a database be queried checking to see what warehouse a product is in?

Thanks

Tim

Belden Motosport
extragear
 
Posts: 169
Joined: Mon Apr 02, 2007 10:53 am
Location: Binghamton, NY

Postby Jim » Wed Jul 15, 2009 3:52 pm

Things in the cart are rechecked. So for example if a quantity has changed the price would be recomputed, shipping charges will be recomputed, tax will be recomputed. Gift Certificates, Coupons, reward quantities updated.

The only thing that can be done, that has an interface to a merchant action, is the custom shipping add on, which will be called to calculate new shipping charges.
Jim
Site Admin
 
Posts: 4953
Joined: Fri Aug 04, 2006 1:42 pm
Location: Utah

Postby extragear » Thu Jul 16, 2009 11:36 am

What are the limitation of the custom shipping add-on? I realize that it would depend on the programming skills of whoever wrote it.

Would it be possible to pass the zip code of the shopper and sku or sku's of the items in the cart.

Then query a database consisting of:

A table containing each SKU, and each warehouse that the sku is available in. with number of units in each warehouse.

For example,

SKU Warehouse 1 In NY Warehouse 2 In Michigan Warehouse 3 California

SB707 3 21 8
TB340 0 22 9


A table containing each zipcode associated with each warehouse.


Warehouse 1 Zip Code Warehouse 2 Zip Code Warehouse 3 Zip Code

13833 58963 99658


Then determine:

1. What warehouse is the closest to the customer

2. Return two different shipping options to the customer. (note, we arent interested in providing anything other than standard ground UPS because 99.99% of the time no one wants to pay the price for faster levels of service.)

These shipping options would be:

A. Flat standard ground shipping from a default warehouse with the Shopsite shipping charges based on currency. For example, orders totaling $0 to $49.99 charging $9, orders totaling $50 to $99.99 charging $12 and orders totaling over $100 or more shipping with no charge.

Ship Standard Ground UPS From NY Warehouse


B. Ship from near warehouse option

Ship Standard Ground UPS From (Whichever Warehouse is the closest)

For example,

Ship Standard Ground From California Alternative Warehouse

The cost for this would be a flat $12 charge plus our regular shipping charges as mentioned above.

3. The time in transit from

A. The default warehouse

B. Whichever alternative warehouse was the closest to the customer.

And return the time in transit information to the shopper.

Note, if more than one item was being ordered and the items were not in the same warehouse, it would be acceptable for the order to ship from the default warehouse.

This doesnt seem to be asking too much of a custom program to do. We are curious if this might be possible before we pursue this further.

Thanks

Tim
extragear
 
Posts: 169
Joined: Mon Apr 02, 2007 10:53 am
Location: Binghamton, NY

Postby Jim » Thu Jul 16, 2009 12:19 pm

Some of that may be possible and some probably would not. Check the specs for the interface
http://shopsite.com/help/10.0/en-US/sc/ ... g.api.html
http://shopsite.com/help/10.0/en-US/sc/ ... .spec.html

What is passed to the script and what ShopSite expects back are list in those documents. What you do to get what you send back doesn't matter as long as it comes back properly formatted.
Jim
Site Admin
 
Posts: 4953
Joined: Fri Aug 04, 2006 1:42 pm
Location: Utah


Return to User Forum

Who is online

Users browsing this forum: No registered users and 123 guests