Batch Create Products

curl --request POST \
  --url https://backend.anglera.com/products/batch \
  --header 'Content-Type: application/json' \
  --header 'X-Anglera-API-Key: <api-key>' \
  --data '
{
  "sheet_id": "<string>",
  "products": [
    {
      "name": "<string>",
      "sku": "<string>",
      "mapped_data": {},
      "input_source_url": "<string>"
    }
  ],
  "tab_id": "<string>",
  "auto_enrich": true,
  "update_if_exists": true,
  "replace_all": true
}
'

{
  "message": "<string>",
  "sheet_id": "<string>",
  "created": [
    {
      "id": 123,
      "name": "<string>",
      "sku": "<string>",
      "status": "<string>"
    }
  ],
  "updated": [
    {}
  ],
  "errors": [
    {
      "name": "<string>",
      "reason": "<string>"
    }
  ],
  "deleted_count": 123
}

POST

products

batch

Batch Create Products

curl --request POST \
  --url https://backend.anglera.com/products/batch \
  --header 'Content-Type: application/json' \
  --header 'X-Anglera-API-Key: <api-key>' \
  --data '
{
  "sheet_id": "<string>",
  "products": [
    {
      "name": "<string>",
      "sku": "<string>",
      "mapped_data": {},
      "input_source_url": "<string>"
    }
  ],
  "tab_id": "<string>",
  "auto_enrich": true,
  "update_if_exists": true,
  "replace_all": true
}
'

{
  "message": "<string>",
  "sheet_id": "<string>",
  "created": [
    {
      "id": 123,
      "name": "<string>",
      "sku": "<string>",
      "status": "<string>"
    }
  ],
  "updated": [
    {}
  ],
  "errors": [
    {
      "name": "<string>",
      "reason": "<string>"
    }
  ],
  "deleted_count": 123
}

Creates multiple products in a sheet in a single request. Supports optional auto_enrich to queue products for enrichment immediately, update_if_exists to update existing products matched by name, and replace_all to replace the entire sheet contents.

Request

curl -X POST "https://backend.anglera.com/products/batch" \
  -H "X-Anglera-API-Key: your_api_key" \
  -H "Content-Type: application/json" \
  -d '{
    "sheet_id": "100",
    "products": [
      {
        "name": "Frigidaire Side-by-side Fridge",
        "sku": "FRSS26L3AF",
        "mapped_data": {"brand_name": "Frigidaire"},
        "input_source_url": "https://example.com/product/123"
      },
      {
        "name": "Samsung French Door Fridge",
        "sku": "RF28T5001SR"
      }
    ],
    "auto_enrich": false,
    "update_if_exists": false
  }'

Body Parameters

sheet_id

string

required

ID of the sheet where products should be added

products

array

required

Array of product objects (max 100). Each product can have:

Show Product object

name

string

required

Product display name. Used for deduplication within the request (last wins) and for matching with update_if_exists.

sku

string

Stock Keeping Unit

mapped_data

object

Key-value pairs to map into the product. Keys must match mappable attribute keys.

input_source_url

string

URL to scrape directly (bypasses web search)

tab_id

string

Target tab for new products. If omitted, products go to the sheet’s default tab. Use List Tabs to find existing tab IDs, or Create Tab to create a new one.

auto_enrich

boolean

default:"false"

When true, products are created with QUEUED status and sent to the enrichment queue. When false (default), products are created with DRAFT status. Use Batch Enrich to trigger enrichment later.

update_if_exists

boolean

default:"false"

When true, matches existing products by name within the sheet and updates them in-place. Matched products appear in the updated array instead of created. Ignored when replace_all is true.

replace_all

boolean

default:"false"

When true, all existing products in the sheet are permanently deleted before creating the new products. The response includes a deleted_count field indicating how many products were removed.

This is a destructive operation. All existing products in the sheet — including their enrichment results, price reports, and validation data — will be permanently deleted and cannot be recovered. Use this for workflows where you need to fully sync a sheet to a known list of products (e.g., weekly price report refresh).

Response

message

string

Summary of the operation

sheet_id

string

The sheet ID

created

array

Products that were newly created

Show Product object

number

Unique product identifier

name

string

Product name

sku

string

Stock Keeping Unit

status

string

DRAFT or QUEUED

updated

array

Products that were updated (only when update_if_exists is true). Same shape as created.

errors

array

Products that failed validation or insertion

Show Error object

name

string

Product name (or (missing) if not provided)

reason

string

Error description

deleted_count

number

Number of products that were deleted from the sheet. Only present when replace_all is true.

All Created
Replace All
Partial Errors

{
  "message": "Created 2 product(s), updated 0 product(s)",
  "sheet_id": "100",
  "created": [
    {"id": 9001, "name": "Frigidaire Side-by-side Fridge", "sku": "FRSS26L3AF", "status": "DRAFT"},
    {"id": 9002, "name": "Samsung French Door Fridge", "sku": "RF28T5001SR", "status": "DRAFT"}
  ],
  "updated": [],
  "errors": []
}

{
  "message": "Created 2 product(s), updated 0 product(s)",
  "sheet_id": "100",
  "deleted_count": 5,
  "created": [
    {"id": 9010, "name": "Frigidaire Side-by-side Fridge", "sku": "FRSS26L3AF", "status": "DRAFT"},
    {"id": 9011, "name": "Samsung French Door Fridge", "sku": "RF28T5001SR", "status": "DRAFT"}
  ],
  "updated": [],
  "errors": []
}

{
  "message": "Created 1 product(s), updated 0 product(s)",
  "sheet_id": "100",
  "created": [
    {"id": 9001, "name": "Frigidaire Side-by-side Fridge", "sku": "FRSS26L3AF", "status": "DRAFT"}
  ],
  "updated": [],
  "errors": [
    {"name": "Bad Product", "reason": "invalid mapped_data key(s): ['nonexistent_key']"}
  ]
}

Errors

Status Code	Description
`400`	Missing required fields, invalid products array, or exceeds 100 product limit
`401`	Invalid API key
`404`	Sheet not found
`500`	Internal server error

Add Product for Enrichment Batch Enrich Products

Documentation Index

​Request

​Body Parameters

​Response

​Errors

Request

Body Parameters

Response

Errors