All imports

Sale Items / Products

Import menu items from POS exports or a spreadsheet. Auto-creates categories and assigns revenue accounts.

Free

Supported Formats

POS Product List (.xlsx)

Currently supports POPOK POS product catalog export.

More POS systems coming soon

BasilBook Template (.xlsx / .csv)

Your own file with matching column headers.

Column Reference

ColumnRequiredDescription
nameProduct/menu item name
sellingPriceBase selling price
categoryCategory (auto-created if new)
productCodeExternal product code / SKU
unitUnit of measure
costPriceCost price for margin calculation
revenueAccountCode
  • Links this item to a specific revenue account in your Chart of Accounts.
  • When a sale is recorded, the system auto-generates a journal entry that credits this account — so your financial reports show exactly how much revenue comes from food vs beverages vs delivery.
  • Common codes: 4000 (Food Revenue), 4100 (Beverage Revenue), 4210 (Delivery Food Revenue)
  • Leave blank to use the default revenue account.
descriptionOptional description

How It Works

  • Auto-detects POPOK vs BasilBook format
  • Matches by productCode first, then name
  • revenueAccountCode maps to your Chart of Accounts — see /chart-of-accounts for available codes
  • Sales generate automatic journal entries via the Auto-Journal engine — learn more at /auto-journal
  • Available during onboarding and Setup Wizard

API Endpoint

POST/api/sale-items/import

Ready to import sale items / products?