Paladin POS Integration
FastQuery syncs with Paladin POS to give your team instant access to inventory and product data. This guide walks through setting up the automated SFTP export from your Paladin system.
How It Works
Section titled “How It Works”Paladin exports inventory to FastQuery’s secure SFTP server. FastQuery processes uploads automatically — no manual steps needed after initial setup.
| Export | What it contains |
|---|---|
| Full inventory | Complete snapshot — prices, quantities, descriptions, departments, UPCs |
| Inventory updates | Small, frequent files with just the quantities that changed |
The full export is your nightly baseline; the smaller update files keep quantities current throughout the day. FastQuery handles each automatically — you don’t choose a “type”, the system detects it from the file’s contents.
Note: New products added in Paladin during the day appear after the next full export, not in the smaller update files. The update files only adjust quantities for products already known to FastQuery.
SFTP Connection Details
Section titled “SFTP Connection Details”Configure your Paladin export with these connection settings. FastQuery creates the Username and Password for you on the Integrations page.
| Setting | Value |
|---|---|
| Protocol | SFTP |
| Host | ftp.fastquery.app |
| Port | 49152 |
| Username | (shown on the Integrations page) |
| Password | (created on the Integrations page) |
Tip: This is NOT your FastQuery login password. FastQuery issues a separate SFTP password for the Paladin export on the Integrations page.
Your SFTP Password
Section titled “Your SFTP Password”FastQuery creates this password for you. You do not choose one.
- Log into FastQuery and go to Settings > Integrations.
- Find Paladin POS in the list of providers and click it.
- Click Create SFTP credentials. FastQuery shows your username and password.
- Copy the password into your Paladin export configuration.
Come back to this page at any time and click Reveal password to read it again.
If your password was set before FastQuery issued them
Section titled “If your password was set before FastQuery issued them”FastQuery cannot show a password that you chose yourself in the past. We kept only a one-way check of it, never the password. Your export keeps working, so there is nothing to fix.
To get a password you can read back, click Create new password. The old password stops working immediately, so update your Paladin export at the same time.
Facility ID Setup
Section titled “Facility ID Setup”Each facility in FastQuery must have its Facility ID set to match your Paladin store number (the storeId in your export).
When adding a facility, enter the Paladin store number as the Facility ID. For example, if your store number is 0, set the Facility ID to 0.
Important: If the Facility ID doesn’t match the store number in the export, FastQuery won’t be able to process the uploads.
Barcodes (UPCs)
Section titled “Barcodes (UPCs)”FastQuery reads product barcodes from Paladin’s Alternate Part Numbers field. Products with a valid UPC there will be scannable in FastQuery and matched to catalog images and details.
Tip: For the best experience, make sure your products’ UPCs are entered in the Alternate Part Numbers field in Paladin. Products without a valid UPC still sync — they’re just matched by description instead of by barcode.
What Data Gets Synced
Section titled “What Data Gets Synced”Once connected, FastQuery automatically imports product descriptions, pricing (including promotional prices), stock levels, departments, barcodes, bin/location codes, on-order quantities, sales history, and last sale/receipt/count dates from your Paladin exports.
Count Adjustment Files
Section titled “Count Adjustment Files”When your team finalizes a counting task in FastQuery, the report email includes a CSV adjustment file listing each counted SKU and its new quantity, so the corrections can be brought into Paladin without retyping them.
Troubleshooting
Section titled “Troubleshooting”Files are not appearing in FastQuery
Section titled “Files are not appearing in FastQuery”- Verify the SFTP connection details are correct — especially the port (
49152). - Confirm the SFTP password matches the one on the Integrations page.
- Check that the Paladin export ran and completed successfully.
Barcodes are missing for some products
Section titled “Barcodes are missing for some products”Those products likely don’t have a valid UPC in their Alternate Part Numbers field in Paladin. Add the UPC there and it will sync on the next full export.
Inventory quantities seem outdated
Section titled “Inventory quantities seem outdated”Quantities reflect the last export received. If the full export hasn’t run recently, or the update files have stopped arriving, the data may be stale — check the Integrations page for recent sync events.
Quick Checklist
Section titled “Quick Checklist”- SFTP credentials created on the FastQuery Integrations page
- Facility ID set to Paladin store number for each facility
- Full inventory export configured and scheduled (nightly recommended)
- Inventory update export configured for throughout the day
- Exports pointed to
ftp.fastquery.appport49152 - Product UPCs entered in Paladin’s Alternate Part Numbers field
- First export completed — check the Integrations page for sync events