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.3
        • 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.3
        • 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
  • Table columns
  • Associations

Was this helpful?

  1. API-References
  2. Entities

Offer

Was this helpful?

Table-name: b2b_offer

Plugin

Table columns

Field
Class
Type
Is required

id

IdField

binary

true

statusId

FkField

binary

true

offerCustomerId

FkField

binary

true

employeeId

FkField

binary

true

number

StringField

varchar

false

deliveryDate

DateTimeFid

Datetime

false

documentDate

DateTimeField

Datetime

false

validUntil

DateTimeField

Datetimte

false

matchcode

StringField

varchar

false

commission

Stringfield

varchar

false

process

StringField

varchar

false

editorId

FkField

binary

false

billingAddressId

FkField

binary

true

deliveryAddressId

FkField

binary

true

salesChannelId

FkField

binary

true

currencyId

FkField

binary

true

price

CartPriceField

json

false

optionalPrice

CartPriceField

json

false

shippingCosts

CalculatedPriceField

json

false

shippingMethodId

FkField

binary

true

deepLinkId

StringField

varchar

false

headerText

LongTextField

text

false

footerText

LongtextField

text

false

file

StringField

varchar

false

customFields

CustomFields

json

false

mailTo

Stringfield

varchar

false

mailCc

Stringfield

varchar

false

updatedAt

UpdatedAtField

Datetime

false

createdAt

CreatedAtField

Datetime

true

Associations

Field
Entity
Class

status

OfferStatusEntity

ManyToOneAssociationField

offerCustomer

OfferCustomerEntity

OneToOneAssociationField

employee

EmployeeEntity

ManyToOneAssociationField

editor

CustomerEntity

ManyToOneAssociationField

billingAddress

OfferAddressEntity

OneToOneAssociationField

deliveryAddress

OfferAddressEntity

OneToOneAssociationField

salesChannel

SalesChannelEntity

ManyToOneAssociationField

currency

CurrencyEntity

ManyToOneAssociationField

paymentCondition

PaymentConditionEntity

ManyToOneAssociationField

items

OfferItemEntity

OneToOneAssociationField

shippingMethod

ShippingMethodEntity

ManyToOneAssociationField

paymentMethod

PaymentMethodEntity

ManyToOneAssociationField

Offer Function for Sales Agents