#### 

Sitecore Commerce 9 has a possibility to link relative SellableItems to SellableItem OOTB. All these related SellableItems will be rendered in Related Products component on Storefront site. If you need to configure a list of related products, all you need to navigate to SellableItem in BizFx site and link them in Related Products section.

Technically, when you link any related SellableItem to SellableItem as a related product, Sitecore Commerce Engine creates a new RelatedProduct list per each SellableItem, for example *List-relatedproduct-6042102-ByDate*, where 6042102 is a product id. All this data Commerce Engine stores in [SitecoreCommerce9\_SharedEnvironments].[dbo].[CatalogLists] table in SQL.

Sitecore provides Postman request Lists - RelatedProduct Relationships to retrieve related products by list:

*{{ServiceHost}}/{{ShopsApi}}/GetList(id='RelatedProduct-6042102',type='Sitecore.Commerce.Plugin.Catalog.SellableItem, Sitecore.Commerce.Plugin.Catalog',skip=0,take=100)?$expand=Items*

Everything was good till Sitecore Commerce 9 Update-3 was rolled out. When I tried to retrieve related products with the Postman request above, I didn’t get a list of related products. It was a surprise for me and I started to investigate this issue.

During my investigation I found that Sitecore changed list name for related products from *relatedproduct* to *relatedsellableitemtosellableitem*.

[SitecoreCommerce9\_SharedEnvironments].[dbo].[CatalogLists] table in SQL starts form Update-3 version looks like:

![](https://www.brimit.com/-/media/images/blog/sitecore-commerce-9-get-related-products-for-sellableitem---1.png)

Then I took a look at Postman request and found that there was an old list name. Instead of request url above should be:

*{{ServiceHost}}/{{ShopsApi}}/GetList(id='relatedsellableitemtosellableitem-6042102',type='Sitecore.Commerce.Plugin.Catalog.SellableItem, Sitecore.Commerce.Plugin.Catalog',skip=0,take=100)?$expand=Items*

After that I was able to retrieve related product in Postman:

  ![](https://www.brimit.com/-/media/images/blog/sitecore-commerce-9-get-related-products-for-sellableitem---2.png)

Hope it helps someone who encounters the same issue!

###### Author

[!\[apaliakou\](https://www.brimit.com/-/jssmedia/feature/blogs/authors/apaliakou.jpg?h=216&iar=0&w=360&hash=5BE96F17AE5B47F66D9F684B87773675)
Andrei Paliakou
Sitecore MVP/ Lead Developer](https://www.brimit.com/blog/author?authors=Andrei%20Paliakou)

#### More on Sitecore

[!\[How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2024/vercel_cover-image.png)
#Guides#How-toDXPE-commerce
##### How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects
Optimize and accelerate the development and deployment of complex multisite Sitecore projects.
Alexei Vershalovich on July 17, 2024](https://www.brimit.com/blog/how-vercel-will-help-you-save-effort-when-deploying-sophisticated-sitecore-projects)

[!\[Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2023/sitecore-mentoring---cover-image.png)
#How-toDXP
##### Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story
How to participate in the Sitecore Mentor program and help younger colleagues jump-start a career in Sitecore development.
Sergey Baranov on October 2, 2023](https://www.brimit.com/blog/training-up-tomorrows-sitecore-mvps)

[!\[Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2022/headless/adobestock_456986731.jpg)
#How-toDXPE-commerce
##### Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)
Discover how a headless CMS can benefit organizations that use Sitecore.
Daniil Raschupkin, Palina Trokhautsava on September 15, 2022](https://www.brimit.com/blog/going-headless-part-2-when-a-headless-cms-is-your-best-bet-if-you-have-sitecore)

![](https://bat.bing.net/action/0?ti=187017043&tm=gtm002&Ver=2&mid=5b517747-48a4-4686-b3aa-f5e61d9ea1bf&bo=2&gtm_tag_source=1&pi=0&lg=en-US&sw=800&sh=600&sc=24&nwd=1&tl=Sitecore%20Commerce%209%3A%20Get%20related%20products%20for%20SellableItem&kw=Sitecore,%20Commerce,%20sellableitems&p=https%3A%2F%2Fwww.brimit.com%2Fblog%2Fsitecore-commerce-9-get-related-products-for-sellableitem&r=&lt=286&evt=pageLoad&sv=2&asc=D&cdb=AQAY&rn=761726)