View Single Post
Old 06-23-2009, 05:27 PM   #14 (permalink)
Ryan Brown
Certified Partner
 
Ryan Brown's Avatar
 
Join Date: Mar 2006
Location: San Diego, CA
Posts: 182
Ryan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud ofRyan Brown has much to be proud of
Default

Sounds like a great way to use the 3 price types aberry. As far as a way to maintain your cost values across all 3 price levels in an easier way - try filtering your Product Grid in MMPD for a selection of database items, then clicking on the Excel button. This will prompt you to export data to a CSV file (will export whatever is filtered for in the grid).

Once exported - remove any data columns from the sheet you will not be updating (makes your life easier and reduces chances for errors). Take the cost from UnitCostA and paste the value into UnitCostB and UnitCostC. Thsi way you can easily make sure all cost values are the same without editing each item one at a time.

Once finished editing the CSV sheet save and import it back into D-Tools from the Import tab in MMPD.
__________________
Ryan Brown
Media Environment Design
Founding D-Tools Certified Partner
(760) 434-9040
ryanbrown@medesign.tv
Linked In
D-Tools Custom Reports
Free D-Tools QuickTips Videos
Ryan Brown is offline   Reply With Quote