How to Export Product Metadata from Salsify

Salsify UI Export

Channel Export

Salsify REST API

import requests
import time
import csv
import json

API_KEY = "your_api_key"
ORG_ID = "your_org_id"
BASE_URL = f"https://app.salsify.com/api/v1/orgs/{ORG_ID}"
HEADERS = {
    "Authorization": f"Bearer {API_KEY}",
    "Content-Type": "application/json",
}

# Step 1: Create an export run
export_config = {
    "configuration": {
        "entity_type": "product",
        "format": "csv",
        "properties": [
            "salsify:id", "salsify:name", "salsify:created_at",
            "salsify:updated_at", "Product Name", "Description",
            "Brand", "Category", "SKU", "Status"
        ]
    }
}
resp = requests.post(
    f"{BASE_URL}/export_runs", headers=HEADERS, json=export_config
)
run_id = resp.json()["id"]

# Step 2: Poll until complete
while True:
    status = requests.get(
        f"{BASE_URL}/export_runs/{run_id}", headers=HEADERS
    ).json()
    if status["status"] == "completed":
        download_url = status["url"]
        break
    time.sleep(5)

# Step 3: Download the CSV
csv_data = requests.get(download_url).text
with open("salsify_metadata.csv", "w") as f:
    f.write(csv_data)

print("Export complete: salsify_metadata.csv")