Docs

Data Operations Articles & FAQ

changes, csv export, export, Order, 2020

461783

2020-12-13T05:00:23Z

2025-02-12T08:23:03Z

181

1

1

249133

Retrieving order information from Chargebee.

Retrieving order information from Chargebee. 

This article covers

If there is a way to filter all orders by customer_id via API.

How to retrieve the list of all orders filtered by customer_id via API?

Summary

  • The Order Export file that you would download will include one additional file “OrderLineItems.csv”
  • List orders API will now return, order's id parameter was appended with a database ID if that order was deleted due to a customer, invoice, or subscription deletion

Solution

If you are directly using the List orders API then currently it wouldn't be possible to filter orders via Customer ID as there is no such parameter available within this API, however, as a workaround, you can use List Invoice API wherein you would get the Customer Id parameter to filter. Post which you can take the Order ID from the output and then use the Retrieve an Order API to retrieve the order.

Order Export CSV

Orders.csv now contains one row for each unique order in Chargebee, so that you can more easily conduct order-level analysis and record-keeping without transforming the data

Can I access the line item level data in the older orders.csv file?

Yes. That data now lives in the OrderLineItems.csv file

Will the OrderComments.csv file still be downloaded?

Yes, the order comments will still be available as part of the download

Will this impact exports via API?

Yes, there will be a minor upgrade to the list results, going forward when you list Orders via APIs you will now see deleted orders as part of the list. See the question on list order changes via API.

I have multiple shipments associated with an order, will that show up in my Chargebee export?

Right now, only the data associated with an order's first shipment is captured in Chargebee. We're planning to support multiple shipment tracking in Chargebee in the near future. If this is urgent for your business, please let me know, and I can put you in contact with our product management team.

List Order API change

Why are orders showing up as deleted that didn't appear so before when I call the list order API?

Previously, when our list orders API returned deleted orders, the order ID was appended to include an additional database id if the order was deleted because a customer, invoice, or subscription was deleted. Now, all deleted orders are returned with their original id, regardless of the mechanism of deletion. You no longer have to remove the database ID to match deleted orders to existing order records in your system.

If you have further questions feel free to contact our Support Team.

Related Article
How to export order reference IDs?

List orders API

Related Articles 

While performing bulk operations, all the columns are consolidated into a single column in the template upload file.
How can I import multiple coupons into Chargebee using Bulk operations?
How can I export items with the import format on PC 2.0?
How to disable or remove the trial period from the multiple price points of multiple plans in bulk on PC 2.0 Chargebee site?
How do I migrate subscriptions from Stripe to Chargebee while continuing to use Stripe as my payment gateway?
Bulk upload subscriptions for an existing customer: Parallel processing of data
What bulk operations can I perform in Chargebee?
I am getting the "the column () appears more than once in file" while importing data into Chargebee. How can I fix this?
Types of addresses added for customers in Chargebee
How to export list of customers with excess payment?
How to add notes to a customer record that is visible only for the business's reference?
How to not send the cancel subscription emails to subscriptions that have a cancellation scheduled?
Euro currency display on invoice PDF - Symbol is displayed in the incorrect order.
How do I migrate subscriptions from a different billing system to Chargebee while using Stripe as my payment gateway?
How to import credit notes?
What are all the bulk operations for Payment Method?
How to migrate offline customers into Chargebee?
How to export the billing periods associated to the subscriptions?
Bulk apply coupons to subscriptions
How to export order reference IDs?
Line items ID missing for tiered addons in the product catalog export
How to export subscriptions specific to a recurring addon?
How to export customers data of all active subscribers?
I need to download a report for ‘Not Paid’ invoices within a specific period.
Is it possible to build a report to show all the customers and the total amount of usage (units)?
Extract new trial customers contact details on a daily basis
How can I export a list of customers with their billing and shipping addresses?
How to manually sync status for in-progress transactions?
How to collect payment for invoices in bulk?
How to create a report for invoices that have promotional credits applied?
How to export payments that was successful?
I want to create an advance invoice on a recurring basis via bulk operation. what are the values that I need to pass in the bulk operation CSV?
How to export list of customers who has payment method with auto-collection 'OFF'?
How to update customers' auto collection in bulk?
Was this article helpful?
Loading…