Aerodrome Documentation

Article content

The shipping exception import allows you to import a list of shipping exceptions in bulk. The rules are exactly the same as defined in Working with Shipping Exceptions. Please see that article for more information.

You can download an example csv here: Example Shipping Exceptions CSV

Column Definitions

Col No Name Value
1 SKU An identifier from your catalog which represents the product.
2 Fulfillment Node Shipping exceptions are configured on a per-fulfillment node basis, meaning the product can have separate shipping rules set for each configured fulfillment node.
3 Service Level The service level to override. If you have configured shipping by level in the Jet partner portal, then you would set the level here instead of using Method.
Valid Values:
  • Second Day
  • Next Day
  • Priority
  • Expedited
  • Standard
  • Scheduled (freight)
  • 5 to 10 Day
  • 11 to 20 Day
  • Scheduled (freight 11 to 20 day)
4 Shipping Method A general shipping method to override.
Valid Values:
  • DHL Global Mail
  • FedEx 2 Day
  • FedEx Express Saver
  • FedEx First Overnight
  • FedEx Ground
  • FedEx Home Delivery
  • FedEx Priority Overnight
  • FedEx Smart Post
  • FedEx Standard Overnight
  • Freight
  • Ontrac Ground
  • UPS 2nd Day Air AM
  • UPS 2nd Day Air
  • UPS 3 Day Select
  • UPS Ground
  • UPS Mail Innovations
  • UPS Next Day Air Saver
  • UPS Next Day Air
  • UPS SurePost
  • USPS First Class Mail
  • USPS Media Mail
  • USPS Priority Mail Express
  • USPS Priority Mail
  • USPS Standard Post
5 Override Type Modifies the behavior of "Charge"
Valid Values:
  • Override charge
  • Additional charge

If shipping_exception_type is "restricted", override type and shipping charge amount should not be provided.
If the override type is "Additional charge" the shipping method or service level provided must exist on the fulfillment node as defined within your Jet Partner Portal.

6 Shipping Charge Amount A number that is greater than zero. Do not include a dollar sign. — Based on override type, this is either an amount that overrides the shipping amount, or an additional fee to add on to the calculated shipping amount
7 Shipping Exception Type The shipping exception type
Valid Values:
  • Exclusive
  • Restricted