I'm new to using tea commerce and right now I'm wondering how I can implement a transaction report based on the countries that have bought a product through my store and wither or not I have the ability to specify a date range in which the report should be generated and cover.
The best way I beleive for this is to. Run a sql query to return the OrderIds and then once you have the Ids of the order that you need for your report you can the use TC.GetOrders method to get the actual order objects back to build your report from.
Hmm good question. The dll files do some magic with Umbraco when it starts up - it starts uf the dependency handler of Tea Commerce. DependencyContainer.Configure( Assembly.Load( "TeaCommerce.Umbraco.Configuration" ) );
Dont know if everything will work if you run in from a console app as TC need the web.config to find the connection string etc.
Generating a transaction report
I'm new to using tea commerce and right now I'm wondering how I can implement a transaction report based on the countries that have bought a product through my store and wither or not I have the ability to specify a date range in which the report should be generated and cover.
Hey,
The best way I beleive for this is to. Run a sql query to return the OrderIds and then once you have the Ids of the order that you need for your report you can the use TC.GetOrders method to get the actual order objects back to build your report from.
Hope this helps.
Tom
As Tom says the easy way is to create a custom dahsboard maybe and then some UI to display the info you need to show/download.
Kind regards
Anders
Would I be able to do such a thing throw a console program to generate this in a text file?
Hmm good question. The dll files do some magic with Umbraco when it starts up - it starts uf the dependency handler of Tea Commerce.
DependencyContainer.Configure( Assembly.Load( "TeaCommerce.Umbraco.Configuration" ) );
Dont know if everything will work if you run in from a console app as TC need the web.config to find the connection string etc.
Kind regards
Anders
is working on a reply...