Shipping, Tax and Insurance
 
Setup Bulk Shipping

How to create a Bulk Shipping File for Shipping


The Bulk Shipping File allows you to easily manage your Shipping Options. This is especially useful if you utilize numerous Shipping Options, affecting many countries. The “Bulk Shipping Import” feature can be found on the main Shipping page.
You will need to create a Comma Separated Value file, or CSV file from which the information will be read.

The CSV File - Layout

The CSV file is split into two sections. The first section depicts information about the Shipping Method, while the second section contains all the information about the Shipping Options which need to be added.

The Header requires the following information:

  • Your Merchant Identifier Code (Example: FF555LJI333)
  • Shipping Method Name: The way the shipping gets calculated on your buyer's purchase. This field does not require the name, instead it requires a code to represent the selected Method:
    1. Flat Rate per Basket
    2. Flat Rate per Item
    3. Matrix by Cost
    4. Matrix by Quantity
    5. Matrix by Volume
    6. Matrix by Weight
    7. Volumetric Shipping
  • Shipping Type Name: The name of your Shipping Type (example: Door to Door)
  • Currency: Specifies the currency for which this Shipping Method is required
    • ZAR – South-African Rand
    • USD – United States Dollar
    • EUR – Euro
    • GBP – Great Britain Pounds
  • Handling Surcharge: This is no longer being utilized and should be set to 0. If you wish to charge buyers a handling surcharge you may set it up in the Handling Section.
  • Active : Specifies if you want this Shipping Method to be active or not (1 for active, 0 for inactive)

An example of the Header in CSV format is as follows:

MerchantIdentifier, Shipping Method Name, Shipping Type Name, Currency, Handling Surcharge, Active, FF555LJI333, 1, My Flat Rate per Basket Shipping, GBP, 0, 1

In the above example the Merchant (with identifier FF555LJI333) has selected to use Flat Rate per Basket (1) and has named the Shipping Method (My Flat Rate per Basket Shipping) for use with British Pounds (GBP). A zero (0) is entered as the Handling Surcharge is no longer used, and the one (1) entered indicates that the Merchant wants this Shipping Method to be active and immediately available.

The shipping records require the following information for each Shipping Option you wish to import:

Depending on the method being used, your records might differ slightly.

For Flat Rate per Basket (1) and Flat Rate per Item (2):
Field Name Required Description
Country Code Yes The two-digit country code for the country the rate should be mapped to, e.g. United States of America’s country code is “US” and South Africa’s country code is “ZA”.
State Yes The State which the Shipping Option is for.
City Yes The City which the Shipping Option is for.
Zip Code Yes The Zip code which the Shipping Option is for.
Fee Yes The cost of shipping. Please include the cent value in decimal format, e.g. if the product is R10 the price field would be 10.00. No other formatting is required for instance R1, 000.00 for the price would be in the price field 1000.00


Example:

US,Texas,Dallas,5555,15.00

For Matrix by Cost (3), Matrix by Quantity (4), Matrix by Volume (5) and Matrix by Weight (6):
Field Name Required Description
Country Code Yes The two-digit country code for the country the rate should be mapped to, e.g. United States of America’s country code is “US” and South Africa’s country code is “ZA”.
State Yes The State which the Shipping Option is for.
City Yes The City which the Shipping Option is for.
Zip Code Yes The Zip code which the Shipping Option is for.
Base Range Yes This is the Base Unit, which indicates the minimum required Unit to be achieved before this Shipping Option will be taken into account.
Fee Yes The cost of shipping. Please include the cent value in decimal format, e.g. if the product is R10 the price field would be 10.00. No other formatting is required for instance R1, 000.00 for the price would be in the price field 1000.00
Infinity Yes To apply infinity to this Shipping Option, set this value to “1” otherwise set it to “0”

Example:
  • ZA,Gauteng,Pretoria,0000,5,15.00,0 ZA,Gauteng,Pretoria,0000,10,20.00,1

  • For Volumetric Shipping (7)
    Field Name Required Description
    Country Code Yes The two-digit country code for the country the rate should be mapped to, e.g. United States of America’s country code is “US” and South Africa’s country code is “ZA”.
    State Yes The State which the Shipping Option is for.
    City Yes The City which the Shipping Option is for.
    Zip Code Yes The Zip code which the Shipping Option is for.
    Base Range Yes This is the Base Unit, which indicates the minimum required Unit to be achieved before this Shipping Option will be taken into account.
    Commodity Rate Yes This defines the Commodity rate for calculating the volumetric weight. Volumetric weight is calculated using the following formula: (Length x Width x Height) / Commodity Rate = Volumetric Weight.
    Fee Yes The cost of shipping. Please include the cent value in decimal format, e.g. if the product is R10 the price field would be 10.00. No other formatting is required for instance R1, 000.00 for the price would be in the price field 1000.00
    Infinity Yes To apply infinity to this Shipping Option, set this value to “1” otherwise set it to “0”

    Example:
    SA,Limpopo,Vryburg,1234,0,100,60.00,0
    SA,Limpopo,Vryburg,1234,1000,100,120.00,0
    SA,Limpopo,Vryburg,1234,3000,100,300.00,1


    An Example of a Complete CSV:

    MerchantIdentifier, Shipping Method Name, Shipping Type Name, Currency, Handling Surcharge, Active, FF555LJI333, 1, My Flat Rate per Basket Shipping, GBP, 0, 1, ZA,Gauteng,Pretoria,0000,5,15.00,0,ZA,Gauteng,Pretoria,0000,10,20.00,1

    Related Topics:

      Shipping Guide

      Insurance Guide

      Tax Guide

      Setup Bulk Insurance

      Setup Bulk Tax