Table Rate Rules & CSV Import

The Webkul Table Rate Shipping management screen allows administrators to review existing rules, perform mass deletions, edit individual rate rows, and bulk upload thousands of rates using CSV.

Navigating to Shipping Rules Grid

From the Magento Admin Panel, navigate to MAGE TABLE RATE → Manage Table Rate Shipping.

Grid Capabilities

• Filter & Search: Filter rules by Entity ID, Destination Country, Region, Method Name, Price, Status, Customer Group, and Store View.
• Sorting: Sort columns by clicking on any column header.
• Mass Actions: Select checkboxes next to one or more rules, choose an action from the Actions dropdown, and confirm.
• Edit Action: Click the Edit link in the Action column of any row to modify its parameters.

Bulk Importing Shipping Rules via CSV

To add or update shipping rules in bulk, use the CSV upload feature:

1. On the top right of the shipping manager grid, click Add Shipping.
2. On the Add Shipping Rates screen, locate the CSV File import section:

3. Click Download Sample File to obtain the official CSV template (adminShippingInfo.csv).

4. Open the CSV file in your spreadsheet editor (e.g. LibreOffice Calc, Excel, or Google Sheets).
5. Fill in your rate matrix following the column specification below.
6. Save the file in UTF-8 CSV format.
7. Under Import Shipping, click Choose File, select your completed CSV file, and click Upload Shipping (or Save Shipping).
8. The grid updates with a status notification confirming your rules have been processed.

CSV Column Specification

Each row in the CSV represents a distinct shipping rule:

Sample CSV Content

country_code,region_id,zip,zip_to,price,weight_from,weight_to,price_from,price_to,shipping_method,numeric_zipcode,alphanumeric_zipcode,quantity_from,quantity_to,status,customer_group,store_view
"US","*","90001","90100","10","1","100","1","999999","Standard Shipping",yes,"*","1","10","1","*","*"
"GB","*","*","*","25","0","50","1","500","Royal Mail Express",no,"SW1A","1","50","1","General","default"
"CA","Ontario","K1A","K1A","18","0","20","50","2000","Canada Priority",no,"K1A 0B1","1","20","1","*","*"

Editing Individual Shipping Rules

To modify a specific rule without re-uploading the entire CSV:

1. On the Webkul Table Rate Shipping Manager grid, click the Edit link in the Action column next to the target rule.
2. The edit screen presents all rule configuration options organized into sections:

1. Destination & Method Information

Configure destination geographic boundaries, method label, and flat shipping price:

• Country: Select destination country (e.g. United States).
• Region/State: Select specific state/province or * for all regions.
• Zip Code From & Zip Code To: Define postal code range boundaries (e.g. 90001 to 90100).
• Shipping Method: Enter customer-facing method label (e.g. Standard Shipping).
• Price: Shipping fee charged when rule conditions are satisfied.

2. Weight, Price & Quantity Boundaries

Define cart threshold requirements:

• Weight From & Weight To: Set package weight thresholds.
• Price From & Price To: Set cart order subtotal thresholds.
• Numeric Zipcode: Choose Yes for numeric ranges, No for alphanumeric postal codes.
• Quantity From & Quantity To: Minimum and maximum item count thresholds.

3. Customer Groups & Store Scoping

Target customer groups, store views, and toggle rule availability:

• Status: Toggle rule between Enabled and Disabled.
• Customer Group: Select one or multiple customer groups (e.g. ALL GROUPS, NOT LOGGED IN, General, Wholesale, Retailer).
• Store View: Select applicable store views or All Store Views.

3. Click Save Shipping in the top right corner to persist the changes.