Importing orders
To import several orders into Paazl at once you need to include the orders in an Excel file and then upload the file to Paazl. It doesn't matter what you call the file, but it must have the .xls extension and not .xlsx. Download the import orders sample file for an example of what the file looks like.
Note
Make sure you remove any header rows and unnecessary worksheets from your Excel file before uploading it! The file must only contain order data.
Note
Should you experience problems importing the file—for example, because it is unclear what data values you need to enter—contact Paazl Customer Support.
Fill in order details in the Excel file as follows.
| Excel column | Description | Required | Example |
|---|---|---|---|
| A | Addressee surname | Required | Feuerstein |
| B | Addressee first name | Required | Friederich |
| C | Addressee other name | Optional | Bedrock Industries Ltd. |
| D | Addressee country (ISO 3166-2 code) | Optional | US |
| E | Addressee street (required for addresses outside the Netherlands) | Conditional | Cobblestone Way |
| F | Addressee city (required for addresses outside the Netherlands) | Conditional | Bedrock |
| G | Addressee postal code | Required | 70777 |
| H | Addressee house number | Required | 301 |
| I | Addressee house number extension | Optional | a |
| J | Addressee e-Mail address | Optional | fred@bi.com |
| K | Carrier (this is the code listed in Paazl carrier codes) | Required | FEDEX |
| L | Shipping option (the identifier code displayed in your Paazl web app account under ) | Required | INTERNATIONAL_ECONOMY |
| M | Cash on delivery / Insured amount | Optional | 40.20 |
| N | Carrier's customer number (required for DHL Pack Stations) | Conditional | XXX123 |
| O | Pickup location name | Optional | ShipCenter |
| P | Pickup location postal code | Optional | 10990 |
| Q | Pickup location house number | Optional | 3 |
| R | Addressee e-mail | Optional | fred@bi.com |
| S | Addressee mobile phone number | Optional | (800) 810-0233 |
| T | Order reference | Required | order007 |
| U | Number of labels | Required | 3 |
| V |
Will the shipment be consolidated (i.e. the labels will be printed, for example, 1/3, 2/3, 3/3)? If so, fill in "collo", otherwise leave blank. |
Optional | collo |
| W | Sender name | Required | Paazl |
| X | Sender postal code | Required | 1018LL |
| Y | Sender house number | Required | 9 |
| Z | Sender house number extension | Optionql | 580 |
| AA | Returns name | Required | Paazl |
| AB | Returns Postal code | Required | 1018LL |
| AC | Returns House number | Required | 9 |
| AD | Returns House number extension | Optional | 580 |
| AE | Weight (required by some carriers) | Conditional | 1 |
| AF | Description (required by some carriers) | Conditional | Saber Tooth Tiger ivory |
| AG | Addressee phone number (required by some carriers) | Conditional | (800) 810-0233 |
| AH | Customs value (required for cross-border orders; the default currency is euros) | Conditional | 50.75 |
| AN | Country of manufacture (ISO 3166-2 code; default is "NL") | Optional | DE |
| AO | Length (cm; required by some carriers for cross-border orders) | Conditional | 30 |
| AP | Width (cm; required by some carriers for cross-border orders) | Conditional | 20 |
| AQ | Height (cm; required by some carriers for cross-border orders) | Conditional | 10 |
| AT | Packaging type (indicates who supplies the packaging; default is "Your Packaging") | Optional | FEDEX_TUBE |
| AX | Carrier contract number (required if carrier code is not recognized) | Conditional | 2323232AA |
Note
- The workbook must have the .xls file extension and not the .xlsx file extension
- The workbook must have a single sheet
- You can import a maximum of 1,000 orders per sheet
- Make sure to put house numbers and house number extensions into separate columns
- The default country code is NL
- When importing Dutch addresses, only fill in the postal code and house number—the house number extension is optional. Paazl automatically will fill in the street address and city name
- Make sure your browser doesn't block Paazl pop-ups, otherwise you won't be able to upload the file!
Note
If you are importing shipments for your own custom carrier, fill in 'BLANK' in the carrier column, and 'BLANK_<number>' (e.g. BLANK_1) in the shipping option column.
You will find the identifier for your custom carriers in the web app under
Once your file is ready, log into your Paazl web app account and follow the steps below.
