Application File Imports Release Notes Sync Web Services FAQ

Product Sales Transaction File

Intended Application

For product-level transaction importing in which a single file may contain transactions of multiple transaction types from multiple locations.  Supports either retail amount->point conversion via ALP SaaS 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.

 

File Structure

DATA COLUMN

DATA TYPE DATA REQUIRED? FORMATTING NOTES

Activity Timestamp

Date/Time

Yes

MM/DD/YYYY HH:MM:SS

Based on a 24 hour clock

Account Id

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|1002|2000|108339|14.00|13.00|11.00|GMPD|A123456
08/10/2014 13:02:50|ABC1002|2000|108339|14.00|13.00|11.00|GMPD|B123456
08/11/2014 13:02:50|0001002|2000|098633|14.00|13.00|11.00|GMPD|C123456
08/12/2014 13:02:50|222111994499|2000|098633|-14.00|-13.00|-11.00|GMR|D123456R
08/13/2014 13:02:50|1ASDF77|2000|098633|14.00|13.00|11.00|GMPD|D123456

Please note: All external ALP SaaS links and references are directed to US datacenter unless specifically noted.


Tags:
Home: Aimia Loyalty Platform SaaS Wiki
Copyright © 2019 Aimia Inc. All Rights Reserved.
What's new: Recently changed articles