Objective
Exporting orders in Jumper in CSV or Excel file.
Applies To
- Jumper
- Export Orders
You can export orders in CSV or Excel format of your Orders. You can filter the date range for your Orders Export CSV files.
Procedure
- Go to ‘View orders’ under Orders in the menu bar.
- In My orders, click on ‘Export orders’ option at the top.
- You will find a pop up, where you can select your date range for export, your choice of format and need to specify your delimiter. Once done click on ‘Export’
- Once clicked on export, you can generate & export a filtered data report.
Here’s a sample of Exported CSV file for orders.
Note: Orders Export CSV files are updated within 30 minutes from the time when Order is confirmed.
Default columns found in the CSV are listed below.
|
Field |
Description |
|
Order_Id |
Order Identifier |
|
OrderDate |
Date when Order is completed (based on Merchant’s timezone) |
|
Order_DateTime |
Date and Time when Order is completed (based on Merchant’s timezone) |
|
Order_Source |
Platform where Customer made the Order |
|
Reference_ID |
Internal Reference Number for Jumper |
|
Customer_First_Name |
Customer’s first name |
|
Customer_Last_Name |
Customer’s last name |
|
Customer_Email |
Customer’s email |
|
Customer_Mobile |
Customer’s mobile Number |
|
Address_Line_1 |
Customer’s Address |
|
Address_Line_2 |
Customer’s Address |
|
City |
City of Customer’s Address |
|
State |
State of Customer’s Address |
|
Postal_Code |
Postal Code/ Zip code of Customer’s Address |
|
Country |
Customer’s Country |
|
Payment_By |
Payment Gateway Used |
|
Payment_Made |
True if payment has been made *For Cash-on-delivery, True if Order is marked as paid in Jumper's dashboard |
|
Shipping_Status |
Either “Shipped” or “Not Shipped” |
|
SKU |
Item SKU |
|
Item |
Item Name |
|
Variation_SKU |
Variation SKU (if applicable) |
|
Variation |
Variation Name (if applicable) |
|
Item_Discount |
Discount applied on Item |
|
Discount_Code |
Discount Code applied on Item |
|
Qty |
Item Quantity |
|
Subtotal |
Amount before discount for the Line Item |
|
Gross_Amount |
Order’s Gross Amount (before discount) |
|
Discount |
Order’s Total Discount |
|
Net_Amount |
Order’s Net Amount (after discount) |
|
Tax |
Order’s Tax Amount |
|
Special_Notes |
Special Instructions from Customer |
Further in the Order Source, the following default values are provided to help you track the source of Customer Interaction.
|
Order_Source |
Source |
|
|
Facebook Comments/ Messenger Private Messages |
|
JUMPER |
Jumper's Conversational Landing Pages |
|
Widget |
Attentive Widget |
|
|
Instagram Direct |
|
WEB/ WEBSITE |
Jumper's Conversational Landing Pages |
|
LINE |
LINE |
|
BOT |
Jumper's Conversational Landing Pages |
|
|
Twitter DM |
|
|
WhatsApp Business API |
|
SHORTLINK |
Messenger Redirect Links |
|
IMESSAGE |
iMessage |
|
YOUTUBE/YT |
Youtube |