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. You can find your Username and set your Password on the Integrations page in FastQuery.
| Setting | Value |
|---|---|
| Protocol | SFTP |
| Host | ftp.fastquery.app |
| Port | 49152 |
| Username | (shown on the Integrations page) |
| Password | (set on the Integrations page) |
Tip: This is NOT your FastQuery login password. You set a separate SFTP password specifically for the Paladin export on the Integrations page.
Setting Your SFTP Password
Section titled “Setting Your SFTP Password”- Log into FastQuery and go to Settings > Integrations.
- Find Paladin POS in the list of providers and click it.
- Enter a new SFTP password and save.
- Use this password when configuring the export in Paladin.
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 what you set 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 password set 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