PIMCore社区版CSV导入：父对象与对象标题映射问题咨询

Got it, let's tackle these two CSV import pain points in Pimcore Community Edition one by one—no more all objects dumping into the root, and no more generic Pimcore ID titles!

1. Mapping Parent Objects to Avoid Root Folder Clutter #

Here's how to route imported objects to their correct parent folders/objects:

• First, prep your CSV data
  Add a dedicated column (e.g., parent_path or parent_id) to your CSV. Use either:

  • The full Pimcore path of the parent object/folder (like /products/wearable-tech), or
  • The numeric Pimcore ID of the parent object/folder (if you have that handy, it's more reliable)

• Configure the import mapping

  1. Go to Settings > Import Definitions in Pimcore and open your existing object import definition (or create a new one).
  2. Navigate to the Data Mapping tab.
  3. Locate the Parent field (this is the default parent association field for objects; if you're using a custom parent relation field in your object class, select that instead).
  4. Map your CSV's parent_path/parent_id column directly to this Parent field. Pimcore will automatically resolve the path/ID to the correct parent object during import.

• Test before full import
  Run a small test import with 2-3 rows to confirm objects land in the correct parent location instead of the root folder.

2. Mapping Custom Titles to Replace Pimcore ID Defaults #

To get meaningful titles instead of the auto-generated numeric IDs:

• Add a title column to your CSV
  Create a column like object_title and fill it with the desired title for each object (e.g., "Wireless Headphones Pro" instead of "123").

• Map the title field in your import definition

  1. In the same Data Mapping tab of your import definition, find the Title field (or your custom title field if you've added one to your object class).
  2. Map your CSV's object_title column to this field.

• Double-check import options
  Head to the Options tab of your import definition. Make sure there's no setting overriding your title mapping—for example, some setups auto-generate titles from IDs if no mapping is detected, but since you've mapped the title field, this should be ignored.

• Verify the results
  After testing the import, check the objects in Pimcore—their titles should match exactly what you entered in the CSV, not the default numeric IDs.

Quick Pro Tips #

• If your object class doesn't have a dedicated title or parent field, first go to Settings > Classes, edit your object class, and add those fields (a Text field for title, an Object Relation field for parent if needed).
• Always back up your Pimcore data before running large imports—better safe than sorry!

内容的提问来源于stack exchange，提问作者PHowell