Column Mappings — API Docs | Simple Product Feeds

Get column mappings

GET /v1/column_mappings

Returns the full column mapping configuration, including available source columns, valid feed columns, and the resolved mapping between them.

The resolved mapping merges your custom overrides with the default Shopify-to-Google Merchant column mapping.

Required scope: read_settings

Request

curl https://app.simpleproductfeeds.com/v1/column_mappings \
  -H "Authorization: Bearer spf_live_sk_your_key_here"

Response

{
  "data": {
    "object": "column_mappings",
    "source_columns": [
      "title", "body_html", "vendor", "product_type",
      "handle", "tags", "sku", "price", "compare_at_price",
      "inventory_quantity", "image_src"
    ],
    "feed_columns": [
      "id", "title", "description", "link", "image_link",
      "price", "sale_price", "availability", "brand",
      "google_product_category", "condition", "gtin", "mpn"
    ],
    "mappings": {
      "title": "title",
      "body_html": "description",
      "vendor": "brand",
      "image_src": "image_link",
      "price": "price",
      "compare_at_price": "sale_price"
    }
  }
}

Response fields

Field	Type	Description
`object`	string	Always "column_mappings".
`source_columns`	string[]	Available source columns from your Shopify product data.
`feed_columns`	string[]	Valid target feed column names (Google Merchant Center fields + extra columns).
`mappings`	object	Resolved mapping from source columns to feed columns. Includes both default and custom overrides.

Errors

Status	Code	Description
422	`no_feed`	No feed has been configured for this shop.

Update column mappings

PATCH /v1/column_mappings

Updates column mapping overrides. Provide a mappings object with source column names as keys and feed column names as values. Your overrides are merged with the default mapping.

Required scope: write_settings

Parameters

Parameter	Type	Required	Description
`mappings`	object	Yes	Key-value pairs mapping source columns to feed columns.

Request

curl -X PATCH https://app.simpleproductfeeds.com/v1/column_mappings \
  -H "Authorization: Bearer spf_live_sk_your_key_here" \
  -H "Content-Type: application/json" \
  -d '{
    "mappings": {
      "vendor": "brand",
      "product_type": "google_product_category",
      "tags": "custom_label_0"
    }
  }'

Response

Returns the updated column mappings object with the fully resolved mapping.

Errors

Status	Code	Description
422	`no_feed`	No feed has been configured for this shop.
422	`invalid_param`	The `mappings` parameter must be a valid object.