This article will explain the required file format for importing pricing information into OASIS.
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
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.
- NewPartNumber (used for the REPLACE instruction line only)
- OverageSplit (only use if different from default MFG terms)
- 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
The file name format below is recommended:
[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:
|PRICING.MFG.DISCONTINUED20070401.CSV||All discontinued items|