Skip to main content

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​

  1. Sign in to the Kennicott Core portal
  2. Go to Products → Upload Products
  3. Click Upload CSV and select your file
  4. Wait for processing to complete (usually a few seconds to a minute)
  5. Review the results — Kennicott Core shows you how many rows were accepted and any rows that need attention
  6. Fix any flagged rows in your file and re-upload if needed
  7. 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 sendingExample value
Your product SKU (one per product family)ROSE-RED-STD
Product nameRed Standard Rose
Box typeHB
Unit of saleBunch

Columns required before Shopify publish​

These can be blank when you first submit your catalog. Add them before products are published.

What you're sendingExample value
Price42.50
Available from (date)2026-07-01

Optional columns​

What you're sendingExample value
ColorRed
GradeSelect
VarietyFreedom
Stems per bunch25
Units per box20
Bunches per box20
Total units per box500
Available to (date)2026-09-30
Image URLhttps://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
note

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 seeWhy it happenedWhat to do
Rows skipped — missing required fieldA required column is blank or the header doesn't matchCheck column headers match your configured profile
Duplicate rowsThe same SKU + box type combination appeared twiceRemove duplicates from your file
Conflict — same SKU, different valuesTwo rows have the same identity but different product namesCheck your source data for inconsistencies
Price not acceptedPrice is not a valid numberUse a plain decimal like 42.50 without currency symbols
Date not acceptedDate is in the wrong formatUse 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