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

  1. Download the appropriate CSV template
  2. Fill in your data following the template format
  3. In Katura admin, go to Settings β†’ Import Data β†’ Upload CSV
  4. Select the data type (Products, Customers, etc.)
  5. Upload your CSV file
  6. Review the column mapping and make adjustments if needed
  7. Click Import
  8. 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

ErrorCauseFix
Missing required fieldA required column is emptyFill in all required fields (marked with * in the template)
Invalid price formatPrices contain currency symbols or commasUse plain numbers: 49.99 not $49.99
Duplicate SKUTwo rows have the same SKUEnsure each product/variant has a unique SKU
Image URL not accessibleThe image URL returns a 404Verify image URLs are publicly accessible

Was this article helpful?

CSV Import β€” Bulk Data Import from Any Platform | KATURA