Export data

Learn to bulk export resources to a CSV or JSON file from Composable Commerce.

You can export data only from Projects in Google Cloud Regions.

Prerequisites

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

  • View all: Operations permission to access the export logs page and to download export files
  • View all: Categories permission to export Categories
  • View all: Customers permission to export Customers
  • View all: Discount codes permission to export Discount Codes
  • View all: Orders permission to export Orders
  • View all: Products permission to export Products and Inventory

Best practices

To speed up the export process and reduce the size of exported files, you should:

  • Export a limited number of resources. Instead of exporting all the resources, you can filter or select specific resources to export.
  • Select only the necessary locales and fields.
  • Create multiple export files for large resources. For example, when exporting Products, create separate files for general fields, price fields, and asset fields.

If you intend to import the exported CSV file, the CSV file must be no larger than 35 MB and contain fewer than 80 000 rows.

Use keys as identifiers

Keys are optional unique identifiers for resources in your Project, but they are essential for exporting and importing. Before exporting, ensure the resources to export, and all related resources, have keys. For example, when exporting Discount Codes, both the Discount Codes and the Cart Discounts they use should have keys.

Export Categories

  1. Go to Categories > Categories search.

  2. Click the Import / Export drop-down and select Export categories.

  3. In the Export categories dialog, follow these steps:

    • Choose to export all Categories, or only the ones you have selected.
    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Export Customers

  1. Go to Customers > Customer list.

  2. Click the Import / Export drop-down and select Export customers.

  3. In the Export customers dialog, follow these steps:

    • Choose to export all Customers, or only the ones you have filtered or selected.
    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Export Discount Codes

  1. Go to Discounts > Discount code list.

  2. Click the Actions drop-down and select Export discount codes.

  3. In the Export Discount Codes dialog, follow these steps:

    • Choose to export all Discount Codes, or only the ones you have filtered or selected.
    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Export Inventory

  1. Go to Products > Product list.

  2. Click the Actions drop-down and select Export inventories.

  3. In the Export inventories dialog, follow these steps:

    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Export Orders

  1. Go to Orders > Order list.

  2. Click the Import / Export drop-down and select Export orders.

  3. In the Export orders dialog, follow these steps:

    • Choose to export all Orders, or only the ones you have filtered or selected.
    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Export Products

  1. Go to Products > Product list.

  2. Click the Actions drop-down and select Export products.

  3. In the Export products dialog, follow these steps:

    • Choose to export all Products, or only the ones you have filtered or selected.
    • For File format, choose to export the data as a CSV or JSON file.
    • For File name, enter a name for the file containing the export data.
    • For Locale, select the languages to export the data in. To include data for all configured locales, select the Include all locales checkbox.
  4. Click Continue.

  5. Select the fields to be exported and click Start export.

Download the export files

The export operation is a background task. The time to complete the operation corresponds to the amount of data exported. If the data is large, the export can take longer. For quicker exports, you should export only the necessary resources, locales, and fields. To view the current status of your exports, and to download exported files, go to Operations > Export.

If several export operations are run within a short period, they will be queued to ensure smooth running of the export process. Queued exports are automatically processed in the order in which they were created.

Export log files are removed after 24 hours.

Viewing the export file

For CSV exports, the headers and values match those in the CSV import documentation:

For JSON exports, the fields and types match those in the HTTP API documentation: