My suppliers vary in their location in the US and the shipping carrier they use. Some suppliers have flat rate shipping costs for certain products. Magento only allows the setup of one ‘ship from’ zip code and also does not allow for flat rate shipping by product.
a) In the backend… every product needs to have a new field created for "zip code" and "shipping carrier" (dropdown menu selection of UPS, FedEx, and USPS) that will be used to calculate the shipping cost based on the zip code entered for that product and the shipping carrier chosen (UPS, FedEx, or USPS).
b) In the backend…every product needs to have a new field for "flat shipping cost". This field would be left blank if flat shipping did not apply. If the product had a flat shipping cost, that value would be entered here and the “zip code” and “shipping carrier” would be ignored.
c) In the backend…every product needs to have a new field for “expedited shipping available” with a dropdown selection of (Y or N). Default value is Y. If Y is entered here, then the customer will have the choice of either Ground or 2-Day shipping which will be calculated based on the shipping carrier’s actual rates for those selections. For products that have flat rate shipping, the expedited shipping would not apply and would not be available during the checkout process. If the customers cart has at least one flat rate shipping product or at least one expedited shipping product that has N selected in the backend, then 2-Day shipping will not show up as an option during checkout. The only time that 2-Day shipping should be an option in the checkout is if all of the products in the cart have Y for the expedited shipping available field.
c) In the frontend…the customer would NOT have a choice of shipping carriers during checkout. The customer would only choose whether they want Ground or 2-Day shipping (if all products set to Y for expedited shipping above). The customer is not to see what carrier was being used for shipping.
d) The shipping estimator would also need to work if the customer wants to estimate the shipping cost before they Proceed to Checkout.
Item A has zip code 22193, ships via UPS, has expedited shipping available
Item B has zip code 22193, ships via UPS, does not have expedited shipping available
Item C has zip code 12550, ships via FedEx, has expedited shipping available
Item D has a flat shipping cost of $40.00
The logic would be as follows:
1. If a customer buys Item D, no shipping option would show during checkout and the total shipping would be $40.
2. If a customer buys Item A and Item C, then both Ground and 2-Day shipping would show as an option and the total shipping would be the UPS calculated rate for A + the FedEx calculated rate for C.
3. If a customer buys Item A and Item B, then no shipping option would show during checkout and the total shipping would be the UPS calculated rate for Item A + the UPS calculated rate for Item B.
4. If a customer buys Item A and Item D, then no shipping option would show during checkout and the total shipping would be the UPS calculated rate for Item A + $40.00.