Thank you, I think I’ll go with this solution.
I need the third table since I need to save split data for each store.
I wanted to report a couple of what may be bugs:
1. In your doc pages the anchors don’t seem to work (ex. this link is not taking me to the tax_total section: http://haseydesign.com/flexi-cart/user_guide/cart_summary_session_data#tax_total )
2. It seems that the shipping is taxed even though $config[‘defaults’][‘shipping’][‘tax_rate’] = 0;
Example:
I’m adding one item to my cart (€22), quantity: 2 (€44), shipping is €10, set with
$shipping_data = array(
'value' => 10 //example
);
$this->flexi_cart->set_shipping($shipping_data);
Tax is 21%, set with
$tax_data = array(
'rate' => 21,
'name' => 'VAT'
);
$this->flexi_cart->set_tax($tax_data);
Results:
$this->flexi_cart->item_summary_total(); // 44
$this->flexi_cart->shipping_total(); // 10
$this->flexi_cart->tax_name()." @ ".$this->flexi_cart->tax_rate(); //VAT @ 21%
$this->flexi_cart->tax_total(); //11.34, calculated on €54
$this->flexi_cart->total(); //65.34 (54+11.34)
Results in a foreach cart items:
$this->flexi_cart->item_tax_total($row_id, false, false, false); //9.24, calculated on €44, without shipping
I’m guessing the 11.34 is wrong - tax has to be calculated on products without shipping.
Or viceversa. Actually, maybe 11.34 is correct and 9.24 is not.
How can I set this? I am not (yet) using a shipping db table, but even then I’ll still set shipping rate as shown above.
Thank you once again.