Hey ${desensitizationEmail}, to make sure your account security, please verify your email address here. Verify Email
For your account security, please link your email. Verify Email
Drag or upload an image to search.
0
Video Gallery
Queue0
Our Services
CJ Platform
Order Fulfillment
Warehousing
Shipping
Pro Services
  • Products Automatic Listing
  • Product Reviews Importing
  • Product Connection
  • PayPal, Credit Card Payment
  • Automatic Invoice
  • Tracking Number Setting
  • Multiple Store Management
  • Store Transfer
  • Print on Demand
  • Multiple Staff Accounts
  • Chrome Extension
  • Mobile APP Processing
  • CJ API for Developers
  • CJ Wallet with 2% Discount
  • Improper Products Report
List products to your store automatically.

${articleTitle}

How to Import an Excel Order?

18800 4 mins article
Date Created: Dec. 29, 2020 19:31:24 Last Edited: Aug. 24, 2023 10:20:38

If you do not have a store or website connected with our platform, you can import orders via Excel files.

Here are the general steps.

1. Log into your CJ account > Orders > Imported Orders > Click the icon .

2. Click "Download" to download our template.

3. Fill in the order details.

4. Go back to My CJ > Imported Orders > Upload the edited Excel.

 

Log into your CJ account > Orders > Imported Orders > Click the icon     

Click "Download" to download our template

 

Open the Excel File at the bottom and enter the necessary order information.

 

Go back to My CJ > Imported Orders> Upload the edited Excel.

 

Note 1: 

a. Please do not remove/change the top row highlighted in green.

b. Order Number = the order number from your store.

c. As for products with variants, please make sure the variants are included in the SKU. For example: CJABCDEF12345-Red-XXL instead of CJABCDEF12345; or CJJD118270901AZ instead of CJJD1182709.

d. As for products without variants, please make sure the "-default" is included behind the SKU number. For example: CJABCDEF12345-default.

 

Note 2:
1. Our POD products can also be imported via excel sheets.
2. You can enter the URL to upload the product image. File format can be converted here: SM.MS.
 
 

 

Note3:

a. For orders shipping to the EU countries, you should fill in your tax number.

 

b. If you want to apply the CJ's IOSS, you should set it up in 'Edit Address' after uploading the Excel. Please be noted that you should set the IOSS options in your Profile before setting up.

 

 

Note 4:

a. Before uploading excels, please make sure that the products have been added to your SKU List.

b. You can also create orders by searching for products. 

c. Once imported successfully, orders can be found in Imported Orders and you can click "Add to Cart" to pay.

d. You can click 'Failed Orders' to find out the reasons for the failure when importing completed.                                                                                                        

If you have more doubts, you can contact us.