CSV 파일을 사용하여 제품 가져오기 및 내보내기
CSV(쉼표로 구분된 값) 파일을 사용하여 제품을 Shopify 스토어로 가져오고 스토어에서 제품을 내보낼 수 있습니다. CSV 파일을 사용하면 한 번에 많은 수의 제품 및 세부 정보를 가져오거나 내보낼 수 있습니다. 따라서 Shopify와 다른 시스템 간에 제품 정보를 교환하려는 경우에 유용할 수 있습니다.
CSV 파일 열기 및 편집 방법에 대해 알아보기
샘플 CSV 파일 다운로드
템플릿으로 사용할 샘플 제품 CSV 파일을 다운로드하여 확인할 수 있습니다.
샘플 파일에는 예제 제품과 몇 가지 이형 상품이 들어 있습니다. 가져오기 파일에는 보통 더 많은 제품과 이형 상품이 포함됩니다. 샘플 파일을 사용하여 가져오기 파일을 직접 생성하는 경우 모든 예제 제품을 제거해야 합니다.
샘플 파일에는 위치가 하나인 스토어에만 사용되는 Variant Inventory Qty 열이 포함되어 있습니다. 여러 위치를 사용하는 경우 재고 수량을 가져오거나 내보내려면 재고 CSV 파일을 사용합니다.
제품 CSV 파일의 고려 사항
제품 CSV 파일을 사용하기 전 다음 고려 사항을 검토하십시오.
제품 CSV 파일의 서식 지정
제품 CSV 파일이 올바르게 작동하려면 다음 기준을 충족하는지 확인해야 합니다.
제품 CSV 파일의 첫 줄에는 제품 CSV 설명 표에 지정된 대로 열 헤더가 와야 합니다.
각 열은 comma로 구분해야 합니다.
제품 CSV 파일의 필수 열
필수 열은 아래의 조건에 따라 포함되어야 합니다.
제품 CSV 파일을 생성하여 신규 제품을 가져오려는 경우에는 Title만 필수 열입니다.
CSV 파일을 사용해 제품을 업데이트하려는 경우의 필수 열은 Handle 및 Title입니다.
제품 CSV 파일에서 값을 반드시 포함해야 하는 열
Title 열 외의 일부 열에도 값이 필요한 경우가 있습니다. 값이 필요한 열이 공란으로 비어 있으면, 다음과 같은 경우 기본 값이 자동으로 생성됩니다.
- 열이 있지만 해당 열의 값이 공란인 경우
- CSV 파일에 열이 없지만 값이 공란일 수 없는 경우
아래의 표에는 값이 꼭 있어야 하는 열과 이러한 열이 공란일 때 자동으로 생성되는 기본 값이 설명되어 있습니다.
| 칼럼 | 열이 비어 있으면 생성되는 기본 값 | Handle | 이 값은 Title 열의 값에 따라 생성됩니다. 예를 들어, Title 열의 값이 Black Sun Glasses이면 이 열의 값은 black-sun-glasses가 됩니다. |
|---|---|
| Vendor |
Shopify 계정을 생성할 때 입력한 스토어 이름입니다(예: John's Apparel, johns-apparel). 이 이름은 Shopify에 로그인할 때 사용하는 스토어 이름과 동일합니다. |
| Published |
TRUE, 즉, 제품이 게시되어 온라인 스토어 판매 채널에서 구입 가능한 상태를 의미합니다. |
| Option1 | Title |
| Option1 Value | Default Title |
| Variant Inventory Quantity | 0 |
| Variant Inventory Policy |
값이 |
| Variant Fulfillment Service | manual |
| Variant Price | 0.0 |
| Variant Requires Shipping |
값이 |
| Variant Taxable | TRUE |
| Variant Grams | 0.0 |
| Variant Weight Unit | kg |
| Status | |
For more information about these and other columns, refer to the product CSV description table.
Overwriting product details using an import CSV file
CSV 파일을 가져올 때 동일한 핸들의 현재 제품을 덮어쓰도록 옵션을 선택할 수 있습니다. 누락된 열에는 기존 값이 사용됩니다. 이 옵션을 선택하면 가져오기 CSV 파일의 핸들이 제품 목록의 기존 핸들과 일치하면 CSV 파일의 값이 기존 제품 목록의 일치하는 열에서 값을 덮어씁니다. 덮어쓰기 옵션을 선택하지 않은 경우에는 CSV 가져오기 작업 중에 기존 핸들과 일치하는 제품은 무시됩니다.
-
가져오기 CSV 파일의 필수 열이 비어있는 경우 제품 목록의 해당 값은 비어있는 것으로 덮어씁니다.
예를 들어, 기존 제품 목록의 Standard Product Type 값이
John's Apparel이지만, 가져온 CSV 파일의 Standard Product Type 열이 비어있다면John's Apparel은(는) 비어있는 열로 덮어쓰게 됩니다. -
가져오기 CSV 파일에 필수가 아닌 열이 포함되지 않고 기존 제품 목록에는 포함된 경우 제품 목록의 값은 동일하게 유지됩니다.
예를 들어 Variant Image 열이 기존 제품 목록에는 포함되지만 가져오기 CSV 파일에 포함되지 않은 경우 제품 목록의 값은 동일하게 유지됩니다.
Description of the product CSV file
For information about which columns are required, and which columns require that values are entered, refer to the considerations for product CSV files.
| Column | Description |
|---|---|
| Handle |
Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each product. For example, the handle for a "Women's Snowboard" should be Every line in the CSV file that starts with a different handle is treated as a new product. To add multiple images to a product, you must add multiple lines with the same handle. |
| Title |
The title of your product. For example, |
| Body (HTML) |
The description of the product in HTML format. Learn more about how overwriting existing products affects the data in this column. |
| Vendor |
The name of the vendor for your product. For example, Values must be at least two characters long. Learn more about how overwriting existing products affects the data in this column. |
| Standard product type |
A label that describes the type of product. This label must be taken from the predefined standardized list of product types. You can input the standard product type in either of the following ways:
Learn more about adding a standard product type Learn more about how overwriting existing products affects the data in this column. |
| Custom product type |
A custom label that describes the category of a product. This label doesn't need to conform to any predefined format. Learn more about adding a custom product type Learn more about how overwriting existing products affects the data in this column. |
| Tags |
A comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you use a plain text editor, then you need to manually add the quotes. For example, Learn more about how overwriting existing products affects the data in this column. |
| Published |
Indicates whether a product is published on your online store. Valid values are |
| Option1 Name |
If a product has an option, then enter its name. For example, If a product has only one option, then this value should be |
| Option1 Value |
Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs. If a product has an option, then enter its value. For example, If a product has only one option, then this value should be |
| Option2 Name |
If a product has a second option, then enter its name. For example, Learn more about how overwriting existing products affects the data in this column. |
| Option2 Value |
Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs. If a product has a second option, then enter its value. For example, Learn more about how overwriting existing products affects the data in this column. |
| Option3 Name |
If a product has a third option, then enter its name. Learn more about how overwriting existing products affects the data in this column. |
| Option3 Value |
Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs. If a product has a third option, then enter its value. Learn more about how overwriting existing products affects the data in this column. |
| Variant SKU |
The SKU of the product or variant. This is used to track inventory with inventory tracking services. This field can't be left blank if you're using a custom fulfillment service . Learn more about how overwriting existing products affects the data in this column. |
| Variant Grams |
The weight of the product or variant in grams. Don't specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter Shopify always imports and exports the weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service. |
| Variant Inventory Tracker |
Include your inventory tracking for this variant or product. Valid values include If the existing inventory tracking options are removed, then inventory is no longer tracked. Learn more about how overwriting existing products affects the data in this column. |
| Variant Inventory Qty |
The number of items you have in stock of this product or variant. This column is only used for Shopify stores that have a single location. Note: This column is only available for store that have only one location. If your store manages inventory at multiple locations, then this column isn't included. If you want to import or export inventory quantities, then use the inventory CSV file. Learn more about how overwriting existing products affects the data in this column. |
| Variant Inventory Policy |
How to handle orders when the inventory level for this product or variant has reached zero. Variants with a |
| Variant Fulfillment Service |
The product or variant fulfillment service used. The following are the valid values for this column:
If you use a custom fulfillment service, then you can add the name of the service in this column. For the custom name, use only lowercase letters. Spaces aren't allowed and you must replace them with a dash (-). Periods and other special characters are removed. For example, if "Joan's Fulfillment" is your fulfillment service's name, enter You must have a custom fulfillment service set up in your Shopify admin before you can add the name of the service in this column. |
| Variant Price |
The price of the product or variant. Only include the price and don't include any currency symbols. For example, |
| Variant Compare at Price |
The "Compare at Price" of the product or variant. Only include the price and don't include any currency symbols. For example, Learn more about how overwriting existing products affects the data in this column. |
| Variant Requires Shipping |
The option to require shipping. Valid values are |
| Variant Taxable |
Apply taxes to this variant. Valid values are |
| Variant Barcode |
The barcode, ISBN, or UPC of the product. Learn more about how overwriting existing products affects the data in this column. |
| Image Src |
Enter the URL for the product image. Shopify downloads the images during the import and re-uploads them into your store. These images aren't variant-specific. The variant image column is where you specify variant images. You can't change the image file name after that image has been uploaded to your store. Don't upload images that have
Learn more about how overwriting existing products affects the data in this column. |
| Image Position |
Enter the number that represents the order in which you want the image to appear on the product's page. The images appears in order from smallest to largest starting from an image position value of Learn more about how overwriting existing products affects the data in this column. |
| Image Alt Text |
Alt (alternate) text describes an image and is an important part of a product description. If an image can't load for any reason, then alt text is shown instead. It's also used by assistive technology to describe an image to a customer who's visually impaired. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but the optimal length is 125 characters or fewer. Learn more about how overwriting existing products affects the data in this column. |
| Gift Card |
Indicates whether the product is a gift card. Valid values are Learn more about how overwriting existing products affects the data in this column. |
| SEO Title |
The SEO Title is found on a product's details page under the Search engine listing preview header in the Page title field. The SEO Title is alphanumeric and can include up to 70 characters. If you leave this column blank when you import a product, then the value in the Title column is entered into the Page title field on the product's details page. Learn more about how overwriting existing products affects the data in this column. |
| SEO Description |
The SEO description is also found on a product's details page under the Search engine listing preview header in the Description. The SEO description is alphanumeric and can include up to 320 characters. If you leave this column blank when you import a product, then the value in the Body (HTML) column is entered into the Description field on the product's details page. Learn more about how overwriting existing products affects the data in this column. |
| Google Product Category |
If you currently use a Google product category, you can use it as your Shopify standard product type. You can use the standard product type, the Google Product Category, or both. Provide the most specific category possible for each item. The Google Product Category (GPC) (google_product_category) uses Google's product taxonomy. You can input the Google product category in either of the following ways:
Learn more about how overwriting existing products affects the data in this column. |
| Google Shopping metafields |
The Google Shopping columns might be used by an app to synchronize products to the Google Merchant Center. However, Shopify's Google channel doesn't use these metafields. You can ignore values in the columns that include Google Shopping in their names unless an app tells you to use them. Learn more about how overwriting existing products affects the data in this column. |
| Variant Image |
The URL for images of variants. If you add an URL, then it must be a functioning image URL. Learn more about how overwriting existing products affects the data in this column. |
| Variant Weight Unit |
Valid values are |
| Variant Tax Code |
Available to: Shopify Plus plan The Avalara code to apply taxes to this product. This field only applies when you import to or export from a store that uses the Shopify Plus plan's integration with Avalara AvaTax. When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code column is filled. If you import this CSV file into a store that doesn't have Avalara set up, then your import fails. Learn more about how overwriting existing products affects the data in this column. |
| Cost per item |
How much it costs you for the product or variant. Only include the cost. Don't include any currency symbols. For example, Learn more about how overwriting existing products affects the data in this column. |
| Status |
Indicates whether a product is available to your customers. Valid values are:
|
Collection column exception
To organize your products into collections during the CSV file upload, you can add a new column anywhere in your CSV file with the header name Collection.
When you export a CSV file, the Collection column is not included.
| Column | Description |
|---|---|
| Collection |
Enter the name of the collection that you want to add this product to.
You can add a product to only one collection. This value can be blank. Learn more about how overwriting existing products affects the data in this column. |
Create your product CSV file
For each product, you need to decide if it's a simple product or one with variants.
Simple product: A simple product doesn't include variants. If you upload a product that doesn't have variants, then enter all the fields for the product in the first row along with the URL for the first image. In the following rows, only enter the handle and the URL for each additional image.
Product with variants: If you upload a product that has variants, then enter all the fields for the product in the first row along with the URL for the first image. In the following rows, enter the handle. Then skip the Title, Body (HTML), Vendor, and Tags columns. Fill out the rest of the variants' details and each image URL.
After you've added all your products and images, save your CSV file in UTF-8 format using LF-style linefeeds. If you're not familiar with encodings, then see your spreadsheet or text editor program's documentation.
To view an example CSV file, download this sample product CSV file, and then open it in Google Sheets or another spreadsheet program.
Prepare your images
A CSV file can only contain text, therefore, you need to make sure that all product images are on an existing website. Those image URLs are only used during the CSV file importing process. You can delete the URLs after your import is complete.
If the files are only on your computer, then to link to their URL, you must upload them to your Shopify store or to another image hosting service.
If you're switching to Shopify from another platform, then you can copy the current image URLs and use them in the CSV file.
If the product CSV file was produced by exporting your products from Shopify, then you don't need to do anything because your images are already on your website.
When you have URLs for each product image, you can start building your CSV file.
Adding multiple product images in a CSV file
You can add more product images to your CSV file by uploading more images to your Shopify admin. If you're building your Shopify store with a CSV file, then the process is a little different. Review the following considerations:
You need to be able to edit a CSV file. Shopify recommends using Google Sheets to view a formatted version of your CSV files.
You can add up to 250 images to a product.
Your product images must be uploaded to a publicly accessible URL. That is, they should be behind an
https://protocol with no password protection. To do this, you can upload images to the Files page of the Shopify admin. The URLs generate automatically. After you click Upload files, you can select up to a couple hundred images to upload in bulk.
Add multiple product images to your CSV file
- Insert new rows. You must use only one row per image.
- Copy and paste the handle.
- Copy and paste the image URLs.
Insert a new row
Open your CSV file in your spreadsheet program, such as Google Sheets.
Locate the products that you want to add images to.
In the next row, click and drag the row numbers to select multiple rows. Select the same number of rows as the number of additional images you add.
While those rows are highlighted, right-click anywhere in the highlighted area, and then select Insert X rows above.
Copy and Paste the Handle value
- Copy and paste the Handle value of the required product into column A for your new rows.
Copy and Paste the image URLs
On the Files page, upload your images to Shopify.
Click the Copy link icon for one image URL at a time.
In the CSV file in your spreadsheet application, scroll sideways to the last columns of the CSV file.
In the Image Src column, paste the image URL into each line.
Repeat steps 2 to 4 for all the images for this product
Optional: To improve your SEO, enter values into all the Image Alt Text fields. Learn more about Image alt text.
Save the CSV file and import it to Shopify.