Skip to content
PiCortex Help

Import a price list

Last updated 2026-11-09 · PiCortex Team

Import a price list

Got a price list from a supplier as a spreadsheet? Import it instead of retyping every line. You upload the file, check what will happen, and only save when it looks right.

You can also send a price list to the assistant on WhatsApp — it shows you the same summary and imports only after you confirm.

What you need

  • A .xlsx or .csv file, up to 2,000 rows.
  • One row per item. The first row holds the column names.
  • Any of these columns: Name, Code or SKU, Selling price, Cost price, Supplier, Supplier code, Lead time (days), Customer, Category, Description. Extra columns are ignored.

Import the file

  1. Go to Products & Services and click Import price list.
  2. Upload the file. The preview shows:
    • how many items will be created, updated or left unchanged;
    • how each column was matched to a product field — change any match from the dropdown;
    • any rows with problems, so you can fix them in the file and upload again.
  3. Check the preview, then click Import N products.
  4. The result shows what was imported and anything that failed.

Nothing is saved until you click the import button. If the file changes after the preview, the import asks you to preview again.

What happens to your existing items

  • A row whose Code or SKU matches an existing product only updates its prices. The name, description and everything else you may have edited stay as they are.
  • A row with no match creates a new product.
  • A Supplier column fills in that supplier's price for the item, with the supplier code and lead time if given.
  • A Customer column makes the item visible only to that customer. Leave the column out to keep the item available to everyone.

Tips

  • Use the Code or SKU column when you have one. It's the most reliable way to match rows to existing items.
  • If many rows report problems, check the column matching at the top of the preview — a wrong match is usually the cause.
Was this article helpful?

Still need help?

Contact us on WhatsApp and we'll assist you.

Import a price list | PiCortex Help