Purchase Activity Integration via Batch Mode

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 or to deduct points for purchases that are returned, you must upload the purchase activity file to the designated FTP Server in CSV format.

Purchase Activity File:

This file contains a list of all purchase transactions and/or return transactions with the order details necessary to award points for purchases or deduct points for returns.

The file expects one row per purchase item for an order OR one row per returned item. So, if the order contains 5 items, there will be 5 rows for that order in the CSV file.

The same file can have both purchase transactions as well as return transactions.

The naming convention for this file is ZN_DAILY_TRANSACTIONS_YYYYMMDD.csv. For example, a file with orders for July 21, 2020, should be named ZN_DAILY_TRANSACTIONS_20200721.csv.

Find the sample file here.

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

Note: If the merchant is unable to provide a comma separated string, then columns like product_category1, product_category2 etc., can be used. Based on the prefix (ie- product_category), all the product categories will be converted to a single comma separated string.

Similar approach will be followed for product_tags- product_tags1, product_tags2 etc., should be combined.