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
Thread: which field shows final price?
Results 1 to 5 of 5
-
26 Mar 2008, 10:33 AM #1
Zen Follower
- Join Date
- Apr 2005
- Posts
- 206
- Plugin Contributions
- 0
which field shows final price?
-
26 Mar 2008, 12:09 PM #2
Black Belt
- Join Date
- Feb 2005
- Location
- Lansing, Michigan USA
- Posts
- 20,021
- Plugin Contributions
- 3
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, 05:42 PM #3
Zen Follower
- Join Date
- Apr 2005
- Posts
- 206
- Plugin Contributions
- 0
Re: which field shows final price?
Hi,
Originally Posted by stevesh
I believe so as well, but it will be great if zen cart term can confirm this.
thanks!
Doubletiger
-
26 Mar 2008, 06:13 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
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, 06:15 PM #5
Zen Follower
- Join Date
- Apr 2005
- Posts
- 206
- Plugin Contributions
- 0
Re: which field shows final price?
Hi, DrByte Originally Posted by DrByte
many thanks for your confirmation!
best regards!
Doubletiger
Similar Threads
-
which function or class return the final price of a product?
By weber in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 24 Mar 2011, 11:58 PM -
Show special price info in shopping cart (instead only the final price)?
By Cindy2010 in forum Setting Up Specials and SaleMakerReplies: 1Last Post: 19 Jan 2011, 02:06 AM -
Specials showing lowest attribute - want to select which price shows
By jill8026 in forum Setting Up Specials and SaleMakerReplies: 9Last Post: 23 Jun 2010, 02:50 AM -
Changing the price which shows up on attributes.
By mrcoolboy15 in forum Setting Up Categories, Products, AttributesReplies: 18Last Post: 7 Jul 2008, 05:34 AM -
Quantity Discount works, but Final Price field doesn't show discount
By TJB in forum General QuestionsReplies: 0Last Post: 3 Apr 2008, 08:16 PM
