The Huboo dashboard supports CSV order imports. 


Importing your orders to Huboo via CSV is simple; just follow the steps below:


  • Download a copy of our CSV order import file from HERE

  • Complete the file using the guidelines below and in the column header notes in the template file
  • Save/export the file as a .csv file
  • Import the file to Huboo using the instructions in this article


Important Note


Data Validation


The template file includes a series of validations to ensure you enter correctly-formatted data. 


If the data you enter breaches any of these validations, the cell will highlight red. Notes for each column are provided in the hover-over on the column headers and explained in full detail below.


If you intend to copy and paste data into the template file, please ensure you use "Paste values only" (right click. click 'Paste special' then click "Paste values only" from the sub-menu: 


Not using "Paste values only" will result in the validation rules in the cells being over-written.


NB: You cannot import orders for Bundle Listings 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.



Importing Your Completed File


Once you've completed your file ready for import and have checked all details are correct and meet our validation criteria (see below for complete details), you can import this using the "Sales" section of your dashboard


  • Log into your Huboo dashboard
  • Click the "Sales" menu link in the sidebar navigation and click "Add Manual Order" from the drop-down 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). 

If you try to upload an order with an SKU that does not correlate to any of your "Listings with Huboo" the order line for that SKU will fail to import. 

Please note that if any items within your csv are out of stock 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 - raise a ticket with for our technical support team.


Template Contents and Validation Rules Explained


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

Address Line 1

First line of your customer’s address, including House/Building Number / Name

Address Line 2

(Optional) Second line of address

Address Line 3

(Optional) Third line of address

Address Line 4

(Optional) Fourth line of address

Country

Select the country from the drop-down list in the template file.

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 unit price retail value of the line item (not the overall sales) (to allow you to track sales values from the dashboard. This should be in GBP and a numeric value only (no £ sign etc). Always use the price of qty 1 as this will be multipled by the quantity field.

Channel

(Optional) The marketplace from which the order was placed.

Please note, the IOSS number for each marketplace specified, will be recorded against each individual order.


ISO country code taxonomy list


CountryAlpha-2 code
AfghanistanAF
AlbaniaAL
AlgeriaDZ
American SamoaAS
AndorraAD
AngolaAO
AnguillaAI
AntarcticaAQ
Antigua and BarbudaAG
ArgentinaAR
ArmeniaAM
ArubaAW
AustraliaAU
AustriaAT
AzerbaijanAZ
Bahamas (the)BS
BahrainBH
BangladeshBD
BarbadosBB
BelarusBY
BelgiumBE
BelizeBZ
BeninBJ
BermudaBM
BhutanBT
Bolivia (Plurinational State of)BO
Bonaire, Sint Eustatius and SabaBQ
Bosnia and HerzegovinaBA
BotswanaBW
Bouvet IslandBV
BrazilBR
British Indian Ocean Territory (the)IO
Brunei DarussalamBN
BulgariaBG
Burkina FasoBF
BurundiBI
Cabo VerdeCV
CambodiaKH
CameroonCM
CanadaCA
Cayman Islands (the)KY
Central African Republic (the)CF
ChadTD
ChileCL
ChinaCN
Christmas IslandCX
Cocos (Keeling) Islands (the)CC
ColombiaCO
Comoros (the)KM
Congo (the Democratic Republic of the)CD
Congo (the)CG
Cook Islands (the)CK
Costa RicaCR
CroatiaHR
CubaCU
CuraçaoCW
CyprusCY
CzechiaCZ
Côte d'IvoireCI
DenmarkDK
DjiboutiDJ
DominicaDM
Dominican Republic (the)DO
EcuadorEC
EgyptEG
El SalvadorSV
Equatorial GuineaGQ
EritreaER
EstoniaEE
EswatiniSZ
EthiopiaET
Falkland Islands (the) [Malvinas]FK
Faroe Islands (the)FO
FijiFJ
FinlandFI
FranceFR
French GuianaGF
French PolynesiaPF
French Southern Territories (the)TF
GabonGA
Gambia (the)GM
GeorgiaGE
GermanyDE
GhanaGH
GibraltarGI
GreeceGR
GreenlandGL
GrenadaGD
GuadeloupeGP
GuamGU
GuatemalaGT
GuernseyGG
GuineaGN
Guinea-BissauGW
GuyanaGY
HaitiHT
Heard Island and McDonald IslandsHM
Holy See (the)VA
HondurasHN
Hong KongHK
HungaryHU
IcelandIS
IndiaIN
IndonesiaID
Iran (Islamic Republic of)IR
IraqIQ
IrelandIE
Isle of ManIM
IsraelIL
ItalyIT
JamaicaJM
JapanJP
JerseyJE
JordanJO
KazakhstanKZ
KenyaKE
KiribatiKI
Korea (the Democratic People's Republic of)KP
Korea (the Republic of)KR
KuwaitKW
KyrgyzstanKG
Lao People's Democratic Republic (the)LA
LatviaLV
LebanonLB
LesothoLS
LiberiaLR
LibyaLY
LiechtensteinLI
LithuaniaLT
LuxembourgLU
MacaoMO
MadagascarMG
MalawiMW
MalaysiaMY
MaldivesMV
MaliML
MaltaMT
Marshall Islands (the)MH
MartiniqueMQ
MauritaniaMR
MauritiusMU
MayotteYT
MexicoMX
Micronesia (Federated States of)FM
Moldova (the Republic of)MD
MonacoMC
MongoliaMN
MontenegroME
MontserratMS
MoroccoMA
MozambiqueMZ
MyanmarMM
NamibiaNA
NauruNR
NepalNP
Netherlands (the)NL
New CaledoniaNC
New ZealandNZ
NicaraguaNI
Niger (the)NE
NigeriaNG
NiueNU
Norfolk IslandNF
Northern Mariana Islands (the)MP
NorwayNO
OmanOM
PakistanPK
PalauPW
Palestine, State ofPS
PanamaPA
Papua New GuineaPG
ParaguayPY
PeruPE
Philippines (the)PH
PitcairnPN
PolandPL
PortugalPT
Puerto RicoPR
QatarQA
Republic of North MacedoniaMK
RomaniaRO
Russian Federation (the)RU
RwandaRW
RéunionRE
Saint BarthélemyBL
Saint Helena, Ascension and Tristan da CunhaSH
Saint Kitts and NevisKN
Saint LuciaLC
Saint Martin (French part)MF
Saint Pierre and MiquelonPM
Saint Vincent and the GrenadinesVC
SamoaWS
San MarinoSM
Sao Tome and PrincipeST
Saudi ArabiaSA
SenegalSN
SerbiaRS
SeychellesSC
Sierra LeoneSL
SingaporeSG
Sint Maarten (Dutch part)SX
SlovakiaSK
SloveniaSI
Solomon IslandsSB
SomaliaSO
South AfricaZA
South Georgia and the South Sandwich IslandsGS
South SudanSS
SpainES
Sri LankaLK
Sudan (the)SD
SurinameSR
Svalbard and Jan MayenSJ
SwedenSE
SwitzerlandCH
Syrian Arab RepublicSY
Taiwan (Province of China)TW
TajikistanTJ
Tanzania, United Republic ofTZ
ThailandTH
Timor-LesteTL
TogoTG
TokelauTK
TongaTO
Trinidad and TobagoTT
TunisiaTN
TurkeyTR
TurkmenistanTM
Turks and Caicos Islands (the)TC
TuvaluTV
UgandaUG
UkraineUA
United Arab Emirates (the)AE
United Kingdom of Great Britain and Northern Ireland (the)GB
United States Minor Outlying Islands (the)UM
United States of America (the)US
UruguayUY
UzbekistanUZ
VanuatuVU
Venezuela (Bolivarian Republic of)VE
Viet NamVN
Virgin Islands (British)VG
Virgin Islands (U.S.)VI
Wallis and FutunaWF
Western SaharaEH
YemenYE
ZambiaZM
ZimbabweZW
Åland IslandsAX




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



Assigning The Correct IOSS Number To Orders Created Manually


If the orders you are creating manually originated on a marketplace, you may need to include an IOSS number for that marketplace on the order to ensure the end customer is not charged import duties/VAT when the goods arrive in the destination country.


Selecting the appropriate sales channel within the manual order prompts Huboo to include the respective IOSS number for the original sales channel. 


If the sales channel your order is sourced from is not listed, Huboo currently does not have up to date IOSS number records for that marketplace. 


In this instance you should either check with the marketplace if they have a valid IOSS number - and provide this to Huboo if available, or select "Other", in which instance Huboo will include your own IOSS number entered at https://client.huboo.uk/profile/billing-info if you have entered one. 

If you have not, selecting "Other" will lead to no IOSS number being included in the shipment data.