Overview

This document will review the process of updating a suppliers standard cost by formatting a provided spreadsheet using Microsoft Excel.

Note:  We recommend performing a backup of your inventory via the Price Import/Export.  This will give you a restore point in case of any issues.

Cost Update Spreadsheet Specifications

Note: If you are running Decor Fusion release 1.5.0.8 and are doing a Benjamin Moore Cost update this spreadsheet formatting is no longer necessary. Please refer to the following article for more information: https://decorfusion.helpjuice.com/90497-pricing/benjamine-moore-cost-update

For all other vendors a sample Cost Update Spreadsheet would look something like this:

• You will need the columns ‘Item’, ‘UPC’ and ‘Standard Cost’.  Note: You can also add a Description column to help with identifying unmatched items.

• These columns should be of type “Text”.  
• The spreadsheets name has to be Sheet1.  
• The Excel document must be saved as a “Excel 97-2003 Workbook” or “Excel Workbook”

Procedures

To perform a Cost Update on your inventory, click the Inventory Menu and select the Cost Update Wizard.  The Cost Update Wizard screen will open.

Click the Import Data button and select your Cost Update Excel Spreadsheet (See footnote on Cost Update Spreadsheet specifications).  The path and name to the file will now be displayed, note it down. This utility will work with both .xls and .xlsx file formats.

Then click the Next button.  This screen will allow you to select the update options.

On this screen you will want to select Set To Imported Cost under the Cost Change column for Standard Cost.  If you want your Price Levels associated with the imported items to update by the % change between the old cost and the new cost, select the Adjust Selling Prices. Then click the Next button.

On the next screen, click the Review button to display the pending update changes. The Cost Change Tab will show you the percent change between the previous cost and the new cost.

After reviewing the changes and confirming they are satisfactory, click the Update button. And you are done.

If instead the cost update will just be a percentage increase then please see the related article.