In the item overview you get a perfect view of your items and category assignments. By clicking on a category in the overview, all articles that are assigned to this category are displayed.
Important information such as the order number, the item description or the price can be seen right from the table overview. The overview also shows whether articles are active or inactive.
By clicking on the column name (1), the contents of the table can be sorted directly. In this way you can quickly and easily sort your articles, e.g. by order number or price. Below the table is an option bar (2) for the table. Here you can see how many items are already in the selected category. You can scroll directly to the next page or set how many items are to be displayed per page. If you want to display the variants of an item in the overview, you can tick Show variants (3).
Here you will find an explanation of all columns and column contents as well as all symbols.
Please note that the column "Active" affects the entire article. There is an additional column "Variant active". The column "active" is not inherited by "variant active" and it may therefore be necessary to adjust it additionally. To do this, it may be necessary to show the column first.
This also applies to the column "Sales", for variants this is the column "Detail_lastStock".
Click on the edit pencil to open the item detail window. There you can change or make all settings, just like with a new item.
You can also change the values displayed in the overview (except manufacturer and tax) directly by double-clicking. Enter your changes and confirm them with the Enter key.
You can quickly and easily delete many items in the item overview. To delete a single item, simply click on the delete symbol (1). If you then confirm the dialogue, the item will be deleted completely.
To delete several items at once, you will find a checkbox to the left of the order number (5) to quickly select the desired items. Then select the button delete item (2) in the options bar at the top and confirm the dialogue. Here you will also find the option to select all items from the current view at once (4).
Article images, associated thumbnails and other media (e.g. deposited downloads) are not removed from the server when an article is deleted.
By clicking the Add item (3) button you can add a new item at any time.
At the top right of the overview you will find the Search field (1). This is a suggestion search. Search hits are automatically suggested when you enter them.
The following criteria are considered during the search:
In the search hit overview, you can also edit your items directly by double-clicking on them. As in the normal overview, you can see how high the stock level is and whether an item is active or inactive. For example, you can only find inactive items in the administration and not in the storefront.
The split view facilitates the mass processing of products, which can be created more quickly.
To activate the split view, you must select an item using the checkbox (1) and then click on Activate split view (1).
Multi-edit" is a former advanced feature of the commercial Shopware versions, which has been included in the Shopware standard since Shopware 5. Multi-edit supports you in quickly changing items in a batch process, e.g. quickly deactivating items that no longer have stock. In general, Multi-edit offers 2 main functions, the simple filtering of articles according to certain criteria and the multiple modification of these articles. In the following article, we explain how multiple changes work and give you helpful tips and tricks on how to use them.
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 is suitable for anyone who has not yet / does not want to deal with the database structure, SQL queries and logical links and wants to test/use the general function of the plugin.
Click on "Add" and create a new filter. The first selection you make here refers to a property, for example "Article.Name" for the article name. The middle selection specifies an operation such as "=", "<=" or "ISTRUE". In the third field you define the condition. Please note that for some operators, such as "ISTRUE", no condition can be set because ISTRUE (is true) is already the condition!
Article.Name = Test
This would create a filter that shows you all articles with the name "Test".
You can also add more conditions by clicking on "Add" again. These conditions are each created with an AND link, so ALL conditions must be met in order for the articles to be listed.
Article.Name = Test Article.ID > 5
This filter gives you the items whose name is "Test" and whose ID is greater than "5".
A simple filter can be converted to an advanced filter at any time, but not all advanced filters can be converted to a simple one. The simple filter does not support parenthesis of commands and OR-operation
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:
Please note that it may be necessary to edit "Detail.active" in addition to "Article.active". This also applies to setting the clearance function, which must also be set for "Detail.lastStock".
Alternatively, calculation tasks can be defined here or strings can be extended:
// 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 restore function uses a folder in the server's file system to store the restore statements, these are stored under /files/backup, so make sure that this folder has read and write permissions for Shopware.
The restore function is used to restore the ORIGINAL state that existed before the change was made.
In the restore mode you can see the filters that were applied. You can also see which original changes were made.
By pressing the restore icon (blue rotating arrow), the change is restored to the ORIGINAL value.
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.
As with the categories, for example, the associations are used here. So if you add "Hello" to the unit.name of 10 articles, the unit.name itself will of course be changed and thus also apply to the other articles with the corresponding unit.
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|