Connected apps

A connected app links your company to another system you already use, so its data comes into TicketStacker on its own instead of someone exporting and importing files. Each company connects its own account, once. After that it syncs on its own, and you can sync it any time.

Where to find them

Open Settings and click Connected apps, or go to Sales & Inventory → Setup → Import and click Open the SandStar connector.

The page has two parts: the apps you've connected, and the app library.

Connected lists your company's apps. Each row shows how often it syncs (every minute, every hour, every night at a set hour, or only when you click), what the last sync brought in (sales, items, products, subscriptions and so on), when it last synced and when it syncs next, and its status:

• Healthy: the last sync worked.
• Not synced yet: connected, waiting for its first sync.
• Needs attention: the last sync failed. Click Fix it to open the app's page and see why (a changed password, for example).

Sync now runs a sync straight away (Send now for QuickBooks). Click an app's name to open its page, with its settings and Import history.

App library has every app, with a chip for each kind: Point of sale, Online store, Vending and micro markets, ATMs, Subscriptions, File storage, Scheduling and Accounting. Or type in Search apps. Each tile says whether it's Connected, Available, needs an add-on (like Retail add-on) or is Coming later (like Square, Clover or your ATM processor). Click a tile to see what it brings in and who keeps the official numbers: the app itself (like Lightspeed, your register system) or TicketStacker (like SandStar, where TicketStacker keeps the stock count). Then click Connect, or Manage connection once it's connected.

SandStar VMS

For smart coolers run on SandStar. It reads the same reports you'd export from SandStar VMS by hand:

• Machine stock: the Inventory Report, imported like a SandStar file on Sales & Inventory → Setup → Import. It updates what's in each machine and what to restock, and brings SandStar's product pictures along.
• Sales: the Order Details report, with every order and every correction and their products. See Vending sales.

To connect, open SandStar VMS, enter the company's SandStar Username and Password (a login that can see Report Management; type the username exactly as you do at vms-us.sandstar.com, which isn't always an email, and click the eye to check the password), choose What to sync, how far back to Load sales history (this month only, from the start of last month, the last 3, 6 or 12 months, the last 2 years, or from a date), and the hour to Sync every night at, then click Connect and sync. TicketStacker signs in and runs the first sync right away: machine stock, this month's sales and up to three earlier months. Older months load three at a time on each nightly sync (or each Sync now) until they reach the date you chose, so a year of history takes a few nights. Each night also re-reads the last week, because corrections and late payments change recent days.

To reach further back later, use Load older sales from on the connector's page: pick a date and click Load. The page shows how far back sales are loaded and whether older months are still coming.

The password is stored encrypted and is never shown again. It's only used to read reports: nothing in SandStar is changed. Only people who can use Inventory can see or change the connector.

Nayax and Cantaloupe Seed

Two more vending systems, with the Inventory add-on:

• Nayax: an Admin pastes the Lynx API token from their Nayax Core login. Machines, each machine's latest sales and its stock (par levels and what's missing) come in every night. See Nayax.
• Cantaloupe Seed: Cantaloupe has no open API, so you upload Seed's sales export (CSV or Excel). See Cantaloupe Seed.

Machines from either match yours by serial number, then name, and their sales show on Vending sales next to SandStar's.

QuickBooks Online

The one app TicketStacker sends to rather than reads from. A company Admin signs in with Intuit and picks accounts; received purchase orders, each day's sales per location and host commissions paid then go to QuickBooks as bills, journal entries and expenses, each once. See QuickBooks Online.

Lightspeed Retail

For stores on Lightspeed Retail (R-Series), with the Retail add-on. Its Connect button opens Sales & Inventory → Setup, where an Admin clicks Connect Lightspeed and signs in with Lightspeed. Sales, items, stock per shop and more come in every minute. See Retail tools for Lightspeed.

Shopify

For your online store or Shopify point of sale, with the Retail add-on. It reads products, variants (with SKU and barcode), images, your locations, stock at each location and orders. It never reads a customer's name, email, phone or address. What happens next depends on whether you also use Lightspeed:

• No Lightspeed: Shopify is your store system. Sales reports, Returns, Subscriptions, Prices, Images, Brand audits, Purchase orders and Statements all work on your Shopify data, and changes you make there (prices, tags, images, stock) go back to Shopify. See Shopify as your store system.
• With Lightspeed: Lightspeed keeps the numbers. Shopify is your online catalog: Images and Subscriptions match its products to Lightspeed items by SKU, and nothing in Shopify is changed.

Only company Admins connect it, three ways:

• Connect with Shopify: enter the Store address for Shopify sign-in (your-store.myshopify.com), sign in to Shopify and allow TicketStacker.
• From Shopify: install TicketStacker from your Shopify admin and allow it. Shopify sends you back to TicketStacker: sign in, choose the company and click Connect Shopify. Finish within an hour, in the same browser.
• Paste an access token: in Shopify admin, open Settings → Apps and sales channels → Develop apps, create an app, give its Admin API read_products, write_products, read_inventory, write_inventory, read_locations and read_orders access and install it. Paste the Admin API access token (it starts with shpat_) with the Store address, then click Connect and sync.

As your store system, Shopify syncs every hour; as an online catalog, every night at the hour you choose. A big store's first sync can take a few minutes while Shopify prepares the export; if it isn't ready in time, the next sync picks it up. The first sync brings in the last 60 days of orders.

If you connect Lightspeed later, Lightspeed becomes the store system: the Shopify copy of your locations, items, stock and orders is removed (it refills from Lightspeed) and Shopify stays your online catalog.

If the store uninstalls TicketStacker's app in Shopify, every company connected through it is disconnected and its Shopify data (products, and as a store system its locations, stock and orders) is removed from TicketStacker. A connection made with your own access token isn't affected.

ReCharge

For subscriptions sold through ReCharge, with the Retail add-on. It reads active subscriptions, customers, delivery addresses, upcoming charges (with their shipping method) and failed charges. In ReCharge, open Apps & integrations → API tokens and create a token with read access to subscriptions, customers, addresses, charges and orders. An Admin pastes it as the API token and clicks Connect and sync. It syncs every night. See Subscriptions.

Shopify and ReCharge tokens are stored encrypted and never shown again. ReCharge is only read; Shopify is changed only when Shopify is your store system and someone uses a store tool. Change sign-in replaces the token (leave it blank to keep the saved one), and the nightly hour can be changed any time. Only Admins can connect, change or disconnect them.

Google Drive and Microsoft 365

These two are where Retail saves vendor credit statements, not systems TicketStacker reads from. Each company connects its own account. Both cards open Sales & Inventory → Purchasing → Statements, where an Admin sets them up under Save statements to:

• Google Drive: click Connect Google Drive and sign in with Google, then click Choose a folder and pick the folder in Google's picker (or Make a new folder for me). TicketStacker can only see that folder and the files it adds.
• Microsoft 365: click Connect Microsoft 365 and sign in with Microsoft, then paste a SharePoint or OneDrive folder link.

Under Connected, each shows who signed in and the folder it's saving in. TicketStacker only adds statement PDFs to the folder you pick. Disconnecting stops saving there; statements already made stay in TicketStacker. See Vendor credit statements.

Sync now, history and disconnecting

On each app's page:

• Sync now runs a sync straight away. Sales can take a minute while SandStar builds its report.
• Change sign-in or what to sync updates the login (leave the password blank to keep the saved one), what to sync, or the nightly hour.
• Import history lists every sync and file upload: when, how (Nightly, Sync now or File upload), whether it worked, how many records came in, and what (machines and items for stock; dates, transactions and dollars for sales). If one part fails, the other still runs and the reason is shown.
• Disconnect asks first, then deletes the saved password and stops syncing. Data already synced and the history stay.

SandStar doesn't publish these reports for other software, so if they change their site a sync may fail. The connector will say so here, and you can still import the files by hand.