If your menu is already in your POS, you do not have to type it again. Export it from the POS and upload the file under Offerings › Import and export › Import the menu from your POS. Ovyrena turns every item into an Offering. There is no connection to the POS: export again and upload again whenever your menu changes.
Export the menu
- Square: in the Square Dashboard, open Items › Item library › Actions › Export library, choose All items and Excel or CSV.
- Clover: in the Clover Dashboard, open Inventory › Items, then the ⋮ menu › Export. Upload the Excel file as it is: Ovyrena reads its categories and tax rates from the other sheets.
- Another POS: export the item or menu list as Excel (.xlsx) or CSV. Any spreadsheet with item names and prices works.
Upload it
- Choose your POS, then what the items are (Products or Services), how they are charged, and a tax rate for items whose tax the file does not say.
- Choose the file and Check file.
- For a Square or Clover export, Ovyrena knows the columns. For any other file, choose the row with the column names and match the columns: Name and Price are required; Variation, POS code, Category, Description and Tax rate are optional. Then Check items.
- Review the changes and import them, the same way as a price list. See Export and import the price list.
What Ovyrena does with the file
- Variations: every variation becomes its own Offering, such as Draft Beer · Pint and Draft Beer · Pitcher. Clover already names its variants this way (Draft Beer Pint).
- Matching: items are matched with your Offerings by POS code (the SKU in Square), or by name when there is no code, so importing again updates prices instead of adding duplicates.
- Tax: from a Square or Clover export, each item gets the rate of the tax it has in the POS, or no tax. An item with two or more taxes gets the rate you chose for the file. Prices are read as including or before tax as set in your tax settings.
- Categories from the POS become Offering categories.
- Not imported: archived or hidden items, items sold by weight, items with a price entered at the register (no price in the file), and modifiers such as extra cheese. The preview lists the rows it leaves out.
Good to know
- Time is never charged from a POS item. A table charged by the hour keeps its own hourly Offering; see Charge per hour.
- Offerings that are not in the file are not changed.