ProductCart Shopping Cart Software Forums : Orders Data https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 12:40:39 +0000 Mon, 12 Oct 2015 19:31:46 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=6036 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Orders Data : Please add a few new columns to...]]> https://forum.productcart.com/orders-data_topic6036_post22530.html#22530 Author: joshs
Subject: 6036
Posted: 12-October-2015 at 7:31pm

Please add a few new columns to the ProductsOrdered table.

Discounted Unit Price: UnitPrice minus unit discount  (qty discount, retail sales discount, whatever)  
IE:  UnitPrice = 12.00, Quantity = 10, [UnitPriceDiscounted] = 11.25
Store discounts change often - going back into the items history - there isn't data to look at line item discounts.

QOH: adding the quantity on hand at the time of the sale would be very useful in MRP calculations and inventory history.  Could even be a huge time saver come tax time.

In analyzing sales data these are often numbers we are seeking to use.

Adding this personal customization is possible - until the store gets constant updates that overwrite the customization. 

Thanks
Josh Shirley


]]> Mon, 12 Oct 2015 19:31:46 +0000 https://forum.productcart.com/orders-data_topic6036_post22530.html#22530