Developer forum

Forum » Ecommerce - Standard features » Product count increases

Product count increases

E-mail notifications
Jannich Ariyanayagam
Jannich Ariyanayagam
Reply
Posted on 28/11/2019 10:29:20

Hi Dynamicweb,

We have a solution where the products count is 41k even when there is only 3.7k records in the products table on the database.

I also checked the index files which are getting huge.
Why is this happening? is there a way to clean this up?

I have attached the row count in the ecom products table and the count of the shop in the backoffice.


Dynamicweb version 8.9

 

rows.png shop.png

Replies

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Posted on 29/11/2019 15:27:03
Reply

Hi jannich,

The value you see there is actually the total number of group/product relations within that shop.

You can find the relations in the EcomGroupProductRelation and EcomShopGroupRelation tables.

Best regards,
Morten

 

You must be logged in to post in the forum