2

A client has variable tax amounts per product therefore require the use of Fixed Product Taxes (FPT). We also require the ability to use Catalog Price Rules to apply discounts on the catalog. Unfortunately, even after ensuring "Apply Discounts To FPT" is enabled, the discount is being applied to the product price but not the Fixed Product Tax amount. I assume "Apply Discounts To FPT" only takes affect in Sales Rules as oppose to Catalog Rules.

For example

Normal Price Calculation:

Product costs: £34.16

FPT Amount: £6.83

Total: £40.99

Catalog Rule applies 30% off Price Calculation:

New Product Costs: £23.91

Total: £30.74

Therefore it is still applying £6.83 rather than 30% off £6.83.

Is there a way of applying Catalog Rules on FPT amounts?

  • Hi Raj, not sure, but: your tax seems to be about 20%... are you sure that you can't go with a few tax rules for products (like, in Germany, we have 7 or 19% that must be chosen on product-creation), but have to use FPT? – simonthesorcerer Oct 21 '14 at 23:00
  • Thanks for you reply. Unfortunately, the client has varying types of products. Some which are fully taxable but others which are partially. E.g. An academic book isn't a taxed product in UK but a CD contained within the book is taxed. The client has worked this out and provided via an ERP and vary in percentages. – Raj Oct 22 '14 at 12:59
3

Raj,

Catalog Price Rules are calculated in advance by Magento, before rendering a page. Also these rules do not include any tax calculation for product. They are applied before tax gets calculated for a product. Also fixed price tax, same as regular taxes, are always applied on top of the final price calculation of the product, so you never get discount on FPT.

So the logic in standard taxes is like that:

  1. Config option -> Catalog Prices "Including Tax":

    Our product price is already including tax, so it will just calculate what is the base price without tax (by using default tax country for admin) and use it later on in checkout and catalog to show tax amounts, depending on the product tax classes.

  2. Config option -> Catalog Prices "Excluding Tax": Our product price does not include tax, so it will use it as a base price and just will calculate prices depending on customer group, location, etc.

But your problem seems not in FPT logic itself, since this functionality is done specially for fixed fee, not a percentage. Usually FPT is used as fixed amount, like fee to plastic bottle, so people return it back to recycle, to get the fee back. For instance in NL they charge 0,25 EUR for each plastic bottle of drink you buy in supermarket, and you can get them back if you return it to supermarket.

In your case FPT is not applicable at all, since CD is bundled with book and it is different pricing model. In my point of view, you were supposed to use "Bundle" product type and have your book and cd as separate simple products with own tax classes. Then in checkout process and on product pages the prices are calculated correctly. But, this one has some drawback on category pages, but this is another story.

  • Thanks Ivan. We figured that would be the case and we've had to unfortunately change our approach to catalog price rules. The client's ERP now handles price changes inclusive of changes to FPT. Now that you've confirmed catalog rules does not take FPT into consideration, I can accept this as an answer. – Raj Nov 14 '14 at 9:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.