Tutorials & Solutions

Building the shipping spreadsheet

VTEX Team
VTEX Team
Last updated
12/31/2019

The shipping spreadsheet is used to register the zip code coverage area, the values to be charged, which weight limits will be considered and occasional additional values due to each carrier. The process is quite simple, and better detailed below.

shipping-spreadsheet-en

How to build the spreadsheet

After closing contracts with the carriers responsible for the deliveries, they normally inform you the zip code and weight ranges included on the contract, which are related to the prices and additional shipping. With this information already set, now it's just a matter of filling out each field of the spreadsheet.

  • ZipCodeStart: Start of the zip code coverage area interval.
  • ZipCodeEnd: End of the zip code coverage area interval.
  • PolygonName: Identification of the polygon defined on the geolocation function.
  • WeightStart:** Start of the weight range (grams) for the corresponding ZIP code range.
  • WeightEnd: End of the weight range (grams) for the corresponding ZIP code range.
  • AbsoluteMoneyCost: Absolute shipping price to be charged, which means at least this amount will always be charged.
  • PricePercent: Additional value of shipping, according to the price of the cart. Understand how additional shipping is configured
  • PriceByExtraWeight: Additional value of shipping, according to the weight (grams) of the cart. Understand how additional shipping is configured
  • MaxVolume: Maximum dimensional weight (centimeters) to be transported by the carrier.
  • TimeCost: Delivery time of the order by the carrier, in HH:MM:SS format.
  • Country: Country where the delivery will take place. Must be filled out with the 3-digit ISO code of the country.
  • MinimumValueInsurance: It's an additional shipping with absolute value, which will be compared to the value registered in the PricePercent field times the cart value. The hightest of the two values will be added to the shipping. Only one of the values must be added. See more in What is the Minimum Value Insurance field?
Note:Pay attention to the file size. If it is bigger than 10MB, you will need to compress it with a .zip extension. This Zip file must also have 10MB tops for the upload to be successful. If somehow it still exceeds that limit, we recommend you to split it between more carriers.
Still got questions?
Ask the community
Find solutions and share ideas in VTEX's community.
Talk to our experts
Get in touch if you have something specific to ask about the platform.
  • PT
  • ES
VTEX website