> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://fpd-doc.ganymede-apps.net/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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.

![](https://storage.crisp.chat/users/helpdesk/website/-/c/b/1/7/cb1733eed2f3b800/scr-20250814-pvep_uzpixv.png)

![](https://storage.crisp.chat/users/helpdesk/website/-/c/b/1/7/cb1733eed2f3b800/scr-20250814-pvmj_15mltu.png)

---

### **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`:

| Title | ID |
| ---- |
| Background | background |
| Text Color | text_color |

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`)](https://www.dropbox.com/scl/fi/kcypy73s43ijahx6j3ben/full_settings_import_all.csv?rlkey=y1k1k5sbwush21yap1e2r8v8m&st=om3ksccm&dl=0) 
📄 [Profile Title & ID List (`profile_title_id_list.csv`)](https://www.dropbox.com/scl/fi/kcypy73s43ijahx6j3ben/full_settings_import_all.csv?rlkey=y1k1k5sbwush21yap1e2r8v8m&st=om3ksccm&dl=0)