Import data

Learn how to import Categories and Products using a CSV file.

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

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

Create a CSV file

The following CSV templates provide an example of how to import data from CSV files. The data contained in these templates is compatible with our sample data.

  • For categories, you can download the template here.
  • For products, since the data can be complex, you can do any of the following:
    • Import a large CSV file containing the complete product data. You can download the template here.
    • Import smaller CSV files containing the data for prices, price tiers, assets, and images. You can download the templates here for prices, price tiers, assets, and images.

Upload a CSV file

To import data, the Administrators Team must grant you the following permissions for the Project:

  • View and edit all: Operations permission for importing resources through CSV files
  • View and edit all: Categories permission for importing Categories
  • View and edit all: Products permission for importing Products
  1. Go to Operations > Import, and click the Upload files tab.

  2. Select the resource type from the drop-down, upload the file, and then click Upload file.

    Preview of a Categories import after file upload.

  3. After the file is uploaded and validated successfully, verify the information, and then click Start import. You can also upload another file simultaneously while an import operation is running.
    To monitor the import progress, click the Import logs tab. For more information, see Import logs.

Import logs

To access the import logs, the Administrators Team must grant you the View all: Operations permission for the Project.

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.

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

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 using the Import API.
    • Manual file upload: imported from a CSV file.
  • Resource type: resource type provided at the time of the import container creation.
  • Status: import status of an import container:
    • Successfully completed: all resources were successfully imported.
    • Partially completed: some import operations were successful while others are in Failed or Unresolved states.
    • Failed: all import operations were unsuccessful.
    • Processing: some import operations are still in progress.
    • Wait for unresolved references: some import operations are Unresolved and are awaiting missing or undefined references.
    • Canceled: the import operations were manually terminated. Resources imported before cancellation were not removed.
    • No running imports: the import container has no running or waiting import operations.

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.