B2Bsellers Suite
API Referenceswww.b2b-sellers.comPublic demoshopRoadmap
v2.X.X+v3.X.X (Shopware 6.5/6.6)
v2.X.X+v3.X.X (Shopware 6.5/6.6)
  • Home
  • Product Tour
    • Plans & Plugin Concept
    • Public Demoshops
    • Get a personal B2B demo store?
    • Changes Made to Customers - What Are Companies, Employees and Sales Representatives
  • User Guide
    • Installation, Setup & Upgrade
      • Installation
      • Upgrade
      • Requirements
      • Easy activate all Addons and Features
      • Use Test-Customers
      • License Settings
      • Common Installation and Upgrade Errors
    • User Documentation (Alpha)
    • Configuration
      • Shop Admin Configurations
      • License, purchaseable Addons and Features configuration
      • E-Mail Templates
      • B2B Flow/Business Events
      • Registration process
      • PDP variant list
    • Configuration of purchasable Addons
      • E-Procurement (OCI-Punchout)
      • E-Procurement (cXML Purchase Order / Ariba)
      • Register Requests (wip)
      • Order Lists
      • URL Authentication
    • Performance
    • FAQs
    • Support Lifecycle & Release Strategy
    • Customer Support
  • Using HTTP Cache for Logged-In Users
  • Developer Guides
    • First Steps
      • Getting Started
      • Concept of Extensions
      • Dockware Setup (Docker)
      • How to start the b2b-platform vue.js watcher
      • How to build the b2b-platform (vue.js)
      • How to extend the B2B Platform (Storefront Vue.js)
      • Protection of the Store-API
      • How to develop your first extensions
      • CLI-Commands
        • Migration of existing Shopware Customers
      • Frosh Shopware-CLI Admin-Watcher
      • Cronjobs
      • Development Helpers
      • Example Plugins
    • Smart developer helpers
      • B2bPlatformContext
      • B2bContextTrait
      • EmployeePermissionTrait
      • B2B Body Classes
      • UseCustomer URL Parameter
      • Useful Vue.js Components for the B2B Platform
      • Useful Storefront Shopping World Elements
      • How to import external orders and offers?
    • How to's
      • Using B2Bsellers Suite with Shopware frontends
      • Add or remove subscription intervals
      • Add additional data to the order confirmation mail
    • Guides for ERP-Interface
      • Overview - Full integrated ERP-Systems
      • Integration of ERP orders to Shopware 6
      • Integration Customers and Employees from ERP
    • Tips for Deployment / Continuous Integration
    • Typical errors
  • API-References
    • Database Schema
    • Entities
      • Custom Fields for existing Shopware Entities
      • Budget
      • BudgetEmployee
      • CollectionAccount
      • CustomerPrice
      • Employee
        • EmployeeCustomer
        • EmployeePermission
        • EmployeeRole
      • CustomerActivity
        • CustomerActivityType
      • Offer
        • OfferAddress
        • OfferCustomer
        • OfferItem
        • OfferStatus
      • ProductSubscription
      • ProductSubscriptionOrder
      • PasswordlessLogin
      • PaymentCondition
      • ProductExplodedView
      • B2bProductList
        • B2bProductListItem
        • B2bProductListType
      • RegisterRequest
        • RegisterRequestStatus
        • RegisterRequestActivity
      • SalesRepresentativeCustomer
    • Store API
    • Store-API
      • Account Request
      • Customer Activity
      • Customer Activity Type
      • Customer Last Orders
      • Customer List
      • Customer Price
      • Customer Sales Ranking
      • Customer Search
      • Delivery Interval
      • Delete Product Subscription
      • Document
      • Employee
      • Employee Permission
      • Employee Role
      • Employee Order
      • Login Target List
      • Offer Document
      • Offer
      • Offer Mail
      • Offer Order
      • Offer Status
      • Ordered Products
      • Platform Cms
      • Product List
      • Product Table Listing
      • Product Subscription
      • Product Subscription List
      • Sales Statistic
      • Snippet
    • Admin API
      • General Admin-API Info
      • Order Extension
  • Release Notes
    • B2BsellersCore
      • Version v3.x.x
        • Version v3.3.2
        • Version v3.3.1
        • Version v3.3.0
        • Version v3.2.2
        • Version v3.2.1
        • Version v3.2.0
        • Version v3.1.6
        • Version v3.1.5
        • Version v3.1.4
        • Version v3.1.3
        • Version v3.1.2
        • Version v3.1.1
        • Version v3.1.0
        • Version v3.0.3
        • Version v3.0.2
        • Version v3.0.1
        • Version v3.0.0
      • Version v2.x.x
        • Version v2.4.2
        • Version v2.4.1
        • Version v2.4.0
        • Version v2.3.6
        • Version v2.3.5
        • Version v2.3.4
        • Version v2.3.3
        • Version v2.3.2
        • Version v2.3.1
        • Version v2.3.0
        • Version v2.2.6
        • Version v2.2.5
        • Version v2.2.4
        • Version v2.2.3
        • Version v2.2.2
        • Version v2.2.1
        • Version v2.2.0
        • Version v2.1.2
        • Version v2.1.1
        • Version v2.1.0
        • Version v2.0.2
        • Version v2.0.1
        • Version v2.0.0
      • Version v1.x.x
        • Version v1.1.8
        • Version v1.1.7
        • Version v1.1.6
        • Version v1.1.5
        • Version v1.1.4 - security update
        • Version v1.1.3
        • Version v1.1.2
        • Version v1.1.1
        • Version v1.1.0
        • Version v1.0.4
        • Version v1.0.3
        • Version v1.0.2
        • Version v1.0.1 - Hotfix
        • Version v1.0.0
      • Version v0.x.x (beta)
        • Version v0.9.6
        • Version v0.9.5
        • Version v0.9.4
        • Version v0.9.3
        • Version v0.9.2
        • Version v0.9.1
  • Help
    • Core Settings
      • Permanent Shopping Cart Settings Changes April 2024
Powered by GitBook
On this page
  • Configuration
  • Table columns
  • Associations
  • Store API Methods

Was this helpful?

  1. API-References
  2. Entities

CustomerPrice

Last updated 9 months ago

Was this helpful?

Table-name: b2bsellers_customer_price

Find below a link to configuration options, and a list of all available fields and associations for customer specific prices.

Configuration

The following linked page will give you information on:

  • How to add specific customer prices

    • via Shopware Admin

    • via API

  • Creating customer specific proces without UUID's (Product and Customer)

  • Some handy command lines for console to use

Table columns

Field
Class
Type
Is required

id

IdField

binary

true

customerId

FkField

binary

true

productId

FkField

binary

true

productVersionId

ReferenceVersionField

binary

true

currencyId

FkField

binary

false

productNumber

StringField

varchar

false

currencyIsoCode

StringField

varchar

false

customerNumber

StringField

varchar

false

from

IntField

int

false

to

IntField

int

false

priceNet

FloatField

Float

false

pseudoPriceNet

FloatField

Float

false

updatedAt

UpdatedAtField

Datetime

false

createdAt

CreatedAtField

Datetime

true

validFrom

DateTimeField

Datetime

false

validUntil

DateTimeField

Datetime

false

Associations

Field
Entity
Class

customer

CustomerEntity

ManyToOneAssociationField

product

ProductEntity

ManyToOneAssociationField

currency

CurrencyEntity

ManyToOneAssociationField

Store API Methods

Customer specific prices | B2Bsellers Suite
Customer Price | B2Bsellers Suite
Logo
Logo