When is it appropriate to use queryOrders instead of searchOrders?

Use searchOrders for indexed fields like status, email, or dates. Only use queryOrders when you need to search for non-indexed custom attributes that aren't available in the search index.

Why should I use ProductSearchModel instead of Category.getProducts()?

ProductSearchModel is index-backed and designed for high-traffic storefront pages, whereas getProducts() hits the database directly and can cause significant performance bottlenecks under load.

How do I prevent memory leaks when querying large datasets?

Always call the .close() method on result iterators and use optimized methods like CustomerMgr.processProfiles for batch operations to ensure the system manages memory effectively.

What is the result limit for B2C Commerce search APIs?

Most search-based APIs in B2C Commerce, including ProductSearchModel and CustomerMgr.searchProfiles, are capped at the first 1,000 hits to maintain system stability and performance.

Salesforce B2C Data Querying

Name: Salesforce B2C Data Querying
Author: SalesforceCommerceCloud

bySalesforceCommerceCloud

•

电子商务解决方案

Optimizes data retrieval in Salesforce B2C Commerce using index-backed search APIs and performance-first querying patterns.

This skill provides comprehensive guidance on efficiently querying products, orders, customers, and system objects within the Salesforce B2C Commerce (Demandware) environment. It emphasizes the use of high-performance, index-backed APIs like ProductSearchModel and searchOrders to ensure storefront scalability while avoiding common database-intensive pitfalls. Developers can use this skill to implement paged search results, handle complex refinements, and manage large-scale data processing in background jobs with optimized memory management, ultimately improving site speed and reliability.

主要功能

01Paging and result set optimization to prevent memory leaks and slow loads

02Advanced Order and Customer querying using search-based managers

03Best practices for batch processing large datasets in scheduled jobs

04Architectural comparison of index-friendly vs. database-intensive APIs

0528 GitHub stars

06Implementation of index-backed ProductSearchModel for storefront performance

使用场景

01Building high-performance product listing and search result pages

02Implementing customer profile lookups and order history features

03Diagnosing and fixing slow category pages caused by expensive database calls

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add salesforcecommercecloud/b2c-developer-tooling b2c-querying-data

For use in Claude.ai and ChatGPT

Download Skill