Hey, ${email}, To make sure your account security, please verify your email address here. Verify Email
Language Flag / ${ currency.currency }
Flag ${ language.name }
${ f.name }
${ currency.currency }
${ c.currency }
Source More
  • Go to 1688
  • Go to Taobao
  • Go to AliExpress
Queue ${ queueNum }
Our Services




How to Import an Excel or CSV Order

Create Date: 2018-03-26 03:33:51 Last Edited: 2020-08-04 06:20:57

To place orders from an e-commerce platform other than Shopify conveniently, there is a way to import your orders using our Excel Template manually.

If you are using the Shopify platform, you can connect your Shopify store to our application and orders can be automatically retrieved into our system.

If you are using other platforms not integrated with us, please follow the steps below to submit orders to us.

Step 1: Log in to your app.cjdropshipping.com > click on My CJ

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

There are 2 kinds of products that can be added into your SKU List:

Step 3: Under the DropShipping Center > Imported Orders > Import Excel Order > Import New.

Step 4: Click on the Excel File Icon.  Note: you can also choose the copy and paste option or create orders if it's not a bulk order.

Step 5: Click Download next to Excel Orders Template to download our template > Click Confirm.

Step 6: Open up the Excel File 'CJDropshippingExcelOrderTemplate.xlsx'

Step 7: Do not remove/change the top row highlighted in green.

  • Order Number - Order Number from your e-commerce store
  • SKU
    • For products that have VARIANT, make sure the variant is included in the SKU.  For example: CJABCDEF12345-Red-XXL.
    • For products that have NO VARIANT, make sure the "-default" is included behind the SKU number.  For example: CJABCDEF12345-default.
    • Variant means the product may have different models, colors, sizes, etc.

After all the relevant field has been filled in, save the excel file.

Step 8: Go back to the CJ account, and click on Import Excel Orders> click on Upload > Confirm

Step 9:  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 you click on 'Confirm' you will see the order in the 'Process Required' as shown below.

Check the orders that you would like to proceed, and click 'Add to Cart'.

If our system detects an error in the excel file that you uploaded, please follow the steps below to fix the errors.

Step 10:  An error screen will pop up, click 'Confirm'.

Step 11: The screen 'Failed to Draft' will indicate the field that is erroneous with red underlines.  Make sure to fix ALL red underline fields before resubmitting.  When all the errors are fixed, check the orders you want to Import.

Step 12: Click 'Yes' to resubmit the orders

Step 13:  Orders that have been correctly submitted after you made the change will disappear from the 'Failed to Draft' page.

When you're done importing the orders, you will see it under the 'Process Required'. Check the orders that you would like for us to process, and click 'Add to Cart' to make the payment.

Please note, we can only process any orders after receiving payment on the orders.