Import Category data and monitor the status of import activities.
Import from CSV file
Merchant Center lets you perform bulk data import by uploading data from a CSV file.
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:
|Unique identifier of the Category to create or update. This must only include letters, numbers, underscores (_) or dashes (-). A |
|The name of the Category. Must be included when creating a new Category.|
|The slug for the Category. Must be included when creating a new Category.|
|A description of the Category.|
|An additional identifier for the Category (for example, if the Category exists in external systems).|
|The name of the Category for search engines.|
|A description of the Category for search engines.|
|Keywords related to the Category for improved search engine performance.|
|If this is a child Category, this is the |
|Must be included when |
|Key of a Type to reference in a Custom Field.|
|Must be included when |
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
name.de 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.de for English and German respectively.
Money Custom Fields require four headers and values:
|Currency code compliant to ISO 4217. For example, |
|The number of cents in the currency.|
|The value must always be |
|The number of digits after the decimal separator.|
Upload a file
Go to Operations > Import, and click the Upload files tab.
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.
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 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 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.