Shopware 6.1.4 sales_channel
Sales Channel definitions — each represents a distinct storefront, API endpoint, or POS terminal.
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | binary(16) | NO | Primary Key |
| type_id | binary(16) | NO | Index Foreign Key → sales_channel_type.id |
| short_name | varchar(45) | YES | |
| configuration | longtext | YES | |
| access_key | varchar(255) | NO | Unique |
| language_id | binary(16) | NO | Index Foreign Key → language.id |
| currency_id | binary(16) | NO | Index Foreign Key → currency.id |
| payment_method_id | binary(16) | NO | Index Foreign Key → payment_method.id |
| shipping_method_id | binary(16) | NO | Index Foreign Key → shipping_method.id |
| country_id | binary(16) | NO | Index Foreign Key → country.id |
| navigation_category_id | binary(16) | NO | Index Foreign Key → category.id |
| navigation_category_version_id | binary(16) | NO | Foreign Key → category.version_id |
| navigation_category_depth | int(11) | NO | Default: 2 |
| footer_category_id | binary(16) | YES | Index Foreign Key → category.id |
| footer_category_version_id | binary(16) | YES | Foreign Key → category.version_id |
| service_category_id | binary(16) | YES | Index Foreign Key → category.id |
| service_category_version_id | binary(16) | YES | Foreign Key → category.version_id |
| active | tinyint(1) | NO | Default: 1 |
| maintenance | tinyint(1) | NO | Default: 0 |
| maintenance_ip_whitelist | longtext | YES | |
| customer_group_id | binary(16) | NO | Index Foreign Key → customer_group.id |
| mail_header_footer_id | binary(16) | YES | Index Foreign Key → mail_header_footer.id |
| payment_method_ids | longtext | YES | |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| fk.sales_channel.country_id | country_id | No |
| fk.sales_channel.currency_id | currency_id | No |
| fk.sales_channel.customer_group_id | customer_group_id | No |
| fk.sales_channel.footer_category_id | footer_category_id,footer_category_version_id | No |
| fk.sales_channel.header_footer_id | mail_header_footer_id | No |
| fk.sales_channel.language_id | language_id | No |
| fk.sales_channel.navigation_category_id | navigation_category_id,navigation_category_version_id | No |
| fk.sales_channel.payment_method_id | payment_method_id | No |
| fk.sales_channel.service_category_id | service_category_id,service_category_version_id | No |
| fk.sales_channel.shipping_method_id | shipping_method_id | No |
| fk.sales_channel.type_id | type_id | No |
| PRIMARY | id | Yes |
| uniq.access_key | access_key | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| country_id | country | id |
| currency_id | currency | id |
| customer_group_id | customer_group | id |
| footer_category_id | category | id |
| footer_category_version_id | category | version_id |
| mail_header_footer_id | mail_header_footer | id |
| language_id | language | id |
| navigation_category_id | category | id |
| navigation_category_version_id | category | version_id |
| payment_method_id | payment_method | id |
| service_category_id | category | id |
| service_category_version_id | category | version_id |
| shipping_method_id | shipping_method | id |
| type_id | sales_channel_type | id |
Relations (to this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| id | customer | sales_channel_id |
| id | sales_channel_translation | sales_channel_id |
| id | sales_channel_language | sales_channel_id |
| id | sales_channel_currency | sales_channel_id |
| id | sales_channel_country | sales_channel_id |
| id | sales_channel_shipping_method | sales_channel_id |
| id | sales_channel_payment_method | sales_channel_id |
| id | cart | sales_channel_id |
| id | order | sales_channel_id |
| id | product_review | sales_channel_id |
| id | seo_url | sales_channel_id |
| id | sales_channel_domain | sales_channel_id |
| id | mail_template_sales_channel | sales_channel_id |
| id | number_range_sales_channel | sales_channel_id |
| id | product_visibility | sales_channel_id |
| id | newsletter_recipient | sales_channel_id |
| id | document_base_config_sales_channel | sales_channel_id |
| id | seo_url_template | sales_channel_id |
| id | theme_sales_channel | sales_channel_id |
| id | product_export | sales_channel_id |
| id | product_export | storefront_sales_channel_id |
| id | promotion_sales_channel | sales_channel_id |
| id | main_category | sales_channel_id |