The shipping rate template is a spreadsheet where you enter shipping cost options that will be offered to your customers. It contains information such as ZIP code ranges, shipment weight limits, and the service fee charged by the company in charge of deliveries.
Please fill in the template according to the shipping service contract agreed between your store and the carrier/courier.
To add shipping costs to the template, you have to:
You can also add shipping costs in the Shipping rates module. We recommend using the shipping rate template to include multiple ZIP code ranges and using the Shipping rates module to manage existing shipping costs and add ZIP code ranges individually.
Fill in the fields in the spreadsheet
To fill in the fields in the spreadsheet, consult the terms agreed with the company responsible for shipping your products. Make sure the information you enter follows these terms.
To download the template, go to Shipping > Shipping strategy > Shipping policies > Create shipping policy. In the Upload shipping rates section, click on Download spreadsheet model.
Fill in the columns considering that for each location there are:
- An associated ZIP code (or geolocation) range
- Accepted weight ranges
- Fixed and additional shipping costs
- Maximum shipment volume
See below the spreadsheet columns content to understand each field in detail.
<p>You must fill in the fields according to the following rules: <body> <ul> <li>For numerical ranges, the accepted values are from <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">0000000</span> to <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">99999999</span>. </li> <li>For alphabetical ranges, the accepted values are from <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">AAAAAAAA</span> to <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">ZZZZZZZZZ</span>. <li>For alphanumerical ranges, the maximum value is <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">ZZZZZZZZ</span>.</li> </ul> </body> </td> </tr> <tr class="bb b--muted-3"> <td class="t-body pa5"> <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">ZipCodeEnd</span> </td> <td class="t-body pa5">The second and last part of the ZIP code range. </td> </tr> <tr class="bb b--muted-3"> <td class="t-body pa5"> <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">PolygonName</span> </td> <td class="t-body pa5">The polygon identification defined in the <a href="https://help.vtex.com/en/tutorial/gerenciar-geolocalizacao/"> geolocation</a> function. </td> <td class="t-body pa5">To use geolocation, after filling in the <b>PolygonName</b> column with the desired values, fill in the <b>ZipCodeStart</b> and <b>ZipCodeEnd</b> columns with the value `0`.<p>You should fill in this field only if the <b>ZipCodeStart</b> and <b>ZipCodeEnd</b> fields are used, as they contain equivalent function data. </td> </tr><tr class="bb b--muted-3"> <td class="t-body pa5"> <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">WeightStart</span> </td> <td class="t-body pa5">The minimum weight allowed, in decimal number. </td> <td rowspan="2" class="t-body pa5">Consider the same weight unit informed when adding a SKU. For example, if you <a href="https://help.vtex.com/en/tutorial/campos-de-cadastro-de-sku--21DDItuEQc6mseiW8EakcY"> added SKUs</a> using grams, this will be the default unit for <b>WeightStart</b> and <b>WeightEnd</b>. </td> </tr> <tr class="bb b--muted-3"> <td class="t-body pa5"> <span class="t-body c-on-base pa2 mw6 br2 bg-muted-4">WeightEnd</span> </td> <td class="t-body pa5">The maximum weight allowed, in decimal number. </td> </tr>
We used the term "weight" when referring to "mass" in this documentation for readability.
Here is an example of how to fill in the fields in the spreadsheet.
Upload the spreadsheet in VTEX Admin
Once you have completed the spreadsheet, save it as .xls or .zip file format and upload it via VTEX Admin.
Follow the steps below:
- In the VTEX Admin, go to Shipping > Shipping Strategy > Shipping Policies, or type Shipping Strategy in the search bar at the top of the page.
- If you want to use a new shipping policy, click on the
Create shipping policybutton. If you want to edit an existing shipping policy, click on the pencil icon next to it. - In both cases, download the spreadsheet and complete its fields. Then, upload the file in the Upload shipping rates section, as illustrated in the image below.
- After completing these steps, click on
Save changes.
For new shipping policies, other steps are required. Check out the article Shipping policy for more information.
Each tab in the spreadsheet supports a maximum of 65,536 rows. You can create as many tabs as you want on the same worksheet, provided that it does not exceed the limit of rows and the maximum file size of 10MB. You can compress the file by saving it as .zip, if necessary. If the file is still too large to upload, you can split it into two files and create another shipping policy to upload the second file.
In the event that the spreadsheet contains an error, you will receive an email with details about the error. Make sure you have reviewed all the fields before uploading the file again.
Uploading the file and receiving confirmation may take a while because file processing may not occur immediately depending on the volume of data.