# Migrate product sales from shopware 5 for sorting?

**URL:** <https://forum.shopware.com/t/migrate-product-sales-from-shopware-5-for-sorting/104510>\
**Category:** Shopware 6 (English)\
**Created:** [10. Juli 2024 um 12:20 UTC](https://forum.shopware.com/t/migrate-product-sales-from-shopware-5-for-sorting/104510 "2024-07-10T12:20:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![binuabraham990](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@binuabraham990](https://forum.shopware.com/u/binuabraham990)\
**Post date:** [10. Juli 2024 um 12:20 UTC](https://forum.shopware.com/t/migrate-product-sales-from-shopware-5-for-sorting/104510/1 "2024-07-10T12:20:17Z")

</div>

Hi guys,

In the SW5, there was an option to add custom sorting by popularity. From what I check, I could see that the popularity sorting is using table s\_articles\_top\_seller\_ro (field sales).

However in SW6, there is no topseller tables. And in SW6, topseller sorting can be load by product.sales field. However, products.sales in shopware 6 is migrated from same column in SW5 ( s\_articles\_details.sales).

My questions are,

1. Is this observation correct?
2. If I populate product.sales in SW6 from the value of s\_articles\_top\_seller\_ro.sales from SW5, is there any issue going to happen in the future? Is there any functionalities in SW6, which use products.sales as input? I checked in shopware 6, so far I couldn’t find anything.

Thank you

---

<div class="post-metadata">

**Author:** ![MichaelF](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@MichaelF](https://forum.shopware.com/u/MichaelF)\
**Post date:** [15. Juli 2024 um 15:39 UTC](https://forum.shopware.com/t/migrate-product-sales-from-shopware-5-for-sorting/104510/2 "2024-07-15T15:39:01Z")

</div>

I’m also experiencing the same issue after trying migrating to SW6 and would like to have sorting by popularity based on past sales.

All entries in product.sales are 0 though. Eager to hear more on this topic.
