Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

Learn more about...


Which price is actually charged in Orders_ShoppingCart (Custom report)

Long story short, trying to build a report that's calculates taxes charged, and am a little confused by the orders_ShoppingCart table.  I see OrderedProductPrice, OrderedProductRegularPrice, OrderedProductSalePrice and OrderedProductExtendedPrice.  I see taxRate which appears to be the multiplier to calculate tax.  But on which price should I be working with?  Thanks for your help!
asked Jun 6, 2016 in MultiStore by tekigreg (120 points)

1 Answer

0 votes
OrderedProductPrice should be what was actually charged to the customer for each line item.  That's Quantity x whichever other column was used, which will vary based on sales, promotions, customer levels, etc.
answered Jun 9, 2016 by Vortx ScottS (13,500 points)