Since carriers like DHL and UPS charge a significant surcharge for bulky goods, it's often desirable to only enable bulky goods shipping methods for orders containing certain items. To do this, you need to add a new attribute to the item, adjust the configuration of the shipping costs module, and edit all configured shipping methods. Proceed as follows:
Go to Settings → Freitext-Verwaltung (Custom Field Management).
Click Hinzufügen (Add) to create a new free-text field, then enter the following values in the right-hand area:
Spaltenname (Column Name) – attr_bulky_goods
Spaltentyp (Column Type) – Checkbox
Label (any) – Sperrgut (Bulky Goods)
Support Text (optional) – (any) Enable this field to mark the item as bulky goods.
Hilfe Text (Help Text) (optional) – (any) Enable this field to mark the item as bulky goods
Position (optional) – (any)
Im Backend anzeigen (Display in Backend) – (check this box)
Übersetzbar (Translatable) – (any)
Click Speichern (Save). Now navigate to Settings → Grundeinstellungen (Basic Settings) → Storefront → Versandkosten-Modul (Shipping Costs Module).
Add the following text to the field Erweiterte SQL-Abfrage (Advanced SQL Query):
, MAX(at.attr_bulky_goods="1") AS has_bulky_goods
Important: Do not delete any values that may already be present, otherwise the functionality of the shipping costs module will no longer be guaranteed. Also make sure to include the leading comma!
Click Speichern (Save) and close the Grundeinstellungen (Basic Settings) window. Go to Settings → Versandkosten (Shipping Costs).
Open the shipping method to which a bulky goods product is assigned, or create it first.
In the shipping method's details, select the Erweiterte Einstellungen (Advanced Settings) tab.
Enter the following value into the Eigene Bedingung (Custom Condition) field:
If the field is otherwise empty: has_bulky_goods
If another expression is already contained in the field: && has_bulky_goods
Click Speichern (Save) and close the detail view of the bulky goods shipping method
Open the shipping method to which no bulky goods product is assigned, or create it first.
Enter the following value into the Eigene Bedingung (Custom Condition) field:
If the field is otherwise empty: !has_bulky_goods
If another expression is already contained in the field: && !has_bulky_goods
Now carry out this step for all other shipping methods for which bulky goods items are not allowed.
The shipping methods are now configured. Finally, for every item or item variant that should be treated as bulky goods, you need to enable the new Sperrgut (Bulky Goods) attribute field in its details.