Import Category data and monitor the status of import activities.

Import-related functionality and the Import API are only available in Google Cloud Regions.

Import from CSV file

Merchant Center lets you perform bulk data import by uploading data from a CSV file.

To import data from a CSV file in Merchant Center, the Administrators Team must grant the View and edit all: Operations permission to your respective Project and Team.

Currently, you can only import Categories.

CSV file requirements

Click here to download an template CSV file for importing Category data.

When creating a CSV file, the following headers and values are supported:

keyUnique identifier of the Category to create or update. This must only include letters, numbers, underscores (_) or dashes (-). A key must always be included.
name.enThe name of the Category. Must be included when creating a new Category.
slug.enThe slug for the Category. Must be included when creating a new Category.
description.enA description of the Category.
externalIdAn additional identifier for the Category (for example, if the Category exists in external systems).
metaTitle.enThe name of the Category for search engines.
metaDescription.enA description of the Category for search engines.
metaKeywords.enKeywords related to the Category for improved search engine performance.
parent.keyIf this is a child Category, this is the key of the Category to use as the parent. A Category with this key must exist before importing. parent.key is required when updating a child Category.
parent.typeIdMust be included when parent.key has a value. The value must always be category.
custom.type.keyKey of a Type to reference in a Custom Field.
custom.type.typeIdMust be included when custom.type.key has a field. The value must always be type.
custom.fields.nameOfCustomFieldReplace nameOfCustomField with the name of the Custom Field as defined in the respective FieldDefinition. The value must conform to the FieldType of the Custom Field.

For headers that end with .en, you can change en to reference another language. You can also include this header multiple times to include values for different languages. For example, including the header allows you to include a German name, and name.en-US allows you to include an American English name.

The CSV file must not be larger than 10 megabytes and must contain fewer than 5000 rows.

Importing Custom Fields

All Custom Fields except number, reference, and sets are supported.

When importing LocalizedString Custom Fields, you must include headers and values for each language. For example: custom.fields.nameOfCustomField.en and for English and German respectively.

Money Custom Fields require four headers and values:

custom.fields.nameOfCustomField.currencyCodeCurrency code compliant to ISO 4217. For example, USD, EUR, or GBP.
custom.fields.nameOfCustomField.centAmountThe number of cents in the currency.
custom.fields.nameOfCustomField.typeThe value must always be centPrecision.
custom.fields.nameOfCustomField.fractionDigitsThe number of digits after the decimal separator.

Upload a file

  1. Go to Operations > Import, and click the Upload files tab.

  2. Select the resource type from the drop-down, and upload the respective file. You can either drag the file into the input box, or browse and select the file from your local machine.

    File Import Uploaded View.

  3. Verify the information after the file is uploaded and validated successfully, and click Import categories. To monitor the import progress, click the Import logs tab. For more information on the import log, see Import logs table.
    You can also upload another file simultaneously while the import operation is running.

Import logs

To access Import Logs in Merchant Center, the Administrators Team must grant the View all: Operations permission to your respective Project and Team.

Import logs are historical records of all your import activities performed in the last 48 hours using the Merchant Center or Import API. It helps you track the import progress, and check errors and pending actions in Import Containers.

List of import logs.

To access the import logs, go to Operations > Import and click the Import logs tab. The import logs table is generated when the page is loaded. To update the visible data thereafter, you must manually refresh the table.

The import log table has the following columns:

  • Time created: date and time the import container was created.
  • Import container key / File name: name or unique key of the import container.
  • Import type: indicates the method of data import:
    • Automated import: imported via the Import API.
    • Manual file upload: manually uploaded by users.
  • Resource type: resource type provided at the time of the import container creation.
  • Status: import status of an import container:
    • Successfully completed: all operations are successfully imported.
    • Partially completed: all operations are in the final state; some operations are successful while others are in error or pending states.
    • Failed: all operations failed to be imported.
    • Running: Some operations are still in one of the incomplete states, such as processing.

History of an Import Container

To view individual import request items or operations of an Import Container, click the corresponding row in the import logs table. The operations are uniquely identified by resource key and the table displays the following details:

  • Status: symbolic representation of an import operation's status:
    • Red indicates a failed operation.
    • Blue indicates an operation in progress or waiting.
    • Green indicates a successful operation.
  • Identifier: unique identifier of an operation.
  • Validation message: placeholder for the details of the import status that displays the detailed error, required action, or success message.

Import history of an import container.