Categories

How To Import Order to Merchize Manually

Content Manager
< All Topics
Table of Contents

🇻🇳 Click here for Vietnamese version.

This guide will show you how to import multiple orders at a time with a CSV file. 

Step 1: Download the template file 

  1. Go to Dashboard > Orders > CSV Import 
  2. Select the suitable options and click the respective links to download the right template:
  • Merchize: Regular orders
  • Order with label (TikTok, Walmart): Orders from TikTok, Walmart, or any other options that require a shipping label.
  • FBA: FBA orders

merchize csv import options

Note: For the Merchizem and Order with label import options, you have two template files:

  • Download example CSV: Required specific details about each order’s product title, types, colors, and sizes to import orders.
  • Download template using Merchize’s catalog products for orders: Required Merchize SKU to map your orders to the product from Merchize’s catalog precisely. 

Step 2: Fill in the order information

Regular template (from Download example CSV options)

Here is a list of the data you need for the CSV import. You have to enter the information in the Required fields and can leave the Optional fields blank.

  • mockUpFront (required)/ mockUpback/…: Link to the preview image.

Note: Your mockup files should be smaller than 4Mb. If your mockup file is larger than 4Mb, orders will fail to be imported.

  • designFront/ designBack…: Link to the printable file. This should be in the form of a URL image link (PNG or JPEG file). You can use any cloud services (for example, Google Drive, Dropbox, etc). Please make sure you have adjusted your settings to allow us to gain access to the file (Or you can upload it later on the order details page).
  • type (required): Example: T-shirt; Mug,…
  • title (required): Example: Women Black T-shirt; …
  • SKU (optional): For your reference only (Example: A unique identifier of the product).
  • size (required): Size of the particular line item.
  • color (required): Color of the particular line item (For products with no color base, for example, AOP products, you can add “White" to this field).
  • orderNumber (required): set custom order numbers in Merchize stores.
  • PrintingMethod (optional): Specify the preferred printing methods. This field is optional, and only applicable for products available with two printing options: DTG and DTF. You can only enter either “DTG" or “DTF" for each cell.

Notes: 

Add multiple items to the order
If the order has multiple items, you need to add single items for each row, and fill the same Order Number, Customer and Shipping Address information.
 
Add multiple orders in one sheet
You can add multiple orders in one sheet with different Order Numbers.
  • tag (optional): categorize orders using custom tags.
  • quantity (required): Quantity of the particular line item.
  • name, address1, city, state, country, postalCode (required): delivery recipient information.
  • address2, phone, email, tax (optional): additional delivery recipient information.
  • thankcard, brandkitA5clothes, brandkitA5, brandkitA6 (optional): Link to the Brand Kit design. Each column represents a Brand Kit option. Only provide Brand Kit design links for orders that apply Brand Kit.

Merchize SKU template (from Download template using Merchize’s catalog products for orders)

This template will require the following fields:

  • orderNumber (required)
  • merchizeSKU (required)
  • quantity (required)
  • quantity (required): Quantity of the particular line item.
  • name, address1, city, state, country, postalCode (required): delivery recipient information.
  • address2, phone, email, tax (optional): additional delivery recipient information.
  • thankcard, brandkitA5clothes, brandkitA5, brandkitA6 (optional): Link to the Brand Kit design. Each column represents a Brand Kit option. Only provide Brand Kit design links for orders that apply Brand Kit.

Step 3: Import orders

  1. Go to Admin Dashboard > Orders > Click CSV Import 
  2. Click “Import” button for the type of order you want to import (regular orders, orders with labels, or FBA orders)
  3. Select the CSV file you have completed using the available templates.
  4. Check the result.

Go to Order > More actions > Order import log to see if your order is successfully imported.

If you have an errored order, you will see it appear under the Failed tab.

Go to Orders > Click on the “Order number” to see the order details

Related articles