Hey ${email}, to make sure your account security, please verify your email address here. Verify Email
Language Flag / ${ currency.currency }
Language
Flag ${ language.name }
${ f.name }
Currency
${ currency.currency }
${ c.currency }
Confirm
Source More
  • Go to 1688
  • Go to Taobao
  • Go to AliExpress
  • Go to Shopify
Queue ${ queueNum > 99 ? '99+' : queueNum}
Our Services
×

${CJPubTitle}

${CJPubtxt}

${articleTitle}

How to Import an Excel or CSV Order

1045 4 mins article
Date Created: 2020-12-29 11:31:24 Last Edited: 2021-7-16 9:30:9

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

Here are the general steps.

1. Log into your CJ account > Dropshipping Center > 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.

 

Here are the specific steps. 

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

 

Note:

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.

 

2. Click "Download" to download our template.

 

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

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.

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

 

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

 

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

 

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

 

Tick the boxes on the left to select orders, click 'Update' when you have completed the instructions in 'Action', and orders will be moved to Imported Orders.  

 

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

                                                                                                                   

                                                                                                                      Contact Us