Developer forum

Forum » Ecommerce - Standard features » Get all info on sales on a certain product

Get all info on sales on a certain product

E-mail notifications
Hans Ravnsfjall
Hans Ravnsfjall
Reply
Posted on 17/06/2019 15:28:20

Hi

We need a solution for a costumer who wants to get an overview on all info product sales, product by product.

In other words, they want to be able to look up a product, and see who has bought the product and how many instances of the product is sold on each order.

How can we achieve this the simplest in a Dynamicweb All-in-one Free solution?

 

/Hans


Replies

 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 19/06/2019 16:48:19
Reply

anoyone? :)

 
Nicolai Pedersen
Posted on 20/06/2019 09:57:31
Reply

Hi Hans

You can write SQL that you can publish using the data list module.

BR Nicolai

 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 20/06/2019 10:43:15
Reply

Ok,

 

Could I also use Indexing and eg. a querypublisher?

have no experience using the data list module, but will try it if it is the best/only solution.

/Hans

 
Nicolai Pedersen
Posted on 20/06/2019 11:12:54
Reply

You cannot because the index does not hold the information - you would need to do c# code in order to index the information you need. You can get it using SQL without coding.

BR Nicolai

 

You must be logged in to post in the forum