logo
Product management

Pricing

Configure pricing for SKUs with scoped pricing and grade references

Overview

Pricing is stored in sku_based_pricing with scopes that allow inheritance from global defaults down to product-specific overrides.


Pricing Structure

Scopes (least to most specific)

  • Global – default for all
  • Manufacturer – overrides global for a manufacturer
  • Range – overrides manufacturer for a range
  • Product – overrides range for a product

Price Types

  • Direct price – number (e.g. 299)
  • Grade reference – string (e.g. GRADE_A) resolved via gradeToPrice

Pricing CSV Format

# ======= SCOPE: Demo Manufacturer (MANUFACTURER ID: 17) =======
Scope,Category,SKU,Selection Name,Price/Grade,Grade To Price Change

"Demo Manufacturer","Fabric","FAB-VB-001","Velvet Blue","299",""
"Demo Manufacturer","Fabric","FAB-LG-002","Linen Grey","GRADE_A",""
"Demo Manufacturer","Legs","LEG-OAK-01","Oak","150","grade_a=120"

Columns

ColumnPurpose
ScopeScope name (display)
CategorySame as SKU mapping
SKUSKU code (must match SKU mapping)
Selection NameDisplay name
Price/GradeNumber or grade label; empty = no price / inherit
Grade To Price ChangeOptional overrides: grade=price,grade=price (e.g. grade_a=120)

Grade Definitions

Each scope can define grades:

# Grade Definitions for this scope:
Scope,Category,SKU,Selection Name,Price/Grade
"Demo Manufacturer","Grade","GRADE_A","Grade Definition","399"
"Demo Manufacturer","Grade","GRADE_B","Grade Definition","499"

Inheritance

  • Product inherits from Range → Manufacturer → Global
  • Range inherits from Manufacturer → Global
  • Manufacturer inherits from Global
  • Empty Price/Grade cells inherit from the parent scope

Retailers

Retailers can override pricing at range/product level via scopes. They see manufacturers they have access to, and pricing CSV exports include all accessible manufacturers.


Next Steps

After setting up your pricing:

  1. Set up SKUs (if not done) → SKU Management

On this page