FAQ - Profile Import CSV/JSON

Here’s a polished help desk article for your Fancy Product Designer Shopify app based on the chat messages and the two CSV files you provided:

Profile Import & Export (CSV & JSON)

Fancy Product Designer allows you to import and export profiles in two formats:

• JSON (default format, as exported by the app)
• CSV (custom spreadsheet format for bulk editing or creation)

This article explains how to use the CSV import option.

1. Overview

The Profile Import feature is designed for both full and partial profile imports:

• JSON → Perfect for backing up and restoring complete profiles exactly as exported.
• CSV → Ideal for editing or creating profiles in a spreadsheet format, where each profile setting is represented as a column.

You can download:

• A sample CSV file from the Profile page in the app.
• A list of all available field keys (title_id_list) for reference when adding custom columns.

2. Preparing Your CSV File

You have two options when preparing your CSV import file:

Option A — Use the Provided Full Template

• Download the full settings template (full_settings_import_all.csv).
• Each setting is already listed as a column header.
• Simply fill in the values for each row (profile).

Option B — Create Your Own Custom Template

• Start with the example import file.
• Add additional columns based on the profile_title_id_list.csv reference file.
• Only include the settings you need to update—missing columns will not affect existing settings.

3. Column Headers & Field Keys

• Each column header in the CSV corresponds to a field ID from the title_id_list.
• They have to be prefixed with settings.
• If you want to import a Subprofile - you can configure the overwrite behavior with the prefix overwrite. (That has to be TRUE otherwise the value of the parent profile is not overwritten.)
• The title is a human-readable label, while the ID is the actual key used for importing.

Example from title_id_list:

When creating your CSV:

• Always use the ID (not the title) as the column header.

4. Handling Multiple Values in a Cell

Some fields allow multiple selections (e.g., multiple fonts, multiple colors).

When entering multiple values in one cell:

• Wrap the cell content in double quotes (")
• Separate values with a comma and a space (`, `)

Example:

"Value1, Value2, Value3"

5. Importing Your CSV File

1. Go to the Profile page in Fancy Product Designer.
2. Click Import Profile.
3. Choose your CSV file.
4. Review the import summary to confirm which settings will be updated.
5. Confirm the import.

6. Notes & Best Practices

• You can import partial profiles—only the included columns will be updated.
• The CSV must use UTF-8 encoding to ensure special characters are preserved.
• Always keep a backup of your current profiles before importing new ones.

Related Downloads:

📄 Full Settings Import Template (full_settings_import_all.csv)

📄 Profile Title & ID List (profile_title_id_list.csv)

Updated on: 14/08/2025