fbpx
Drop Shipping Business
How to connect Shopify Shops to app.cjdropshipping.com
03/26/2018
CJ DropShipping US warehouse
CJDropshipping Service Fee
03/28/2018
Show all

How to Import an Excel or CSV Order

To submit orders coming from an e-commerce platform other than Shopify, you will have to manually import your orders using our Excel Template.

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.

Step 1: Login 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 are in your SKU List.

There are 2 ways to bring products into your SKU List:

  1.  Products that we’ve successfully sourced for you after you’ve posted your sourcing request
  2.  Products that you see in our website can be added to your SKU list when you’ve contacted your sales representative and let them know the SKU for the product you want to list under your SKU List, or please email the SKU to support@cjdropshipping.com, please indicate on the Subject Line: Add to My CJ SKU List + your CJ ID number or your CJ username.

Step 3: Under the “DropShipping Center” menu > left side panel  “Imported Orders” > top right corner click “Import Excel Order” > Select “Import New”.

Step 4: Click on the Excel File Icon.  Note: you can also choose the copy and paste option if you like.

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 VARIANCE, make sure the variance is included in the SKU.  For example: CJABCDEF12345-Red-XXL.
    • For products that have NO VARIANCE, make sure the “-default” is included behind the SKU number.  For example: CJABCDEF12345-default.
    • Variance 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 tap” 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 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” tap.  Check the orders that you would like for us to process, and click “Add to Cart”  to make the payment.

Please note, we can not process any orders prior to receiving payment on the orders.

Facebook Comments