Importing Orders To Huboo Manually Via CSV File
The Huboo dashboard supports CSV order imports.
Importing your orders to Huboo via CSV is simple; just follow the steps below:
Download our template CSV order file (Click the link, go to ‘File’, click ‘Download’ and select ‘CSV’ format
Populate the fields with the relevant customer and order data for your orders. PLEASE NOTE - you cannot import bundle orders to Huboo via CSV - you should import them as individual rows per each SKU in the bundle. Contact your Client Success Manager if you need help with this.
Column Header | Values Required |
Order # | Enter an order number here.
When entering your Order # please note:
|
Shipping Name | Your customer’s name / the addressee for the order
This should NOT exceed 30 characters
|
Address Line 1 | First line of your customer’s address, including House/Building Number / Name
This should NOT exceed 30 characters
|
Address Line 2 | (Optional) Second line of address
This should NOT exceed 30 characters
|
Address Line 3 | (Optional) Third line of address
This should NOT exceed 30 characters
|
Address Line 4 | (Optional) Fourth line of address
This should NOT exceed 30 characters
|
Country | Delivery country -
This should NOT exceed 30 characters
You must refer to the country names taxonomy table below and enter the name exactly as it appears in the table |
Post Code | Postcode for recipient. Do not use ‘special characters’ in this field. |
SKU | Your channel SKU as linked within Huboo. This must match the SKU perfectly. Any rows with errors will not be imported. |
Shipping Service | The level or type of shipping service required for the order.
Please refer to the table in point 3 below for full taxonomy. |
Quantity | The quantity of this SKU to be sent |
Email Address | The delivery recipient email address |
Sale Price | (Optional) The retail value of the sale (to allow you to track sales values from the dashboard. This should be in GBP and a numeric value only (no £ sign etc) |
Country names taxonomy list |
Afghanistan |
Albania |
Algeria |
American Samoa |
Andorra |
Angola |
Anguilla |
Antigua and Barbuda |
Argentina |
Armenia |
Aruba |
Australia |
Austria |
Azerbaijan |
Bahamas |
Bahrain |
Bangladesh |
Barbados |
Belarus |
Belgium |
Belize |
Benin |
Bermuda |
Bhutan |
Bolivia |
Bonaire, Sint Eustatius and Saba |
Bosnia and Herzegovina |
Botswana |
Bouvet Island |
Brazil |
British Indian Ocean Territory |
British Virgin Islands |
Brunei Darussalam |
Bulgaria |
Burkina Faso |
Burundi |
Cambodia |
Cameroon |
Canada |
Cape Verde |
Cayman Islands |
Central African Republic |
Chad |
Chile |
China |
Christmas Island |
Cocos [Keeling] Islands |
Colombia |
Comoros |
Cook Islands |
Costa Rica |
Croatia |
Cuba |
Curaçao |
Cyprus |
Czech Republic |
Democratic Republic of the Congo |
Denmark |
Deutschland |
Deutschlands |
Djibouti |
Dominica |
Dominican Republic |
East Timor |
Ecuador |
Egypt |
El Salvador |
Equatorial Guinea |
Eritrea |
Estonia |
Ethiopia |
Falkland Islands |
Faroe Islands |
Fiji |
Finland |
France |
French Guiana |
French Polynesia |
French Southern Territories |
Gabon |
Gambia |
Georgia |
Germany |
Ghana |
Gibraltar |
Greece |
Greenland |
Grenada |
Guadeloupe |
Guam |
Guatemala |
Guernsey |
Guinea |
Guinea-Bissau |
Guyana |
Haiti |
Heard Island and McDonald Islands |
Honduras |
Hong Kong |
Hungary |
Iceland |
India |
Indonesia |
Iran |
Iraq |
Ireland |
Isle of Man |
Israel |
Italy |
Ivory Coast |
Jamaica |
Japan |
Jersey |
Jordan |
Kazakhstan |
Kenya |
Kiribati |
Kosovo |
Kuwait |
Kyrgyzstan |
Laos |
Latvia |
Lebanon |
Lesotho |
Liberia |
Libya |
Liechtenstein |
Lithuania |
Luxembourg |
Macao |
Macedonia |
Madagascar |
Malawi |
Malaysia |
Maldives |
Mali |
Malta |
Marshall Islands |
Martinique |
Mauritania |
Mauritius |
Mayotte |
Mexico |
Micronesia |
Moldova |
Monaco |
Mongolia |
Montenegro |
Montserrat |
Morocco |
Mozambique |
Myanmar [Burma] |
Namibia |
Nauru |
Nepal |
Netherlands |
New Caledonia |
New Zealand |
Nicaragua |
Niger |
Nigeria |
Niue |
Norfolk Island |
North Korea |
Northern Mariana Islands |
Norway |
Oman |
Pakistan |
Palau |
Palestine |
Panama |
Papua New Guinea |
Paraguay |
Peru |
Philippines |
Pitcairn Islands |
Poland |
Portugal |
Puerto Rico |
Qatar |
Republic of Ireland |
Republic of the Congo |
Réunion |
Romania |
Russia |
Russian Federation |
Rwanda |
Saint Barthélemy |
Saint Helena |
Saint Kitts and Nevis |
Saint Lucia |
Saint Martin |
Saint Pierre and Miquelon |
Saint Vincent and the Grenadines |
Samoa |
San Marino |
São Tomé and Príncipe |
Saudi Arabia |
Senegal |
Serbia |
Seychelles |
Sierra Leone |
Singapore |
Sint Maarten |
Slovakia |
Slovenia |
Solomon Islands |
Somalia |
South Africa |
South Georgia and the South Sandwich Islands |
South Korea |
South Sudan |
Spain |
Sri Lanka |
Sudan |
Suriname |
Svalbard and Jan Mayen |
Swaziland |
Sweden |
Switzerland |
Syria |
Taiwan |
Tajikistan |
Tanzania |
Thailand |
Togo |
Tokelau |
Tonga |
Trinidad and Tobago |
Tunisia |
Turkey |
Turkmenistan |
Turks and Caicos Islands |
Tuvalu |
U.S. Minor Outlying Islands |
U.S. Virgin Islands |
Uganda |
UK |
Ukraine |
United Arab Emirates |
United Kingdom |
United States |
Uruguay |
Uzbekistan |
Vanuatu |
Vatican City |
Venezuela |
Vietnam |
Wallis and Futuna |
Western Sahara |
Yemen |
Zambia |
Zimbabwe |
STATE SELECTION : Canada, USA & Australia State Validation:
For Canada, Address Line 4 MUST match one of this list:
Ontario |
Quebec |
Nova Scotia |
New Brunswick |
Manitoba |
British Columbia |
Prince Edward Island |
Saskatchewan |
Alberta |
Newfoundland and Labrador |
For Australia, Address Line 4 MUST match one of this list:
New South Wales |
Victoria |
Queensland |
Western Australia |
South Australia |
Tasmania |
For United States, Address Line 4 MUST match one of this list:
Alabama |
Alaska |
Arizona |
Arkansas |
California |
Colorado |
Connecticut |
Delaware |
District Of Columbia |
Florida |
Georgia |
Hawaii |
Idaho |
Illinois |
Indiana |
Iowa |
Kansas |
Kentucky |
Louisiana |
Maine |
Maryland |
Massachusetts |
Michigan |
Minnesota |
Mississippi |
Missouri |
Montana |
Nebraska |
Nevada |
New Hampshire |
New Jersey |
New Mexico |
New York |
North Carolina |
North Dakota |
Ohio |
Oklahoma |
Oregon |
Pennsylvania |
Rhode Island |
South Carolina |
South Dakota |
Tennessee |
Texas |
Utah |
Vermont |
Virginia |
Washington |
West Virginia |
Wisconsin |
Wyoming |
Shipping Service Selection
Please see below a list of shipping service codes you should use to select the correct service from Huboo. These must be entered into the CSV file exactly as shown below (case and space sensitive)
Shipping Service Code | Huboo Shipping Service |
HUBOO_24 | Huboo 24 Hour Service (e.g. Royal Mail First Class) |
HUBOO_24_SG | Huboo 24 Hour Service With Signature |
HUBOO_48 | Huboo 48 Hour Service (e.g. Royal Mail Second Class) |
HUBOO_48_SG | Huboo 48 Hour Service With Signature |
HUBOO_24_TR | Huboo Fully Tracked 24 Hour Service (e.g. DPD or Royal Mail 24 Fully Tracked) |
HUBOO_48_TR | Huboo Fully Tracked 48 Hour Service (e.g. DPD or Royal Mail 48 Fully Tracked) |
HUBOO_48_TR_SG | Huboo Fully Tracked 48 Hour Service With Signature |
HUBOO_INT_SG | Huboo International Signed for |
HUBOO_INT_TR | Huboo International Tracked |
HUBOO_INT | Huboo International Standard Untracked |
HUBOO_INT_TR_SG | Huboo International Tracked and Signed |
HUBOO_GTD1PM | Special Guaranteed Delivery by 1pm |
(N.B.: if you have already mapped your shipping options on your channel to Huboo, you can use the exact shipping method title text as used on your channel).
We kindly request that you send a copy of your completed file to your Business Development Manager to validate data is in the correct format when processing a CSV order upload for the first time.
This is simply to ensure we avoid accidental errors in order details and shipping methods as well as to ensure the file will upload correctly.
Once validated by your Business Development Manager, visit your Huboo Dashboard and click the ‘Add Manual Order’ button in the ‘Sales’ menu:
To the right hand side of this page you’ll find a ‘Multiple/Batch Upload’ button
You will find our CSV uploader in this page. Use the ‘Choose File’ button to select your CSV file from your device and click ‘Upload’ on the right hand side of the page:
Once uploaded, you’ll be taken to an upload report page.
If there are any errors with your file, they will be detailed here. If there are no errors, your orders should appear within your ‘Sales’ tab shortly (please allow up to 15 minutes for this to take place).
Please note that if any items within your csv are out of stock or any SKUs therein are not in our system as a ‘Listing With Huboo’ the respective orders for these items will appear in your ‘Sales Not With Huboo’ tab.
It is important you allow at least 15 minutes between uploading the file and expecting the orders to appear in your ‘Sales With Huboo’ tab.
IF YOU ARE CONCERNED THE IMPORT HAS NOT WORKED DO NOT TRY TO RE-UPLOAD THE FILE - contact your Client Success Manager to investigate.
