Import Prices (Inventory) - Easily Update Inventory Prices

Inventory > Inventory > Inventory Inquiry > Import Prices
Job/Projects > Inventory > Inventory Inquiry > Import Prices

Import Prices Import Prices (Inventory) Overview

The Sapphire Import Prices tool enables the SapphireOne user to import pricing details on inventory items. Within Inventory mode, the user has the ability to set the price on an inventory item that is contained within the SapphireOne data file. Inventory prices can fluctuate due to a multitude of reasons, such as supply chain demand, stock shortage, inflation, trade laws, market trends, and more. The Import Prices tool is an extremely useful tool as it allows the user to efficiently change prices of all inventory items within SapphireOne.

For example, there may be a natural disaster, such as flooding, that damages a large amount of fruit and vegetable produce, i.e., avocados, bananas, potatoes, etc. Due to a shortage in supply, a vendor may increase the price of their produce, for example, a 30% markup for that particular harvest. The vendor then informs the buyer of the price changes and may have the new inventory prices on a spreadsheet, which they provide to the client. Within SapphireOne, the user has the ability to efficiently change the prices of all inventory items directly from the spreadsheet file by using the Import Prices tool, which will correspondingly update the inventory prices.

How To Use the Import Prices Tool

Once the SapphireOne user has selected the Import Prices tool the Prices alert will be displayed. The SapphireOne user is presented with two options, which are documented below.

  1. Multiple Columns – This option will allow the user to import prices for multiple columns all at the same time from a tab delineated text file.
  2. Price Code Column – This option allows for the Importing of a price for a single specific column using the appropriate code in a column in the tab delineated text file.

Selecting Import File – To select the import file, highlight your desired option and click on the OK-Button button. This will take you to the standard ‘find’ or ‘browse for a file’ screen on your local machine.

When using gateway II to import data, Column A serves as reading and writing instructions. However, in this case, headers should not be included as SapphireOne will read every row of data.

The screenshot provided showcases the initial page of a base inventory inquiry, specifically highlighting the displayed Prices section.

Prices will be displayed across two columns, starting from column A to J, with the Inventory ID and Std in columns A and B respectively. The display will end at column K for the Ex price.

Data Entry:  ID  Std  Ex 
Example 1 AACUT 300  280  240  0 0 0
Example 2 WASH  100 90  80 70 70  60  50  45 
Example 3 AASIL 100  80 70  60  50 
  • Column A – The Inventory ID must be entered here. 
  • Columns B to K – Enter prices from Column B = Standard through to column K = Exempt
  • No Data – If the cell has no data SapphireOne will not write/re-write a price for the cell that has no data. 
  • Example 1 – This will write/re-write SapphireOne new price codes all the way from Standard to B.
    • Prices from C to Ex will be re/written to zero.
  • Example 2 – This will write all SapphireOne price codes from Std to G.
    • Since there is no data in price codes H and Ex they will be left as they are.
  • Example 3 – This will write a price of 100 to the Std Price.
    • Zero Prices- Prices A to F will have a price of zero written to them.
    • Last 4 Prices – Prices from F to EX will have prices written from 80 down to 50.
  • The end of the file marker in column A can either be %%%% or %EN 

SapphireOne will only import a Tab delineated text file. So the entry of 0, zero in a cell will be held and subsequently written to the data file. It will over write any price that is in SapphireOne back to 0, zero.  If the import file is converted to an excel file at any time, excel will remove these zero’s completely. When imported, those prices that were in the data file will not be altered. 

Price Code Column import

This function operates in the same way as the Multiple Columns import function except that one column is used to tell SapphireOne to write prices to a selected price code data entry field. 

The import tab delineated text file will only need to have the three columns as seen below. 

  • Column A – Enter the Inventory ID
  • Column B – Enter the Price that is to be written
  • Column C – Enter the Price Code data entry field that SapphireOne is to write the price to.
    • Price Codes – S for Standard, A to H as they are and EX for the Exempt price code.
Spreadsheet Columns: 
SapphireOne Data Entry:  ID  Price  Price Code 
SapphireOne Data Entry:  ID  Price  Price Code 
Example1:  WASH  15.44 
Example 2:  WASH  16.50 
Example 3:  WASH  10  EX 
  • Example 1 will write a price of $15.44 into the Standard price data entry field. 
  • Example 2 will write a price of $16.50 into the D price data entry field. 
  • Example 3 will write a price of $10.00 into the EX price data entry field. 
  • The end of the file marker in column A can either be %%%% or %EN 

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?

Previous Article

Import Price Break

Next Article

Include Deleted