Importing/exporting delivery rates in bulk
You can use the delivery rate import system to create delivery rates in bulk. Delivery rates can also be edited in bulk by taking an export, editing the file, and uploading it back into the import system.
You do not need to create applicable delivery zones before importing delivery rates. Any delivery zones not already configured in your ShopWired account will be automatically configured as a result of the import.
Creating new delivery rates
Creating new delivery rates
To create new delivery rates:
- Navigate to Checkout > Delivery & collection, and select
managefor the delivery rates section - Select
import - Select
download the import template - Use spreadsheet editing software to populate the template with the delivery rates you want to create (detailed below)
- Save the file as a
- Select
importfrom the delivery rates page - Select the CSV file from your device's hard drive
- Select
import
Editing delivery rates in bulk
Editing delivery rates in bulk
To edit delivery rates:
- Navigate to Checkout > Delivery & collection, and select
managefor the delivery rates section - Select
export - Select
prepare your exportand wait whilst your export is generated - Use spreadsheet editing software to edit the details of each delivery rate. Do not change the value in the
IDcolumn - Save the file as a
- Select
importfrom the delivery rates page - Select the CSV file from your device's hard drive
- Select
import
Delivery rate import column definitions
Delivery rate import column definitions
| Column Name | Description | Example Values |
|---|---|---|
| ID | Leave this field empty when creating a new delivery rate. If updating an existing delivery rate, provide its unique ID (obtained by exporting current delivery rates) | 123456 |
| Zone | Enter the name of the delivery zone the rate applies to (ensure the name matches exactly as it appears in your ShopWired account) | United Kingdom |
| Name | The display name of the delivery rate | Next Day Delivery |
| Postcodes | If using the UK postcode shipping feature, enter applicable postcodes (separate multiple postcodes with a comma) | B, W1, BT33 |
| States | If applicable, enter the US states for this delivery rate (ensure exact spelling, separate multiple states with a comma) | California, Texas |
| Criteria | Enter By Price or By Weight to define the delivery rate's criteria |
By Weight |
| From | The starting value of the price/weight range, 0 can be used |
0 |
| To | The ending value of the price/weight range, enter 0 for unlimited |
10 |
| Cost | The cost of the delivery rate, this should be entered in accordance with your ShopWired account's | 4.99 |
| Maximum | For price-based rates, enter the maximum weight. For weight-based rates, enter the maximum price | 20 |
| Package Weight | For weight-based rates, include the weight of the package to determine if the rate applies | 2 |
| Zero Rated | Enter Yes if the delivery rate is zero-rated/exempt from VAT. Leave blank if not |
Yes |
| Enabled | Enter Yes if the delivery rate is , No if it is |
Yes |
| Included/Excluded | If using the Delivery Rate Exceptions app, enter Included for qualifying products or Excluded for excluded products |
Included |
| Product IDs | Enter the product IDs that qualify for or are excluded from the rate. Obtain product IDs by exporting your products | 123456, 123457 |
