Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Importing product data can save you a lot of time in comparison with manual entry. You may already have a list of products in a spreadsheet. It is often easier to edit a spreadsheet and import the product data.

This article covers:

Overview

A CSV file typically contains a set of records, each of which is a set of fields that are separated by commas. You can import a CSV file contain a list of product records.

There are two approaches to importing product data, add records to a sample CSV file or export product data to a CSV and edit that file. After editing a CSV file and saving it, you can import your product data. Follow the instructions in the sections below.

Being by clicking the Import button to view the Import Jewelry Products page.

Create a new CSV file

Follow these steps to create a new CSV file:

  1. Click the Sample CSV button to download and view the sample CSV file.

  2. Open this file in a spreadsheet application to view the header row and two example rows (records).

  3. Add product records to that file, being careful to enter the data so that it matches the other data in the same column

  4. Remove the two sample records at the top of the file.

  5. Rename the file and save it, preserving the .CSV filename extension.

Export existing products to a CSV file

  1. To export all of your existing product data to a CSV file, Click the Export Data button.

  2. Open this file in a spreadsheet application to view all of your product records.

  3. Edit any of the records, being careful to enter the data so that it matches the other data in the same column.

  4. Add product records to that file.

Export Product Data

To export any product data that you already have on your website, click the Export Data button and then click the link in the green alert box.

Open this file in a spreadsheet application to view all of your product records. Edit any field of any row, ensuring that the data you enter matches the pattern for that column.

Import the edited product data CSV file

In the Import your product data section, check the boxes to enable the constraints you want to apply when you import the CSV file.

When your CSV file is ready, click the Find CSV File button, locate the file, and click the Open button to upload it. Then, click the Import CSV button to import the contents of the CSV file.

  • No labels