ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Suggestions
  New Posts New Posts RSS Feed - Orders Data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Orders Data

 Post Reply Post Reply
joshs View Drop Down

Joined: 07-April-2009
Location: Utah
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote joshs Quote  Post ReplyReply Direct Link To This Post Topic: Orders Data
    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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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

This page was generated in 0.063 seconds.