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
• Go to Draft order
• Click Import

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: Currently, the system supports two template types:

Gearment Template: Use this template if Gearment provides the shipping label.

Platform Label Order Template: Use this template if the seller or platform provides the shipping label.

Step 3: Download the Import Template

Click Download Gearment Template

Use this file to prepare your order data before uploading.

Important:

• Do not delete or rename any columns in the template.
• Keep the original format to avoid import errors.

Step 4: Fill in Order Information

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

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
• Brazil

Refer to the tax instruction guide for more details.

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.

Fix Failed Imports

• Click View Detail
• Download the Failed Import File

• Check the last column to see the error message

• 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

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.

Updated on: 03/10/2026