BigCommerce - Get Products
Description
Section titled “Description”This module allows querying products from a BigCommerce store. It can get a specific product by ID or SKU, or list products with various filters such as category, brand, visibility, price range, and stock.
Configuration
Section titled “Configuration”Required Credentials
Section titled “Required Credentials”- Store Hash: Unique hash of your BigCommerce store (visible in the control panel URL)
- Access Token: API V3 access token
Parameters
Section titled “Parameters”| Parameter | Type | Required | Description |
|---|---|---|---|
| credentials_id | credential | Yes | BigCommerce credentials |
| product_id | number | No | Specific product ID |
| sku | string | No | Product SKU |
| name | string | No | Search by name (partial) |
| categories | string | No | Category IDs separated by comma |
| brand_id | number | No | Brand ID |
| is_visible | boolean | No | Filter by visibility |
| availability | select | No | Availability: available, disabled, preorder |
| price_min | number | No | Minimum price |
| price_max | number | No | Maximum price |
| inventory_level_min | number | No | Minimum stock |
| inventory_level_max | number | No | Maximum stock |
| sort | select | No | Sorting |
| limit | number | No | Result limit (default: 50) |
| page | number | No | Results page (default: 1) |
Output
Section titled “Output”{ "success": true, "products": [...], "total": 150, "total_pages": 3, "current_page": 1, "message": "25 products retrieved"}Product Fields
Section titled “Product Fields”id: Product IDname: Product namesku: SKUprice: Pricesale_price: Sale priceretail_price: Retail priceweight: Weightinventory_level: Available stockis_visible: Visibilitycategories: Array of category IDsbrand_id: Brand IDcustom_url: Custom URLimages: Array of images
Usage Example
Section titled “Usage Example”Get product by ID
Section titled “Get product by ID”{ "product_id": 123}Search products by category
Section titled “Search products by category”{ "categories": "18,19", "is_visible": true, "limit": 100}Filter by price range
Section titled “Filter by price range”{ "price_min": 10, "price_max": 100, "sort": "price:asc"}API Used
Section titled “API Used”- Endpoint:
GET /stores/{store_hash}/v3/catalog/products - Documentation: BigCommerce Catalog API
- Uses the BigCommerce V3 API for products
- Products are sorted by modification date by default
- The maximum limit per page is 250 products
- For SKU searches, the value must be exact
Related Nodes
Section titled “Related Nodes”- BigcommerceCreateProduct - Create product
- BigcommerceUpdateProduct - Update product
- BigcommerceGetOrders - Get orders