Import Prices (Inventory)

Where Used: Inventory > Inventory > Inventory Inquiry
And also Job/Projects > Inventory > Inventory Inquiry 

Import Prices Overview

The Sapphire Import Prices tool enables the user to import the 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 from supply chain demand, stock shortage, inflation, trade laws, market trends and more. The Import Prices tool is an extremely useful tool allowing the user to simply and efficiently change the prices all inventory items within the SapphireOne application.

For example, there may be a natural disaster such as flooding that damages a large amount of fruit and vegetable produce i.e. avocados, banana, potatoes, etc. and due to a shortage in supply, a vendor may increase the price of their produce, such as a 30% mark up 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 the client with. Then 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.

.

Sapphire Tools-Import-Options Menu

Once the SapphireOne user has selected the Import Prices tool the Prices alert as seen to the right will be displayed.

The SapphireOne user then has two options which are documented below.
Multiple columns or prices from Standard to Ex.

  • 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.
  • 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 – For both options highlight your selection and select the OK-Button button and you will be taken to the standard find or browse for a file screen on your local machine. 

When gateway II is used to import data, Column A has a syntax which acts as reading and writing instructions. This is not the case here! For this reason do not include headers as SapphireOne will read each and every row of data here.

The Screen shot below is from the first page of a base inventory Inquiry with just the Prices area selected.

Because of the Inventory ID and Std in columns A and B, prices will be stepped across two colums for prices from A to J ending at column K for the Ex price.

Columns: 
Data Entry:  ID  Std  Ex 
A B C D E F G H I J K
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 over writing 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 and 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 

Was this helpful?

Next Article

Include Deleted