> ## Documentation Index > Fetch the complete documentation index at: https://docs.closient.com/llms.txt > Use this file to discover all available pages before exploring further. # Bulk import products from CSV > Upload a CSV file to create or update products in bulk. The CSV must include a GTIN column (also accepts ``barcode``, ``upc``, ``ean``, or ``gtin-8`` / ``gtin-12`` / ``gtin-13`` / ``gtin-14``). Optional columns: ``product_name`` (also ``name`` / ``title``), ``brand``, ``manufacturer``, ``description``, ``image_url`` (also ``image`` / ``photo_url``), ``country_of_origin`` (also ``country`` / ``origin``), ``net_content`` (also ``size`` / ``weight`` / ``volume``). Maximum upload size is 10 MiB; maximum 10,000 data rows per upload. Imported products are claimed for the authenticated user's organization with BRAND_CLAIMED authority. The endpoint returns 200 with a per-row error report even on partial success — only request-level failures (auth, file type, file size, no brand membership) produce 4xx responses. ## OpenAPI ````yaml /openapi/openapi-products.json post /products/api/v1/import/csv openapi: 3.1.0 info: title: Products API version: 1.0.0 description: > Look up, claim, and browse GTINs in the Closient product repository. ## Authentication All endpoints require an API key passed via the `X-API-Key` HTTP header, unless otherwise noted. ``` X-API-Key: csb__ ``` Generate API keys in **Settings > API Keys** in your dashboard, or via the Account API. Session-based (cookie) authentication is also accepted for browser-based access. ## Rate Limits | Tier | Requests / minute | Requests / day | |-------------|-------------------|----------------| | Default | 300 | 10,000 | | Custom | Contact us | Contact us | Rate-limit headers are included on every response so callers can self-throttle without hitting our 429s ("informed governor"): - `RateLimit-Policy` — every active window, e.g. `300;w=60, 10000;w=86400` - `RateLimit-Limit` — quota for the **most-restrictive** currently-active window - `RateLimit-Remaining` — requests left in that window - `RateLimit-Reset` — seconds until that window resets (relative; clock-skew safe) Legacy `X-RateLimit-*` aliases are also emitted for back-compat. `X-RateLimit-Reset` keeps the absolute Unix-timestamp shape to avoid breaking existing consumers. When rate-limited, you receive `429 Too Many Requests` with a `retry_after_seconds` field in the error envelope and a `Retry-After` header. ## Pagination List endpoints return paginated results in this envelope: ```json { "data": [...], "pagination": { "page": 1, "page_size": 25, "total_count": 342, "total_pages": 14, "has_next": true, "has_previous": false } } ``` Use `?page=2&page_size=50` query parameters. Maximum page size is 100. ## Error Responses All errors conform to [RFC 9457 Problem Details](https://www.rfc-editor.org/rfc/rfc9457) with `Content-Type: application/problem+json`: ```json { "type": "https://closient.com/docs/errors/not_found", "title": "Not Found", "status": 404, "detail": "The requested resource was not found.", "error_code": "not_found", "retryable": false, "timestamp": "2026-03-31T12:00:00+00:00" } ``` Common error codes: `unauthorized` (401), `forbidden` (403), `not_found` (404), `validation_error` (422), `rate_limited` (429), `internal_error` (500). termsOfService: https://www.closient.com/terms/ servers: - url: https://www.closient.com security: [] tags: - name: Products description: Look up, claim, and browse products and trade items. - name: Product Group description: Manage GDSN packaging hierarchy relationships. - name: Import description: Bulk import products from CSV files. - name: QR description: Generate QR codes encoding GS1 Digital Link URLs. - name: Codes description: Generate GS1 DataMatrix and 1D barcodes (EAN/UPC/ITF-14/Code128). - name: Digital Link description: >- Parse GS1 Digital Link URIs into structured AIs (GTIN, lot, expiry, serial). - name: Labels description: >- Bulk label-export jobs: ZIPs of QR / DataMatrix / 1D symbols and multi-up sheet PDFs, async via Celery with status polling. externalDocs: description: Closient Documentation url: https://docs.closient.com paths: /products/api/v1/import/csv: post: tags: - Import summary: Bulk import products from CSV description: >- Upload a CSV file to create or update products in bulk. The CSV must include a GTIN column (also accepts ``barcode``, ``upc``, ``ean``, or ``gtin-8`` / ``gtin-12`` / ``gtin-13`` / ``gtin-14``). Optional columns: ``product_name`` (also ``name`` / ``title``), ``brand``, ``manufacturer``, ``description``, ``image_url`` (also ``image`` / ``photo_url``), ``country_of_origin`` (also ``country`` / ``origin``), ``net_content`` (also ``size`` / ``weight`` / ``volume``). Maximum upload size is 10 MiB; maximum 10,000 data rows per upload. Imported products are claimed for the authenticated user's organization with BRAND_CLAIMED authority. The endpoint returns 200 with a per-row error report even on partial success — only request-level failures (auth, file type, file size, no brand membership) produce 4xx responses. operationId: apps_products_api_imports_csv_import parameters: [] requestBody: content: multipart/form-data: schema: properties: file: description: CSV file to import. Must be UTF-8 encoded. format: binary title: File type: string required: - file title: FileParams type: object required: true responses: '200': description: OK content: application/json: schema: $ref: '#/components/schemas/CSVImportResultOut' '401': description: Unauthorized content: application/json: schema: $ref: '#/components/schemas/ErrorOut' '403': description: Forbidden content: application/json: schema: $ref: '#/components/schemas/ErrorOut' '422': description: Unprocessable Content content: application/json: schema: $ref: '#/components/schemas/ErrorOut' security: - APIKeyHeaderAuth: [] - OAuthTokenAuth: [] - SessionAuth: [] components: schemas: CSVImportResultOut: description: |- Outcome of a single CSV upload to ``POST /import/csv``. The four counters (``created`` / ``updated`` / ``skipped`` / ``error_count``) sum to ``total_rows`` for any successful request. The endpoint returns 200 even when individual rows fail — per-row failures are reported in ``errors`` rather than aborting the whole upload. A non-empty ``errors`` list is therefore expected on partial success and is not itself an error condition. examples: - created: 42 error_count: 2 errors: - column: gtin line: 12 message: 'Invalid GTIN: must be 8, 12, 13, or 14 digits.' - line: 37 message: Row is empty. skipped: 1 total_rows: 50 updated: 5 - created: 25 error_count: 0 errors: [] skipped: 0 total_rows: 25 updated: 0 properties: total_rows: description: Total number of data rows processed (excluding the header row). minimum: 0 title: Total Rows type: integer created: description: Number of new products created from the upload. minimum: 0 title: Created type: integer updated: description: Number of existing products updated (matched by GTIN). minimum: 0 title: Updated type: integer skipped: description: >- Number of rows skipped because they were duplicates of an earlier row or yielded no changes. minimum: 0 title: Skipped type: integer error_count: description: >- Number of rows that failed validation. Equals the length of ``errors``. minimum: 0 title: Error Count type: integer errors: description: Per-row validation failures. Empty when every row imported cleanly. items: $ref: '#/components/schemas/RowErrorOut' title: Errors type: array required: - total_rows - created - updated - skipped - error_count title: CSVImportResultOut type: object ErrorOut: description: |- RFC 9457 Problem Details response. All API errors are returned in this format with Content-Type: application/problem+json. examples: - detail: The requested resource was not found. error_code: not_found retryable: false status: 404 timestamp: '2026-03-31T12:00:00+00:00' title: Not Found type: https://closient.com/docs/errors/not_found - detail: Validation error. details: - loc: - body - name msg: Field required type: missing error_code: validation_error retryable: false status: 422 timestamp: '2026-03-31T12:00:00+00:00' title: Validation Error type: https://closient.com/docs/errors/validation_error - detail: Rate limit exceeded. Please try again later. error_code: rate_limited retry_after: 31 retryable: true status: 429 timestamp: '2026-03-31T12:00:00+00:00' title: Rate Limited type: https://closient.com/docs/errors/rate_limited properties: type: description: URI reference identifying the error type. title: Type type: string title: description: Short human-readable summary of the error. title: Title type: string status: description: HTTP status code. title: Status type: integer detail: description: Human-readable explanation of this specific occurrence. title: Detail type: string error_code: description: Machine-readable error code (e.g. not_found, unauthorized). title: Error Code type: string retryable: default: false description: Whether retrying the same request can succeed. title: Retryable type: boolean timestamp: description: ISO 8601 timestamp of when the error occurred. title: Timestamp type: string retry_after: anyOf: - type: integer - type: 'null' description: Seconds to wait before retrying (when applicable). title: Retry After owner_action_required: anyOf: - type: boolean - type: 'null' description: Whether the error requires account owner intervention. title: Owner Action Required details: description: Additional context (validation errors, etc.). title: Details required: - type - title - status - detail - error_code - timestamp title: ErrorOut type: object RowErrorOut: description: |- Validation failure for a single CSV row. Returned inside :class:`CSVImportResultOut.errors`. ``line`` is the 1-indexed CSV row number (the header row is line 1, so the first data row is line 2). ``column`` is set when the failure can be attributed to a specific column; it is null for row-level failures such as an empty row or a malformed line. examples: - column: gtin line: 12 message: 'Invalid GTIN: must be 8, 12, 13, or 14 digits.' - line: 37 message: Row is empty. properties: line: description: >- 1-indexed CSV row number where the error occurred. The header counts as line 1, so the first data row is line 2. minimum: 1 title: Line type: integer column: anyOf: - type: string - type: 'null' description: >- CSV header name of the column that caused the error. Null for row-level failures (empty row, unparsable line) where no single column is at fault. title: Column message: description: >- Human-readable error description suitable for surfacing to the uploader. title: Message type: string required: - line - message title: RowErrorOut type: object securitySchemes: APIKeyHeaderAuth: type: apiKey in: header name: X-API-Key OAuthTokenAuth: type: http scheme: bearer SessionAuth: type: apiKey in: cookie name: sessionid ````