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.
Enter an order number here.
When entering your Order # please note:
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
Delivery country -
You must refer to the country names taxonomy table below and enter the name exactly as it appears in the table
Postcode for recipient. Do not use ‘special characters’ in this field.
Your channel SKU as linked within Huboo. This must match the SKU perfectly. Any rows with errors will not be imported.
The level or type of shipping service required for the order.
Please refer to the table in point 3 below for full taxonomy.
The quantity of this SKU to be sent
The delivery recipient email address
(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
Antigua and Barbuda
Bonaire, Sint Eustatius and Saba
Bosnia and Herzegovina
British Indian Ocean Territory
British Virgin Islands
Central African Republic
Cocos [Keeling] Islands
Democratic Republic of the Congo
French Southern Territories
Heard Island and McDonald Islands
Isle of Man
Northern Mariana Islands
Papua New Guinea
Republic of Ireland
Republic of the Congo
Saint Kitts and Nevis
Saint Pierre and Miquelon
Saint Vincent and the Grenadines
São Tomé and Príncipe
South Georgia and the South Sandwich Islands
Svalbard and Jan Mayen
Trinidad and Tobago
Turks and Caicos Islands
U.S. Minor Outlying Islands
U.S. Virgin Islands
United Arab Emirates
Wallis and Futuna
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 Hour Service
(e.g. Royal Mail First Class)
Huboo 24 Hour Service With Signature
Huboo 48 Hour Service
(e.g. Royal Mail Second Class)
Huboo 48 Hour Service With Signature
Huboo Fully Tracked 24 Hour Service
(e.g. DPD or Royal Mail 24 Fully Tracked)
Huboo Fully Tracked 48 Hour Service
(e.g. DPD or Royal Mail 48 Fully Tracked)
Huboo Fully Tracked 48 Hour Service With Signature
Huboo International Signed for
Huboo International Tracked
Huboo International Standard Untracked
Huboo International Tracked and Signed
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.