Cancelation Report

Summary

The cancelation report can be dropped onto the Ordergroove SFTP on a daily basis and can contain any of the fields listed below. Please let your Ordergroove contact know if you need any of the non-default fields included, or any fields excluded (e.g., exclude PII for PCI compliance).

The cancellation report can be customized in the following ways:

  • Only include subscriptions canceled no longer than X days in the past
  • Only include subscriptions canceled more than X days in the past

File Format & Naming Convention

[client_name]_cancelled_subscriptions_MMDDYYYYHHHMMSS.csv

FIELD NAME

MAPPING/DEFINITIONS

DATA TYPE

SAMPLE DATA

Public Subscription ID

Subscription public ID within the OG system

NOTE: This is not a default field so please inform OG if you would like it included

String, up to 40 characters

959b9168686311e98300bc764e1043b0

Merchant

Merchant Name

String, up to 80 characters

Snacks Company

User ID

Customer ID in Ordergroove system

Int, up to 11 characters

723497823

Merchant User ID

Customer ID in merchant system

String, up to 128 characters

238082

Create Date

Subscription creation date (MM/DD/YYYY)

Date, exactly 10 characters

04/05/2019

Create Time

Subscription creation time (MM/DD/YYYY HH:MM:SS)

Datetime, exactly 19 characters

2019-04-05 20:56:08

Start Date

Subscription start date (MM/DD/YYYY)

Date, exactly 10 characters

2019-04-10

Customer Status

Displays if the subscription was created by a new or existing subscriber

String, up to 128 characters

Existing

Subscription ID

Subscription ID in Ordergroove system

String, up to 40 characters

1721223

Offer ID

Offer ID in Ordergroove system. Indicates where a customer opted-in to subscription and which messaging they saw.

Int, up to 11 numbers

5159

Merchant Order ID

Order ID in merchant system that created the subscription

String, up to 80 characters

2145873

Guest Checkout

Was guest checkout used to create subscription? (Y/N)

String, up to 128 characters

N

Email Address

Subscriber's email address

String, up to 128 characters

jane.smith@Ordergroove.com

First Name

Subscriber's first name

String, up to 128 characters

Jane

Last Name

Subscriber's last name

String, up to 128 characters

Smith

Product

Product name

String, up to 1024 characters

caramel almond & sea salt

Product ID

Product ID

Int, up to 11 numbers

17030

SKU

Product SKU

String, up to 64 characters

17030

Frequency

Subscription order placement frequency (in days)

Smallnt, up to 6 characters

30

Reminder

Subscription order reminder prior to order placement (in days)

Subscription order reminder prior to order placement (in days)

10

Status

Is the subscription active or inactive?

String, up to 128 characters

Inactive

Quantity

A number of item units within a subscription. Will always be '1' for Diaper & Wipes Bundle.

Smallnt, up to 5 characters

3

Price

Product price

Decimal, up to 99999999.99

10.95

Discount Price

Discount price for the product

Decimal, up to 99999999.99

10.4

24 Hour Cancel

Was the subscription canceled within 24 hours of creation time? (Y/N)

String, up to 128 characters

N

Cancel Date

Date subscription was canceled (MM/DD/YYYY)

Date, exactly 10 characters

04/29/2019

Cancel Reason

reason subscription was canceled (numbered code)

String, up to 512 characters



2|I have too much of this product.

Cancel Reasons

Orders Placed

Number of orders attempted over the life of the subscription (successful & rejected)

String

2

Last Order Date

Last order date of the subscription (MM/DD/ YYYY)

Date, exactly 10 characters

04/26/2019

Total Active Subscriptions

Number of active subscriptions for that customer at that point in time.

NOTE: This is not a default field so please inform OG if you would like it included

Smallnt, up to 5 characters

3

Subscriber Status

Does the customer currently have any active subscriptions (1=yes, 2=no)

NOTE: This is not a default field so please inform OG if you would like it included

Boolean

1