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:

  • Orders for the same customer with multiple SKUs need to have unique order numbers (1 order # per row)

  • Do NOT leave the Order # field blank


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.