Forum management
- Threads started by me
- Threads I participate in

Developer forum

Where is the product sort order store in Dynamicweb tables?

Sten Hougaard

Posted on 07/06/2013 10:27:12

Hi,

As I have created a datalist to fetch products from a given ecomgroup (for use in navigation) I would love to be able to sort the products in the custom sort order which the customer have applied to the products.

But where is that information stored in the Dynamicweb Tables? I cannot find that information on EcomProducts table.

Anyone know that?

Med venlig hilsen / Kind regards

Sten Hougaard

Webdeveloper

727 Online as

www.727.dk

Replies

Morten Bengtson

Posted on 07/06/2013 10:34:33

Hi Sten, my friend :)

The product sorting is relative to the groups. A product can be attached to multiple groups and products can be sorted within each group.

in order to get the correct sorting you will have to join the table EcomGroupProductRelation and sort by GroupProductRelationSorting.

/Morten

You must be logged in to post in the forum