Our standard CSV order import file template does not support creating order for Huboo Bundle listings.
If you need to create orders manually via CSV for Huboo Bundle listings, you must use our Bundle-Compatible CSV Order Import File template HERE.
To create orders via CSV for non-Bundle, standard Huboo Listings, you must use our standard CSV Order Import Template File. You cannot mix orders for Huboo Bundle Listings and standard Huboo Listings within one CSV file.
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
Using the file to create orders for Huboo Bundle Listings
To create orders for Huboo Bundle listings using this file, follow the steps below;
- In the "SKU" field, simply enter "Bundle"
- In the "Bundle SKU" field, enter the SKU you assigned to your Huboo Bundle at https://client.huboo.uk/bundle
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:
|
Shipping Name | Your customer’s name / the addressee for the order (must not exceed 27 characters) |
Address Line 1 | First line of your customer’s address, including House/Building Number / Name (no more than 30 chars) |
Address Line 2 | (Optional) Second line of address (must not exceed 30 characters) |
Address Line 3 | (Optional) Third line of address (must not exceed 30 characters) |
Address Line 4 | (Required) County or State (must not exceed 30 characters) |
Country | Delivery country - You must refer to ISO country code taxonomy table below and enter Alpha-2 code exactly as it appears in the table |
Post Code | Postcode for recipient. Do not use ‘special characters’ in this field (hypens, as found in Polish postcodes, are not allowed) |
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 | The marketplace from which the order was placed. If the order is from your own store / offline, simply select 'other'. Please note, the IOSS number for each marketplace specified will be recorded against each individual order. |
ISO country code taxonomy list
Country | Alpha-2 code |
---|---|
Afghanistan | AF |
Albania | AL |
Algeria | DZ |
American Samoa | AS |
Andorra | AD |
Angola | AO |
Anguilla | AI |
Antarctica | AQ |
Antigua and Barbuda | AG |
Argentina | AR |
Armenia | AM |
Aruba | AW |
Australia | AU |
Austria | AT |
Azerbaijan | AZ |
Bahamas (the) | BS |
Bahrain | BH |
Bangladesh | BD |
Barbados | BB |
Belarus | BY |
Belgium | BE |
Belize | BZ |
Benin | BJ |
Bermuda | BM |
Bhutan | BT |
Bolivia (Plurinational State of) | BO |
Bonaire, Sint Eustatius and Saba | BQ |
Bosnia and Herzegovina | BA |
Botswana | BW |
Bouvet Island | BV |
Brazil | BR |
British Indian Ocean Territory (the) | IO |
Brunei Darussalam | BN |
Bulgaria | BG |
Burkina Faso | BF |
Burundi | BI |
Cabo Verde | CV |
Cambodia | KH |
Cameroon | CM |
Canada | CA |
Cayman Islands (the) | KY |
Central African Republic (the) | CF |
Chad | TD |
Chile | CL |
China | CN |
Christmas Island | CX |
Cocos (Keeling) Islands (the) | CC |
Colombia | CO |
Comoros (the) | KM |
Congo (the Democratic Republic of the) | CD |
Congo (the) | CG |
Cook Islands (the) | CK |
Costa Rica | CR |
Croatia | HR |
Cuba | CU |
Curaçao | CW |
Cyprus | CY |
Czechia | CZ |
Côte d'Ivoire | CI |
Denmark | DK |
Djibouti | DJ |
Dominica | DM |
Dominican Republic (the) | DO |
Ecuador | EC |
Egypt | EG |
El Salvador | SV |
Equatorial Guinea | GQ |
Eritrea | ER |
Estonia | EE |
Eswatini | SZ |
Ethiopia | ET |
Falkland Islands (the) [Malvinas] | FK |
Faroe Islands (the) | FO |
Fiji | FJ |
Finland | FI |
France | FR |
French Guiana | GF |
French Polynesia | PF |
French Southern Territories (the) | TF |
Gabon | GA |
Gambia (the) | GM |
Georgia | GE |
Germany | DE |
Ghana | GH |
Gibraltar | GI |
Greece | GR |
Greenland | GL |
Grenada | GD |
Guadeloupe | GP |
Guam | GU |
Guatemala | GT |
Guernsey | GG |
Guinea | GN |
Guinea-Bissau | GW |
Guyana | GY |
Haiti | HT |
Heard Island and McDonald Islands | HM |
Holy See (the) | VA |
Honduras | HN |
Hong Kong | HK |
Hungary | HU |
Iceland | IS |
India | IN |
Indonesia | ID |
Iran (Islamic Republic of) | IR |
Iraq | IQ |
Ireland | IE |
Isle of Man | IM |
Israel | IL |
Italy | IT |
Jamaica | JM |
Japan | JP |
Jersey | JE |
Jordan | JO |
Kazakhstan | KZ |
Kenya | KE |
Kiribati | KI |
Korea (the Democratic People's Republic of) | KP |
Korea (the Republic of) | KR |
Kuwait | KW |
Kyrgyzstan | KG |
Lao People's Democratic Republic (the) | LA |
Latvia | LV |
Lebanon | LB |
Lesotho | LS |
Liberia | LR |
Libya | LY |
Liechtenstein | LI |
Lithuania | LT |
Luxembourg | LU |
Macao | MO |
Madagascar | MG |
Malawi | MW |
Malaysia | MY |
Maldives | MV |
Mali | ML |
Malta | MT |
Marshall Islands (the) | MH |
Martinique | MQ |
Mauritania | MR |
Mauritius | MU |
Mayotte | YT |
Mexico | MX |
Micronesia (Federated States of) | FM |
Moldova (the Republic of) | MD |
Monaco | MC |
Mongolia | MN |
Montenegro | ME |
Montserrat | MS |
Morocco | MA |
Mozambique | MZ |
Myanmar | MM |
Namibia | NA |
Nauru | NR |
Nepal | NP |
Netherlands (the) | NL |
New Caledonia | NC |
New Zealand | NZ |
Nicaragua | NI |
Niger (the) | NE |
Nigeria | NG |
Niue | NU |
Norfolk Island | NF |
Northern Mariana Islands (the) | MP |
Norway | NO |
Oman | OM |
Pakistan | PK |
Palau | PW |
Palestine, State of | PS |
Panama | PA |
Papua New Guinea | PG |
Paraguay | PY |
Peru | PE |
Philippines (the) | PH |
Pitcairn | PN |
Poland | PL |
Portugal | PT |
Puerto Rico | PR |
Qatar | QA |
Republic of North Macedonia | MK |
Romania | RO |
Russian Federation (the) | RU |
Rwanda | RW |
Réunion | RE |
Saint Barthélemy | BL |
Saint Helena, Ascension and Tristan da Cunha | SH |
Saint Kitts and Nevis | KN |
Saint Lucia | LC |
Saint Martin (French part) | MF |
Saint Pierre and Miquelon | PM |
Saint Vincent and the Grenadines | VC |
Samoa | WS |
San Marino | SM |
Sao Tome and Principe | ST |
Saudi Arabia | SA |
Senegal | SN |
Serbia | RS |
Seychelles | SC |
Sierra Leone | SL |
Singapore | SG |
Sint Maarten (Dutch part) | SX |
Slovakia | SK |
Slovenia | SI |
Solomon Islands | SB |
Somalia | SO |
South Africa | ZA |
South Georgia and the South Sandwich Islands | GS |
South Sudan | SS |
Spain | ES |
Sri Lanka | LK |
Sudan (the) | SD |
Suriname | SR |
Svalbard and Jan Mayen | SJ |
Sweden | SE |
Switzerland | CH |
Syrian Arab Republic | SY |
Taiwan (Province of China) | TW |
Tajikistan | TJ |
Tanzania, United Republic of | TZ |
Thailand | TH |
Timor-Leste | TL |
Togo | TG |
Tokelau | TK |
Tonga | TO |
Trinidad and Tobago | TT |
Tunisia | TN |
Turkey | TR |
Turkmenistan | TM |
Turks and Caicos Islands (the) | TC |
Tuvalu | TV |
Uganda | UG |
Ukraine | UA |
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 |
Uruguay | UY |
Uzbekistan | UZ |
Vanuatu | VU |
Venezuela (Bolivarian Republic of) | VE |
Viet Nam | VN |
Virgin Islands (British) | VG |
Virgin Islands (U.S.) | VI |
Wallis and Futuna | WF |
Western Sahara | EH |
Yemen | YE |
Zambia | ZM |
Zimbabwe | ZW |
Åland Islands | AX |
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 |