CRM Subscription File

Summary

The CRM Subscription File is a delta file of all subscriptions, dropped daily onto the Ordergroove SFTP, with 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