Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


EZier New Fields

Recommended Posts


I have gone over the entire forum looking for an answer to my question and have found it mentioned a couple of times but not really addressed.

I have the ez fields contribution installed and working fine accept for one problem that is preventing me from having it live, so for now it works but is commented out in the related files.


The problem is that after entering the FULL retail price for all my products we discovered that it is adding the tax % to the dollar amounts from the product_retail_price and over inflating the retail price on the website.

retailers in Australia can get into a lot of trouble for misreporting normal retail prices or over exagerating sales savings so we cant use it like that.

We also have several retail stores which generally do sell our products at the RRP so we need the RRP shown on the site to be acurate to our retail stores pricing and our "buy online Price" to have a lower price for our sites members.

So my question is how can I make ez fields use the actual figure from the product_retail_price field without it re-calculating and adding the tax on top of the product_retail_price.

Share this post

Link to post
Share on other sites

or you could amend all the product_retail_price to be excl tax.


There is a thread for usefull code snippets which has the sql to do this in one statement.





Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile


Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.


For links mentioned in old answers that are no longer here follow this link Useful Threads.


If this post was useful, click the Like This button over there ======>>>>>.

Share this post

Link to post
Share on other sites



This contribution works great for me, however, I also have the "Quick Updates" contribution installed and when I use Quick Updates to update the net pricing I can't seem to also update the Retail price.


Can someone please help me? I tried playing with the code myself but couldn't seem to figure it out.


Jane N.

Edited by guberish

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now