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.
Installation and setup #
- Install the plugin in the Plugin Manager and activate it.
- You find the price changes under Configuration > Preise ändern (change prices).
- 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.
| Field | Effect |
|---|---|
| Name | Name of the change, only for you. |
| Status | Automatic 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.
