Wiki

Case Status
Log In

Wiki

 
Formatted Price Files for OASI…
  • RSS Feed

Last modified on 6/20/2017 10:26 AM by User.

Tags:

Formatted Price Files for OASIS

Overview

This document describes a file layout used by OASIS that may be created easily in a program or by hand using a spreadsheet application. The file format allows for new, obsolete and partial data loading (e.g. fixture information but no pricing, followed by a file containing pricing).

This file format is also used by the Ingen Software pricing service, allowing for large amounts of pricing information to be divided up and efficiently processed regardless of the network topology involved.

Unlike an exported price file, the formatted price files allow one group (e.g. a manufacturer) to format the file and send it to all sales agencies.

The File

Version of OASIS

Although this feature has existed for some time now, this document covers enhancements added since OASIS V2.6.3 W207B1.

File Format

The file must be formatted as an ASCII text file in tabular format. Each cell must be “delimited” with the ASCII TAB character. Additionally, the file must contain the following header information:

Line 1: Instruction line (typically “ADD/UPDATE”)

Line 2: Column headings

The remainder of the file contains the pricing information.

Instructions

Instructions include:

  • “UPDATE ONLY” – Data is updated in OASIS. No new fixtures are added (excellent for creating a “discontinued” file where the user is not to be notified of discontinued items they have never seen before.
  • “ADD/UPDATE” – Data is updated in OASIS and new fixtures are created (if not already in OASIS). This is the most common instruction.
  • “REPLACE” – The “NewPartNumber” column is used to fetch the current fixture number (as “PartNumber”) then renumber the fixture using “NewPartNumber”. Other data may be included.

Row Headings – Attributes

PartNumber – REQURIED – the fixture
NewPartNumber – Only used in “Replace” mode (see above).
AdderCodes – “adder codes”
Description – fixture description
MFGClassID – manufacturer product heir.
StandardCarton – carton quantity
Stock – stocking information (just text for the user)
UnitQuantity – unit quantity
UnitWeight – weight of one item.
UPC – item UPC code
SubstitutionNotes – substitution or discontinued notice
MFGPart – manufacturer’s product code (may be UPC or ERP system code).
FreightClass – Carrier freight classification
EffectiveStart – pricing effective start date
EffectiveEnd – pricing effective end date
OverageSplit – over-riding overage split (only use if different from default MFG terms
CartonLength – length of carton
CartonWidth – width of carton
CartonHeight – carton heigth
SKU – SKU (may be used as an alternate lookup in OASIS).
PartQuantity – part quantity
MFGWarehouse – manufacturer’s stocking warehouse location (may be a list)
Voltage – fixture voltage
Finish – fixture finish
WLamp – fixture lamping (text only)
MFGQuote – manufacturer’s quote number
Program – product “sales program” information
ShowInPriceBook – flag “Y” – show in customer price book, “N”- don’t show

Row Heading - Pricing

Price columns use a colon separated method to group pricing and label the pricing within OASIS. When creating a new price “column” OASIS will define the column in OASIS automatically. When updating an existing price column, OASIS will detect the existence of the price column and update the prices in the exiting column automatically.

The price columns start with “P” for price and “C” for commission. The letter is followed by a number from 1 through 15. The numbers are used to group together the price and commission columns. Finally, the column name contains a colon followed by the column name which is limited to alphanumeric characters, ‘%’ and spaces.

For example, the following columns define pricing or a 10% column and a 15% column:

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

NOTICE: OASIS always pairs pricing and commission columns for reps (distributor version of OASIS ignore commission columns). Even if all prices for a column are the same, the commission rate MUST be provided.

An Example

Assuming the file is saved in a text file where the cells are delimited by tab characters, the following example is provided:

ADD/UPDATE

 

 

 

 

 

PartNumber

Description

P1: 10% Pricing

C1: 10% Pricing

P2: 15% Pricing

C2: 15% Pricing

RR-32-120

Round fixture, 120V,

50

10

65

15

SQ-33-120

Square fixture, 120V

44

10

54

15

File Names

Whether emailing the resulting file or storing on a FTP server, the file name recommendation below is recomended to help everyone understand the contents of the pricing file.

  PRICING.$MFG.$NOTE.TXT

PRICING is a constant and is required for the pricing service.

$MFG is the Ingen ID for this manufacturer/brand.

$NOTE is typically the date in the following format: YYYYMMDD

 

For example:

   PRICING.CTL.20070401E.TXT

 

 

Pricing for Ingen ID CTL last modified on 20070401 – stepping E.

 

If breaking a file into multiple segments, it would be best to include a description of the file segment. For example:

    PRICING.MFG.AMDATA20070401.TXT                      - A-M part attributes

    PRICING.MFG.NZDATA20070401.TXT                        - N-Z part attributes

    PRICING.MFG.AMPRICES20070401.TXT                    - A-M pricing

    PRICING.MFG.NZPRICES20070401.TXT                     - N-Z pricing

    PRICING.MFG.DISCONTINUED20070401.TXT          - All discontinued items