Creating Products in Bulk via Import
In the Mailship portal, you can create products in two ways:
Add products individually.
Upload products in bulk via import.
On this page, we will look at how to create products in bulk using import. If you are interested in creating individual products, follow this guide: Creating a Product
How to Import Products
You can easily download the import template in your chosen format directly from the portal. Once filled out, simply upload it to the Mailship system, and your products will be added all at once.
1) Downloading the Template
In Mailship, go to the Products section, click on the three dots 
next to the "Create" button, and select Import. Choose your preferred format and click Download.
2) Filling Out the Template
Fill out the template by entering only the mandatory fields or the ones you wish to use.
How to Edit Fields in the Template:
Do not delete columns you don’t plan to use; simply leave them blank. Deleting columns will cause the import to fail.
Explanation of Individual Fields:
Field Name | Field Meaning | Example |
SKU* | Primary EAN = EAN code of the product (the product must be labeled with this code) | MS51822190117 |
Internal Sku* | Internal SKU = Your internal product identifier | PROD_123 |
Name* | Product Name = Your name for the product | Mug |
Weight (g) | Weight in grams | 120 |
Height (mm) | Height in millimeters | 1200 |
Width (mm) | Width in millimeters | 1600 |
Length (mm) | Length in millimeters | 2000 |
Reference Numbers* | Reference Number = Additional EAN or, if no other identification number is needed, we recommend entering the EAN | 1485622190189 |
Packaging Type* | Packaging Type = Classic / Oversized | A = classic B = oversized |
Work Around Sn In | Serial Number Tracking - For more information, visit: Services and Functions for Products | 1 = Enable Tracking 0 = Without Tracking |
Work Around Ean Sticker | CURRENTLY UNAVAILABLE | Leave blank |
Work Around Warranty Inf | CURRENTLY UNAVAILABLE | Leave blank |
Work Around Lot | Batch Tracking - For more information go to page: Services and Functions for Products | 1 = Enables Batch Tracking for the Product 0 = For Non-Batch-Tracked Goods |
Description | Product Description - Your custom note about the product | Porcelain White Mug |
Product Group | Product Group - e.g., magazine, footwear, toys, etc. | Porcelain Dishes |
Eshops** | E-shop(s) Where the product will be available | internal.mailstep |
Country Of Origin | Country of Origin - Where the product was manufactured, important for customs clearance | CZ |
Hs Code | HS Code - Tariff code based on the Harmonized System of the World Customs Organization | 6912 |
Type* | Product type - For more information about product types, visit: Products | physical virtual |
|
It is not possible to create product bundles through bulk import. If you need to create a product bundle, it must be done manually in the system administration. | ||
Imei Check Required | CURRENTLY UNAVAILABLE | Leave blank |
Requires Additional Work | PAID SERVICE ON REQUEST | 1 = Enables Additional Work 0 = No Additional Work |
Requires Qualitative Receiving | PAID SERVICE ON REQUEST | 1 = Enables Inspection 0 = No Inspection |
Expected Turnover | Product turnover rate | ("A" / "B" / "C" / "D") |
Inbound expiration offset | How old can the goods be at the time of inbound. (For example, if the offset is 60, the product must not have an expiration date older than 60 days when we receive it.) | 60 |
Outbound expiration offset | How old can the goods be at the time of expedition. (For example, if the offset is 60, the product must not have an expiration date older than 60 days from the moment when expedition is created.) | 60 |
Localisation | PAID SERVICE ON REQUEST API INTEGRATION ONLY | cs, en, pl |
* Mandatory field.
** Although the field is not mandatory in the system, it is recommended to assign an e-shop to products. Without this assignment, products will not be available for expeditions or stock advice.
3) Uploading the Template
To import the completed template into Mailship, go back to the Products section. Click on the three dots next to the Create button and select Import. Then Choose File, locate the completed template, and finally click the Import Files button to complete the process.
How Do I Know the Import Was Successful?
You can confirm a successful import if no error message appears after uploading the file. This indicates that the products have been successfully added to the Mailship system. To double-check, you can verify the import by searching for a specific SKU or EAN code in the system.
Possible Issues and Their Solutions
Deleted Column
Validation failed, you have to provide at least 1 product.
If a column is deleted, the data will shift into the position of the removed field. For example, a value intended for the "Country of Origin" field may end up in the "E-shop" field. In such cases, you need to complete a new template without deleting any columns.
Mandatory Field Not Filled
RreferenceNumber: Reference number must not be blank or greater than 0.
If a mandatory field is missing, it must be completed, and the import file uploaded again.
Incorrectly Entered Value
Country "cs not found.
If a value in a column is entered incorrectly (e.g., the language Czech is written as "cz" instead of the correct "cs" according to ISO-639), the value must be corrected to the proper format.
Expiration offset can only be used for products with lot evidence.
If LOT evidence is disabled for the product but the Expiration Offset is filled in, you must either enable batch tracking or remove the Expiration Offset.
