CSV uploading allows users to import a large number of orders into Crowdsender to manage their shipment. In this article we will cover some of the most common mistakes users encounter with CSVs, as well as a step-by-step guide to upload a CSV.
Common errors
If you've uploaded CSV files in the past, or if you've just uploaded a file and failed, there's probably an easy-to-fix culprit. Here are a few helpful reminders to get you going.
Correct field formatting is essential when uploading a CSV. Missing or incorrect fields are the most common problems associated with a failed upload.
Before uploading your CSV, make sure that the required fields are filled in with the correct format.
Use our templates. Download one of our sample CSV files to better understand the format and save that CSV file as a template for future use.
Upload Orders via CSV
Step 1: Download the file
To make the process easier for you, we have created two templates that you can use:
Download this minimun CSV template if you deliver within the European Union.
If your order has to be delivered outside the European Union you need this advanced CSV template.
📔 Note: The maximum is 1000 orders per CSV upload.
Step 2: Fill in the data
Let's take a look at the types of data you will find in the CSV:
Data | Description | Type of data |
Order number* | A number identifying a purchase or order placed by a customer. | Open field. Required. |
Box* | The number of boxes in that order. | Must be in number format. E.g.: "1", "2" or "3". Required. |
Box Gross Weight* | The total weight of the consignment including packaging. | Must be in number format. E.g.: "00.14". Required. |
Box Gross Weight Unit* | The unit of measure of weight. | Only kg and g are allowed. Required. |
Name* (Destination address) | Name of the person who is to receive the order. | Open field. Required. |
Surname* (Destination address) | Surname of the person who is to receive the order. | Open field. Required. |
Street* (Destination address) | Address where the order has to be sent. | Open field. Required. |
Number* (Destination address) | Number of the street where the order has to be sent. | Must be in number format. E.g.: "1", "2" or "3". Required. |
Apartment, local, etc. (Optional) (Destination address) | Any further details that the delivery person should be aware of when delivering the parcel. | Open field. Optional. |
Zip/Postal code* (Destination address) | Postal code to which the order should be sent. | Must be in number format. E.g.: "48015”. Required. |
City* (Destination address) | City to which the order should be sent. | Open field. Required. |
State/Province (Optional) (Destination address) | Province to which the order should be sent. | Open field. Optional. |
Country* (Destination address) | Country to which the order should be sent. | Must be in ISO format. E.g.: "ES". Required. |
Email* (Destination address) | Email of the person who is to receive the order. | Only email is allowed. Ex: prueba@crowdsender.io. Required. |
Prefix* (Destination address) | Prefix of the phone number of the person who is to receive the order. | Must be in prefix format. E.g.: "+34". This is required. |
Phone Number* (Destination address) | Phone number of the person who is to receive the order. | Must be in number format. E.g.: "664584456". Required. |
Item Title | Product name of the order. | Open field. Required only in the advanced CSV. |
SKU | The reference code of an item in the order. | Open field. Required only in the advanced CSV. |
Quantity | Quantity of the product requested in the order. | Must be in number format. E.g.: "1", "2" or "3". Required only in the advanced CSV. |
Net Weight | The weight of a product without its container or package. | Must be in number format. E.g.: "00.14". Required only in the advanced CSV. |
Weight unit | The unit of measure of weight. | Only kg and g are allowed. Required only in the advanced CSV. |
Price | Price of the product requested in the order. | Must be in number format. E.g.: "00.14". Required only in the advanced CSV. |
Category (Optional) | Category of the product requested in the order. | Open field. Optional. |
Subcategory (Optional) | Subcategory of the product requested in the order. | Open field. Optional. |
Taric | Classification system used by the European Union for the classification of products in the customs territory. | Open field. Required only in advanced CSV and if sending outside the European Union. |
Box Length | Length of the box to be sent. | Must be in number format. E.g.: "30.00". Required only in advanced CSV and if sending outside the European Union. |
Box Width | Width of the box to be sent. | Must be in number format. E.g.: "30.00". Required only in advanced CSV and if sending outside the European Union. |
Box Height | Height of the box to be sent. | Must be in number format. E.g.: "30.00". Required only in advanced CSV and if sending outside the European Union. |
Box dimensions Unit | The unit of measure of dimensions. | Only in and cm are allowed. Required only in advanced CSV and if sending outside the European Union. |
Box Category of Items | Categorization of products to be shipped. | Only “COMMERCIAL_SAMPLE”, “DOCUMENTS”, “GIFT”, “COMMERCIAL_GOODS” and “OTHERS” are allowed. Required only in advanced CSV and if sending outside the European Union. |
Box Non-delivery | Indicate what to do if the courier is unable to deliver the order. | Only “RETURN_SENDER” and “DELIVERY_ATTEMPT” are allowed. Required only in advanced CSV and if sending outside the European Union. |
Box Nº Invoice | Invoice number for export. | Open field. Required only in advanced CSV and if sending outside the European Union. |
Box Incortem | Logistic code that each transport contract has and that indicates the conditions of delivery. | Open field. Required only in advanced CSV and if sending outside the European Union. E.g.: DAP (delivered at palace) |
Send date | Date on which it is expected to be sent to the delivery person. | Must be in date format. E.g: "02-12-2022". Optional. |
Courier | Delivery service provider that will manage the delivery of the product. E.g.: DHL, UPS, Correos, DPL, GLS… | Must be in Crowdsender Contract ID format. You can find it in the Crowdsender platform > Settings > Courier > My contracts > Actions (From the contract you want to select) > View contract ID. |
Seller | Where was the purchase made. | Open field. Optional. |
Name* (Pick up address) | Name of the person who should send the order. | Open field. Required only in the advanced CSV. |
Surname* (Pick up address) | Surname of the person who should send the order. | Open field. Required only in the advanced CSV. |
Street* (Pick up address) | Address from which the order is sent. | Open field. Required only in the advanced CSV. |
Number* (Pick up address) | Number of the address from which the order is being shipped. | Must be in number format. E.g.: "1", "2" or "3". Required only in the advanced CSV. |
Apartment, local, etc. (Pick up address) | Any other shipping address details. | Open field. Optional. |
Zip/Postal code* (Pick up address) | Postal code from where the order is being shipped. | Must be in number format. E.g.: "48015”. Required only in the advanced CSV. |
City* (Pick up address) | City from where the order is being shipped. | Open field. Required only in the advanced CSV. |
State/Province (Pick up address) | Province from where the order is being shipped. | Open field. Optional. |
Country* (Pick up address) | Country from where the order is being shipped. | Must be in ISO format. E.g.: "ES". Required only in the advanced CSV. |
Language* (Pick up address) | Language of the delivery address. | Open field. Required only in the advanced CSV. |
Prefix* (Pick up address) | Prefix of the phone number of the company to send the order to. | Must be in prefix format. E.g.: "+34". Required only in the advanced CSV. |
Phone Number* (Pick up address) | Phone number of the company to send the order to. | Must be in number format. E.g.: "664584456". Required only in the advanced CSV. |
VAT number (Pick up address) | EU tax identification number of the company sending the order. | Open field. Optional. |
EORI number (Pick up address) | European Union Economic Operator Identification Number of the company sending the order. | Open field. Optional. |
Order Custom field 1 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Order Custom field 2 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Order Custom field 3 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Order Custom field 4 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Order Custom field 5 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Order Custom field 6 | Custom field in the order. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 1 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 2 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 3 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 4 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 5 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
Box Custom field 6 | Custom field in the order box. This data can be configured on the Configuration > Company page. | Open field. Optional. |
📔 Note in the advanced CSV: If an order has more than one product per box you should duplicate the line as many products as the box has and you will only have to change the specific details of each product. E.g.: If you have an order with two products it should look like this:
Order number | Box | Weight | Street (Destination address) | Item title | Price |
#00001 | 1 | 0.3kg | Luna Street | Blue trousers | 30,00€ |
#00001 | 1 | 0.3kg | Luna Street | Red T-shirt | 40,00€ |
and if an order has more than one box, the order number must be duplicated and in the box field we must add one more number. E.g.:
Order number | Box | Weight | Street (Destination address) | Item title | Price |
#00001 | 1 | 0.3kg | Luna Street | Blue trousers | 30,00€ |
#00001 | 1 | 0.3kg | Luna Street | Red T-shirt | 40,00€ |
#00001 | 2 | 0.2kg | Luna Street | Green T-shirt | 25,00€ |
📔 Note: Boxes can come unordered as long as they are in a row in the same order. There cannot be interleaved orders e.g. #0001, #0002, #0001 in this case they will be treated as 3 separate orders.
Step 3: Upload the file
Once the data has been filled in, it is time to upload the CSV.
In the top corner of the order page there is a button to upload a CSV file.
Uploading the CSV will automatically show all orders in the Inbound orders tab.
📔 Note: If there is an error in the upload we will notify you of the status of each order. These are the statuses:
Error: You have not filled in a required field to process the order and therefore the CSV could not be uploaded to Crowdsender.
To review: The order has been uploaded correctly but some data has an incorrect format.
Registered: The order has been successfully uploaded and is ready to be processed.