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. |
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 |