CSV / Spreadsheet import
Import data from any platform using CSV templates.
Overview
If your current platform isn't directly supported, you can import data using CSV files. Katura provides downloadable templates for each data type.
Download CSV templates
Download the template for each type of data you want to import:
- Products β product name, description, price, SKU, images, variants
- Customers β name, email, phone, addresses, tags
- Orders β order number, date, customer, line items, totals
- Inventory β SKU, quantity, location
- Collections β name, description, product assignments
Tip
Download templates from Settings β Import Data β CSV Templates in your admin. The templates include example rows and column descriptions.
Steps to import
- Download the appropriate CSV template
- Fill in your data following the template format
- In Katura admin, go to Settings β Import Data β Upload CSV
- Select the data type (Products, Customers, etc.)
- Upload your CSV file
- Review the column mapping and make adjustments if needed
- Click Import
- Review the import report for any errors
Warning
For product images, include the full URL to each image in the image_url column. Katura will download and re-host the images automatically.
Common CSV errors
| Error | Cause | Fix |
|---|---|---|
| Missing required field | A required column is empty | Fill in all required fields (marked with * in the template) |
| Invalid price format | Prices contain currency symbols or commas | Use plain numbers: 49.99 not $49.99 |
| Duplicate SKU | Two rows have the same SKU | Ensure each product/variant has a unique SKU |
| Image URL not accessible | The image URL returns a 404 | Verify image URLs are publicly accessible |
