Add Products Faster With Product CSVs

Add Products Faster With Product CSVs

shopify upload product csv

Shopify is a powerful platform, which makes it easy to build a beautiful online store quickly. One way to make that process even quicker is importing products via CSV. A CSV file, also known as comma-separated values file, stores tabular data (numbers and text) as plain text. Importing product data via CSV can speed up your design or development process by providing data to populate your store quickly—instead of copying and pasting lorem-ipsum text into product descriptions, and searching for photos.

Great news! We’ve compiled a set of product CSVs which contain high quality images and product data, such as variants, that you can import into a Shopify store. These product CSVs provide high quality product data for design and testing purposes, and you can use them to build themes and stores on Shopify. The product CSVs and images we’ve compiled cover the following product categories:

  1. Apparel
  2. Jewelry

Even if your current project focuses on another vertical, using realistic product photos in your prototypes and mockups can really help your client visualize the final product.

So, how can you start using these resources? You can download, clone or fork them from a repository hosted on Github.

Disclaimer: These images are from Burst, a stock photo website run and maintained by Shopify. They can be used for commercial or non-commercial use in accordance with the Creative Commons license, and the Burst Terms of Service.

How to import a product CSV

To start a product CSV import, navigate to the Products page in the Shopify Admin and click on ‘Import’ found in the top left hand corner, under the title of the page:

shopify upload product csv - import products

Clicking on import will open a modal window with the option to upload a CSV file.

shopify upload product csv - import product modal window

Click the ‘Choose File’ button and select the product CSV file you would like to use for your store. I will be using the `apparel.csv` as an example in this article.

shopify upload product csv - choose file modal

Click ‘Upload file’. Once you’ve confirmed that the data you are importing looks correct in the preview (i.e. the title of your product, description and type shows up in the right place), click ‘Start import’ to import the CSV file.

shopify upload product csv - preview modal of product csv import

Depending on the CSV you select to upload, the import should take less than 5 minutes to populate your store. Once the import is finished, you will see the imported products in your store with real product descriptions, variants, and thumbnails. With this newly populated data, you can start building the store’s theme using real images and data, and test all the variations.

shopify upload product csv - shopify admin product view

Above, you can see a product that’s been imported to the store via CSV file. Below, here’s that same product in ‘View’ using the free Debut theme by Shopify:

shopify upload product csv - debut theme product view

You might also like: Using Placeholder Images for Products with the placeholder_svg_tag filter.

Product images

Alternatively, you may be working on a design concept for a client and need some quality product images before you start writing a line of code. You can find all the product images for download on the Burst website, along with many more not included in the CSV files. Simply search ‘products’ on Burst to see hundreds of product images free to use in your designs and prototypes.

shopify upload product csv - shopify stock photography website, Burst

Sketch Shopify Data Populator

If you’re designing your concepts in Sketch, you may also want to check out how you can work with dynamic product data and images using our Sketch Shopify Data Populator. Build your layout as you would normally and populate the product content with the plugin—it’s really that easy!

To learn more about the plugin, check out our post accompanied with a step by step how-to video tutorial: 3 Easy Steps for Working with Realistic Data in Sketch Using JSON.

Automate with Developer Tools

Automate data importing with Developer Tools for macOS. Importing a store with data can be lengthy task that cuts into your development time.

With Developer Tools’ data generator, you can populate your development store quickly. Simply download the Developer Tools app, connect it to your Shopify stores by logging in with credentials or with an access token, and start using the data generator right away.

developer tools: test store
An example of a realistic looking Shopify test store, built quickly using the data generator in Developer Tools.

An example of a realistic looking Shopify test store, built quickly using the data generator in Developer Tools.

You might also like: Working with Product Variants When Building a Shopify Theme.

Tools to develop faster

We hope that the resources we develop and share with you save time and help you become more productive. Importing real product data can be helpful to demo a store, so get started today using these free CSV imports!

HTML CSS and JavaScript are the client-side elements of each website. Learn them to become a web developer.

Is there is a specific resource you’re looking for? Let us know in the comments below.

About the Author

Tiffany is a Front End Developer Advocate Lead at Shopify. She specializes in front end development, user experience design, accessibility, and is passionate about inspiring young designers and developers. Previously, she was an Ottawa Chapter Lead for Ladies Learning Code and worked as a Front End Developer for Partnerships at Shopify.

Grow your business with the Shopify Partner Program

Learn more