You can upload a catalog in a CSV from anywhere. Here is the format we expect, and what we do when your file is messy.
The minimum columns
Your CSV needs five columns at minimum:
- sku — your internal product identifier, must be unique
- name — the product name as it should appear to clinics
- price_cents — the price in cents (so 4995 means $49.95). If your file has dollars and cents (like 49.95), we will convert it.
- category — a free-form text category. We map it to our taxonomy.
- description — a paragraph or two about the product
Anything else you put in the file we will keep — extra columns become attributes that clinics can filter on (size, dose, manufacturer, etc).
What we do with messy files
If your file has different column names — say "Item Number" instead of "sku" — we map it for you. The first import takes longer because your operator hand-walks the column mapping with you. Future imports use the same mapping automatically.
If your file has duplicate rows, we use the most-recent. If a row has missing required fields, we flag it for you to review instead of importing it broken.
Updating an existing catalog
Re-upload the same CSV. We compare against what is already in the system and:
- New SKUs get added
- Existing SKUs get updated (price, description, attributes)
- SKUs missing from the new file stay live unless you check the "delete missing" box
So your normal workflow is: change your master spreadsheet, export to CSV, drop it in. Five seconds.
What about images?
For the first import, you can leave the image column blank and we will source images from the manufacturer when available. For your own product photography, the image column should hold a URL to each photo. We download and re-host the images so your CDN bill does not go up.