BuiltSync Lite and BuiltSync Full

Lite shows your SQL Server store live in BuiltOFFICE as view-only; Full (no longer offered for new stores) copies data to the cloud and writes changes back.

How-toWorks on: WindowsUpdated

The mode is chosen when BuiltPOS support or your reseller creates the store. You can see it on the BuiltSync dashboard: the badge at the top left says LITE or FULL (or LOCAL BUILTPOS).

BuiltSync Lite (the normal setup)#

  • BuiltOFFICE reads your SQL Server live through BuiltSync. Nothing is copied to the cloud.
  • BuiltOFFICE is view only for this store. A yellow strip says "Store data is view only (BuiltSync Lite). Make product, price, stock and staff changes on the store's own POS."
  • The store computer and its internet connection must be on for BuiltOFFICE to show data. When it's off, figures show — ("data unavailable").
  • The SQL login only needs db_datareader (read access).
  • Some BuiltOFFICE features that need the BuiltPOS cloud database are hidden for these stores.
  • Reports → Store Health is shown for these stores. It reports the connection to the store computer; the Terminals, KDS & Kiosk card says Not available, because sales are rung on the legacy Windows POS.

BuiltSync Full#

  • BuiltSync copies sales and other data to a cloud database every sync cycle, and writes changes made in BuiltOFFICE back to your SQL Server.
  • The SQL login needs db_datareader and db_datawriter.
  • Full is no longer offered for new stores. Stores already on Full keep working.

Which should I have?#

You don't pick it in BuiltSync. If you need to change it, contact support. Moving the store fully to BuiltPOS is the long-term way to get every feature — ask support about migrating.

Good to know#

  • In Lite mode the dashboard Overview shows the tunnel instead of sync counters: Tunnel (Up or Down), Last query, Connected since and Last disconnect. Full stores show Pushed, Pulled, Last push and Last pull. See Check that BuiltSync is connected.
  • A store whose POS runs its own BuiltPOS database on the store computer shows LOCAL BUILTPOS in the badge. It has no SQL Server step.

Was this helpful?

Still need help?

Open a ticket from the app

In any BuiltSOFTHUB app, open Help & Support and choose Report a problem. Our replies appear under My tickets.

Email us

Write to support@builtsofthub.com. Tell us the store name and what you were doing when it happened.