Acceo Integration
FastQuery syncs with Acceo to give your team instant access to inventory and product data. FastQuery is an official Acceo integration partner — the export is set up together with Acceo, and this guide covers the few things you configure on the FastQuery side.
How It Works
Section titled “How It Works”Acceo exports inventory files per store via SFTP to FastQuery’s secure server. FastQuery processes uploads automatically — no manual steps needed after initial setup.
| Export | What it contains |
|---|---|
| Full inventory | Complete snapshot — prices, quantities, descriptions, barcodes, bin locations, and more |
| Inventory updates | Smaller, frequent files that keep the data current throughout the day |
The full export is your nightly baseline; the smaller update files keep the data fresh during business hours. An update file with no changes simply tells FastQuery your feed is alive — that’s normal, not an error.
Tip: We recommend scheduling the full export to run overnight so your team starts each day with fresh data.
SFTP Connection Details
Section titled “SFTP Connection Details”The export is configured 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 Acceo export on the Integrations page.
Setting Your SFTP Password
Section titled “Setting Your SFTP Password”- Log into FastQuery and go to Settings > Integrations.
- Find Acceo in the list of providers and click it.
- Enter a new SFTP password and save.
- Use this password when the export is configured in Acceo.
Facility ID Setup
Section titled “Facility ID Setup”Each facility in FastQuery must have its Facility ID set to match your Acceo store number, so FastQuery can route each store’s export to the right facility.
When adding a facility, enter the Acceo store number as the Facility ID. For example, if your store number is 57552, set the Facility ID to 57552.
Important: If the Facility ID doesn’t match your Acceo store number, FastQuery won’t be able to process that store’s uploads.
What Data Gets Synced
Section titled “What Data Gets Synced”Once connected, FastQuery automatically imports product descriptions, pricing, cost, stock levels, barcodes (UPC codes), aisle/bin locations, departments, manufacturer names and part numbers, vendor information, minimum/maximum stock levels, and 12-month sales history from your Acceo export.
Count Adjustment Files
Section titled “Count Adjustment Files”When your team finalizes a counting task in FastQuery, the report email includes an adjustment file in Acceo’s fixed-width format, named <store number><MMDDYY>.txt. Each line carries the SKU and the newly counted quantity, so you can import the corrections into Acceo instead of typing them in one by one.
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 Acceo export ran and completed successfully.
- Check the Integrations page for recent sync events and error messages.
Barcodes are missing for some products
Section titled “Barcodes are missing for some products”Products without a valid UPC code in Acceo still sync — they’re just matched by description instead of by barcode. If a barcode you expect is missing, check that the product’s UPC is entered correctly in Acceo.
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 Acceo store number for each facility
- Daily full export configured with Acceo, pointed to
ftp.fastquery.appport49152 - Inventory update export configured for throughout the day (optional but recommended)
- First export completed — check the Integrations page for sync events