which field shows final price?

26 Mar 2008, 9:33 AM

#1

Zen Follower

Join Date:: Apr 2005
Posts:: 199
Plugin Contributions:: 0

which field shows final price?

Hi

my products have two prices -- before tax and after tax. in zencart database, I can find before tax price in "product_price" field from "products" table, but I cannot find a field which stock final price (after tax), does anyone know which field from which table contains such data?

thank you in advance!

doubletiger

26 Mar 2008, 11:09 AM

#2

stevesh

Black Belt

Join Date:: Feb 2005
Location:: Lansing, Michigan USA
Posts:: 19,793
Plugin Contributions:: 2

Re: which field shows final price?

I'm just guessing, but that is probably calculated on the fly as part of the checkout process, and isn't stored in the database.

26 Mar 2008, 4:42 PM

#3

doubletiger

Zen Follower

Join Date:: Apr 2005
Posts:: 199
Plugin Contributions:: 0

Re: which field shows final price?

stevesh:

I'm just guessing, but that is probably calculated on the fly as part of the checkout process, and isn't stored in the database.

Hi,

I believe so as well, but it will be great if zen cart term can confirm this.

thanks!

Doubletiger

26 Mar 2008, 5:13 PM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: which field shows final price?

Only the pre-tax price is stored in the database.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

26 Mar 2008, 5:15 PM

#5

doubletiger

Zen Follower

Join Date:: Apr 2005
Posts:: 199
Plugin Contributions:: 0

Re: which field shows final price?

DrByte:

Only the pre-tax price is stored in the database.

Hi, DrByte

many thanks for your confirmation!

best regards!

Doubletiger