How to Import Products from CSV
Bulk-import your product catalog with a CSV file. Includes a downloadable template and an AI prompt that turns a list of product names into a ready-to-import CSV.
Published · Updated
How to Import Products from CSV
Bulk-import your product catalog with a CSV file in three steps. This guide ships with a starter template and an AI prompt that turns a plain list of product names into a valid CSV.
New to CSV imports? Start by downloading the template below — every column header matches a Biokit product field exactly.
1. Download the template
Download products-template.csvThe template includes one row per product type (physical, digital, service) so you can see what valid data looks like.
2. Generate or fill in your products
Open the file in any spreadsheet (Numbers, Excel, Google Sheets) and replace the example rows with your products.
Field reference
| Column | Required | Description |
|---|---|---|
name | yes | Product title — up to 200 characters. |
price | yes | Decimal price in your currency, e.g. 29.99. |
currency | no | 3-letter code (USD, EUR, GBP...). Defaults to USD. |
description | no | Up to 1000 characters. Quote it if it contains commas. |
category | no | Free-form label used to group products on your store page. |
paymentUrl | no | Where the "Buy" button takes the customer. Full URL (Stripe, Lemon Squeezy, Gumroad, etc.). Leave empty to add it later from the dashboard. |
imageUrl | no | Full public image URL. |
type | no | physical, digital, or service. Defaults to digital. |
Rules to avoid an error
- Save as UTF-8 CSV, not UTF-16.
- Wrap any field that contains a comma or a line break in double quotes.
- Escape an embedded
"by doubling it:"He said ""hi""". - Keep prices as plain numbers — no
$sign, no thousands separator.1299.00is fine;$1,299.00is not.
3. Don't want to type? Use this AI prompt
Paste a list of product names into ChatGPT, Claude, or Gemini together with this prompt and it will hand back a CSV that matches the template exactly.
You are a CSV-formatting assistant for the Biokit product importer.
Given the list of products below, return a single CSV that:
- Uses exactly these columns in this order: name, price, description, category, currency, paymentUrl, imageUrl, type
- Includes a header row.
- Writes price as a plain decimal in the product's currency (e.g. $29 →
29.00, no$, no thousands separator). - Quotes any field containing a comma, double quote, or newline.
- Leaves optional columns empty (back-to-back commas) when unknown — never invent URLs.
- Uses currency "USD" unless the user specifies otherwise.
- Sets type to one of: physical, digital, service. Infer from the product name when obvious.
- Writes a 1-sentence description for each product unless one is given.
Return only the CSV — no markdown fences, no commentary.
Products: — PASTE YOUR LIST HERE —
Always open the AI-generated CSV in a spreadsheet and skim each row before importing. Models occasionally invent prices or make up URLs.
4. Import the file
In your Biokit dashboard:
- Open the Store that should receive the products.
- Click Import products in the toolbar.
- Drop your CSV onto the upload area or click to choose it.
- Review the preview Biokit shows you. Bad rows are flagged with the exact reason.
- Click Import. Successful rows appear in your product list immediately.
That's it — your catalog is live.
Troubleshooting
"Invalid price" — Remove the currency symbol and thousands separator. $1,299.00 becomes 1299.00.
"Encoding error" — Re-save the file as CSV UTF-8 (Comma delimited). Excel sometimes saves as UTF-16 by default.
Some rows are skipped — Each skipped row shows the column that failed. Common culprits: missing name, missing price, malformed URLs.
Need to update existing products? — CSV import only adds new rows. To bulk-edit existing products, export them, edit, and use the Shopify import guide flow as a model — separate update flow ships next.