Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

Modifying Schema and Catalog Data

Modifying Schema and Catalog Data

The following steps outline how to modify the database schema and catalog data.

Schema Modifications

  1. Open schema-customizations-changelog.xml, located in extensions/database/ext-data/src/main/resources/schema.
  2. Add one or more changesets to schema-customizations-changelog.xml with the desired changes. For details on the possible database modifications you can make using changesets, see the Liquibase Changeset Refactoring manual.
  3. Run the Data Population tool to update the database as described in Populate the Database.
Warning:

Once a changeset has been committed, it must never be edited. Instead, commit additional changesets to counteract your change.

Data Modifications

When you're working on the initial implementation of a project, the catalog data you create will usually be used for testing or for deployment to all environments. Test data should be added to the extensions/database/ext-data/src/main/resources/data/test-data folder and data for all environments to the extensions/database/ext-data/src/main/resources/data/rel-1.0-data folder.

Easiest ways to create catalog data:

  • Use the Commerce Manager Client to configure the catalog and export the changes using the Import/Export tool.
  • Manually create the Import/Export XML files using the data in the commerce-data project as examples.

Then run the Data Population tool to update the database as described in Populate the Database.

Tip: Re-running Import/Export change sets

Unlike Liquibase changes sets which only process once, Import/Export change sets process every time the Data Population tool runs in your local development environment.

For more more information, see: