Project Detail

Description

I have many suppliers that I use and some of them charge sales tax if the order is shipped to a state that they operate in. I need a custom solution to charge sales tax based on who the supplier of the product is and what state the product is being shipped to.
-------------------------------------------------------------------------------------

So for example, assume the following 4 suppliers: A, B, C, D

Supplier A charges sales tax to any shipments to California (8%) and New York (8.5%)
Supplier B charges sales tax to any shipments to California (8%) and Texas (7%)
Supplier C charges sales tax to any shipments to New York (8.5%) and Ohio (5%)
Supplier D does not charge sales tax anywhere

I have already created an attribute called “supplier” which I added to each product. I need the backend to have a section called “Manage Supplier” (possibly under Catalog). In that section, I would have all of my suppliers listed (to be pulled from the attribute “supplier” if possible) to be able to edit their information.

For each supplier, I need each of the built-in Magento states to show and a field where I can enter a sales tax percentage. If the field has a value entered then that percentage would be applied to that product during checkout if the ship to address is in the same state. If there is not a value entered for that state, then tax would not be applied to that product.

The default tax would still be set up under Sales->Tax->Manage Tax Rules. This default tax rule would apply to all products. Currently this is set up for the state of Virginia. This default tax would apply to any shipments made to Virginia. Shipments to any other state would depend on the Supplier Tax setup under Manager Supplier.

-----------------------------------------------------------------------------------

Here are a few checkout examples…

Order 1 – one product from Supplier A and one from Supplier B shipping to Texas. The sales tax of 7% is to be charged for the product from Supplier B only.

Order 2 – one product from Supplier A and one from Supplier B shipping to California. The sales tax of 8% would be applied to both products.

Order 3 – one product from Supplier A, one product from Supplier B, and one product from Supplier C shipping to New York. The sales tax of 8.5% is to be applied to the product from Supplier A and from Supplier C.

Order 4 – one product from Supplier C and one product from Supplier D shipping to Virginia. The default sales tax is to be applied to all products because Virginia is set as the default tax state under Sales->Tax->Manage Tax Rules

-----------------------------------------------------------------------------------

Experienced Magento developers wanted. Please let me know your cost and how long it would take you to complete this project.

Thank you.