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}

cjdropshipping

How to Import an Excel or CSV Order?

Create Date: 2020-11-25 10:33:44 Last Edited: 2021-03-30 09:54:31

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. Login in your CJ account> DropShipping Center > Imported Orders > Click the icon;

2. Click "Download" to download our template;

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

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


Here are the specific steps. 

1. Please Login in your CJ account > DropShipping Center > Imported Orders > Click the icon;



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. Click "Download" to download our template; 

Note: You also have an option to create orders if it's not a bulk order. 



3. 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 

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

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

 c. 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.




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



After you upload the excel, the window "Note" will pop up to mention the upload situation. Here you can check the number of failed orders. Please click "Failed Orders" to check the error.



Then it will enter the page with the reasons and operations that you need to do. Please check it and click the operation (Add to SKU list, for example) to revise the order. Then please click "Update". Then the order will be synced to the Imported Orders



Please check the imported excel orders in Imported Orders and click "Add to Cart" to pay.

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

 START & SCALE YOUR BUSINESS WITH CJDROPSHIPPING