Item overview

Version

5.5.0 or newer

Table of contents

Introduction

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.

 

Sorting

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.

 

 

  • Number is the item number as it appears in the item detail interface.
  • Name is the name and/or description of the item.
  • Manufacturer is the name of the manufacturer as it appears in the item detail interface.
  • Active shows whether an item is active and available in the frontend or not.
  • Stock is the remaining quantity of the item.
  • The Info column provides a quick summary of the important information such as whether the item has variants of if an image has been assigned.

 

Actions

 

 

Editing items

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.

 

Deleting items

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.

Adding items

By clicking the Add item (3) button you can add a new item at any time.

 

 

Searching for items

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:

  • Search by manufacturer
  • Search by order number
  • Search by item description
  • Search by items not in stock
  • Search by items with no category assigned
  • Search by items with no image

Edit items directly

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.

Split-View

 

 

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.

 

Further options

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.

 

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.

 

Filter

 

 

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.

 

Simple filter

 

 

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!

Example:


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!

 

Example:


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.

 

Advanced filter

 

 

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

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.

  • a = b (a is equal b)
  • a != b (a is not equal b)
  • a ~ b (a matches the regular expression b)
  • a !~ b (a don't match the regular expression b)
  • a IN (b, c) (a = b OR a = c)
  • a ISNULL (a has no value)
  • a > b (a is bigger than b)
  • a >= b (a is bigger or equal b)
  • a < b (a is less than a)
  • a <= b (a is less than or equal b)
  • a ISTRUE (a is true - bool 1)
  • a ISFALSE (a is false - bool 0)

The following operators can be used to link multiple expressions:

  • AND (links two expressions logically with AND)
  • OR (links two expressions logically with OR)
  • ( respectively ) (allows you to bracket your expressions to execute - the bracketed expressions are executed before the operator between the brackets)

 

Multi-edit

 

 

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
 

 

Revert settings function

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!

 

Log function

Shopware creates a log of all activity performed within this module. You can find this log under Settings > Logfile.

 

Tips & Tricks

Examples

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.

Values

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 = s_article
  • attribute = s_articles_attributes
  • detail = s_articles_details
  • supplier = s_articles_supplier
  • category = s_categories
  • unit = s_core_units
  • tax = s_core_tax
  • vote = s_articles_vote
  • configurationset = s_article_configurator_set
  • configuratorgroup = s_article_configurator_group
  • configuratoroption = s_article_configurator_option
  • propertyset = s_filter
  • propertygroup = s_filter_option
  • propertyoption = s_filter_values
  • price = s_articles_prices
  • image = s_articles_img

 

  • HASIMAGE = Has an image
  • ISMAIN = Main item / variant preselection
  • HASPROPERTIES = Has properties
  • HASCONFIGURATOR = Has configurator
  • HASBLOCKPRICE = Has block prices
field nameDescription
article.nameItem - name
article.descriptionItem - short description
article.descriptionLongItem - long description
article.addedDate when the item was added
article.activeItem's active state
article.pseudoSalesPseudo sales of the item
article.highlightItem - highlight state
article.keywordsItem - meta keywords
article.changedDate when the item was changed
article.priceGroupActiveItem’s price groups are active
article.lastStockItem's “sold out” flag
article.crossBundleLookDeprecated
article.notificationItem - notification state
article.templateItem - template
article.modeItem - mode
article.availableFromItem's “available from date”
article.availableToItem's “available to date”
detail.numberItem - order number
detail.supplierNumberItem - manufacturer number
detail.kindType of variant (1=preselection, 2=other)
detail.additionalTextAdditional text (variants text)
detail.activeItem - active state
detail.inStockItem - stock
detail.stockMinItem - min. stock
detail.weightItem - weight
detail.widthItem - width
detail.lengthItem - length
detail.heightItem - height
detail.eanItem - EAN
detail.positionItem - position (when more variants are used)
detail.minPurchaseItem - min. purchase
detail.purchaseStepsItem - purchase steps
detail.maxPurchaseItem - max. purchase
detail.purchaseUnitItem - purchase unit
detail.referenceUnitItem - reference unit
detail.packUnitItem - pack unit
detail.shippingFreeItem - shipping free state
detail.releaseDateItem - release date
detail.shippingTimeItem shipping time
supplier.nameSupplier - name
supplier.imageSupplier - image
supplier.linkSupplier - link
supplier.descriptionSupplier - description
category.nameCategory - name
category.positionCategory - position
category.metaKeywordsCategory - meta keywords
category.metaDescriptionCategory - meta description
category.cmsHeadlineCategory - headline
category.cmsTextCategory - description
category.activeCategory - active state
category.templateCategory - template
category.blogCategory - blog category state
category.pathCategory - path
category.externalCategory - external state
category.hideFilterHide category’s filter state
category.hideTopHide category’s top navigation state
category.noViewSelectHide category view
category.changedCategory - change date
category.addedCategory - add date
unit.nameUnit name (i.e. Lb.)
unit.unitUnit (i.e. pound)
attribute.attrFree text field
tax.taxTax rate
tax.nameTax rate name
vote.nameVote name
vote.headlineVote - headline
vote.commentVote - comment
vote.pointsVote - points
vote.datumVote - date
vote.activeVote - active state
vote.emailVote - email
vote.answerVote - answer
vote.answer_dateVote - answer date
configuratorset.nameConfiguratorSet - Name
configuratorset.publicConfiguratorSet - public state
configuratorset.typeConfiguratorSet type - (Image, Selection, Default)
configuratorgroup.nameConfiguratorGroup - name
configuratorgroup.descriptionConfiguratorGroup - description
configuratorgroup.positionConfiguratorGroup - position
configuratoroption.nameConfiguratorOption - name
configuratoroption.positionConfiguratorOption - position
propertyset.namePropertySet - name
propertyset.positionPropertySet - position
propertyset.comparablePropertySet - comparable state
propertyset.sortModePropertySet - sort mode
propertygroup.namePropertyGroup - name
propertygroup.filterablePropertyGroup - filterable state
propertyoption.valuePropertyOption - value
propertyoption.positionPropertyOption - position
propertyoption.valueNumericPropertyOption - numeric value
image.descriptionImage description
image.pathImage - path
image.mainImage main - state
image.positionImage - position
image.widthImage - width
image.heightImage - height
image.relationsImage - relations
image.extensionImage - extension
price.pricePrice
price.pseudoPricePseudo price
price.basePriceBase price