Batch Mode Integration is a convenient way to award points for offline purchases performed via in-store Point-of-Sale or telephone. Please familiarize yourself with Batch Mode Integration before proceeding with this article.

To award points for any offline purchase activity, you must upload the following 3 purchase activity files to the designated FTP Server in CSV format.

  • Purchase Activity File: List of daily orders
  • Products Data File: List of products associated with those daily orders
  • Returns Activity File: List of daily order returns

These files are described in detail below.

Purchase Activity File (required):

This file contains a list of all purchase transactions with the order details necessary to award points for purchases. This file is mandatory.

The naming convention for this file is ZN_DAILY_ORDERS_YYYYMMDD.csv. For example, a file with orders for April 27, 2017 should be named ZN_DAILY_ORDERS_20170426.csv.

The fields contained in this CSV file are described in the table below:

*In case Rules are being applied in the Purchase activity, this field becomes mandatory.

A sample file named ZN_DAILY_ORDERS_20170426.csv is included for your reference at the end of this help article.

Products Data File (recommended):

This file contains itemized product details for each order.

It is required only if you want to apply product-specific business rules for awarding points e.g. Awarding 2x points for category=SHOES. The order ID is the unique key used to match product data with the orders from the ‘Purchase Activity’ file and points will be awarded based on the business rules configured in the Zinrelo admin console. However, we recommend including this file in the daily FTP upload.

The naming convention for this file is ZN_DAILY_PRODUCTS_YYYYMMDD.csv. For example, a file with orders for April 27, 2017 should be named ZN_DAILY_PRODUCTS_20170426.csv.

The fields contained in this CSV file are described in the table below:

A sample file named ZN_DAILY_PRODUCTS_20170426.csv is included for your reference at the end of this help article.

Returns Activity File (optional):

This file contains details of all returned orders. The order ID is the unique key used to match the returns with the original award transaction and points will be deducted for the original order.

The naming convention for this file is ZN_DAILY_RETURNS_YYYYMMDD.csv. For example, a file with orders for April 27, 2017 should be named ZN_DAILY_RETURNS_20170426.csv

The fields contained in this CSV file are described in the table below:

A sample file named ZN_DAILY_RETURNS_20170426.csv is included for your reference at the end of this help article.

Download Attachments:

  1. ZN_DAILY_ORDERS_20170426.csv: https://drive.google.com/open?id=14_pD5GEDh9inqJwkzuEvoVWYQXWwxST0
  2. ZN_DAILY_PRODUCTS_20170426.csv: https://drive.google.com/open?id=1XKlaOWjz-Mc4gHpCmJdK5eiEKpPEhd1t
  3. ZN_DAILY_RETURNS_20170426.csv: https://drive.google.com/open?id=1mX6A_yIFkjkBxZrbSN63uaJep5qGZnig
Did this answer your question?