Create New Orders on SellerCloud by Excel or CSV File in Bulk

Last Updated on February 20, 2020 by

In this documentation, we will define how to bulk import new orders on SellerCloud by excel or CSV file step by step.

SellerCloud is a cloud-based solution for multi-channel merchants. Manage your inventory, orders, and much more! Normally SellerCloud synced the order from the marketplaces that are integrated with SellerCloud. Some marketplaces are not able to integrate with SellerCloud for those marketplaces order we need to generate manually or feed files. Also, if there is an old order or any physical orders, we need to create manually or by using excel/CSV files.

By using excel or CSV file you can easily upload many orders at a time and this will save your time. Today we will discuss how to upload orders by using excel or CSV files.

If you want to create manually order on SellerCloud, you may visit our another article – https://www.ecomclips.com/blog/how-to-create-new-orders-manually-in-sellercloud-interface/

Import new order by excel

For importing new orders on SellerCloud you just need to follow the below steps. 

Step 1 (Create an Excel with all Necessary Information): First, you need to prepare an excel sheet where you need to put all the necessary information using a header. 

Note: This is the most important step. Header name you can use any name and we just need to map the header name with the proper field, we will show the mapping in the below step.

Step 2 (Map the excel header with Sellercloud): Once logged into the SellerCloud, you can see that on the top side of the screen- SellerCloud features are grouped into categories that you can use. Click on “Import Mapping Tool” from Settings Tab.

After clicking Import Mapping Tool this will take you the Mapping Tool page. Click on Add New Mapping.

Step 3: Now you need to fillup the below details.

  1. Choose the company for which the profile will be used.
  2. Name the profile and select an Order Source for the orders imported under the profile. For example, Local Source, Website, or Wholesale.
  3. Select the Warehouse that these orders should ship from. Leave the Vendor dropdown blank. 
  4. Check the File contains headers box if the file contains headers.
  5. Check Order is Paid, if applicable.
  6. Click Choose File and upload the file. 

After completing the above click on Save.

Step 4: In this step, you need to map your file with SellerCloud fields. By following SellerCloud Column map your Customer Column.

 If any column you missed to add on an excel sheet that you can add on Custom Value. In that case, you need to choose _CUSTOM_VALUE_REQUERED_ from Customer Column.

Now Save Mapping. You have successfully completed mapping.

Step 5: Click on Import Orders from Orders. Here we will import our excel using the created template.

Step 6: In here you need to fillup the below fields.

Your import has been scheduled. You can monitor Schedule by clicking “Click here To monitor Schedule”.

Once completed the Status you can search your order on Channel Order.

Step 7:  If you want to make charging your order then click on Select Action and scroll down until you find Received Payments.

Select the Payment Method from the dropdown and add the Reference Number that you have.

Now you are all set. You have imported the orders on SellerCloud.

Hope this article will help you to import the new orders by using excel files, also this will save your time as well. If you need any assistance, please comment on the below section.  We would be glad to help you out.

Leave a Comment

BLOG CATEGORIES

BOOK FOR FREE CONSULTATION

Sign Up For Our Newsletter

Keep yourself updated with latest trends to maximize revenues across all of your sales channels.

POPULAR TAGS

What Clients Say About Us?

Wow, their team has been great! I have been working with freelancers and remote marketing agencies for about a decade and they are among the best.

Isaac Curtiss

Office Furniture Outlet INC.

Helped overcome difficult tasks that would have taken us a lot of time. We do recommend their services!

Blake Tanner

Tanner International INC.

I’ve been working with Fred and his team for the past few months and have been very happy with their work.

Dan Hawkins

Mixles Limited

Great help/addition to our business. All tasks are fully completed in a timely manner.

Maurice Embry

Sam Tucker LLC

Used for years now and wil continue to use for many more years. I also have no doubt recommending friends and colleagues to use too.

Nathan Reeves

Xenons Online Limited

Our company has worked with Ecomclips for over a year now. I’ve found the team to be very flexible, easy to coach, and adaptable. You won’t regret working with them.

Abraham Kwan

PG Incorporation

The team at Ecomclips has served all my needs with excellence. They are very attentive to my requirements. Communication is fast and crystal clear. I definitely recommend them.

PR

Right Parts Group INC.

So far I have hired Freddy and his team has been excellent, they are guiding me as grow my business. I will continue to work with them.

Bev Matushewski

FiTTeck INC.

Excellent friendly prompt service

Ahmedani

Ahmedani Canada INC.

We’ve been working with Ecomclips for a couple of years now and we are more than happy and appreciative of the their service. Definitely recommend.

Michael Burnley

Zooshoo INC.

A+++ Perfect!!

Imran Hassam

Amedeo Apparels Limited

RECENT BLOG POSTS

Add Custom Specification on Description Template of Sellercloud

In this article we will discuss about how to add Custom Specification on Description Templ

Read More

What is the Difference between Shadow and Kit on Sellercloud?

In this article, we will discuss the major difference between shadow and kits of Sellerclo

Read More

Detail Overview of Order Import Mapping tool in Sellercloud

In this documentation, we will define how to set up a mapping tool for any order import on

Read More