Import products
On this page
If your catalogue already lives in a spreadsheet, import it instead of adding products one by one. Each row becomes one product with its price, stock and collection, ready to sell.
Prepare your file#
Kartlo reads .csv and .xlsx files with up to 5,000 rows. The first row must hold the column names. Only two columns are required: the product name and the price.
For a ready-made layout, open the import window and click Download Template (.xlsx). It contains every column with one example row.
| Column | Notes |
|---|---|
| Title | Required. The product name. |
| Price | Required. The selling price. |
| Handle (URL slug) | The web address of the product. Made from the title when blank. |
| Description | Product description. |
| Collection | Collection name. A collection that does not exist yet is created for you. |
| Product Type | Your own grouping, such as Bag or Shirt. |
| Vendor | Brand or maker. |
| SKU | Your stock code. Must be unique in your store. |
| Barcode | ISBN, UPC, EAN or GTIN. |
| Compare-at Price | Shown struck through to signal a discount. |
| Cost per Item | What you pay for it. Never shown to shoppers. |
| Quantity | Stock on hand. Blank means 0. |
| Weight (grams) | Used for shipping rates. |
| Status (active/draft/archived) | Blank means active. |
Import the file#
To import products:
- Open Products from your desk and click Import.
- Upload: drop your file into the window, or click to browse.
- Map: check which Kartlo field each of your columns goes into. Set a column to Ignore this column to skip it. Click Preview Data.
- Preview: review the rows. Rows with problems are listed with the reason, such as a missing price, and are left out.
- Click Import (the button shows how many products will be created).
- Result: see how many products were imported and skipped. Expand the list to see why each skipped row failed.
Click Import More to load another file, or Done to close.
What an import creates#
- One product per row, at one price, with stock tracking switched on.
- The product in the named collection, creating the collection if needed.
- A unique web address. If a handle is already used in your store, a short suffix is added rather than skipping the row.
Cost per item and the Accounting app#
When the Accounting app values your stock, every row needs a Cost per Item. Rows without one are skipped with a message saying the cost is required.
Current limits#
- Each row creates a single product with no options. Add sizes or colours by creating the product with options; see Variants.
- Photos cannot be imported from the file, by URL or otherwise. Add them on the product or from the media library.
- Importing does not update existing products. Each row always creates a new product.