Import & Export Options (CSV)
Getting Started

Import & Export Options (CSV)

3 min read Updated Oct 26, 2026

Overview#

Managing a large catalog with dozens or hundreds of colors and custom patterns? With Aris Color Swatch, you can bulk export and import your option value swatch configurations (HEX colors, dual-tone colors, and custom image URLs) across your entire store using a simple CSV file.

Follow this quick guide to bulk update your swatches in minutes!

Step 1: Go to Options#

From your Dashboard, click Go to Options in the setup guide (or click Options in the left sidebar menu).

Make sure you have already clicked Sync Shopify option so your latest Shopify options and values are loaded in the app.

Step 2: Export Your Current Options CSV#

  1. In the top-right corner of the Options page (next to Sync Shopify option), click the Export button.

  2. Your browser will immediately download a CSV file named options-swatch-export-<your-store>-<timestamp>.csv containing all synced options and values across your store.

Step 3: Edit the CSV File#

Open the downloaded CSV file in Google Sheets, Microsoft Excel, or any spreadsheet editor. The file uses 5 standard columns (up to 5,000 rows per file):

Column

Required

Description & Example

option_name

Yes

The exact Shopify option name (e.g., Color, Material).

option_value

Yes

The exact Shopify option value (e.g., Red, Navy Blue).

color_primary

Optional

Primary HEX color code (e.g., #FF0000 or 8-character alpha #FF0000FF).

color_secondary

Optional

Secondary HEX color code for dual-tone swatches (e.g., #0000FF). Leave blank for a single solid color. (Requires color_primary to be filled.)

image_url

Optional

Public image URL starting with http:// or https:// (e.g., https://cdn.shopify.com/.../fabric-red.png).

Example CSV:

option_name,option_value,color_primary,color_secondary,image_url
Color,Red,#FF0000,,
Color,Red/Blue,#FF0000,#0000FF,
Color,Floral,,,https://cdn.shopify.com/s/files/1/0000/0001/files/floral.png

Save your changes as a standard UTF-8 .csv file (maximum file size: 2 MB).

Step 4: Import Your Updated CSV#

  1. Return to the Options page in Aris Color Swatch.

  2. Click the Import button in the top-right corner.

  3. Select your updated .csv file from your computer.

  4. The app processes your file immediately and shows a confirmation banner at the bottom of the screen (e.g., Imported 120/120 rows), updating your Options table right away.

Extra: How Safe Updates & Priority Work#

  • Safe Partial Updates: Leaving color_primary, color_secondary, or image_url blank in a CSV row keeps the existing value currently saved in the app—it will not erase existing colors or uploaded files.

  • No Accidental Deletions: Removing rows from your CSV file will never delete options or option values from your store.

  • Automatic Display Priority: If you provide both HEX color codes and an image_url on the same row, the app saves both and automatically displays the Image URL according to the priority order: Image URL > Upload File > Color HEX > Shopify Variant Image

Pro Tip: Rows with invalid HEX codes, broken URLs, or option names/values that do not exist in your synced Shopify catalog are safely skipped without interrupting the rest of your import.

Need Help? If you need assistance preparing a bulk CSV file for a large catalog, click Chat with us at the bottom right. Our support team is always ready to assist!

Was this article helpful?

If you still need help, our support team is here for you.

Contact Support