Connect FTP to QuickBooks and automate your tasks

Why integrate FTP with QuickBooks

The FTP to QuickBooks integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

Receive inventory updates from your supplier

When a supplier drops a CSV on your FTP server, MESA picks it up on schedule and updates Shopify product inventory automatically. Stock levels stay accurate without manual imports or copy-paste.

Send order files to your fulfillment partner

After orders are placed, MESA generates a formatted CSV and uploads it to your 3PL's FTP server. Your fulfillment partner has what they need without manual exports or email attachments.

Sync product catalog updates from a supplier feed

MESA reads your supplier's product file on a schedule and maps the data to Shopify's format. New SKUs, updated prices, and changed descriptions land in your store without manual intervention.

Send every Shopify order to QuickBooks automatically

When an order is placed, MESA creates the corresponding record in QuickBooks — customer, line items, amount — without anyone touching it. Your books stay current from the moment a sale happens.

Create QuickBooks invoices from Shopify orders

When a wholesale or B2B order comes in, MESA generates an invoice in QuickBooks and routes it to the right customer account. Your billing process runs without manual data entry between systems.

Keep customer records consistent across both platforms

When a new customer places their first Shopify order, MESA creates or updates their record in QuickBooks. Your accounting and your store always reflect the same customer data.

Build any FTP and QuickBooks automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

Credit Memo Created

Starts when a credit memo is created.

• ID
• Line
• Customer Ref
• Sync Token
• Currency Ref
• Txn Date
• Custom Field
• Print Status
• Total Amt
• Apply Tax After Discount
• Doc Number
• Txn Tax Detail
• Email Status
• Bill Addr
• Meta Data
• Remaining Credit
• Balance
• Domain
• Sparse

Customer Created

Starts when a customer is created.

• ID
• Sync Token
• Display Name
• Title
• Given Name
• Middle Name
• Suffix
• Family Name
• Primary Email Addr
• Resale Num
• Secondary Tax Identifier
• Default Tax Code Ref
• Preferred Delivery Method
• GSTIN
• Sales Term Ref
• Customer Type Ref
• Fax
• Business Number
• Bill With Parent
• Currency Ref
• Mobile
• Job
• Balance With Jobs
• Primary Phone
• Open Balance Date
• Taxable
• Alternate Phone
• Meta Data
• Parent Ref
• Notes
• Web Addr
• Active
• Company Name
• Balance
• Ship Addr
• Payment Method Ref
• Is Project
• Source
• Primary Tax Identifier
• G S T Registration Type
• Print On Check Name
• Bill Addr
• Fully Qualified Name
• Level
• Tax Exemption Reason ID

Customer Deleted

Starts when a customer is removed.

Customer Updated

Starts when a customer is modified.

Invoice Created

Starts when an invoice is created.

• ID
• Line
• Customer Ref
• Sync Token
• Ship From Addr
• Currency Ref
• Doc Number
• Bill Email
• Txn Date
• Ship Date
• Tracking Num
• Class Ref
• Print Status
• Sales Term Ref
• Txn Source
• Linked Txn
• Deposit To Account Ref
• Global Tax Calculation
• Allow Online A C H Payment
• Transaction Location Type
• Due Date
• Meta Data
• Private Note
• Bill Email Cc
• Customer Memo
• Email Status
• Project Ref
• Exchange Rate
• Deposit
• Txn Tax Detail
• Allow Online Credit Card Payment
• Allow Online Payment
• Domain
• Sparse
• Custom Field
• Bill Addr
• Ship Addr
• Total Amt
• Home Total Amt
• Apply Tax After Discount
• Balance

Invoice Deleted

Starts when an invoice is removed.

Invoice Updated

Starts when an invoice is modified.

Item Created

Starts when an item is created.

• ID
• Item Category Type
• Name
• Sync Token
• Inv Start Date
• Type
• Qty On Hand
• Asset Account Ref
• Sku
• Sales Tax Included
• Track Qty On Hand
• Sales Tax Code Ref
• Class Ref
• Source
• Purchase Tax Included
• Description
• Abatement Rate
• Sub Item
• Taxable
• U Q C Display Text
• Reorder Point
• Purchase Desc
• Meta Data
• Pref Vendor Ref
• Active
• UQCId
• Reverse Charge Rate
• Purchase Tax Code Ref
• Service Type
• Purchase Cost
• Parent Ref
• Unit Price
• Fully Qualified Name
• Expense Account Ref
• Level
• Income Account Ref
• Tax Classification Ref

Item Deleted

Starts when an item is removed.

Item Updated

Starts when an item is modified.

Fetch CSV File

Fetch a CSV file that matches a pattern from a FTP server.

Fetch CSV File Row Created

Fetch a CSV file when a new row is created.

Fetch FTP File

Fetch a file that matches a pattern from a FTP server.

Fetch XML File

Fetch a XML file that matches a pattern from a FTP server.

Create Account

Create an account.

• Account Type
• Name

Create Credit Memo

Create a credit memo.

• Remaining Credit
• Domain
• Sparse
• ID
• Sync Token
• Meta Data
• Custom Field
• Doc Number
• Txn Date
• Currency Ref
• Exchange Rate
• Line
• Txn Tax Detail
• Customer Ref
• Bill Addr
• Ship Addr
• Total Amt
• Home Total Amt
• Apply Tax After Discount
• Print Status
• Email Status
• Balance
• Project Ref

Update Customer

Update a customer.

• Taxable
• Bill Addr
• Notes
• Job
• Bill With Parent
• Balance
• Balance With Jobs
• Currency Ref
• Preferred Delivery Method
• Domain
• Sparse
• ID
• Sync Token
• Fully Qualified Name
• Display Name
• Print On Check Name
• Active
• Primary Phone
• Primary Email Addr
• Default Tax Code Ref

Integrate FTP with QuickBooks today.

Enjoy a 7-day free trial. Get your first workflow in minutes.