Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

Step 1: Prepare the Data

  1. On the Admin sidebar, go to System > Data Transfer > Import.Image Added2. Under Import Settings, set Entity Type to Kootoro Products.

Image Added

3. To get sample file, Click Download Sample File.

4. Verify that the size of your import file does not exceed the limit shown in the message.

Data import size notificationImage Added


Step 2: Choose the Import Behavior

  1. Set Import Behavior to Add/Update.

Import Behavior 

OPERATIONDESCRIPTION
Add/UpdateNew product data is added to the existing product data for the existing entries in the database. All fields except sku can be updated.

New tax classes that are specified in the import data are created automatically.

New product categories that are specified in the import file are created automatically.

New SKUs that are specified in the import file are created automatically

Note: For products, you can update all fields except SKU through import.
ReplaceThe existing product data is replaced with new data.

Important: Exercise caution when replacing data because the existing product data will be completely cleared and all references in the system will be lost.

If a SKU in the import data matches the SKU of an existing entity, all fields, including the SKU, are deleted and a new record is created using the CSV data. An error occurs if the CSV file references a SKU that does not exist in the database. You can Check Data to display error.
DeleteAny entities in the import data that already exist in the database are deleted from the database.

Delete ignores all columns in the import data, except for SKU. You can disregard all other attributes in the data.

An error occurs if the CSV file references a SKU that does not exist in the database. You can Check Data to display error.
  1. To determine what happens when an error is encountered when importing data, choose:

    • Skip error entries
  2. In the Allowed Errors Count field, enter the number of errors that can occur before the import is canceled.

    The default value is 10.

    Data import behaviorImage AddedImport Behavior

Step 3: Identify the Import File

  1. Click Choose File to select the file to import.

  2. Find the CSV file that you prepared to import and click Open.

    Data import fileImage AddedFile to Import

Step 4: Check the Import Data

  1. In the upper-right corner, click Check Data.

  2. Wait a few moments for the validation process to complete.

    If the import data is valid, the following message appears:

    Success message - file is validImage AddedFile is Valid

  3. If the file is valid, click Import.

    Otherwise, correct each problem with the data that is listed in the message, and try to import the file again.

  4. The import process continues to the end of the data, unless an error is encountered.

    If an error message appears in the Validation Results, correct the problem in the data and import the file again.

    Error message - URL key already existsImage AddedURL Key Already Exists

    A message appears when the import is complete.

...