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
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 - contact your Client Success Manager for assistance.
Template Contents and Validation Rules Explained
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
STATE SELECTION : Canada, USA & Australia State Validation:
For Canada, Address Line 4 MUST match one of this list:
Prince Edward Island
Newfoundland and Labrador
For Australia, Address Line 4 MUST match one of this list:
New South Wales
For United States, Address Line 4 MUST match one of this list:
District Of Columbia
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 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