November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

noname

ulle
ulle
Vote:
 

Hi!

I wonder if there's any way to export all orders with status "completed" from yesterday to a excel or csv file (or something similar). This would be done every day.

#145476
Mar 04, 2016 10:30
Quan Mai
Quan Mai
Vote:
 

Hi,

You can use OrderContext.Search to search for matching orders (SqlMetaWhereClause in OrderSearchParameters can be used). When you have the orders, just write them to excel or csv file as you like.

If you use recent version of Commerce (9.8 or newer), you can serialize them to XML or JSON.

Regards,

/Q

#145481
Mar 04, 2016 11:07
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.