Print Page | Close Window

Orders Data

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=6036
Printed Date: 28-April-2024 at 7:21am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Orders Data
Posted By: joshs
Subject: Orders Data
Date 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




-------------
Josh Shirley
josh@windsurfutah.com



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net