I've been working with thousands of store owners on Shopify, and from my experience, I must say that Shopify export products can certainly be a game-changer tool. Whether you want to make bulk edits to your products' information, back up your product data before any changes, or prepare for migration to another platform, exporting products on Shopify will definitely come in handy.
If you fall into these cases and want to leverage this tool, this article is just for you. In today's post, let's discover the step-by-step guide on:
- How to perform Shopify export products
- How to filter and export the Shopify product list
- How to export data on Shopify, including customer lists and orders
How to Perform Shopify Export Products
04 steps to export Shopify products
Shopify supports product exporting via CSV files. Please remember that if the number of products you want to export is less than 50, you can download the CSV file directly on your browser. In the other case, the Shopify export products file will be emailed to you.
Now that everything is well-noted, follow these steps to export products from Shopify.
- Step 1. From your Shopify admin dashboard, go to “Products” and choose “Export.”
- Step 2. In the pop-up dialogue, tick on what you want to export from Shopify. It could be:
- The current product page you are on
- All products in your inventory
- Only selected products
- Products that match your search
- Step 3. From the same dialogue as above, choose which CSV type you want to import:
- Choose the option “CSV file for Excel, Numbers, or another spreadsheet program” if you want to edit your product CSV file using a spreadsheet program.
- Choose the option “Plain CSV file” if you use a plain-text editor (like Visual Studio Code or Sublime Text) to modify your file.
- Step 4. When everything is ready, hit the “Export products” button to finish.
Shopify product CSV file explained
Now that you've learned how to export Shopify products, I believe it's essential to examine the CSV file and understand what each column means. This avoids any confusion and mistakes that could happen when modifying your data and ensures smoother Shopify import products later on.
Here's a breakdown of all the columns in your CSV files.
Column Name | Required? | Description |
Title | No | The title of your product. For example, Almond Butter. |
Handle | Yes | This value is created based on the value in the Title column. For example, if the value in the Title column is Black Sun Glasses, then the value in this column is black-sun-glasses. |
Vendor | Yes | The name of the store as you entered it when you created your Shopify account. For example, John's Apparel or johns-apparel. This is the same store name that you use when you log in to Shopify. |
Published | Yes | The default value is True, which means that this product will be published and available in the online store sales channel. Published can also be set to false, which means that the uploaded product won't be published. |
Option1 Name | Yes | The default value is Title if no value is set.
|
Option1 Value | Yes |
|
Option1 LinkedTo | No | If a product option is connected to a category metafield, then this value should be product.metafields.shopify.{taxonomy_attribute} |
Variant Grams | Yes |
|
Variant Inventory Qty | Yes |
|
Variant Inventory Policy | Yes |
|
Variant Price | Yes | The price of the product or variant. Only include the price and don't include any currency symbols. For example, 9.99. |
Variant Requires Shipping | Yes | The option to require shipping.
True indicates that the product is a physical product.
False indicates that the product is a non-physical product.
|
Variant Taxable | Yes | Applies taxes to this variant. |
How to Filter and Export Shopify Products List
In many cases, it's not necessary to export all your products on Shopify. If you just want to make changes to some of your items, you can add a filter and export a shortened version of your CSV file.
Here's a few simple steps to do so:
- Step 1. From your Products page, choose “Search and Filter.”
- Step 2. Select “Add a filter” and choose the option that only lists the products you want to export.
- Step 3. Put a tick on what you want to export, then hit the “Export” button.
How to Export Other Data on Shopify
How to export customers on Shopify
- Step 1. From your Shopify admin dashboard, navigate to “Customers” and choose “Export”.
- Step 2. In the pop-up, choose what you want to export, fields included, and file format. The process goes similarly to Shopify export products, so I hope you won't have any problems at this step.
- Step 3. When finished, click the “Export customers” button. The CSV file will be either downloaded right in your browser or sent via email.
For more information, please visit Shopify Help Center to learn more.
How to export Shopify orders
- Step 1. From your Admin dashboard, navigate to “Orders” > “Export”.
- Step 2. In the pop-up, choose the orders you want to export and your desired CSV file format.
- Step 3. Then, click “Export orders” to finish and wait for the CSV to be downloaded.
For more information, please refer to this guide on Shopify Help Center.
Shopify Export Products – FAQs
Can you export Shopify products?
Yes, certainly. Shopify offers a built-in tool to export products on Shopify with ease. Besides products, you can also export other entities like customers and orders for bulk editing.
How do I export a product list from Shopify to Excel?
Unfortunately, there's no direct way to export a product list from Shopify to Excel. You'll need to export it to a CSV file format first, then open it using Excel and save it under the .xml format.
How do I export everything from Shopify?
You can export products, customers, and orders on Shopify with ease, using its building tool. Simply follow these simple steps to export everything from Shopify:
1. From your Shopify Admin dashboard, choose the tab containing what you want to export (products, customers, or orders)
2. Hit the "Export" button
3. Select what you want to export and CSV file format
4. Click "Export products" / "Export customers" / "Export orders" correspondingly.
Can you transfer products from one Shopify store to another?
Yes, you can transfer products from one Shopify store to another. There are two different ways to perform this action, so choose one that best fits your needs and technical background:
- Method 1: Manually export data and import to a new store
- Method 2: Hire a certified Shopify migration expert, like LitExtension, to transfer all your products to another platform accurately and securely.
Key Takeaways
And that brings us to the end of our guide to Shopify export products. By mastering this feature, you can easily export essential entities for bulk edits, data backup, or data migration.
If you like this blog post, please don't hesitate to explore other Shopify-related articles on our websites. I believe they will be an invaluable resource for your business growth.
