Importing Products from CSV

Upload a CSV file to add products in bulk. Map your columns, preview the data, and import everything at once.

Prepare Your CSV File

A CSV (Comma-Separated Values) file is a simple text file where each line is a product and columns are separated by commas. You can create one using Excel, Google Sheets, or any text editor.

Minimum Requirements

  • The file must contain at least a Name column for each product.
  • Additional columns like Price, Description, and Category are optional.
  • Save the file in CSV format (.csv).
Tip: If you already have a product list in a spreadsheet, simply export or save it as a CSV file.

Upload & Map Columns

  1. Go to Import & Export

    Navigate to Settings and select Import & Export.

  2. Upload Your CSV

    Tap the Add button in the Product List section and select your CSV file.

  3. Preview and Map Columns

    An import preview dialog opens showing your data in a table. Use the dropdown at the top of each column to tell GetCost what that column represents (Name, Price, Description, etc.).

  4. Set Access Rights

    Choose who can see the imported products: Private (only you) or Team (your whole team).

  5. Import

    Tap Import to add all the products. The import button is enabled once all required columns are mapped.

Note: Previously uploaded import lists are saved and shown on the Import & Export page. You can delete an old list by tapping the delete button next to it.

Available Columns

When mapping your CSV columns, you can assign each column to one of the following fields.

Column Description
Name The product name (required).
Price The unit price of the product.
Description A text description of the product.
Shelfcode A shelf code or SKU for the product.
URL A web link to the product.
Unique ID An external identifier for the product.
Store Name The store this product comes from.
Hierarchy Product category path using pipe separators (e.g., Flooring|Hardwood|Oak).
Not Used Skip this column during import.
Tip: Use the Hierarchy column to automatically organize imported products into categories. Separate each level with a pipe character (|).

Tips

📋

Check Your Data First

Review the preview table before importing to make sure columns are mapped correctly and data looks right.

📦

Import Other Data Too

The same import page supports importing clients, estimates, invoices, and transactions from CSV files.

🛠

Export First as a Template

Export your existing products to see the CSV format, then use that file as a template for preparing new imports.