Inventory Upload Guide (Excel / API)
As a partner, you can transfer your inventory to PartAndStock in two ways: bulk upload via Excel (XLSX) or an automatic feed through your own API. This guide explains the steps, required fields and common mistakes so your products appear correctly in search results.
1. Upload via Excel
The most practical way for small/medium product counts or manually updated inventories. Just drag and drop your prepared spreadsheet.
2. Feed via API
For large inventories where stock and price change often. You define your own API endpoint; your products stay up to date automatically.
Upload via Excel
Supported formats: .xlsx and .xls. Up to 25 MB. The first row must be the header row; headers can be written in Turkish or English — the system detects them automatically.
Required columns
| MPN | Manufacturer part number (e.g. NE555P). Required. |
| Brand | Manufacturer / brand name (e.g. Texas Instruments). Required. |
Optional columns
| Stock | Quantity on hand (integer). Treated as 0 if empty. |
| Price | Unit price. A single value or price breaks can be entered. |
| Price Breaks | Quantity:price pairs — 1:0.55; 10:0.48; 100:0.42 |
| Currency | TRY, USD, EUR... Defaults to TRY if empty. |
| Product Name | The title shown in the listing. |
| Description | Short product description. |
| Category | The part's category (e.g. Resistors, MOSFET, Capacitors). If it matches an existing category name on the site, it appears in filters and category pages. Technical specs are auto-enriched from the MPN — you don't need to enter them. |
| SKU | Your own stock code. |
| MOQ | Minimum order quantity. |
| Packaging | Reel / Tube / Tray / Cut Tape, etc. |
| Image URL | Full address of the product image. |
| Redirect URL | The page the customer is redirected to for purchase. |
How to write price breaks?
In a single cell, write quantity:price pairs separated by semicolons:
1:0.55; 10:0.48; 100:0.42; 1000:0.37
That is, 1 unit at 0.55; 10+ units at 0.48; 100+ units at 0.42 per unit. For a single price, just write 0.55.
Example table
| MPN | Brand | Stock | Price Breaks | Currency |
|---|---|---|---|---|
| NE555P | Texas Instruments | 5400 | 1:0.55; 10:0.48; 100:0.42 | TRY |
| LM358N | ON Semiconductor | 1200 | 1:0.90 | TRY |
Column order doesn't matter; the system matches by header names.
Upload Excel in partner panelFeed via API
If your inventory is kept in your own system, enter your connection details from the List Products via API page in the partner panel. Fields you'll define:
| Base URL (baseUrl) | The root address of your API, e.g. https://api.firmaniz.com/v1 |
| Authentication type | API Key, Bearer Token, Basic Auth, OAuth 2.0 or no authentication. |
| API key / secret | Stored encrypted; never shown in raw form on screen. |
| Search endpoint | e.g. /products/search |
| Detail endpoint | e.g. /products/{mpn} |
What happens after upload?
- 1
File is received and queued
When your Excel is uploaded, a processing batch is created and its status progresses as Queued → Processing → Completed.
- 2
Rows are validated
Each row is checked; invalid rows are skipped and shown as an error count in the “Recent Uploads” table. Product offers are generated from valid rows.
- 3
Products go live
If your partner membership is approved and your payment is complete, your products start appearing in search results within a few seconds.
Common mistakes
- Leaving the MPN or Brand column empty — these two fields are required; incomplete rows are skipped.
- Writing the price as text (e.g. with a currency symbol). Use only a number or the price-break format.
- Using wrong separators in price breaks — use a colon (:) between quantity and price, and a semicolon (;) between pairs.
- Files over 25 MB — split a large inventory into parts or use the API feed.
Not a partner yet?
To publish your inventory, apply by choosing a partner membership plan.