Data

The Data panel provides database administration tools, API connection settings, cache management, and bulk data import/export.

Database Schema

The database schema section provides administrative controls for data management and end-of-day operations.

Manage Data

Expand the "Manage Data" section to access:

• Update Schema — Synchronizes the database schema to the current app version.
• Export Log — Exports application logs to a text file.
• Update Images — Refreshes image data from storage.
• Clean Data — Runs a data cleanup process to remove duplicate settings records.

Operations

End-of-day closing and Z-run operations:

• New ZRunID — Initializes a new Z-run identifier for the current business period.
• Close All — Archives all open periods at once.
• Close By Date — Archive a single day's transactions. Select the date from the date picker.
• Close By Date Range — Archive transactions within a start and end date range.
• ZRunID — Enter a specific Z-run ID and click "Close Only Transactions By ID" to close transactions for that batch without running credit card, METRC, email, or balance sheet closing.

Version Display

Shows the current APP Version, API Version, and API Database Release for reference.

API Connection Settings

Configures the backend API endpoint the app connects to.

Fields:

• Subdomain — Your site name (e.g., mysite).
• Domain — Dropdown with pre-configured domains:
  • pointlessposdemo1.com
  • pointlessposdemo2.com
  • pointlessposdemo3.com (default)
  • Custom... — Select to enter a custom domain.
• Custom Domain Input — Appears only when "Custom..." is selected.

The current and new API URLs are displayed for preview before saving.

Actions:

• Save — Stores the API URL in localStorage and reinitializes the app connection.
• Exit — Logs out the current user.

Compression

Toggle Enable Compression to enable data compression for API communication (stored in localStorage).

Cache Settings

Manages application caching and localStorage.

Settings:

• Enable Cache — Toggle to enable/disable app caching.
• Cache Time — Set the cache duration value.
• Debug Mode — Toggle to enable debug mode on this device (writes debugOnThisDevice to localStorage).

Actions:

• Delete Cache — Clears localStorage and logs out the current user. This does not affect other users or terminals.

The estimated cache size (in KB) is displayed for reference.

WordPress Token

Generate a temporary WordPress plugin token (valid for 5 minutes). Click Get WordPress Token to generate, then use the copy button to copy the token text. This token connects the POS data to a WordPress CMS instance.

Import / Export

CSV Import

Bulk data import from CSV files with progress tracking.

Schema Types:

Schema	Type
1	Products
2	Inventory
3	Contacts
4	FlowHub Products
5	FlowHub Prices
6	FlowHub Inventory
7	FlowHub Clients
8	FlowHub Vendors
9	FlowHub Strains
14	METRC Reconciliation
15	Inventory Reconciliation

Settings:

• Schema Type Selection — Choose the import schema from the dropdown.
• Ignore Headers — Toggle to skip CSV header rows.
• File Input — Supports drag-and-drop .csv files.
• Download Example — Downloads a sample CSV template for the selected schema.
• Import — Starts the import process with progress bar and record count.
• Import Shopify — Imports from a local Shopify file structure (c:\shopify).

Data Export

Export database data as downloadable CSV files.

Export Schemas:

Schema	Type
2 / 10	Inventory List (product values)
12	Department Count List
13	Category Count List

Select a schema from the dropdown and click Download. A loading spinner appears during export.