In my original post I was asking whether it was possible to use e-cart to change the shipping provider. Instead of using one of the shipping providers that provide real time quotes, I wanted to set up some shipping rules to handle the shipping costs.
As I’m setting up a store for a clothing business I need to work out how to create these shipping rules in ecart and have them work with powerstore. The following are the 3 rules:
Within the state where the store operates, there are 2 zones where each of these zones have a separate shipping cost. So they planned to charge a fixed rate depending on which zone the order was delivered to. This fixed rate would be for orders under 25kg, so since we wouldn’t know in advance how many items would be purchased, would an average clothing item in each clothing category need to be weighed and then this weight multiplied by the quantity purchased in the order to get a total weight. Then if it comes to less than 25kg, the standard rate would apply and for every 5kg above 25kg an extra certain dollar amount would need to be added.
Then there’s another rule that would need to apply for interstate orders. The interstate areas are divided into zones with each zone being a different price. There’s a starting price for the first 5kg weight order and then an additional separate price for each 5kg after that, so like the first rule, would I need to have a garment weight in a database and then multiply this weight by the qty purchased? If the quantity is 5kg or below the standard rate would apply, and if it was above 5kg then I’d need to add the extra price which would be multiplied by each 5kg above the initial 5kg.
The third rule would be for international orders where there would be a list of countries with each country having a fixed shipping rate.
Would someone be able to comment on this and tell me how I'd go about setting it up? Would I need to create extra tables in the database and how would it work with Powerstore?
Really appreciate any advice.