Skip to main content

cafe24 Help Center

Guides
Start Online Store Themes Initial setup
Sell Adding products Selling products Managing products
Manage Orders Customers
Market Promotions Apps
Guides
Start Online Store Themes Initial setup
Sell Adding products Selling products Managing products
Manage Orders Customers 運営管理 セキュリティ管理 機能拡張
Market Promotions 統計・分析
Changelog All Notices Updates Theme updates
Changelog
English (US) 日本語 한국어 Tiếng Việt
Cafe24 Developers Cafe24 Developers
日本語 한국어 Tiếng Việt
Log in
  1. Cafe24 Help Center
  2. Guides
  3. Sell
  4. Managing products

Managing via CSV

You can upload product details for multiple products at once with a CSV file.
Save your time with this bulk management service instead of uploading product details one by one.
You can also bulk add/edit products, product settings, options and inventory in Manage via CSV.

 

General guide

  1. Each menu offers different CSV templates for different purposes.
  2. Fill in the file with the information you want to upload.
  3. Drag and drop the file or select it from your device.
  4. Click Import via CSV to upload the CSV file.
  5. Check your import results once the process is complete. Find out how many items were uploaded and how many failed, as well as the reasons for failure.

Adding new products

  1. Go to Products>Products > Manage via CSV > Add/Edit products (Tab) and click CSV template.
  2. Fill in the CSV template with the product details corresponding to the products you want to add to your store.
  3. Drag and drop the edited CSV file into Products > Products > Manage via CSV > Add/Edit products (Tab) or click Select a file to upload it from your device.
  4. Click Import via CSV.

Info

  • When adding a new product, leave the product code field empty. The product code is automatically created by the system when a product is added.
  • If the product has options, variants will be created automatically when products are added via CSV.

 

Editing registered products

  1. Go to Products > Products > Product list and select the products you want to edit. Click Export as CSV.
  2. In the Export as CSV window, select Basic template for CSV template. You may also have to enter a password to secure the file depending on your settings.
  3. Click Create CSV.
  4. Click the Download button for the CSV file you wish to download under CSV files.
  5. Edit the product details in the CSV file and save the file. Make sure you don't change the file's format.
  6. Go to Products > Products > Manage via CSV > Add/Edit products (Tab). Drag and drop the edited CSV file or click Select a file to upload it from your device.
  7. Click Import via CSV.

Info

If you do not select specific products in the product list before clicking Export as CSV, the file you download will contain the product details of all the products in that list.

 

Adding related products

  1. Go to Products > Products > Product list and select the products you want to edit. Click Export as CSV.
  2. Edit the product details in the CSV file and save the file. Make sure you don't change the file's format.
  3. Drag and drop the edited CSV file into Products > Products > Manage via CSV > Add related products (Tab) or click Select a file to upload it from your device.
  4. Click Import via CSV.

Info

The template you downloaded here can only be used to add related products. Other changes made to the CSV file, such as deleting or adding products, will not be reflected in the system.

 

Editing options

  1. Go to Products > Products > Product list and select the products you want to edit. Click Export as CSV.
  2. In the Export as CSV window, select Reset options/inventory template for CSV template. You may also have to enter a password to secure the file depending on your settings.
  3. Click Create CSV.
  4. Click the Download button for the CSV file you wish to download under CSV files.
  5. Edit the product details in the CSV file and save the file. Make sure you don't change the file's format.
  6. Go to Products > Products > Manage via CSV > Edit options (Tab). Drag and drop the edited CSV file or click Select a file to upload it from your device.
  7. Click Import via CSV.

Info

  • If you do not select specific products in the product list before clicking Export as CSV, the file you download will contain the product details of all the products in that list.
  • Product code is a required field.
  • You can only edit up to 500 options based on the product code.
  • Note that you cannot edit the custom selection or independent variant selection type of options using this feature. Go through the Edit product page to change these type of options. 

Note

We do not recommend editing options via CSV for products that have their inventory tracked.

 

Editing inventory

  1. Go to Products > Inventory > Manage inventory/Out-of-stock products/Minimum stock level and select the products you want to edit, then click Export as CSV.
  2. In the Export as CSV window, select Basic template for CSV template. You may also have to enter a password to secure the file depending on your settings.
  3. Click Create CSV.
  4. Click the Download button for the CSV file you wish to download under CSV files.
  5. Edit the product details in the CSV file and save the file. Make sure you don't change the file's format.
  6. Go to Products > Products > Manage via CSV > Edit inventory (tab). Drag the drop CSV file you've edited or click Select a file to upload it.
  7. Click Import via CSV.

Info

  • If you do not select specific products in the product list before clicking Export as CSV, the file you download will contain the product details of all the products in that list.
  • You can add or edit up to 1,000 variants.
  • Product code, product name, variant code, variant name and accumulated sales cannot be edited via CSV file. You can only edit data related to inventory, display status and sales status.
  • For products that do not have any options, columns F (Variant code) to I (Inventory tracking) should be left empty.

 

Things to remember before using the CSV feature

If you wish to edit your file in a language other than Korean, you must use one of the following file extensions: .xlsx or xls.
Adding unnecessary spaces may cause errors when you upload your file.
If you leave a field empty in the excel file, the corresponding information will not be updated for the product.
Even if you add fields to the basic template and successfully import it to your admin page, those fields will not be updated.
If you do not enter HS codes when uploading products via CSV, the HS code registered in Shipping/Returns will be applied.
If Enable auto-translation for option values is set as Yes in My Store > Store setup > General settings > Products (Tab), the option values you add will automatically be translated into the corresponding localized store's language.
Auto-translation for option values is only available for English, Japanese, Chinese (Simplified) and Chinese (Traditional).
This feature is only supported for Internet Explorer versions above v.10.

 

Prev Next
Was this page helpful?
Update
Related Guides
On this page