ttoomey Posted December 16, 2003 Share Posted December 16, 2003 My shop ships from 2 locations, TN and CA. I would like to ship the products to the customer based upon which of these 2 locations they are closest to, but it seems as though OScommerce is only capable of calculating the shipping cost based on one of the two stores: the one you configure in the Shop Configuration. I am out of ideas and need a good fix for this. If there is no fix and I need custom coding that I have to pay for so be, but I need a solution fast. If you have a solution or would like to offer services please post asap or email: [email protected] Assault If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules. T-Shirts with an edge Powered by OSCommerce + about 20 different custom addons and some Wordpress Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 you could write a query based upon the zip code range, ie anything from 00001 to 55555 from one location, rest from the other (just threw the numbers in as example) and you will also need to have two shipping accounts for each shipper you use, have to switch things based upon that . .. Link to comment Share on other sites More sharing options...
ttoomey Posted December 17, 2003 Author Share Posted December 17, 2003 The question is how do I get the cart's shipping module to charge based upon the closer of the 2 factory locatoins? I know how to do the query to assign it to a location, but how will the cart know which of the two locations to calculate shipping distance? It only knows about one in the configuration part of the Admin. please help?! Assault If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules. T-Shirts with an edge Powered by OSCommerce + about 20 different custom addons and some Wordpress Link to comment Share on other sites More sharing options...
peterx Posted January 9, 2004 Share Posted January 9, 2004 Ah, the joys of supply chain, This all happens during ATP (availability to promise) based on the following factors - You must keep note of - 1. Stock in warehouse + inbound deliveries/goods receipt + manufacturing runs - outbound deliveries/goods issue > ordered quantity This will get any potential warehouse available to ship. 2. Your warehouse address (shipfrom) and 3. Your customer's shipto address Based on a carrier distance matrix, calculate the lowest cost/distance between these two points and you have your route. If the customer has ordered more than you can supply out of one warehouse then you should check other potential warehouses and split the delivery and charge additional freight costs (if the customers will allow split deliveries) otherwise you have to shift the promise delivery date forward until enough material/product is either manufactured or procured through suppliers. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.