Importing Shopify products – Importing products using a CSV file

Importing products into Shopify can be very efficient; unfortunately, Shopify has its own quirks in this regard, which is why this guide can help you.

When setting up an online shop with Shopify, you eventually reach the point where you need to add your products to the shop.

Particularly in the case of large online shops, creating product listings manually often makes little sense, as the effort involved would be enormous.

Fortunately, Shopify offers a simple solution for this: the CSV import. Shopify provides a sample CSV file which you can download from its website.

This allows you to import products into Shopify, which promises to save you a great deal of time when dealing with a large number of items.

According to the instructions, the import process seems quite straightforward at first:

• 1.) Download the sample file
• 2.) Populating the CSV file with your own product data
• 3.) Uploading the CSV file to Shopify

Unfortunately, the process is often not as straightforward as it seems at first glance, as Shopify frequently encounters issues with the file format when importing the file.

Shopify requires a comma-separated CSV file for this.

A German-language version of Excel exports a comma-separated CSV file, but unfortunately uses a semicolon. Only the US version of Excel actually exports a CSV file with commas.

Excel experts can, of course, easily resolve this issue by reformatting the text in a text editor or by adjusting the computer’s language settings – however, for the vast majority of our customers, this is not a practical solution to the problem.

That’s why, in this article, we’d like to introduce you to a much simpler solution for the Shopify CSV import. As As a Shopify agency, we want to offer our customers the best and simplest service possible. That’s why we’ve created a Google Sheets template for importing data into Shopify, which you can easily fill in via your browser and then simply upload to Shopify. This makes it really easy for you to import Shopify products.

Instead of trying to format the CSV correctly and convert it into a format that Shopify accepts, you can simply use our Google Sheets template. To do this, follow these steps:

• 1.) You create a copy of our Google Sheet
• 2.) You enter the product details into the Google Sheet
• 3.) You download the file as a comma-separated CSV
• 4.) This CSV file is recognised straight away by Shopify without any problems

Import Shopify products – quick and easy

We hope our template has saved you a lot of your valuable time. If you’re still facing challenges with your online shop, why not book a free consultation, during which we can show you – with no obligation – how we can support you with your Shopify shop and help you increase your turnover. Whether it’s with SEO for Shopify, a Shopify blog or landing pages for your Shopify shop.