The order report can be dropped onto the Ordergroove SFTP on a daily basis. 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), or any of the non-default fields included.
The order report can be customized in the following ways:
- filtered by order status
- only include orders with a place date no longer than X days in the past
- only include orders with a place date more than X days in the past
File Format & Naming Convention
[client_name]_orders_MMDDYYYYHHMMSS.csv
|
FIELD NAME |
MAPPING/DEFINITIONS |
DATA TYPE |
SAMPLE DATA |
|
Merchant |
Merchant Name |
String, up to 80 characters |
Andy’s Vitamins |
|
Ordergroove User ID |
Subscriber's ID in Ordergroove's system |
Int, up to 11 numbers |
676873 |
|
Merchant User ID |
Subscriber's ID in merchant's system |
String, up to 128 characters |
2142608423 |
|
Place Date |
Date order was made (MM/DD/YYYY) |
Date, exactly 10 characters |
08/26/2025 |
|
Ordergroove Order ID |
Ordergroove Order ID |
Int, up to 11 numbers |
2976631 |
|
Ordergroove Subscription ID |
Ordergroove Subscription ID |
String, up to 40 characters |
911458 |
|
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 |
Growth 3 Bottle Bundle |
|
External Product ID |
External Product ID |
String, up to 64 characters |
1756 |
|
SKU |
Product SKU |
String, up to 64 characters |
HS 1010-8 |
|
Quantity |
Quantity |
Small int, up to 5 characters |
1 |
|
Price |
Price of SKU |
Decimal, up to 99999999.99 |
39.98 |
|
Order Subtotal |
Order subtotal |
Decimal, up to 99999999.99 |
39.98 |
|
Order Status |
Success, Cancelled, Rejected, etc. |
String, up to 128 characters |
Success |
|
Merchant Order ID |
Order ID in merchant's system (will only display if order is in final state) |
String, up to 80 characters |
V263578579 |
|
Rejected Error Code |
Displays Rejected Error Code number (if rejected) |
String, Up to 3 characters |
500 |
|
Rejected Error Message |
Displays Rejected Error Message content (if rejected) |
String, up to 1024 characters |
The expiration date is in the past. |
|
Public Subscription ID |
Public Subscription ID in Ordergroove system NOTE: This is not a default field so please inform OG if you would like it included |
String, up to 40 characters |
e1a84a68539a4b4ea85f2861cc63522f |
|
Public Order ID |
Public Order ID in Ordergroove system NOTE: This is not a default field so please inform OG if you would like it included |
String, up to 40 characters |
32f22212eaf3411c894984e1e98a6f79 |