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
Author
Message
joshs View Drop Down
Newbie
Newbie


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. 

Thanks
Josh Shirley


Josh Shirley
josh@windsurfutah.com
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.