REST API - Models

Address

  • Model: Shopware\Models\Customer\Address
  • Table: s_user_addresses

Structure

Field Type Original object
id integer (primary key)
company string
department string
salutation string
title string
firstname string
lastname string
street string
zipcode string
city string
phone string
vatId string
additionalAddressLine1 string
additionalAddressLine2 string
country int (foreign key) Country
state int (foreign key) State
attribute array

Area

  • Model: Shopware\Models\Country\Area
  • Table: s_core_countries_areas
Field Type Original object
id integer (primary key)
name string
active boolean
countries object array Country

Article Attribute

  • Model: Shopware\Models\Attribute\Article
  • Table: s_articles_attributes
Field Type Original object
attr1 string
attr2 string
attr3 string
attr4 string
attr5 string
attr6 string
attr7 string
attr8 string
attr9 string
attr10 string
attr11 string
attr12 string
attr13 string
attr14 string
attr15 string
attr16 string
attr17 string
attr18 string
attr19 string
attr20 string
articleId integer (foreign key) Article
articleDetailId integer (foreign key) Detail

Article Detail

  • Model: Shopware\Models\Article\Detail
  • Table: s_articles_details
Field Type Original object
number string
supplierNumber string
additionalText string
weight string
width string
len string
height string
ean string
purchaseUnit string
descriptionLong string
referenceUnit string
packUnit string
shippingTime string
prices object array Price
configuratorOptions object array ConfiguratorOption
attribute object Attribute
id integer (primary key)
articleId integer (foreign key) Article
unitId integer (foreign key)
kind integer
inStock integer
position integer
minPurchase integer
purchaseSteps integer
maxPurchase integer
releaseDate date/time
active boolean
shippingFree boolean
esd object Esd

Billing

  • Model: Shopware\Models\Order\Billing
  • Table: s_order_billingaddress
Field Type Original object
id integer (primary key)
orderId integer (foreign key)
customerId integer (foreign key)
countryId integer (foreign key) Country
stateId integer (foreign key)
company string
department string
title string
salutation string
number string
firstName string
lastName string
street string
zipCode string
city string
additionalAddressLine1 string
additionalAddressLine2 string
phone string
vatId string
country object Country
state object/null State
birthday date/time
attribute object BillingAttribute

Billing Attribute

  • Model: Shopware\Models\Attribute\OrderBilling
  • Table: s_order_billingaddress_attributes
Field Type Original object
id integer (primary key)
orderBillingId integer (foreign key)
text1 string
text2 string
text3 string
text4 string
text5 string
text6 string

Category

  • Model: Shopware\Models\Category\Category
  • Table: s_categories
Field Type Original object
id integer (primary key)
name string

Configurator Group

  • Model: Shopware\Models\Article\Configurator\Group
  • Table: s_article_configurator_groups
Field Type Original object
id integer (primary key)
description string
name string
position integer

Configurator Option

  • Model: Shopware\Models\Article\Configurator\Option
  • Table: s_article_configurator_options
Field Type Original object
id integer (primary key)
groupId integer (foreign key) ConfiguratorGroup
name string
position integer

Configurator Set

  • Model: Shopware\Models\Article\Configurator\Set
  • Table: s_article_configurator_sets
Field Type Original object
id integer (primary key)
name string
public boolean
type integer
groups object array ConfiguratorGroup

Country

  • Model: Shopware\Models\Country\Country
  • Table: s_core_countries
Field Type Original object
id integer (primary key)
name string
iso string
isoName string
position integer
description string
shippingFree boolean
taxFree boolean
taxFreeUstId boolean
taxFreeUstIdChecked boolean
active boolean
iso3 string
displayStateInRegistration boolean
forceStateInRegistration boolean
areaId integer (foreign key) Area
states object array State

Currency

  • Model: Shopware\Models\Shop\Currency
  • Table: s_core_currencies
Field Type Original object
id integer (primary key)
currency string
name string
default boolean
factor double
symbol string
symbolPosition integer
position integer

Customer

  • Model: Shopware\Models\Customer\Customer
  • Table: s_user
Field Type Original object
id integer (primary key)
number string
groupKey string (foreign key) CustomerGroup
paymentId integer (foreign key) Payment
shopId string (foreign key) Shop
priceGroupId integer (foreign key) PriceGroup
encoderName string
hashPassword string
active boolean
email string
firstLogin (date of creation) date/time
lastLogin date/time
accountMode integer
confirmationKey string
sessionId string
newsletter boolean
validation string
affiliate boolean
paymentPreset integer
languageId integer (foreign key) Shop
referer string
internalComment string
failedLogins integer
lockedUntil date/time
salutation string
title string
firstname string
lastname string
birthday date
defaultBillingAddress integer (foreign key) Billing
defaultShippingAddress integer (foreign key) Shipping

Customer Attribute

  • Model: Shopware\Models\Attribute\Customer
  • Table: s_user_attributes
Field Type Original object
id integer (primary key)
customerId integer (foreign key) Customer

Customer Group

  • Model: Shopware\Models\Customer\Group
  • Table: s_core_customergroups
Field Type Original object
id integer (primary key)
key string
name string
tax boolean
taxInput boolean
mode boolean
discount double
minimumOrder double
minimumOrderSurcharge double
basePrice double
percent double

Customer Group Surcharge

  • Model: Shopware\Models\Customer\Discount
  • Table: s_customergroups_discounts
Field Type Original Object
id integer (primary key)
discount integer
value integer

Debit

  • Model: Shopware\Models\Customer\Debit
  • Table: s_user_debit
Field Type Original object
id integer (primary key)
customerId integer (foreign key)
account string
bankCode string
bankName string
accountHolder string

Dispatch

  • Model: Shopware\Models\Dispatch\Dispatch
  • Table: s_premium_dispatch
Field Type Original object
id integer (primary key)
name string
type integer
description string
comment string
active boolean
position integer
calculation integer
surchargeCalculation integer
taxCalculation integer
shippingFree decimal
multiShopId integer (foreign key) Shop
customerGroupId integer (foreign key) CustomerGroup
bindShippingFree integer
bindTimeFrom integer
bindTimeTo integer
bindInStock integer
bindLastStock integer
bindWeekdayFrom integer
bindWeekdayTo integer
bindWeightFrom decimal
bindWeightTo decimal
bindPriceFrom decimal
bindPriceTo decimal
bindSql string
statusLink string
calculationSql string
attribute object/null DispatchAttribute

Dispatch Attribute

  • Model: Shopware\Models\Attribute\Dispatch
  • Table: s_premium_dispatch_attributes
Field Type Original object
id integer (primary key)
dispatchId integer (foreign key)

Document

  • Model: Shopware\Models\Order\Document\Document
  • Table: s_order_documents
Field Type Original object
id integer (primary key)
date date/time
typeId integer (foreign key) DocumentType
customerId integer (foreign key) Customer
orderId integer (foreign key) Order
amount double
documentId integer (foreign key)
hash string
type object DocumentType
attribute object DocumentAttribute

Document Attribute

  • Model: Shopware\Models\Attribute\Document
  • Table: s_order_documents_attributes
Field Type Original object
id integer (primary key)
documentId integer (foreign key)

Document Type

  • Model: Shopware\Models\Document\Document
  • Table: s_order_documents
Field Type Original object
id integer (primary key)
name string
template string
numbers string
left integer
right integer
top integer
bottom integer
pageBreak integer

Download

  • Model: Shopware\Models\Article\Download
  • Table: s_articles_downloads
Field Type Original object
id integer (primary key)
articleId integer (foreign key) Article
name string
file string
size int

Esd

  • Model: Shopware\Models\Article\Esd
  • Table: s_articles_esd
Field Type Original object
file string
reuse boolean
hasSerials boolean
serials object array EsdSerial

ESD-Serial

  • Model: Shopware\Models\Article\EsdSerial
  • Table: s_articles_esd_serials
Field Type Original object
serialnumber string

Image

  • Model: Shopware\Models\Article\Image
  • Table: s_articles_img
Field Type Original object
id integer (primary key)
articleId integer (foreign key) Article
articleDetailId integer (foreign key) Detail
description string
path string
main integer
position integer
width integer
height integer
relations string
extension string
parentId integer
mediaId integer Media
The field `path` has to be the local path to the image, seen from the root of the Shopware installation. There is an additional, internal helper field `link`, which allows to supply a URL that is being downloaded and converted to the `path` field internally. See the [product examples](https://developers.shopware.com/developers-guide/rest-api/examples/article/#further-examples] for an example.
  • Model: Shopware\Models\Article\Link
  • Table: s_articles_information
Field Type Original object
id integer (primary key)
articleId integer (foreign key) Article
name string
link string
target string

Locale

  • Model: Shopware\Models\Shop\Locale
  • Table: s_core_locales
Field Type Original object
id integer (primary key)
locale string
language string
territory string

Order Attribute

  • Model: Shopware\Models\Attribute\OrderDetail
  • Table: s_order_attributes
Field Type Original object
id integer (primary key)
orderId integer (foreign key)
attribute1 string
attribute2 string
attribute3 string
attribute4 string
attribute5 string
attribute6 string

Order Detail

  • Model: Shopware\Models\Order\Detail
  • Table: s_order_detail
Field Type Original object
id integer (primary key)
orderId string Order
articleId integer (foreign key) Article
taxId integer (foreign key) Tax
taxRate double
statusId integer (foreign key) Status
number string (foreign key) Order
articleNumber string (foreign key) ArticleDetail
price double
quantity integer
articleName string
shipped integer
shippedGroup integer
releaseDate date/time
mode integer
esdArticle integer
config string
ean string
unit string
packUnit string
attribute object OrderDetailAttribute

Order Detail Attribute

  • Model: Shopware\Models\Attribute\OrderDetail
  • Table: s_order_attributes
Field Type Original object
id integer (primary key)
orderDetailId integer (foreign key) OrderDetail
attribute1 string
attribute2 string
attribute3 string
attribute4 string
attribute5 string
attribute6 string

Order Status

  • Model: Shopware\Models\Order\Status
  • Table: s_core_states
Field Type Original object
id integer (primary key)
name string
position integer
group string
sendMail boolean

Payment

  • Model: Shopware\Models\Payment\Payment
  • Table: s_core_paymentmeans
Field Type Original object
id integer (primary key)
name string
description string
template string
hide boolean
additionalDescription string
debitPercent float
surcharge integer
surchargeString string
position integer
active boolean
esdActive boolean
mobileInactive boolean
pluginId integer

Payment Data

  • Model: Shopware\Models\Customer\PaymentData
  • Table: s_core_payment_data
Field Type Original object
id integer (primary key)
paymentMeanId integer (foreign key)
useBillingData string
bankName string
bic string
iban string
accountNumber string
bankCode string
accountHolder string
createdAt date/time

Payment Instance

  • Model: Shopware\Models\Payment\PaymentInstance
  • Table: s_core_payment_instance
Field Type Original object
id integer (primary key)
firstName string
lastName string
address string
zipCode string
city string
bankName string
bankCode string
accountNumber string
accountHolder string
bic string
iban string
amount string
createdAt date/time

Payment Status

  • Model: Shopware\Models\Order\Status
  • Table: s_core_states
Field Type Original object
id integer (primary key)
name string
position integer
group string
sendMail boolean

Price

  • Model: Shopware\Models\Article\Price
  • Table: s_articles_prices
Field Type Original object
customerGroupKey string (foreign key) CustomerGroup
customerGroup object CustomerGroup
articleDetailsId integer (foreign key) Detail
articleId integer (foreign key) Article
id integer (primary key)
from integer/string
to string
price double
pseudoPrice double
basePrice double
percent double
regulationPrice (>= v5.7.8) double

Price Group

  • Table: s_core_pricegroups
Field Type Original object
id int (primary key)
description string

Property Group

  • Model: Shopware\Models\Property\Group
  • Table: s_filter
Field Type Original object
id integer (primary key)
name string
position integer
comparable boolean
sortMode integer

Property Group Attribute

  • Model: Shopware\Models\Attribute\PropertyGroup
  • Table: s_filter
Field Type Original object
id integer (primary key)
propertyGroupId integer (foreign key)

Property Group Option

  • Model: Shopware\Models\Property\Option
  • Table: s_filter_options
Field Type Original object
id integer (primary key)
name string
filterable boolean

Property Value

Field Type Original object
valueNumeric double
position integer
optionId integer
id integer (primary key)
value string
  • Table: s_articles_relationships
Field Type Original object
id integer (foreign key) Article
name string Article name
  • Table: s_articles_relationships
Field Type Original object
id integer (foreign key) Article
number string Article number

Shipping

  • Model: Shopware\Models\Order\Shipping
  • Table: s_order_shippingaddress
Field Type Original object
id integer (primary key)
orderId integer (primary key)
customerId integer (foreign key) Customer
countryId integer (foreign key) Country
stateId integer (foreign key) State
company string
department string
title string
salutation string
number string
firstName string
lastName string
street string
zipCode string
city string
additionalAddressLine1 string
additionalAddressLine2 string
country object Country
state object State
attribute object ShippingAttribute

Shipping Attribute

  • Model: Shopware\Models\Attribute\OrderBilling
  • Table: s_order_shippingaddress_attributes
Field Type Original object
id integer (primary key)
orderShippingId integer (foreign key)
text1 string
text2 string
text3 string
text4 string
text5 string
text6 string

Shop

  • Model: Shopware\Models\Shop\Shop
  • Table: s_core_shops
Field Type Original object
id integer (primary key)
mainId integer (foreign key)
categoryId integer (foreign key) Category
name string
title string
position integer
host string
basePath string
baseUrl string
hosts string
secure boolean
secureHost string
secureBasePath string
default boolean
active boolean
customerScope boolean
locale object Locale

The locale is only available for languageSubShops.

Similar (GET)

  • Table: s_articles_similar
Field Type Original object
id integer (foreign key) Article
name string Article name

Similar (PUT, POST)

  • Table: s_articles_similar
Field Type Original object
id integer (foreign key) Article
number string Article number

State

  • Model: Shopware\Models\Country\State
  • Table: s_core_countries_states
Field Type Original object
id integer (primary key)
countryId integer (foreign key) Country
position integer
name string
shortCode string
active boolean

Supplier

  • Model: Shopware\Models\Article\Supplier
  • Table: s_articles_supplier
Field Type Original object
id integer (primary key)
name string
image string
link string
description string
metaTitle string
metaDescription string
metaKeywords string

Tax

  • Model: Shopware\Models\Tax\Tax
  • Table: s_core_tax
Field Type Original object
id integer (primary key)
tax string
name string

Translation

  • Model: Shopware\Models\Article\Translation
  • Table: s_core_translation, s_articles_translations
Field Type Original object
metaTitle string
attr1 string
attr2 string
attr3 string
attr4 string
attr5 string
attr6 string
attr7 string
attr8 string
attr9 string
attr10 string
attr11 string
attr12 string
attr13 string
attr14 string
attr15 string
attr16 string
attr17 string
attr18 string
attr19 string
attr20 string
name string
description string
descriptionLong string
keywords string
packUnit string
shopId integer
Top