How to extract Merchanter data into Excel

OData extraction to Excel allows data to be summarised or reconfigured to an appropriate format to report Sales, Purchases, Certification and more.


On your Merchanter system you can:


· OData Extract into Excel



OData extract into Excel

· If you are a Super or Prime user using Excel you can access the OData tables.

· Go to the Data tab in Excel

· If you have accessed your Merchanter system before for OData click on ‘Recent Sources’

· If this is the first time accessing OData from your Merchanter system click on:

· ‘Get Data’

· ‘From Other Sources’

· ‘From OData Feed’



· Enter your system url and type on the end /odata/Analysis for example – https://unitrade400-<mysystem>.mendixcloud.com/odata/Analysis



· When asked for security protocols select ‘Basic’ from the left-hand menu


· Once the data is loaded into Excel you can organise the data by creating Pivot Tables, Pivot Charts and more.


#Product Stock #OData #Excel

12 views0 comments

Recent Posts

See All

OData Stock Summaries within Merchanter allow you to manage and review stocks of Products in the system. On your Merchanter system you can generate the following: · OData Current Stock Summary

Product Stock Locations allow the creation of Locations within Merchanter to manage stocks of Products in the system. This is both to stock control to location level and to display multiple locations