Print Page | Close Window

Orders Data

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
Printed Date: 21-May-2022 at 8:17am
Software Version: Web Wiz Forums 12.04 -

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. 

Josh Shirley

Josh Shirley

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 -
Copyright ©2001-2021 Web Wiz Ltd. -