> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.gearment.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Import Orders via CSV/Excel - Platform Label Order

# Import Orders via CSV/Excel - Platform Label Order

This guide explains how to import orders in bulk using a **CSV or Excel file** when the **shipping label is purchased from the selling platform** instead of Gearment.

This method is commonly used for platforms such as **TikTok Shop, Etsy, eBay, Order Desk, or Poshmark,** when the seller generates the shipping label directly from the platform.

### Step 1: Access the Import Feature

* Login [Gearment portal](https://dash.gearment.com/login?app=pod)
* Go to **Draft order**
* Click **Import**

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/image_gdpwld.png)

### Step 2: Configure Import Settings

Before uploading your file, fill in the following fields:

* **Platform**: Select the selling platform **TikTok Shop**, **Etsy**, **eBay**, **Order Desk**, **Poshmark**.
* **Store**: Select the connected store where the orders belong.
* **File Type:** Use **Platform Label Order Template** when the shipping label is provided by the platform (e.g., TikTok Shop, Etsy, eBay, Order Desk, Poshmark).
**Variant ID - Platform Label Order**: Enter the **Variant ID** of the product.
**Product style - Platform Label Order**: Enter product details: **Style, Color, Size**.

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/import-label_15sfa8l.png)

### Step 3: Download the Import Template

Click **Download Platform Label Order Template**
Use this file to prepare your order data before uploading.

${color}[#ff0000](Important):
* Do **not delete or rename any columns in the template**.
* Keep the **original format**
* Modifying the template structure may cause import errors

### Step 4: Fill in the Order Information
There are **2 ways** to create orders using the import template. Please choose **one method only**.

### 1. Variant ID - Platform Label Order


Open the downloaded file and complete the required fields.

**Order Information**
**Order ID (Reference ID)**: A unique ID used to track the order in your internal system or selling platform.

###### Add Product Information
Each order must include product details.

* **Variant ID**: Use the **Variant ID** listed in the **Product Variant ID sheet** inside the template.
A **Variant ID represents a specific product combination**: Product style + size + color
*Example: GM0002000014 = Classic T-Shirt / Ash / Size L*

* **Quantity**: Enter the number of units ordered.

* **Design Links**: Paste the design URL into the correct **print location column**.
Available columns include:
Design Link Front
Design Link Back
Design Link Pocket
Design Link Left Sleeve
Design Link Right Sleeve
Design Link Whole

Important:
* Make sure the design link is **publicly accessible**.
* Private links may cause mapping product delays.

###### Add Optional Order Information
* **Gift Message Body**: Add a gift message that will be included with the order.

### 2. Product Style - Platform Label Order

Fill in the product details, including: Product style, Color, Size.
Ensure the information matches Gearment’s product style to avoid mapping errors.

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/imageqasxwd_m70ftz.png)


### Step 5: Upload the File

After completing the template:
* Save the file in **CSV or Excel format**
* Click **Upload file** or **drag and drop the file** **here**
Gearment will begin processing the import.

### Step 6: Check Import Logs

After uploading the file, you can track the import result.
Go to:** Logs → Import Orders**. You will see the **import status** for each file.

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/image_1l2xx8w.png)
###### Fix Failed Imports
* Click **View Detail**
* Download the **Failed Import File**

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/image-1_2avq40.png)

* Check the **last column** to see the error message

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/image-2_kbrtvs.png)

* Fix the issue in your original file
* Upload the corrected file again

### Step 7: Process Orders After Import

All successfully imported orders will appear in **Draft Orders**.

From there, you can:
* Map the product
* Approve the order
* Make payment
* Track production **Sale Orders**

![](https://storage.crisp.chat/users/helpdesk/website/-/3/d/2/5/3d25223c2bf9cc00/image_1hvzrlz.png)

You can enable automatic order processing to reduce manual steps.
Go to **Settings** and enable:
* **Auto-approve orders**
* **Auto payment**
When enabled, imported orders will automatically move into **production after import**.


For detailed instructions on creating a Platform Label Order manually, please refer to this guide: [Platform Label Order](https://help.gearment.com/en-us/article/create-a-platform-label-order-1alq5bi/)