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.
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 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.
(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.
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
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.