Upload Base Products Csv

curl --request POST \
  --url https://api.merchantops.ai/api/products/upload-base-csv \
  --header 'Content-Type: application/json' \
  --data '
{
  "csv_content": "<string>",
  "batch_size": 25,
  "enrich_product": true,
  "scrape_brand_site": true,
  "search_lakehouse": true
}
'

{
  "created": 123,
  "failed": 123,
  "total": 123,
  "errors": [
    {}
  ],
  "job_id": "<string>",
  "skipped": 0
}

Products

Upload Base Products Csv

Upload base products from CSV.

Authentication Required: Requires product:write permission.

CSV must have headers with columns:

Required: key, name, productType
All other columns are mapped as properties (e.g. brand, vendorId, productPageURL, color, weight, etc.)

Pipe-delimited arrays supported for any column (e.g. Red|Blue).

Maximum 250 rows allowed. Uses ProductService for creation (proper validation, versioning, NATS events).

Rows whose productType does not exist for the organization are rejected (reported per-row in errors with a did-you-mean hint) — valid rows still import. Property values are type-coerced against the org’s PropertyDefinitions (localized_text wraps to {locale, value}, boolean strings become bools) before creation.

POST

api

products

upload-base-csv

Upload Base Products Csv

curl --request POST \
  --url https://api.merchantops.ai/api/products/upload-base-csv \
  --header 'Content-Type: application/json' \
  --data '
{
  "csv_content": "<string>",
  "batch_size": 25,
  "enrich_product": true,
  "scrape_brand_site": true,
  "search_lakehouse": true
}
'

{
  "created": 123,
  "failed": 123,
  "total": 123,
  "errors": [
    {}
  ],
  "job_id": "<string>",
  "skipped": 0
}

Headers

authorization

string | null

X-Organization-ID

string | null

Cookies

stytch_session

string | null

Body

application/json

Request model for base product CSV upload.

csv_content

string

required

CSV content as string

batch_size

integer

default:25

Batch size for processing (1-50)

Required range: 1 <= x <= 50

enrich_product

boolean

default:true

Run AI enrichment (description, features, attributes)

scrape_brand_site

boolean

default:true

Scrape brand website during enrichment

search_lakehouse

boolean

default:true

Search product lakehouse for existing data

Response

Successful Response

Response model for batch product creation.

created

integer

required

Number successfully created

failed

integer

required

Number that failed

total

integer

required

Total products submitted

errors

Errors · object[]

List of errors

Show child attributes

job_id

string | null

Job ID for tracking batch progress

skipped

integer

default:0

Number unchanged (no new version created)

Get Product Count Upload Csv

⌘I