Set Up Table Rates for Bulkgoods

Bulkgood extends Magento's existing Table Rates import and export. The file keeps Magento's normal destination and condition columns and adds an exact Bulkgood header.

Work at website scope

1. Open Stores > Configuration > Sales > Shipping Methods.
2. Switch to the website whose rates you want to edit.
3. Expand Table Rates and select the intended condition.
4. Export the existing CSV.
5. Edit the exported file, preserving its Magento-generated headers.
6. Set Bulkgood to 0 for ordinary-cart rows and 1 for bulk-cart rows.
7. Import the complete file at the same website scope.

Using Magento's export as the template avoids header differences between Table Rates conditions and Magento releases.

The Bulkgood column

The header must be exactly:

Bulkgood

Use these values:

• 0 for carts without a product marked Bulkgood;
• 1 for carts containing at least one product marked Bulkgood.

The importer rejects nonnumeric and negative values. Although its parser accepts other nonnegative numbers, the stored field is a flag, so 0 and 1 are the supported operational values.

Keep ordinary and bulk rows

If a destination accepts both cart types, provide both variants for the same Magento condition bands. The Bulkgood value is part of the row's identity, so an ordinary and a bulk row can share the same destination and threshold.

Illustrative shape only, with the exact condition header taken from your export:

Country,Region/State,Zip/Postal Code,Weight (and above),Shipping Price,Bulkgood
DE,*,*,0.0000,9.90,0
DE,*,*,0.0000,59.00,1
DE,*,*,100.0000,89.00,1

Product prices still need a matching row

Even if country-specific or general product prices are placed first, Magento must find a Bulkgood = 1 row for the destination and condition. Without it, the carrier returns its configured not-available result instead of a product-derived price.

You can use a broad bulk row as the availability baseline when product prices carry the amount. Its Table Rates price matters only if Table Rate is selected before the product source or used as fallback.

Import checks

After import:

1. Export again and confirm the rows and Bulkgood values.
2. Clear the configuration cache.
3. Test an ordinary-only cart and a bulk cart at the same address.
4. Test each threshold boundary.
5. Test a destination that should not receive the method.

See CSV import troubleshooting if Magento rejects the file.