Time in Transit Database

[extragear]

Greetings:

We would be curious if anyone has tried using the UPS time in transit tool or an external program with the UPS time in transit tool in the following manner.

Lets say you maintain an external database in which you have your sku's, and an associated warehouse count for multiple warehouses.

For example,

SKU XYZ 5 Units in your Texas Warehouse, 10 Units in your New York Warehouse and 6 Units in your Florida warehouse.

In your database you also have a table that shows the zipcode for each warehouse.

Someone drops an item in the cart, enters their zipcode and clicks recalculates. Your external program queries your external database checking to see what warehouses have the item. Then it queries the zipcode database. Then queries the UPS Time In Transit tool with each zipcode.

Which ever zipcode is the closest and shortest time in transit would be the chosen warehouse. The program would then display this time in transit information to the customer.

Any thoughts on this would be appreciated. Note we realize that having orders with more than one item would pose a problem. But would think this code be taken into account as well.

What we are trying to do is present fairly accurate time in transit info and the option of allowing the customer to ship from the closet warehouse (which in our case may not be our warehouse but a suppliers) So we would only have two ship options, standard shipping which means it ships from our warehouse or the option of shipping from the closest warehouse.

Thanks

Tim Sweeney
Beldenmotosport

[CoolHeadTech]

We have a module for shopsite that does show transit time to customers when checking out. It can be easily modified to allow for multiple shipping locations.

Check out http://www.backwoods.com, add something to cart and you will see it in action. This entire site is managed with Shopsite 9.

Providing Transit time is an awesome way to provide extra customer service and the module has served our customers well.

Please send me a PM if you'd like more information on it.

-Chris
UN-Certified Shopsite Designer