Developer forum

Forum » Ecommerce - Standard features » What is the best way to get EcomOrderData

What is the best way to get EcomOrderData

E-mail notifications
Hans Ravnsfjall
Hans Ravnsfjall
Reply
Posted on 18/03/2022 13:39:11

Hi

We have a wesite in 3 languages, using 3 different currencies.

We want to do a monthly data export, where we get this data for all captured orders, and only captured orders.

Delivery info (country)
Order Amount - total
Order Amount - excl. vat and shipping
Order Vat
Order Shipping
Order Currency
Date and Time of Order
Date and Time of Capture

 

Exporting this in the integration framework, does not give the data of when the order is captured

Are there different options of getting orderdata (eg. through the API) and what is the best way of exporting order data, and how can I get the date and time when the order was captured?

/Hans

 


Replies

 
Nicolai Pedersen
Posted on 18/03/2022 15:00:10
Reply
This post has been marked as an answer

You can use the Dynamicweb provider in Data integration as source, and then export it to i.e. CSV:

On the mappings page you can define what to export.​

Votes for this answer: 1
 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 22/03/2022 11:57:12
Reply

ok, thank you 👍🏻

/Hans

 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 23/03/2022 07:36:07
Reply

Nicolai, is there no other way to get just the date of capture, than to use table scripting on OrderCaptureData?

table scripting seems really complicated, so hopefully there is a simpler way?

Could I eg. get the data via API and make a front-end interface?ð

/Hans

 
Nicolai Pedersen
Posted on 23/03/2022 15:36:12
Reply

You can use Dynamicweb.Ecommerce.Services.Orders and get the orders from there.

 

You must be logged in to post in the forum