The CRM Subscription File is a delta file of all subscriptions, dropped daily onto the Ordergroove SFTP. It contains any changes to subscriptions within the configured generation period, typically set to the last day. The file can contain any of the fields detailed below. Please let your Ordergroove contact know if you need any of the fields removed (e.g., exclude PII for PCI compliance).
File Format & Naming Convention
[client_name]_crm_subscription_MMDDYYYYHHMMSS.csv
|
FIELD_NAME |
MAPPING/ DEFINITIONS |
DATA TYPE |
SAMPLE DATA |
|
og_subscription_id |
Subscription ID within the OG system |
String, up to 40 characters |
52845dc2b05531e59d99bc6 64e105ba |
|
customer_id |
The unique identifier for the subscriber in the OG system |
Int, up to 11 characters |
9647 |
|
customer_email |
Subscriber's email |
String, up to 128 characters |
john.doe@ordergroove.com |
|
subscription_create_date |
MMDDYYYYHHMMSS |
Datetime, exactly 14 digits |
10302019150324 |
|
merchant order ID |
Initial order ID on the Merchant's site that creates the subscription |
String, up to 80 characters |
EX13282359 |
|
external product ID |
External Product ID |
String, up to 64 characters |
69527 |
|
SKU |
Product's SKU |
String, up to 64 characters |
69527 |
|
quantity |
Number of item units within the subscription |
Smallint, up to 5 characters |
1 |
|
frequency |
Frequency of subscription (in days) |
Smallint, up to 6 characters |
60 |
|
subscription_status |
1=active ; 0=inactive |
Tinyint(1) |
1 |
|
next_order_date |
MMDDYYYYHHMMSS |
Datetime, exactly 14 digits |
11022020000000 |