Formatted Price Files for OASIS

This article will explain the required file format for importing pricing information into OASIS. 

File Format

The file must be in .XLS, .XLSX, or .CSV format. Each cell must be delimited with the ASCII TAB character.

The file must contain the following header information:

Row 1: Instruction 

Row 2: Column headings

Instruction Options

The instruction on line 1 conveys what action the pricelist is intended to perform. There are three instructions:

• UPDATE ONLY- data is updated in OASIS and no new fixtures are added. 
• ADD/UPDATE- data is updated in OASIS and new fixtures are created.
• REPLACE- data is replaced in OASIS. 

Column Headings – Attributes

The list below provides all possible attribute columns that be imported into OASIS price files. Attributes in red are required. 

• PartNumber
• NewPartNumber (used for the REPLACE instruction line only)
• AdderCodes
• Description
• MFGClassID
• StandardCarton 
• Stock
• UnitQuantity
• UnitWeight
• UPC
• SubstitutionNotes  
• MFGPart
• FreightClass 
• EffectiveStart
• EffectiveEnd
• OverageSplit (only use if different from default MFG terms)
• CartonLength
• CartonWidth
• CartonHeight
• PartQuantity
• MFGWarehouse
• Voltage
• Finish
• WLamp
• MFGQuote
• Program
• ShowInPriceBook (Y/N)

Column Headings - Pricing

Price columns start with “P:” for price or “C:” for commission followed by a number from 1 through 15. The number is used to group pricing and commission columns in the price file. A commission column is required for every price column.

The following columns define pricing for a 10% column and a 15% column:

• P1: 10% Pricing 
• C1: 10% Pricing
• P2: 15% Pricing
• C2: 15% Pricing

Example Spreadsheet

File Name

The file name format below is recommended:

PRICING.[MFG].[NOTE].CSV

Where: 

[MFG] is the ID for the manufacturer/brand provided by Ingen Software

[NOTE] is typically the date in the YYYYMMDD format

If breaking a file into multiple segments, include a description of the file segment in the [NOTE] section. For example: