Intended Application
For product-level transaction importing in which a single file may contain transactions of multiple transaction types from multiple locations and booking dates. Supports either retail amount->point conversion via Kognitiv Loyalty transaction point formula, and also direct point entry in file.
Notes
- Pipe-delimiter must be used to separate columns.
- Header record is not expected. All data rows are processed as records.
- All line items are treated as a quantity of one.
- All items sharing the same transaction type and unique Transaction Id should be contiguous.
- Unique Transaction Id should be different for return and purchase if the intention is to use the same transaction type.
- If a missing product is encountered, the associated transaction is skipped.
- If the booking date is provided and is not in the proper format, it will be ignored.
File Structure
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
---|---|---|---|---|
Date/Time |
Yes |
MM/DD/YYYY HH:MM:SS |
Based on a 24 hour clock | |
Booking Date | Date | Yes | MM/DD/YYYY | |
Alphanumeric |
Yes |
|
||
Location External Reference | Alphanumeric | Yes | ||
Product External Reference | Alphanumeric | Yes | Typically the "SKU" for the product. | |
Item Retail Value |
Decimal | Yes | 0.00 | |
Point Amount | Decimal | Yes |
0.00 |
Only used when point formula is set to "direct point entry". |
Profit Amount | Decimal | Yes | 0.00 | Only used when profit formula is set to "externally calculated". |
Transaction Type External Reference | Alphanumeric | Yes | ||
Unique Transaction Id* | Alphanumeric | Yes |
* - Denotes that the data column helps comprise the transaction unique key for this import file specification.
Sample File
1: 2: 3: 4: 5: |
08/09/2014 13:02:50|07/01/2014|1002|2000|108339|14.00|13.00|11.00|GMPD|A123456 08/10/2014 13:02:50|07/01/2014|ABC1002|2000|108339|14.00|13.00|11.00|GMPD|B123456 08/11/2014 13:02:50|07/02/2014|0001002|2000|098633|14.00|13.00|11.00|GMPD|C123456 08/12/2014 13:02:50|07/03/2014|222111994499|2000|098633|-14.00|-13.00|-11.00|GMR|D123456R 08/13/2014 13:02:50|07/04/2014|1ASDF77|2000|098633|14.00|13.00|11.00|GMPD|D123456 |