Skip to content

enno.dev Commerce Partner

  • Home
  • Shopware 5
  • Shopware 6
  • English
    • Deutsch
    • English

Shopware 5

10
  • Awin Conversion Tracking, Remarketing and Server-to-Server Tracking
  • Empty Cart Button
  • ESD Multi-Download
  • Exclude Search Terms or Redirect Terms to Pages
  • Global Price Changes
  • Preselected Filters
  • Properties AND Operation in the Filters
  • Redeemable Vouchers per Customer Also for Guest Orders
  • Registration Filter Against Spam Registrations
  • Tabs Advanced: Manage All Tabs in One Place

Shopware 6

11
  • Debug for Productive Systems
  • Digital Products and Downloads (ESD)
  • Empty Cart Button
  • Import with Article Numbers: Update Products via Product Number
  • Product Link Instead of Shopping Cart Button
  • Registration Filter Against Spam Registrations
  • Sentinel Admin Security: 2FA, Login Lock, File Type Check
  • Tabs Advanced: Manage All Tabs in One Place
  • Tabs Advanced Extension: Anchor Tabs with Jump Marks
  • Tabs Advanced Extension: Output Entity Custom Fields as Links
  • Tabs Advanced Extension: Product Detail Page Layout Assignment
View Categories
  • Shopware 5
  • Global Price Changes

Global Price Changes

Version 1.0.1 Shopware 5.4 to 5.7 As of May 28, 2024

With this plugin you change prices and pseudo prices of many items at once: by a percentage, by a fixed amount or to a fixed price. You run the change immediately or let it run automatically at a set time. Before each change the plugin creates a backup of the prices.

View in the Shopware Store

Installation and setup #

  1. Install the plugin in the Plugin Manager and activate it.
  2. You find the price changes under Configuration > Preise ändern (change prices).
  3. For automatic changes, the Shopware cron job must be set up. The Shopware documentation describes how to do this.

Creating a price change #

In the list you create, edit, duplicate or delete price changes. The backend module is only available in German. The table shows the German labels in parentheses.

FieldEffect
NameName of the change, only for you.
StatusAutomatic changes only run with the status "Bereit" (ready). After the execution the status is "Ausgeführt" (executed).
Type of change (Änderungsart)You run "Manuell" (manual) yourself. "Automatisch einmalig" (automatic once) runs at the time under "Von" (from).
Deduction type (Abzugsart)"Prozentual" (percentage), "Absolut" (absolute) or "Fester Preis" (fixed price). "Fester Preis" sets all affected items to this price.
Taxes (Steuern)Whether the change is calculated on gross or net prices.
Value for the price (Wert (Preis))Percentage, amount or price. Negative values lower the price.
Value for the pseudo price (Wert (Pseudopreis))The same for the pseudo price. 0 or empty leaves the pseudo price unchanged.
Activate item query, item query (Artikel Query aktivieren, Artikel Query)Limits the change to certain items, see below.

If only the pseudo price should change with "Prozentual" or "Absolut", enter 0 for the price.

After a change, clear the cache so that the new prices appear in the shop. This also applies after a restore.

Selecting items #

Without an item query the change applies to all items. With the field "Artikel Query" you limit it via SQL. This requires knowledge of MySQL. The query may only return one column with IDs from the table s_articles_details. With "Query Testen" (test query) you check whether the query runs. The test does not check whether it returns the right IDs.

Items for which the free text field attr1 is filled in:

SELECT sad.id FROM `s_articles_details` sad LEFT JOIN `s_articles_attributes` saa ON sad.id = saa.articledetailsID WHERE saa.attr1 IS NOT NULL AND saa.attr1 != ""

Items with certain order numbers:

SELECT sad.id FROM `s_articles_details` sad WHERE sad.ordernumber IN ('SW10002', 'SW10004')

Backups #

Under "Backups" you find the backups that the plugin creates before each change. There you restore the old prices or delete backups that you no longer need.

Help #

If this guide does not answer your question, write to us via the contact form on enno.dev.

Contents
  • Installation and setup
  • Creating a price change
  • Selecting items
  • Backups
  • Help

enno.dev Commerce Partner

Shopware plugins
  • Shopware 6
  • Shopware 5
  • All plugins in the Shopware Store
Contact
  • Contact form
  • enno.dev
  • Commerce Partner
Legal
  • Imprint
  • Privacy Policy