> ## Documentation Index
> Fetch the complete documentation index at: https://docs.joinluminous.com/llms.txt
> Use this file to discover all available pages before exploring further.

# All products with company pricing

> Retrieve ALL products in the system with pricing calculated for all active companies 
or filtered by specific company IDs. Unlike company-specific endpoints, this returns 
comprehensive pricing information for multiple companies in a single request.

Each product will include a `company_prices` array containing pricing for each company 
based on their assigned price levels, price groups, and applicable discounts or markups.

This endpoint supports all the same filtering parameters as the regular products endpoint,
allowing you to retrieve company pricing data for specific sets of products.

For detailed information about the filtering system and available operators, 
refer to the [Filter System Documentation](/filters).

## Available Filters
### String Filters
- `name`: Product name
- `description`: Product description
- `sku`: Product SKU (searches both internal SKU and alternate SKUs)
- `upc`: Product UPC/Barcode
- `tag`: Product tags
- `q`: General search matches name OR upc OR sku
- `category.name`: Filter by category name
- `sub_category.name`: Filter by sub-category name
- `supplier.name`: Filter by supplier name

### Integer Filters
- `category.id`: Filter by category ID
- `sub_category.id`: Filter by sub-category ID
- `supplier.id`: Filter by supplier ID

### Float Filters
- `retail_price`: Product retail price
- `wholesale_price`: Product wholesale price

### Boolean Filters
- `sellable`: If the product is sellable or not
- `discontinued`: If the product is discontinued

### DateTime Filters
- `created_at`: When the product was created
- `updated_at`: When the product was last updated

## Company Filtering
Use the `company_id` parameter to filter pricing to specific companies:
- Single company: `?company_id=1`
- Multiple companies: `?company_id=1,2,3`

## Examples
```
# Get all products with pricing for all companies
/products/company-pricing

# Get products with pricing for specific companies only
/products/company-pricing?company_id=1,2

# Find products by SKU with company pricing
/products/company-pricing?sku[eq]=SKU-001

# Find products with specific price range and company pricing
/products/company-pricing?retail_price[gte]=50.00&retail_price[lte]=100.00

# Find products by category with company pricing
/products/company-pricing?category.name[eq]=Electronics
```




## OpenAPI

````yaml /api-reference/build.yaml get /products/company-pricing
openapi: 3.0.0
info:
  title: Luminous API
  version: 1.0.0
  description: API documentation for Luminous
servers:
  - url: https://{companyName}.api.joinluminous.com/external/api/v1
    variables:
      companyName:
        default: companyName
        description: Your company-specific subdomain
security: []
tags:
  - name: Products
    description: Get and manage products
  - name: Pricing
    description: Manage price schedules, levels, and customizations
  - name: BOMs
    description: Manage Bills of Materials (BOMs)
  - name: Labels
    description: Label rendering via Labelary ZPL service
  - name: Companies
    description: Manage business accounts and their associated data
  - name: Contacts
    description: Manage contact information for individuals
  - name: Suppliers
    description: Manage suppliers (factories) — vendors used on purchase orders
  - name: Supplier SKUs
    description: Manage per-supplier SKU and unit-cost overrides for products
  - name: Locations
    description: Manage warehouses and locations
  - name: Inventory
    description: Get and adjust product stock levels
  - name: Lots
    description: Create, update, and delete product lots (batches)
  - name: Transfer Orders
    description: Manage transfer orders
  - name: Fulfillment Orders
    description: Manage fulfillment orders and picklists
  - name: Purchase Orders
    description: Get and modify purchase orders
  - name: Receiving Reports
    description: Manage receiving reports
  - name: Payment Obligations
    description: Manage payment obligations for purchase orders
  - name: Sales Orders
    description: Manage sales orders and sales order shipments
  - name: Purgatory
    description: >-
      Inspect and resolve non-posted sales orders in the purgatory staging
      workflow
  - name: PickFlow Shipping
    description: >-
      Provider-agnostic shipping rates, services, packages, and label purchase
      for PickFlow
  - name: Cycle Counts
    description: >-
      Create, drive, and post PickFlow cycle counts — batches, per-warehouse
      sessions, and CSV import/export
  - name: Print Stations
    description: List paired print stations and enqueue print jobs to them
  - name: Invoices
    description: Get and manage invoices
  - name: Work Orders
    description: >-
      Manage work orders — production lifecycle, steps, materials, links,
      shipments, and comments
  - name: Production Batches
    description: Group and manage work orders as production batches
  - name: Bills
    description: >-
      Accounts payable bill management, payments, attachments, allocations, and
      variance
  - name: Prepayments
    description: Manage vendor prepayments and applications
  - name: Vendor Credits
    description: Manage vendor credits and applications
  - name: Vendor Returns
    description: Manage vendor returns and credit generation
  - name: Customer Returns
    description: Manage customer returns (sales returns), receiving, and restock behavior
  - name: Stock Snapshot
    description: Point-in-time stock snapshots with export support
  - name: Consumption
    description: Consumption reports and exports
  - name: Inventory Aging
    description: Cost-layer-based inventory aging reports
  - name: Bills Reports
    description: Accounts payable bills aging reports
  - name: Forecast
    description: Materialized forecast data
  - name: Reports
    description: Close the books, inventory discrepancy, transaction COGS, and EDI reports
  - name: Tags
    description: Add/remove tags across various resources
  - name: Custom Fields
    description: Get and set custom fields across various resources
  - name: Currency
    description: Currency configuration, exchange rates, and conversion
  - name: Integration Mappings
    description: Manage integration mappings for external systems
  - name: Integration Field Mappings
    description: Manage field-level mappings between Luminous and external systems
paths:
  /products/company-pricing:
    get:
      tags:
        - Products
      summary: All products with company pricing
      description: >
        Retrieve ALL products in the system with pricing calculated for all
        active companies 

        or filtered by specific company IDs. Unlike company-specific endpoints,
        this returns 

        comprehensive pricing information for multiple companies in a single
        request.


        Each product will include a `company_prices` array containing pricing
        for each company 

        based on their assigned price levels, price groups, and applicable
        discounts or markups.


        This endpoint supports all the same filtering parameters as the regular
        products endpoint,

        allowing you to retrieve company pricing data for specific sets of
        products.


        For detailed information about the filtering system and available
        operators, 

        refer to the [Filter System Documentation](/filters).


        ## Available Filters

        ### String Filters

        - `name`: Product name

        - `description`: Product description

        - `sku`: Product SKU (searches both internal SKU and alternate SKUs)

        - `upc`: Product UPC/Barcode

        - `tag`: Product tags

        - `q`: General search matches name OR upc OR sku

        - `category.name`: Filter by category name

        - `sub_category.name`: Filter by sub-category name

        - `supplier.name`: Filter by supplier name


        ### Integer Filters

        - `category.id`: Filter by category ID

        - `sub_category.id`: Filter by sub-category ID

        - `supplier.id`: Filter by supplier ID


        ### Float Filters

        - `retail_price`: Product retail price

        - `wholesale_price`: Product wholesale price


        ### Boolean Filters

        - `sellable`: If the product is sellable or not

        - `discontinued`: If the product is discontinued


        ### DateTime Filters

        - `created_at`: When the product was created

        - `updated_at`: When the product was last updated


        ## Company Filtering

        Use the `company_id` parameter to filter pricing to specific companies:

        - Single company: `?company_id=1`

        - Multiple companies: `?company_id=1,2,3`


        ## Examples

        ```

        # Get all products with pricing for all companies

        /products/company-pricing


        # Get products with pricing for specific companies only

        /products/company-pricing?company_id=1,2


        # Find products by SKU with company pricing

        /products/company-pricing?sku[eq]=SKU-001


        # Find products with specific price range and company pricing

        /products/company-pricing?retail_price[gte]=50.00&retail_price[lte]=100.00


        # Find products by category with company pricing

        /products/company-pricing?category.name[eq]=Electronics

        ```
      operationId: getAllProductsWithCompanyPricing
      parameters:
        - in: query
          name: company_id
          schema:
            type: string
          description: >
            Filter pricing to specific company IDs. Can be a single ID or
            comma-separated list.

            If not provided, pricing for all active companies will be included.
          example: 1,2,3
        - in: query
          name: page
          schema:
            type: integer
            default: 1
          description: Page number for pagination
        - in: query
          name: per_page
          schema:
            type: integer
            default: 10
            maximum: 100
          description: Number of items per page (max 100)
        - in: query
          name: q
          schema:
            type: string
          description: Filter by name OR upc OR sku
        - in: query
          name: name
          schema:
            type: string
          description: Filter by product name
        - in: query
          name: description
          schema:
            type: string
          description: Filter by product description
        - in: query
          name: sku
          schema:
            type: string
          description: Filter by SKU (searches both internal and alternate SKUs)
        - in: query
          name: upc
          schema:
            type: string
          description: Filter by UPC/Barcode
        - in: query
          name: sellable
          schema:
            type: boolean
          description: Filter by sellable status
        - in: query
          name: discontinued
          schema:
            type: boolean
          description: Filter by whether the product is discontinued
        - in: query
          name: retail_price
          schema:
            type: number
            format: float
          description: Filter by retail price
        - in: query
          name: wholesale_price
          schema:
            type: number
            format: float
          description: Filter by wholesale price
        - in: query
          name: created_at
          schema:
            type: string
            format: date-time
          description: Filter by creation date
        - in: query
          name: updated_at
          schema:
            type: string
            format: date-time
          description: Filter by last update date
        - in: query
          name: tag
          schema:
            type: string
          description: Filter by product tags
        - in: query
          name: category.id
          schema:
            type: integer
          description: Filter by category ID
        - in: query
          name: category.name
          schema:
            type: string
          description: Filter by category name
        - in: query
          name: sub_category.id
          schema:
            type: integer
          description: Filter by sub-category ID
        - in: query
          name: sub_category.name
          schema:
            type: string
          description: Filter by sub-category name
        - in: query
          name: supplier.id
          schema:
            type: integer
          description: Filter by supplier ID
        - in: query
          name: supplier.name
          schema:
            type: string
          description: Filter by supplier name
      responses:
        '200':
          description: List of products with company pricing information
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: array
                    items:
                      type: object
                      properties:
                        id:
                          type: integer
                          description: Unique identifier for the product
                        name:
                          type: string
                          description: Product name
                        description:
                          type: string
                          nullable: true
                          description: Product description
                        retail_price:
                          type: number
                          format: float
                          description: Retail price
                        wholesale_price:
                          type: number
                          format: float
                          description: Wholesale price
                        unit_cost:
                          type: number
                          format: float
                          description: Cost per unit
                        landed_cost:
                          type: number
                          format: float
                          nullable: true
                          description: Landed cost per unit
                        manufacturing_fee:
                          type: number
                          format: float
                          nullable: true
                          description: Manufacturing fee per unit
                        company_prices:
                          type: array
                          description: >
                            Array of company-specific pricing for this product.
                            Each object contains pricing 

                            calculated based on the company's price level, price
                            group assignments, and any 

                            applicable discounts or markups based on product
                            category.
                          items:
                            type: object
                            description: Company-specific pricing information
                            properties:
                              company_id:
                                type: integer
                                description: The unique identifier of the company
                                example: 1
                              company_name:
                                type: string
                                description: The name of the company
                                example: Electronics Retailer Pro
                              price:
                                type: number
                                format: float
                                description: >
                                  The calculated price for this company based on
                                  their price level, price group assignments,

                                  and any applicable discounts or markups based
                                  on product category.
                                example: 91.99
                        product_weight:
                          type: number
                          format: float
                          description: Weight of the product
                        product_length:
                          type: number
                          format: float
                          description: Length of the product (in inches)
                        product_width:
                          type: number
                          format: float
                          description: Width of the product (in inches)
                        product_height:
                          type: number
                          format: float
                          description: Height of the product (in inches)
                        qty_low_alert:
                          type: integer
                          description: Low stock alert threshold
                        qty_reorder_threshold:
                          type: integer
                          description: Reorder threshold quantity
                        qty_minimum:
                          type: integer
                          description: Minimum stock quantity
                        sellable:
                          type: boolean
                          description: Whether the product can be sold
                        discontinued:
                          type: boolean
                          description: >-
                            Whether the product is discontinued. Discontinued
                            products will be hidden in the Luminous UI by
                            default.
                        image_url:
                          type: string
                          nullable: true
                          description: URL to the product's main image
                        category:
                          type: object
                          nullable: true
                          properties:
                            id:
                              type: integer
                            name:
                              type: string
                          description: Product category information
                        subcategory:
                          type: object
                          nullable: true
                          properties:
                            id:
                              type: integer
                            name:
                              type: string
                          description: Product subcategory information
                        custom_fields:
                          type: object
                          description: Dynamic custom fields with key-value pairs
                          additionalProperties:
                            type: string
                        attachments:
                          type: array
                          description: Product attachments
                          items:
                            type: object
                            properties:
                              id:
                                type: integer
                                description: Unique identifier for the attachment
                              name:
                                type: string
                                description: Filename of the attachment
                              type:
                                type: string
                                description: MIME type of the attachment
                              size:
                                type: integer
                                description: File size in bytes
                              full_url:
                                type: string
                                description: Full resolution URL of the attachment
                              thumb_url:
                                type: string
                                description: >-
                                  Thumbnail URL of the attachment (if
                                  applicable)
                            required:
                              - id
                              - name
                              - type
                              - size
                              - full_url
                        variants:
                          type: array
                          description: Product variants with company-specific pricing
                          items:
                            type: object
                            properties:
                              id:
                                type: integer
                              name:
                                type: string
                              description:
                                type: string
                                nullable: true
                              attachments:
                                type: array
                                description: Variant-specific attachments
                                items:
                                  type: object
                                  properties:
                                    id:
                                      type: integer
                                      description: Unique identifier for the attachment
                                    name:
                                      type: string
                                      description: Filename of the attachment
                                    type:
                                      type: string
                                      description: MIME type of the attachment
                                    size:
                                      type: integer
                                      description: File size in bytes
                                    full_url:
                                      type: string
                                      description: Full resolution URL of the attachment
                                    thumb_url:
                                      type: string
                                      description: >-
                                        Thumbnail URL of the attachment (if
                                        applicable)
                                  required:
                                    - id
                                    - name
                                    - type
                                    - size
                                    - full_url
                              retail_price:
                                type: number
                                format: float
                              wholesale_price:
                                type: number
                                format: float
                              company_prices:
                                type: array
                                description: >
                                  Array of company-specific pricing for this
                                  variant. Each object contains pricing 

                                  calculated using the same pricing logic as the
                                  main product but applied to the variant.
                                items:
                                  type: object
                                  description: Company-specific pricing information
                                  properties:
                                    company_id:
                                      type: integer
                                      description: The unique identifier of the company
                                      example: 1
                                    company_name:
                                      type: string
                                      description: The name of the company
                                      example: Electronics Retailer Pro
                                    price:
                                      type: number
                                      format: float
                                      description: >
                                        The calculated price for this company
                                        based on their price level, price group
                                        assignments,

                                        and any applicable discounts or markups
                                        based on product category.
                                      example: 91.99
                              custom_fields:
                                type: array
                                items:
                                  type: object
                              variant_attributes:
                                type: object
                                additionalProperties:
                                  type: string
                              sku:
                                type: string
                              upc:
                                type: string
                              sellable:
                                type: boolean
                                description: Whether the variant can be sold
                              discontinued:
                                type: boolean
                                description: Whether the variant is discontinued
                              created_at:
                                type: string
                                format: date-time
                              updated_at:
                                type: string
                                format: date-time
                        variant_attributes:
                          type: object
                          nullable: true
                          description: Available variant attributes
                        sku:
                          type: string
                          description: Internal SKU
                        alternate_skus:
                          type: array
                          description: Alternate SKUs
                          items:
                            type: object
                            properties:
                              id:
                                type: integer
                              sku:
                                type: string
                        upc:
                          type: string
                          description: UPC/Barcode
                        tags:
                          type: array
                          description: Tags associated with the product
                          items:
                            type: object
                            properties:
                              id:
                                type: integer
                                description: Unique identifier for the tag
                              name:
                                type: string
                                description: Name of the tag
                              description:
                                type: string
                                nullable: true
                                description: Description of the tag
                              icon:
                                type: string
                                nullable: true
                                description: Icon identifier or URL for the tag
                              color:
                                type: string
                                nullable: true
                                description: Color code for the tag
                            required:
                              - id
                              - name
                        substitutions:
                          type: array
                          description: >-
                            Product substitutions, these products may be
                            substituted if the main product is out of stock
                          items:
                            type: object
                            properties:
                              id:
                                type: integer
                                description: Substitution record ID
                              priority:
                                type: integer
                                description: >-
                                  Substitution priority (lower number = higher
                                  priority)
                              product:
                                type: object
                                description: The substitute product
                                properties:
                                  id:
                                    type: integer
                                    description: Unique identifier for the product
                                  name:
                                    type: string
                                    description: Product name
                                  description:
                                    type: string
                                    nullable: true
                                    description: Product description
                                  retail_price:
                                    type: number
                                    format: float
                                    description: Retail price
                                  wholesale_price:
                                    type: number
                                    format: float
                                    description: Wholesale price
                                  unit_cost:
                                    type: number
                                    format: float
                                    description: Cost per unit
                                  product_weight:
                                    type: number
                                    format: float
                                    description: Weight of the product
                                  product_length:
                                    type: number
                                    format: float
                                    description: Length of the product (in inches)
                                  product_width:
                                    type: number
                                    format: float
                                    description: Width of the product (in inches)
                                  product_height:
                                    type: number
                                    format: float
                                    description: Height of the product (in inches)
                                  sellable:
                                    type: boolean
                                    description: Whether the product can be sold
                                  discontinued:
                                    type: boolean
                                    description: Whether the product is discontinued
                                  image_url:
                                    type: string
                                    nullable: true
                                    description: URL to the product's main image
                                  sku:
                                    type: string
                                    description: Internal SKU
                                  upc:
                                    type: string
                                    description: UPC/Barcode
                                  created_at:
                                    type: string
                                    format: date-time
                                    description: Timestamp when the product was created
                                  updated_at:
                                    type: string
                                    format: date-time
                                    description: >-
                                      Timestamp when the product was last
                                      updated
                        supplier:
                          type: object
                          nullable: true
                          description: Supplier information
                        created_at:
                          type: string
                          format: date-time
                          description: Timestamp when the product was created
                        updated_at:
                          type: string
                          format: date-time
                          description: Timestamp when the product was last updated
                  meta:
                    type: object
                    properties:
                      current_page:
                        type: integer
                        description: The current page number
                        example: 1
                      from:
                        type: integer
                        description: The starting index of the paginated results
                        example: 1
                      last_page:
                        type: integer
                        description: The last page number
                        example: 5
                      per_page:
                        type: integer
                        description: Number of items per page
                        example: 10
                      to:
                        type: integer
                        description: The ending index of the paginated results
                        example: 10
                      total:
                        type: integer
                        description: Total number of items across all pages
                        example: 50
        '401':
          description: Authentication credentials were missing or invalid
          content:
            application/json:
              schema:
                type: object
                properties:
                  error:
                    type: string
                    example: Unauthorized
                  message:
                    type: string
                    example: Authentication credentials are missing or invalid
                  status_code:
                    type: integer
                    example: 401
        '403':
          description: You do not have permission to perform this action
          content:
            application/json:
              schema:
                type: object
                properties:
                  error:
                    type: string
                    example: Forbidden
                  message:
                    type: string
                    example: You do not have permission to access this resource
                  status_code:
                    type: integer
                    example: 403
      security:
        - BearerAuth: []
components:
  securitySchemes:
    BearerAuth:
      type: http
      scheme: bearer
      description: >-
        Authenticate using a bearer token. To create a token, navigate to
        /settings/api-tokens and click Create API Token.

````