Summary
The inventory report is a useful tool for forecasting item inventory for the subscription program. In this report, items and the place date of the orders are listed, so you can look at any future timeframe and see how many units of each item are scheduled to ship. The export includes the shipping zip code to forecast volume at individual warehouses as well.
Ordergroove creates the next subsequent order when an order is scheduled to place, so most subscriptions will only have one 'unsent' order, and thus only appear on this report one time, unless a product has gone into the Out of Stock flow. The subscription frequency can be utilized to predict additional future orders.
Configurable options:
- Number of days into the future the report will forecast
- Columns included in the report - all fields listed below are enabled by default when the export is activated
File Format & Naming Convention
[client_name]_Inventory_Report_MMDDYYYYHHMMSS.csv
|
FIELD NAME |
MAPPING/DEFINITIONS |
DATA TYPE |
SAMPLE DATA |
|
Discount Price |
The unit price in Ordergroove. Note: This may not be the final unit price charged when the order places. |
Decimal |
19.99 |
|
Place Date |
Date the next order for the subscription is scheduled to be placed |
Date, exactly 10 characters |
08/02/2022 |
|
Product Name |
Name of Product |
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 |
|
OG Order ID |
Ordergroove Order ID |
Int, up to 11 numbers |
2976631 |
|
Detail URL |
URL for PDP |
String, up to 400 characters |
|
|
Date Created |
Date subscription was created |
Date, exactly 10 characters |
08/02/2012 |
|
Frequency |
Subscription order placement frequency (in days) |
Smallint, up to 6 characters |
60 |
|
In Stock |
1 = In stock 0 = Out Of Stock |
Tinyint(1) |
1 |
|
Order Quantity |
Number of item units within the subscription |
Small int, up to 5 characters |
1 |
|
Zip Code |
Shipping zip code |
String, up to 128 characters |
10004-2487 |
|
Extra Data |
Subscription metadata is sometimes used for custom implementations NOTE: This is not a default field so please inform Ordergroove if you would like it included |
JSON object stored as a String, up to 1024 characters |
{"loyalty_status": "gold"} |
|
Public Subscription ID |
Public Subscription ID in Ordergroove system NOTE: This is not a default field so please inform Ordergroove if you would like it included |
String, up to 40 characters |
e1a84a68539a4b4ea85f2861cc63522f |