We have two different warehouses for e.g. once is in CA and other is in VA.
We need to ship product based on state which provides low rate. We prepare list like NY should be served by VA. We also wants UPS to calculate shipping rates based on near by warehouse. Am I able to achieve this by default feature in Magento? If not, is there any code sample/trick you can suggest to achieve it? Do you suggest to use any extension? if yes, which will be best? I checked with some inventory management tools with multi warehouse but none of supports shipping rate calculation via UPS based on state selection for shipping.