> ## Documentation Index
> Fetch the complete documentation index at: https://offergrid.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk update offers from CSV

> Upload a CSV file to update multiple existing offers at once, using the same template as bulk upload (GET /bulk-upload/template). Each row is matched to an existing offer by its "sku" column (scoped to your team), so "sku" is required on every row. Blank cells leave the existing value unchanged — only non-blank columns are applied — which means this endpoint cannot clear a field back to empty. Rows whose SKU does not match one of your offers are reported as errors and never created.



## OpenAPI

````yaml /openapi/openapi-provider.json post /provider/offers/bulk-update
openapi: 3.0.0
info:
  title: OfferGrid API
  description: >-
    **Provider API** - Create and manage service offerings, fulfill orders from
    resellers.


    As a provider, you can:

    - Create and publish service offerings (internet, electricity)

    - Control which resellers can access your offers (all, preferred, or
    selected)

    - View and manage orders from resellers

    - Update order fulfillment status and schedule installations

    - Track order lifecycle from pending to completion
  version: '1.0'
  contact: {}
servers:
  - url: https://api.offergrid.io
    description: Production
  - url: http://localhost:3000
    description: Local development
security: []
tags:
  - name: provider-offers
    description: 'Provider: Manage your service offerings'
  - name: provider-orders
    description: 'Provider: Fulfill orders from resellers'
paths:
  /provider/offers/bulk-update:
    post:
      tags:
        - provider-offers
      summary: Bulk update offers from CSV
      description: >-
        Upload a CSV file to update multiple existing offers at once, using the
        same template as bulk upload (GET /bulk-upload/template). Each row is
        matched to an existing offer by its "sku" column (scoped to your team),
        so "sku" is required on every row. Blank cells leave the existing value
        unchanged — only non-blank columns are applied — which means this
        endpoint cannot clear a field back to empty. Rows whose SKU does not
        match one of your offers are reported as errors and never created.
      operationId: ProviderOffersController_bulkUpdate
      parameters: []
      requestBody:
        required: true
        content:
          multipart/form-data:
            schema:
              type: object
              properties:
                file:
                  type: string
                  format: binary
                  description: >-
                    CSV file with offer data (use the template from GET
                    /bulk-upload/template)
      responses:
        '201':
          description: Bulk update completed
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BulkUpdateResultDto'
        '400':
          description: Invalid CSV file or validation errors
      security:
        - api-key: []
components:
  schemas:
    BulkUpdateResultDto:
      type: object
      properties:
        totalRows:
          type: number
          description: Total rows processed
        successCount:
          type: number
          description: Number of successfully updated offers
        errorCount:
          type: number
          description: Number of failed rows
        updatedOfferIds:
          description: Updated offer IDs
          type: array
          items:
            type: string
        errors:
          description: Detailed errors for failed rows
          type: array
          items:
            type: object
        warnings:
          description: Warnings for all rows
          type: array
          items:
            type: object
      required:
        - totalRows
        - successCount
        - errorCount
        - updatedOfferIds
        - errors
      title: Bulk Update Result
  securitySchemes:
    api-key:
      type: apiKey
      in: header
      name: x-api-key
      description: >-
        Team API key for authentication. Your team role
        (provider/reseller/hybrid) determines which endpoints you can access.

````