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
Queue ${ queueNum }
Our Services
×

${CJPubTitle}

${CJPubtxt}

cjdropshipping

How to Import an Excel or CSV Order?

Create Date: 2018-03-26 03:33:51 Last Edited: 2020-12-04 07:57:38

If you do not have a store or website connected with our platform, your orders still can be dealt with through importing Excel Template manually.

Here are the general steps.

1. My CJ > DropShipping Center > Imported Orders > Process Required;

2. Import Excel Order > Import New > Click the "Excel file" Icon;

3. Click "Download" to download our template;

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

5. Go back to My CJ > Import Excel Orders> Upload the edited Excel > Confirm.

Please watch the video for understanding.


Here are the specific steps. 

1.Please go to My CJ > DropShipping Center > Imported Orders > Process Required;

Note: Before importing any excel orders, please make sure that the products you want to order from us have been added to your SKU List.    




2. Import Excel Order > Import New > Click the "Excel file" Icon;  

Note: You can also choose the "Copy paste" option or create orders if it's not a bulk order.  


3. Click "Download" to download our template;  


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


Note 1: 

  • Please do not remove/change the top row highlighted in green.
  • Order Number - Order Number from your e-commerce store
  • SKU 

    1). Variant means the product may have different models, colors, sizes, etc. 

    2). For products with VARIANTS, please make sure the variants are included in the SKU. For example: CJABCDEF12345-Red-XXL.

    3). For products that have NO VARIANT, make sure the "-default" is included behind the SKU number. For example: CJABCDEF12345-default.

After entering the necessary information, please save the excel file.


Note 2:
Our POD products can also be imported through excel. Please enter information in the "pictures" and "texts" sections. Uploading images cannot meet the requirement and you need to enter the URL of the picture. We recommend you transfer the file format by the website SM.MS.




5. Go back to My CJ > Import Excel Orders> Upload the edited Excel> Confirm;  


If you are have successfully filled in the excel template, you will see a screen that popped up showing the number of orders successfully imported. After clicking "Confirm," you will see the order in the "Process Required" as shown below. Please check the orders and click "Add to Cart" to pay.



If our system detects an error in the excel file, please follow the steps below to fix the errors. Please click “Confirm.” Wrong information will be underlined in red in the “Failed to Draft” section > fix ALL red underline fields > Click “Yes” to resubmit the orders.




Orders that have been correctly submitted after you made the change will disappear from the "Failed to Draft" page.


Feel free to contact us if you have any other doubts.