4.5. Updating Products from Excel

Instead of editing products one by one, you can update them in bulk with Excel. This flow is separate from stock or ingredient Excel; it starts from the product list only.

Open the product list

In Management, open Products and go to the product list. If you cannot manage products, this page or the Actions menu may be hidden.

Product list page
Product list

Download the Excel template

Open Actions at the top of the list and choose Upload from the Excel file (Turkish UI may show Excel dosyasından yükle). In the dialog, download the format file. The template URL is https://files.ritapos.com/excel/products.xlsx.

Actions menu with Excel upload
Actions menu
Upload Excel file dialog
Excel upload dialog

The same menu may include an external-id Excel option. This lesson covers the product template only; do not mix the two.

What the columns mean

The template includes these columns:

  • category — product group / category name
  • product — product name
  • description — description
  • cost — cost
  • salePrice — sale price
  • happyHourPrice — happy hour price
  • taxRate — tax rate
  • barcode — barcode
  • amount — amount field

Matching uses category plus product name: existing rows update, missing ones are created. If amount is greater than 0, a related ingredient or recipe row may also be created or updated; the dialog warns about this.

Upload the file

Select your filled file and choose Upload (Yükle). If you see errors or warnings, fix the rows against the template and try again. Use Cancel to close without uploading.

Note: The stock and ingredient Excel lesson (5.1.4) is a different list. Product updates always start from the product list.