Upload a CSV
This page covers two CSV upload paths:
- Portal CSV upload — you log into the Kennicott Core portal and upload a CSV file through the UI
- API CSV upload — your system sends a CSV to Kennicott Core programmatically (requires an API key)
Both paths use the same product data requirements. The difference is who is doing the uploading and how.
Portal CSV upload
Who this is for: Vendors who log into the Kennicott Core portal to manage their catalog.
What you need
- A portal login
- Your product data in CSV format
- The CSV template or column headers your Kennicott Core administrator has configured for your account
Steps
- Sign in to the Kennicott Core portal
- Go to Products → Upload Products
- Click Upload CSV and select your file
- Wait for processing to complete (usually a few seconds to a minute)
- Review the results — Kennicott Core shows you how many rows were accepted and any rows that need attention
- Fix any flagged rows in your file and re-upload if needed
- Your Kennicott Core administrator will review and publish approved products to Shopify
After uploading
Go to Product Uploads to see your upload history. Click on any upload to see:
- How many products were created or updated
- Any rows with errors and what to fix
Products created via CSV are not published automatically. Your Kennicott Core administrator publishes them after review.
API CSV upload
Who this is for: Vendors using the API path whose systems produce CSV exports.
The API CSV flow uses the same steps as the JSON feed — the only difference is the file format and sourceFormat value.
See Connect by API for the full step-by-step.
The key differences when sending CSV:
- Set
"sourceFormat": "CSV"in the upload request - Upload a CSV file to the presigned URL instead of a JSON array
- Column headers in the CSV must match your configured feed profile
CSV format
Required columns
Every CSV must have these columns. The exact column header names depend on your configured profile — your Kennicott Core administrator will confirm what to use.
| What you're sending | Example value |
|---|---|
| Your product SKU (one per product family) | ROSE-RED-STD |
| Product name | Red Standard Rose |
| Box type | HB |
| Unit of sale | Bunch |
Columns required before Shopify publish
These can be blank when you first submit your catalog. Add them before products are published.
| What you're sending | Example value |
|---|---|
| Price | 42.50 |
| Available from (date) | 2026-07-01 |
Optional columns
| What you're sending | Example value |
|---|---|
| Color | Red |
| Grade | Select |
| Variety | Freedom |
| Stems per bunch | 25 |
| Units per box | 20 |
| Bunches per box | 20 |
| Total units per box | 500 |
| Available to (date) | 2026-09-30 |
| Image URL | https://example.com/rose.jpg |
Multiple pack sizes (variants)
To create multiple Shopify variants for one product, use multiple rows with the same product SKU. Each row is a different pack size.
Example — one rose product with two pack sizes:
SKU,Product Name,Box Type,Units/Box,Sell Unit,Price,Available From
ROSE-RED-STD,Red Standard Rose,QB,10,Bunch,24.50,2026-07-01
ROSE-RED-STD,Red Standard Rose,HB,20,Bunch,45.00,2026-07-01
This creates one Shopify product ("Red Standard Rose") with two variant options: "QB · 10 Bunches" and "HB · 20 Bunches".
Sample CSV
Use this as a starting template. Replace the data with your own products.
SKU,Product Name,Box Type,Sell Unit,Units/Box,Bunches/Box,Stems/Bunch,Color,Grade,Variety,Price,Available From,Available To
ALST-ASST-001,Alstroemeria Assorted,EB,Bunch,4,4,10,Assorted,Select,Super Select,18.50,2026-07-01,2026-09-30
ALST-ASST-001,Alstroemeria Assorted,HB,Bunch,18,18,10,Assorted,Select,Super Select,72.00,2026-07-01,2026-09-30
ROSE-RED-001,Red Standard Rose,QB,Bunch,10,10,25,Red,Select,Freedom,24.50,2026-07-01,2026-09-30
ROSE-RED-001,Red Standard Rose,HB,Bunch,20,20,25,Red,Select,Freedom,45.00,2026-07-01,2026-09-30
The exact column headers your file needs depend on your Kennicott Core feed profile configuration. Your administrator will confirm the correct headers for your account. The names above are illustrative.
Common issues
| What you see | Why it happened | What to do |
|---|---|---|
| Rows skipped — missing required field | A required column is blank or the header doesn't match | Check column headers match your configured profile |
| Duplicate rows | The same SKU + box type combination appeared twice | Remove duplicates from your file |
| Conflict — same SKU, different values | Two rows have the same identity but different product names | Check your source data for inconsistencies |
| Price not accepted | Price is not a valid number | Use a plain decimal like 42.50 without currency symbols |
| Date not accepted | Date is in the wrong format | Use YYYY-MM-DD format: 2026-07-01 |
:::note Planned feature A bulk CSV import with additional business rules (maximum 10,000 rows, inventory snapshot format, and file-level validation) is planned for a future release. This page will be updated when that feature is available. :::
Next step
→ Product and Inventory Requirements — the full field reference