Order Report

Summary

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