Under Items/Overview you can find a table containing key information of your items and category mappings. By clicking on a category, all items assigned to the category will be displayed. Important information such as the order number, item name or price can be found directly in the overview. In addition, the overview also displays whether an item is active or inactive.
Above the Overview table, you can find a description of each column as well as a checkbox which gives you the option of displaying item variants. By clicking on the Name column (1), the contents of the table will be directly sorted alphabetically by name. The same is true for Supplier, Price, etc. Under the Overview table, you can find an options bar (2). Here you can see how many items are in the selected category. You can move to the next page or set how many items per page to display.
By clicking the yellow pencil to the right of the Info column, an editing interface opens in a new window. Here you are able to adjust settings for your items. You are able to edit these values directly in the table by double-clicking (except for Manufacturer and Tax). Simply input your changes and confirm them by pressing Enter.
In the Item overview, you can delete items quickly and easily. To delete a single item, simply click on the delete icon (1) and confirm.
To delete several items at the same time, you can use the checkbox to the left of the order number (5) of the desired item. Then, select Delete selected items from the bar at the top and then confirm. You also have the option of selecting all items on the page (4).
Item images and assigned thumbnails will not be deleted.
By clicking the Add item (3) button you can add a new item at any time.
In the top right corner, you can find a search bar (1). This is a suggestion search, so results are automatically proposed as you enter text.
The following criteria are considered during the search:
You can also directly edit an item that appears in the search results by double-clicking. As before, you are able to view the quantity in stock and whether or not the item is active.
The split view view facilitates the mass processing of products that can be created more quickly in this way.
To activate the split view view, you have an article on the checkbox (1) Select and then active in split view (1) Click.
Multi-edit is a previous Advanced Feature of Shopware’s commercial versions and has since been brought into the standard version of Shopware 5. Multi-edit allows you to edit multiple items in batches and has an editing tool for changing multiple items at once (e.g. deactivate all items without stock).
Multi-edit basically has two main functions: filtering items by configured criteria and changing items in bulk.
The following article describes how multi-edit works and provides you with tips and tricks for working with the module.
Multi-edit is located within the "Item overview" module in your Shopware backend. On the left, you will find the filter and multi-edit window; on the right, a list of your items. This list of items will change at applying new filters.
Under the "Filter" tab, you can filter your items by desired criteria. To do so, just click on "Add" – a popup will appear, where you can easily define your filters using the dropdown fields. Advanced filters are possible with an SQL statement.
The simple filter option is suitable for users who don’t have so much experience with the database structure / SQL statements.
Click on "Add" to create a new filter statement. The first selection means the property that used to filter (i.e. “Article name” for the item name). The second selection is an operator like "=", ">=" or "ISTRUE". The last is your value.
Keep in mind that some operators like "ISTRUE" don't allow separate values because the operator i.e. ISTRUE is the value already!
Article.Name = Test
This will filter all items whose name is "Test".
You can also define multiple statements by clicking "Add" again. These statements will be linked by an "AND", so that all filter statements have to be applied!
Article.Name = Test Article.ID > 5
This filters all items, whose name is "Test" and whose ID is bigger than "5".
A simple filter can always be converted to an advanced filter, but not every advanced filter can be converted to a simple filter because the simple filter doesn’t support "OR" links and bracketing.
Here you can use individual filters to achieve the best result, but you need SQL knowledge to write these filters.
Example: Manufacturer = "Feinbrennerei Sasse" & items under 20 €
To get this result, the following query would is needed:
SUPPLIER.NAME = "Feinbrennerei Sasse" AND PRICE.PRICE < 20
After writing your query you can click "execute" to execute your filter – the item listing will update and show your result.
If you want to reuse your filter, you can always save it and assign a name. Then the filter will appear in the filter list.
The query field has an indicator for the validity. If your statement is invalid, it will stay red; if it's valid, it will turn green. It has also a dynamic message below, notifying you of what’s wrong with your statement.
Operators will be shown dymanically, depending on the given attribute. For example: After the attribute "Article.Name", the operator ">" never can follow, because this is not a string operator.
The following operators can be used to link multiple expressions:
Multi-edit is the main function of this feature and will execute the desired changes to the filtered items. You can define which properties should be changed. In the following example, items will become inactive:
Alternatively, you can also calculate or append strings like this:
// Apends "Example" to the short description of the item Article.description append "Example" // Calculates the item weight + 2 Detail.weight add 2 // Multiplies the topseller by 5 Article.pseudoSales multiply 5
Please note: the revert statements will be saved in the filesystem of your server under /files/backup, so make sure that this folder has read / write permissions for Shopware.
The revert function can revert your changes. Here you can see all changes performed along with their date, affected items and the executed statement.
To revert a change, click "revert changes" (blue rotating arrow) and choose the executed change you want to revert. After flicking on the blue counterclockwise arrow, the change will be reverted.
The revert function is NOT a backup solution. You should always create a backup of your server before making changes in bulk!
Shopware creates a log of all activity performed within this module. You can find this log under Settings > Logfile.
Deactivate all items in category X
First you create a new filter. In the query, use the CATEGORY.ID = "Your category" (you can find the category's ID under Items > Categories in the backend). You then click “execute” to see the filter result.
Now you just have to define the multi-edit for your items. To do this, first click on the “Multi-edit" button, then add your change statement under the column, which will be "Article.active". Your operation must be "set" because we want to deactivate the items. Then execute your changes; you will see the result immediately.
This list of values can also be found in the database. The keyword in front of the dot is important (e.g article.id is located in the table s_articles in the column id.
|article.name||Item - name|
|article.description||Item - short description|
|article.descriptionLong||Item - long description|
|article.added||Date when the item was added|
|article.active||Item's active state|
|article.pseudoSales||Pseudo sales of the item|
|article.highlight||Item - highlight state|
|article.keywords||Item - meta keywords|
|article.changed||Date when the item was changed|
|article.priceGroupActive||Item’s price groups are active|
|article.lastStock||Item's “sold out” flag|
|article.notification||Item - notification state|
|article.template||Item - template|
|article.mode||Item - mode|
|article.availableFrom||Item's “available from date”|
|article.availableTo||Item's “available to date”|
|detail.number||Item - order number|
|detail.supplierNumber||Item - manufacturer number|
|detail.kind||Type of variant (1=preselection, 2=other)|
|detail.additionalText||Additional text (variants text)|
|detail.active||Item - active state|
|detail.inStock||Item - stock|
|detail.stockMin||Item - min. stock|
|detail.weight||Item - weight|
|detail.width||Item - width|
|detail.length||Item - length|
|detail.height||Item - height|
|detail.ean||Item - EAN|
|detail.position||Item - position (when more variants are used)|
|detail.minPurchase||Item - min. purchase|
|detail.purchaseSteps||Item - purchase steps|
|detail.maxPurchase||Item - max. purchase|
|detail.purchaseUnit||Item - purchase unit|
|detail.referenceUnit||Item - reference unit|
|detail.packUnit||Item - pack unit|
|detail.shippingFree||Item - shipping free state|
|detail.releaseDate||Item - release date|
|detail.shippingTime||Item shipping time|
|supplier.name||Supplier - name|
|supplier.image||Supplier - image|
|supplier.link||Supplier - link|
|supplier.description||Supplier - description|
|category.name||Category - name|
|category.position||Category - position|
|category.metaKeywords||Category - meta keywords|
|category.metaDescription||Category - meta description|
|category.cmsHeadline||Category - headline|
|category.cmsText||Category - description|
|category.active||Category - active state|
|category.template||Category - template|
|category.blog||Category - blog category state|
|category.path||Category - path|
|category.external||Category - external state|
|category.hideFilter||Hide category’s filter state|
|category.hideTop||Hide category’s top navigation state|
|category.noViewSelect||Hide category view|
|category.changed||Category - change date|
|category.added||Category - add date|
|unit.name||Unit name (i.e. Lb.)|
|unit.unit||Unit (i.e. pound)|
|attribute.attr||Free text field|
|tax.name||Tax rate name|
|vote.headline||Vote - headline|
|vote.comment||Vote - comment|
|vote.points||Vote - points|
|vote.datum||Vote - date|
|vote.active||Vote - active state|
|vote.email||Vote - email|
|vote.answer||Vote - answer|
|vote.answer_date||Vote - answer date|
|configuratorset.name||ConfiguratorSet - Name|
|configuratorset.public||ConfiguratorSet - public state|
|configuratorset.type||ConfiguratorSet type - (Image, Selection, Default)|
|configuratorgroup.name||ConfiguratorGroup - name|
|configuratorgroup.description||ConfiguratorGroup - description|
|configuratorgroup.position||ConfiguratorGroup - position|
|configuratoroption.name||ConfiguratorOption - name|
|configuratoroption.position||ConfiguratorOption - position|
|propertyset.name||PropertySet - name|
|propertyset.position||PropertySet - position|
|propertyset.comparable||PropertySet - comparable state|
|propertyset.sortMode||PropertySet - sort mode|
|propertygroup.name||PropertyGroup - name|
|propertygroup.filterable||PropertyGroup - filterable state|
|propertyoption.value||PropertyOption - value|
|propertyoption.position||PropertyOption - position|
|propertyoption.valueNumeric||PropertyOption - numeric value|
|image.path||Image - path|
|image.main||Image main - state|
|image.position||Image - position|
|image.width||Image - width|
|image.height||Image - height|
|image.relations||Image - relations|
|image.extension||Image - extension|