How do I import a CSV file into Shopify customers?

From your Shopify admin, go to Customers. Click Import. Click Add file, and then select your customer CSV file . Optional: To update any existing customer profiles, check Overwrite existing customers that have the same email or phone number.

EasyCSV enables you to send spreadsheet data to any app Zapier supports . EasyCSV is also the only app that enables you to create CSV files you can use in your Zap, email the file as an attachment, or upload it via SFTP.

Can I import products to Shopify?

If you want to transfer a large amount of product information between Shopify and another system, then you can use a specially-formatted spreadsheet to import or export that data . Shopify uses CSV (comma-separated value) files to perform this kind of bulk task.

What does import mean on Shopify?

When you import a product to your store, you can adjust product details in your Shopify admin, but you can't edit the product's price . The following product information is imported from a supplier's store to your store: price. inventory. product title.

What is the CSV limit for Shopify?

csv file, there is a file size limit of 15MB per file for products and inventory, and 1MB per file for customer data . If your . csv files are larger than these limits, then you will need to import the information in batches.

Does Shopify have a CSV file?

You can download Shopify's sample CSV file to get started . This file has a few product examples with all the different Shopify fields (or categories) that you can use to create your own Shopify CSV. From here, you'll need to go in and fill in your product information.

Can customers upload Files to Shopify?

Uploadly - File Upload is your kit to add powerful upload fields to your product pages . Let customers choose photos, images and files from their computer or mobile device!

Does Shopify have a customer database?

Every time a new customer places an order with your store, their name and other details are added to your customer list . You can review all of your customers and manage your customer information from the Customers page of your Shopify admin and the Shopify app.

Can you add custom orders to Shopify?

You'll have to make some changes to your Shopify store's product section to start accepting custom orders : Variants: Shopify's built-in product variant feature lets you offer different versions of your products. You can create variants for a product that comes in multiple options, like size or color.

How To Import Customers And Orders To Shopify [Apr, 2024] (2024)

Customers, orders, and product data are among the cornerstones of a revenue-generating store. Therefore, “how to import customers and orders to Shopify” is one of the most common concerns that you might have when transferring your data to Shopify.

In this article, LitExtension – #1 Shopping Cart Migration Expert will show you the simplest ways to perform Shopify import orders and customers:

Step 1: Export data from the source store
Step 2: Add LitExtension App from the Shopify App Store
Step 3: Set up Source Cart and Target Cart
Step 4: Select entities to migrate
Step 5: Run data migration

Export Customers & Orders from the Source Store

You must use Shopify CSV to export customers and orders from the source store. Bear in mind that each source cart has different ways to export data via CSV files, and you should refer to the corresponding document to learn more about this process.

For example, a Shopify CSV for customers' information should include the following fields.

Headers	Information
First Name	The first name of the customer.
Last Name	The last name of the customer.
Email	The email address of the customer.
Company	The name of the company that customer uses (if applicable)
Address1	The first line of the customer's address.
Address2	The second line of the customer's address(if necessary)
City	The city where the customer lives.
Province	The province or state where the customer lives. You must also enter the Province Code
Province Code	The province or state ISO code. Shopify uses ISO alpha 2 codes.
Country	The country where the customer lives.
Country Code	The country ISO code. Shopify uses ISO alpha 2 codes.
Zip	The postal or zip code for the customer's address.
Phone	The customer's phone number.
Accepts Marketing	Indicating whether the customer agrees to subscribe to email marketing, such as a newsletter. Valid entries are yes or no.
Total Spent	The customer's total amount spent. Valid entries must not include a currency symbol. This field will not be imported with customer details.
Total Orders	The customer's total number of orders. This field will not be imported with customer details.
Tags	A comma-separated list of tags used to tag the customer (for example, tag1,tag2,tag3).
Note	Additional information about the customer.
Tax-Exempt	Indicates if the customer is tax-exempt.

⚠️ Please note that it is unable to export existing customers' passwords since they are encrypted outside of Shopify. If you don't want your customers to lose their accounts after the Shopify migration, please consider our “Customers Password Migration” service.

There are also specific requirements for Order CSV files. Orders with multiple line items are displayed on separate lines. To indicate that multiple items were purchased in the same order, many of the fields are left blank.

If you want to import customers and orders to Shopify, you must export your CSV files in UTF-8 format. Fortunately, most spreadsheet applications are capable of saving CSV files in UTF-8 format using the “Save As” or “Export” command.

If you need any further explanation and support, please get in touch with our support team to ease the process. After your data is in the correct CSV format, you can import customers and orders to Shopify.

Power Your Vision on Shopify with LitExtension

Our team of experts can safely import your customers and orders to unlock more growth on Shopify's robust platform. Let us streamline your store's import for success.

Schedule a Free Consultation

Import Customers and Orders to Shopify with LitExtension App

If you want to save time, why don't you import customers and orders to Shopify with LitExtension – the #1 Shopping Shopping Cart Migration Expert?

By using our Shopify migration service, you can automatically and securely transfer customers and orders to Shopify in only 3 steps without having to configure your data manually.

Why LitExtension?

Here comes a comparison between the LitExtension data migration solution and other methods:

LitExtension import customers and orders to Shopify via API.
If you import with LitExtension, product links to the category & order will be preserved.
protect your SEO rankings.

Now, let's see how quickly and easily our solution can help you!

First, go to the Shopify App Store and search for the LitExtension Store Migration app. Then, add this plugin to your Shopify store, and you will be ready to start your migration with us.

Step 1: Set up the Source and Target Store

First, you will see a page where you can enter the information of your Source and Target Cart as below. There are various shopping cart options you can choose from.

Choose your Source Cart from the drop-down menu and insert the store URL. The setup requirements will depend on the Source Cart type. For example, with Magento, you will have to download the “LitExtension Connector“ to your computer – a bridge that connects your cart database with the LitExtension App.

Once you are done, a notification will appear on the screen – “Connection was successfully installed”.

How To Import Customers And Orders To Shopify [Apr, 2024] (2)

Fortunately, when migrating with the LitExtension app, your Shopify store's information is automatically filled in the “Target Cart Setup” field. You can proceed straight to the migration process without having to manually connect to Shopify.

Then, click “Next: Configure your Migration”.

How To Import Customers And Orders To Shopify [Apr, 2024] (3)

Step 2: Select Entities to Migrate to Shopify

In this stage, you can choose the entities that you want to migrate to Shopify. LitExtension supports various types of data: products, pages, blogs post, coupons, etc. Make sure to tick on Customers, Orders, and other data types as you require.

How To Import Customers And Orders To Shopify [Apr, 2024] (4)

To help you extend your migration possibilities, LitExtension also offers Additional Options, Order Status and Language Mapping. Therefore, remember to choose other options in accordance with your business needs and requirements.

Step 3: Import Customers and Orders to Shopify

LitExtension encourages you to runFree Demo Migration first to actually visualize the migration process. You can skip the demo process and jump right into Full Migration. The dashboard should look like this:

How To Import Customers And Orders To Shopify [Apr, 2024] (5)

Once the migration starts, the LitExtension solution will run seamlessly on the server without a browser connection. Therefore, feel free to have a cup of coffee and get back when you receive an email notification if the process is complete.

Additionally, your current eCommerce store can still be up and running during the full migration. So, there will be no loss in revenue!

Save Time Importing Data to Shopify

Trusted specialists streamline data import processes that actualize ambitions

Personal Assistant
Unlimited free demo
Personalized migration
Free additional options

Get a Free Consultation

How to Import Customers and Orders to Shopify By Hand

Manually perform the Shopify import customers

1. From the Shopify dashboard

Navigate to the “Customers” tab on the left side of your dashboard after logging in.

How To Import Customers And Orders To Shopify [Apr, 2024] (7)

Choose the “Import customers” button at the bottom of the page.
Click on the “Add file”button to import your CSV files from your computer.
Finally, press the “Import customers”button.

How To Import Customers And Orders To Shopify [Apr, 2024] (8)

You can only import 1MB or less of customer CSV files. To get around this limit, you can import your customer records using several CSV files. For more details, you can take a look at our article on Shopify CSV Import.

2. Using the Store Importer app

Go to Shopify App Store to find the Store Importer app > Add app, then Install the app in your Shopify dashboard.
On the Import your data into Shopify page, select your current shopping cart (source cart) from the drop-down menu.

How To Import Customers And Orders To Shopify [Apr, 2024] (9)

Under Upload files, you should clickAdd file and select your exported files. You can select any number of CSV files.
Click Continue import > Import.

Important note:Shopify has stopped supporting this Store Importer app since early 2023. If you want to import customers and orders to Shopify, please refer to other methods in this article.

How to import orders into Shopify manually

Currently, it's impossible to manually perform Shopify import orders, so users may need to find other ways to do this. You can use third-party apps or use the app that Shopify has exclusively provided. Each method has its pros and cons, we will give you specific information so that you can make a choice that suits your needs.

1. Using a third-party app

Choosing a good app to start importing orders into Shopify is difficult for those who lack knowledge. Don't worry! We have a suggestion for you: EZ Importer – Order Importer.

EZ Importer enables you to bulk import orders to Shopify easily via CSV. You won’t have to waste time adding fields to Shopify by hand. This app provides a customer data mapper to map the field headers in your CSV with Shopify's order fields.

Moreover, you don’t have to worry about your CSV files and “upload data not found” by using Shopify defaults feature. Specifically, this is how it works in 3 simple steps:

Upload your CSV files.
Map the headers of your CSV files to the appropriate Shopify fields.
Review and import your data!

💡 Explore more: EZ Importer – Order Importer on Shopify App Store

2. Using the Transporter app (Shopify Plus)

The Transporter app is an application used to perform Shopify import orders from CSV to Shopify Plus. Accordingly, you won't have to worry about modifying the form of CSV files that Shopify requires. This can save a lot of your time as there is no need to manually edit these files.

Particularly, the Transporter includes 2 main tools:

Transporter command-line tool: Used to export and convert data from a supported platform into a CSV file.
Transporter app: Used to enter order data into Shopify. This app uploads CSV files and is available from the Shopify App Store.

However, when using this app, your CSV files must at least include the object type name and use UTF-8 encoding.

💡 Explore more: Shopify Transporter App on Shopify App Store

Unsure that your order and payment process work perfectly after Shopify import orders? Here are two ways you can do to check if it runs smoothly.

1. Test with Bogus Gateway to simulate a transaction
2. Place a real order, then cancel and get a refund

💡 To learn more about how to do a test order on Shopify, please refer to this document.

Why Should You Move to Shopify?

Have you ever wondered, is Shopify worth it? Well, the answer is yes, and here are the reasons why.

Firstly, Shopify is fairly simple to use. It is built for everyone, from eCommerce experts to complete newcomers. You don't need any website development experience to set up a fully functional online store with Shopify.

Here are a few steps you could follow to get started on Shopify with no technical knowledge or coding skill required.

Go to the Shopify homepage and create an account
Select the best Shopify theme and customize it to your liking
Set up crucial eCommerce functions (such as shipping, payments,…). At this stage, you can integrate with other third-party apps on the Shopify App Store to enhance the functionalities of your store.
Purchase a Shopify pricing plan and publish your store.

Secondly, you can try all the powerful features that Shopify has to offer (including premium Shopify themes) for 3 days for free to catch a glimpse of how this platform works. Moreover, you can also make use of Shopify's “$1/month for 3 months” deal to save a huge amount of cost.

Regarding Shopify pricing, currently, there are 3 main pricing plans, including Basic Shopify, Shopify, and Advanced Shopify. Each plan's key differences are summarized in the table below:

	Basic Shopify $39/month	Shopify $105/month	Advanced Shopify $399/month
Transaction Fees *if not using Shopify Payments	2.9% + 30¢ online 2.7% + 0¢ offline	2.6% + 30¢ online 2.5% + 0¢ offline	2.4% + 30¢ online 2.4% + 0¢ offline
Staff Accounts *assign & manage staff's activities	up to 2	up to 5	up to 15
Report Systems	Basic reports	Professional reports	Custom reports
Workflow Automation *automatically manage &operate stores	—	fully supported	fully supported
Shipping Discount *shipping subsidies withleading carriers	up to 77%	up to 88%	up to 88%
Duties and import taxes	—	—	fully supported
Third-party calculated shipping rates	—	—	fully supported

We recommend you go for Shopify or Advanced Shopify for outstanding features, including lower transaction fees, more staff accounts, advanced report systems, excellent workflow automation, and more inventory locations. For example, with the Advanced Shopify plan, you can customize the report systems to see what exactly you need!

Moreover, the platform also ensures satisfaction even for large stores, thanks to a collection of great plugins and applications. You can watch our latest Shopify Review and dive deeper into the cart here:

If you're selling elsewhere, migrating to a Shopify store could be beneficial. A proper Shopify migration will save you much effort in building a new store.

Import Customers and Orders to Shopify – FAQs

Can I import orders to Shopify? / Can I import customers to Shopify?

Yes, you can. There are 3 ways to import customers, products, and orders into Shopify. You can do so via separate CSV files, third-party apps, or LitExtension Shopify migration solution. As a whole, LitExtension automated solution will save you the most time and effort because you won't need CSV files to import. Explore more about our

How do I import past orders into Shopify?

Click Apps > Import store from your Shopify admin. Select Shopify from the drop-down menu on the Import your data into Shopify page. Click Add file under Upload files and select your exported files. You can select an unlimited number of CSV files.

Can I manually add orders to Shopify?

You can also manually create orders in your Shopify admin to record orders made outside of Shopify or to send invoices to your customers. Shopify's Orders page is where you manage all of your store's orders.

Can you import HTML into Shopify?

Shopify does not allow you to directly add an HTML file to the root directory of your store. However, you can verify your Shopify store with Google by editing the theme code and adding an HTML meta tag.

Conclusion

Overall, we have shown you how to import customers and orders to Shopify with manual importing, Shopify apps, and LitExtension solution.

Each method has its advantages, but you will save a lot of resources with LitExtension automated solution. Apart fromimporting customers and orders, don't forget to take a look at our tutorial on how to import products to Shopify with a few simple steps. Additionally, here is how to transfer domain to Shopify if you're interested.

Overall, if you find Shopify import orders and customers process too difficult and time-consuming, contact us to migrate data at LitExtension – #1 Shopping Cart Migration Solution. We provide data transfer from one platform to a more powerful one with excellent service and 24/7 support.

If you like this article, don't forget to visit our LitExtension blog to find more topics like this. And, let's join our Facebook Community to get more eCommerce knowledge.