Creating Transfer in Bulk via Import
How to Create Transfer?
In the Mailship portal, you have two options for creating transfer:
Add them individually.
Upload them in bulk using the import.
On this page we’ll look at how to create transfer in bulk using the import feature. If you’re interested in creating transfer individually, follow this guide: Creating Transfer
How to Import Transfers
You can easily download the import template in your selected format directly from the portal. Once completed, simply upload it to the Mailship system, and your transfers will be added all at once.
1) Downloading the Template
In Mailship, go to the Transfer section, click on the three dots next to the +Create button, and then select Import. Choose your preferred format and click Download.
2) Filling Out the Template
Fill out the template with the transfer details.
After downloading the template, you will see a sample row with examples. Values in angle brackets <> are only for demonstration and should not be included during import.
Do not delete columns you won’t use, simply leave them empty. If a column is removed, the import will not function correctly.
How to Import Transfer with Multiple Items?
If you want to import a transfer with multiple products, you need to create a new row for each product. The number of products in the transfer equals the number of rows in the import file. For example, a transfer with three different items will have three rows.
Explanation of Individual Fields
Field Name | Field Meaning | Example |
Organisation* | The name of the organization under which you are creating the transfer. | internal.mailstep |
Internal Number* | Name the transfer. | socks_move_1 |
Warehouse From* | The name of the virtual warehouse from which you are transferring the goods. | internal.mailstep AVAILABLE |
Warehouse To* | The name of the virtual warehouse to which you are transferring the goods. | internal.mailstep AVAILABLE 2 |
Wms From* | The name of the physical warehouse where the transfer will take place. | internal.mailstep PRG AVAILABLE |
Wms To* | The name of the physical warehouse where the transfer will take place. | internal.mailstep PRG AVAILABLE |
|
Wms From and Wms To must match. The transfer takes place within a single physical warehouse. | ||
Type* | The transfer type is always "virtual", so enter "virtual". | virtual |
Note | Your optional note. | Socks move from eshop 2. |
Product Sku* | The product's EAN code (Primary EAN) must match the record in the system. You can enter either the Internal SKU or the Product SKU, or both. | 7612100017043 |
Internal Sku* | The product's SKU code (Internal SKU) must match the record in the system. You can enter either the Internal SKU or the Product SKU, or both. | PR00002607 |
Quantity* | The number of units of the product in the package. The value must be greater than 0. | 20 |
* Mandatory field.
3) Uploading the Template
Once you have completed the template, upload it using the "Choose File" button. Then confirm the import by clicking the "Import Files" button.
How Do I Know if the Import Was Successful or Unsuccessful?
A notification about data processing will appear in the bottom-right corner of the screen once the import starts.
Successful Import: If a green message saying "Done" and "Success" appears in the bar, the expeditions were imported successfully. You will also see the number of successfully uploaded expeditions.
Unsuccessful Import: If the import fails, a red message saying "Error" will appear. For details about the issue, click on "More Info," where you will find information about the reason for the error.
Possible Issues and Solutions
Duplicate transfer name
Row 2: internalNumber: This value is already used.
Ensure that each transfer has a unique name.
Product was not found
Row 2: Product on row 2 not found
This error message means that the product you are trying to upload to the expedition does not exist. Verify its accuracy based on the Product SKU and Internal SKU. You can enter either the Internal SKU or the Product SKU, or both.
Incorrectly filled warehouse name
Row 2: WarehouseFrom xxx not found.
Information about the warehouse (or other values) where the transfer is to be carried out is missing. The solution is to add the correct warehouse name to the appropriate field in the template. After correcting this information, re-upload the file to complete the import successfully.
Required field not filled
Row 2: items[0].quantity: This value should be greater than 0.
Fill in the required field "quantity" with a value greater than 0.
Duplicate products on the line
Row 3: items: The product test-06-02-1 is used multiple times at lines 0, 1.
The product was entered as a duplicate in the import file. Correct the file by removing the duplicates and upload it again.