Integra tu inventario con Mercazul

You are helping me prepare a product CSV for the Mercazul B2B marketplace bulk import.

The CSV header row must start with these 10 required columns, in this exact order:
sku,name_es,name_en,description_es,description_en,category,price,moq,stock,currency
You may then append any of these 4 optional box-composition columns (by name, any order; omit them entirely for simple products):
sell_unit,units_per_box,size_breakdown,size_system

Field rules:
- sku (required): Unique product code. Upsert key within your catalog.
- name_es (required): Product name in Spanish.
- name_en (required): Product name in English.
- description_es (required): Description in Spanish.
- description_en (required): Description in English.
- category (required): Existing category name or slug (case-insensitive). Unknown categories reject the row.
- price (required): Unit price, number ≥ 0.
- moq (required): Minimum order quantity, integer ≥ 1.
- stock (required): Available stock, integer ≥ 0. Replaces the stored quantity.
- currency (required): 3-letter ISO 4217 code (e.g. USD).
- sell_unit (optional): Selling unit: individual (loose), box (by the box), or both. Blank = individual.
- units_per_box (optional): Units per box, integer ≥ 1. Required when sell_unit is box or both; must equal the sum of size_breakdown.
- size_breakdown (optional): Box composition as a comma-separated "size:qty" list. Curve: "38:1,39:2,40:3"; single size: "40:24". Must be empty for individual products.
- size_system (optional): Size system, free text (e.g. EU, US). Optional.

Additional rules:
- Rows are upserted by "sku": an unknown sku inserts a new product (it starts as a draft pending marketplace moderation); a known sku updates the existing product and replaces its stock.
- Both Spanish and English names/descriptions are required. If my source data only has one language, translate the missing one faithfully (no embellishment).
- "category" must match one of my marketplace categories; ask me for my category list if you need it.
- Box products: set sell_unit to box or both, units_per_box to the total pieces per box, and size_breakdown to a "size:qty" list (e.g. "38:1,39:2,40:3") whose quantities sum to units_per_box. Leave all 4 box columns blank for loose/individual products.

Here is a sample of my current inventory export (I will paste it below). Map it to the contract above, flag any rows that would fail validation and why, and output the final CSV in a code block.

MY DATA:
<paste your inventory export here>

You are helping me build an automated inventory sync against the Mercazul B2B marketplace API (Supabase/PostgREST).

Base URL: https://zonalibre-api.izzatissa.site
Auth: every request needs an "apikey" header (publishable key) plus "Authorization: Bearer <access_token>". The token comes from POST /auth/v1/token?grant_type=password with my seller email/password (JSON body: {"email":..., "password":...}); it expires in ~1 hour, so refresh or re-login as needed. Read credentials from environment variables — never hard-code them.

Main sync endpoint: POST /rest/v1/rpc/seller_import_products
Body: {"p_filename": "<label>", "p_rows": [ ...rows ]}
Each row has these fields (the first 10 required; the last 4 optional box-composition fields):
- sku (required): Unique product code. Upsert key within your catalog.
- name_es (required): Product name in Spanish.
- name_en (required): Product name in English.
- description_es (required): Description in Spanish.
- description_en (required): Description in English.
- category (required): Existing category name or slug (case-insensitive). Unknown categories reject the row.
- price (required): Unit price, number ≥ 0.
- moq (required): Minimum order quantity, integer ≥ 1.
- stock (required): Available stock, integer ≥ 0. Replaces the stored quantity.
- currency (required): 3-letter ISO 4217 code (e.g. USD).
- sell_unit (optional): Selling unit: individual (loose), box (by the box), or both. Blank = individual.
- units_per_box (optional): Units per box, integer ≥ 1. Required when sell_unit is box or both; must equal the sum of size_breakdown.
- size_breakdown (optional): Box composition as a comma-separated "size:qty" list. Curve: "38:1,39:2,40:3"; single size: "40:24". Must be empty for individual products.
- size_system (optional): Size system, free text (e.g. EU, US). Optional.
Rows are upserted by "sku". For products sold by the box, set sell_unit (box|both), units_per_box, and a "size:qty" size_breakdown whose quantities sum to units_per_box; leave those blank for individual products. The response includes job_id, inserted_count, updated_count and per-row error_rows — treat any error_rows as a partial failure and log them.

Job history: GET /rest/v1/product_import_jobs?order=created_at.desc&limit=10 (same auth headers).
Quick stock-only update: PATCH /rest/v1/products?sku=eq.<SKU> with a JSON body of changed fields, header "Prefer: return=representation".

My stack and source of truth for inventory: <describe yours — e.g. "a PostgreSQL ERP", "a Shopify store", "a nightly CSV export">

Write a production-quality sync script in <language of your choice> that reads my inventory, maps it to the row contract, pushes it in batches of ≤500 rows, verifies the job result, and exits non-zero on errors. Include a dry-run mode.

Full OpenAPI spec if you need it: the /openapi.yaml file on the marketplace domain.