> ## 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 - Ship by Seller Order

# Import Orders via CSV/Excel (Ship by Seller Order)

This guide explains how to import orders in bulk using a CSV or Excel file when the shipping label is purchased by the seller or the fulfillment center.

### 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 (Shopify, Etsy, etc.).
* **Store**: Select the connected store where the orders belong.
* **File Type:** Use this template when Gearment provides the shipping label.
**Variant ID - Gearment Label**: Enter the **Variant ID** of the product.
**Product style - Gearment Label**: Enter product details: **Style, Color, Size**.

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

### Step 3: Download the Import Template 
 
Click **Download Variant ID - Gearment Label** or **Product style - Gearment Label**
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 to avoid import errors.

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

### Step 4: Fill in Order Information

### 1. Variant ID - Gearment Label

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.

**Shipping Information**: Fill in the recipient's shipping details.
Required fields:
* **First Name**
* **Last Name**
* **Shipping Address 1**: Street address, house number, PO box, etc.
* **Shipping Address 2**: Apartment, suite, unit, building, etc.
* **Shipping City**
* **Shipping State**: Use the **2-letter state code**. Example: California → **CA**
* **Shipping Zipcode**
* **Shipping Country**

Optional but recommended:
* **Shipping Phone**
* **Shipping Email**
Providing phone and email helps reduce delivery issues.

###### 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
${color}[#ff0000](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.
* **Shipping Service**: Select the shipping service for the order.

###### Tax Information for International Orders
Some destinations require tax information.
**For EU Orders**, fill in:
* **IOSS Number**
* **IOSS Value**
**For Certain Countries**: Tax information may be required for orders shipped to:
* **United Kingdom**
* [Mexico](https://help.gearment.com/en-us/article/rfc-tax-number-required-for-orders-shipped-to-mexico-ja29aq/)
* **Brazil**
Refer to the [tax instruction](https://help.gearment.com/en-us/article/sales-taxes-for-orders-shipped-to-california-uk-and-europe-1qyfppp/) guide for more details.

### 2. Product Style - Gearment Label

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/image_qasxwd.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**.