by 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