How to import orders with the CSV template?

2026-11-04 11:58:27
1397







Step 1: Select the order type of Offline order CSV; Download [Offline order improt template] at the bottom of the page.

Order List page under Order Management with the CSV order import button highlighted in red.

CSV order import page with the Offline order CSV option and the offline order import template link highlighted.

Step 2: Follow the guide below to fill out the order details:

The Printable Design Area and Size Requirements fields are marked as Print on demand¹. Fill in the CSV form as follows:

Platform Order ID: Your platform order ID filled in when placing an order, required

Style Code: Please click on the style number in the product library list to inquire about product details. Required fields

Quantity: The quantity of a specific order item

Product Name: Required

Email: Email format must be used, optional

Phone: Customer phone number, optional

Prcipient Name: Recipient name, required

Country: The shipping address is the customer's Country, please convert it to Alpha-2 country code, required

Province/State: The province/state where the customer is located, required

City: The customer's city is the delivery address, required

ZipCode: zip code of customer mailing address, required

Address: Customer's delivery details, required

Country Code: Customer country code, required

Shipping ID: Find the shipping number in "Shipping Information Query", required

Design:Provide links to design material drawings of products, limited to 20, use multiple drawings "," isolation

Mockup:Provide links to renderings of products, limit 20, use multiple pictures "," isolate

Embroidery Mockup:If you wish to add embroidery, please fill this out.

Embroidery Design:If you wish to add embroidery, please fill this out.

Mockup _ Front: No need to fill in

Mockup _ Back: No need to fill in

Mockup _ Left:No need to fill in

Mockup _ Right:No need to fill in

Design _ Front:No need to fill in

Design _ Back:No need to fill in

Design _ Left: No need to fill in

Design _ Right:No need to fill in

Design _ 1~50:No need to fill in

The Size Requirements field is labeled Access to templates². Fill in the CSV form as follows:

Platform Order ID: Your platform order ID filled in when placing an order, required

Style Code: Please click on the style number in the product library list to inquire about product details. Required fields

Quantity: The quantity of a specific order item

Product Name: Required

Email: Email format must be used, optional

Phone: Customer phone number, optional

Prcipient Name: Recipient name, required

Country: The shipping address is the customer's Country, please convert it to Alpha-2 country code, required

Province/State: The province/state where the customer is located, required

City: The customer's city is the delivery address, required

ZipCode: zip code of customer mailing address, required

Address: Customer's delivery details, required

Country Code: Customer country code, required

Shipping ID: Find the shipping number in "Shipping Information Query", required

Design:No need to fill in

Mockup:Provide links to renderings of products, limit 20, use multiple pictures "," isolate

Mockup _ Front: No need to fill in

Mockup _ Back: No need to fill in

Mockup _ Left:No need to fill in

Mockup _ Right:No need to fill in

Design _ Front:No need to fill in

Design _ Back:No need to fill in

Design _ Left: No need to fill in

Design _ Right:No need to fill in

Design _ 1~50:Please download our template and Design your material map in this template. Fill in the corresponding Design link of the material map according to the serial number of the cut piece in the template. Example: https://youtu.be/eoLNRFJT2ZQ


Size Requirements field is labeled Front: 4724*7087px, Back: 7087*7087px... Fill in the CSV form as follows:

Platform Order ID: Your platform order ID filled in when placing an order, required

Style Code: Please click on the style number in the product library list to inquire about product details. Required fields

Quantity: The quantity of a specific order item

Product Name: Required

Email: Email format must be used, optional

Phone: Customer phone number, optional

Prcipient Name: Recipient name, required

Country: The shipping address is the customer's Country, please convert it to Alpha-2 country code, required

Province/State: The province/state where the customer is located, required

City: The customer's city is the delivery address, required

ZipCode: zip code of customer mailing address, required

Address: Customer's delivery details, required

Country Code: Customer country code, required

Shipping ID: Find the shipping number in "Shipping Information Query", required

Design:No need to fill in

Mockup:No need to fill in

Mockup _ Front: According to the surface you need to design, fill in the rendering link here,only one can be filled.

Mockup _ Back: According to the surface you need to design, fill in the rendering link here,only one can be filled.

Mockup _ Left:According to the surface you need to design, fill in the rendering link here,only one can be filled.

Mockup _ Right:According to the surface you need to design, fill in the rendering link here,only one can be filled.

Design _ Front:According to the surface you need to design, fill in your material map link, only one can be filled in.

Design _ Back:According to the surface you need to design, fill in your material map link, only one can be filled in

Design _ Left: According to the surface you need to design, fill in your material map link, only one can be filled in.

Design _ Right:According to the surface you need to design, fill in your material map link, only one can be filled in.



Note:

When you fill in Mockup _ Front, the corresponding Design _ Front is required.

Do not change the contents of the first line and fill in all required fields.

Get the variant link:

API/CSV Products page with the Style Code column for each product highlighted in red.

Step 3: After the csv is completed, upload the file to CatKissFish; And check whether the documents are filled out correctly;

CSV order import page with the Offline order CSV option highlighted above the file upload area.

If there are any wrong items, you can click above to view the reason for the error in the guide order and correct it and re-upload it; Or delete the wrong item directly and click to submit the correct data;

CSV import record page with the Import Record tab and View Results link highlighted beside an invalid row.

Import Record page with the Delete button and the Not filled quantity field highlighted for wrong items.

You can view information about errors and results. Cells entered incorrectly will show three states:

Not filled in: Value required.

Invalid: Bad format.

Step 4: Submit and pay on the order page.

Order List page with the status of a successfully imported order highlighted in green.


Other relevant information:

How to classify and manage accessories?

How do I place an order for items with embroidery?







print on demand
$240 OFF
For New
Work Orders
Help center