Katana to QuickBooks Integration | MESA
Connect Katana to QuickBooks and automate your tasks
Describe to build
Activity reports
Fully supported
MESA's Katana to QuickBooks integration is the fastest way to sync data between the two — without touching a line of code. Choose which fields to send, how they're formatted, and when the sync happens. Start with a pre-built template, customize it with AI, or build something completely unique in under 10 minutes.
★★★★★ 4.9 rating on Shopify App Store
Start when...
Personalize with built-in tools...
Then, do this...
Trusted by 1,000+ Shopify merchants
Why integrate Katana with QuickBooks
The Katana to QuickBooks integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.
Keep Katana production orders in sync with Shopify sales
When an order is placed in Shopify, MESA creates or updates the corresponding production order in Katana. Your manufacturing queue stays current with demand without anyone manually bridging the two systems.
Update Shopify inventory when Katana production is complete
When a production run finishes in Katana, MESA updates the available stock in Shopify. Your storefront reflects what's actually ready to sell without a manual sync step between your factory floor and your store.
Log production and materials data where your ops team works
When Katana records a production event — a run started, a material consumed, a batch completed — MESA writes the details to Airtable, Google Sheets, or ClickUp. Your operations team has a running view without leaving their tools.
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 Katana 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.
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
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.
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
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.
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
Current Inventory Material Out of Stock
Starts when a material's current stock level is below the optimal level (quantity_missing_or_excess <= 0).
Current Inventory Material Updated
Starts when a material's current stock level or average cost is updated.
Current Inventory Product Out of Stock
Starts when a product's current stock level is below the optimal level (quantity_missing_or_excess <= 0).
Current Inventory Product Updated
Starts when a product's current stock level or average cost is updated.
Product Created
Starts when a product is created.
Product Deleted
Starts when a product is deleted.
Product Updated
Starts when a product is updated.
Sales Order Availability Updated
Starts when availability or expected date is updated for products or ingredients.
Sales Order Created
Starts when a sales order is created.
Sales Order Deleted
Starts when a sales order is deleted.
Sales Order Delivered
Starts when a new sales order's status is marked as delivered.
Sales Order Packed
Starts when a new sales order's status is marked as packed.
Sales Order Updated
Starts when a sales order is updated.
Create Account
Create an account.
Account Type
Name
Create Attachable
Create an attachable.
Attachable Ref
Note
Create Bill
Create a bill.
Line
Vendor Ref
Create Class
Create a class.
- 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
Create Customer
Create a customer.
Bill Addr
Notes
Display Name
Primary Phone
Primary Email Addr
Create Department
Create a department.
- Name
Create Invoice
Create an invoice.
Line
Customer Ref
Create Item
Create an item.
Name
Income Account Ref
Expense Account Ref
Asset Account Ref
Type
Track Qty On Hand
Qty On Hand
Inv Start Date
Create Journal Entry
Create a journal entry.
- Line
Create or Update Estimate
Create or modify an estimate.
Domain
Sparse
ID
Sync Token
Custom Field
Doc Number
Txn Date
Currency Ref
Exchange Rate
Txn Status
Line
Txn Tax Detail
Customer Ref
Customer Memo
Bill Addr
Ship Addr
Total Amt
Home Total Amt
Apply Tax After Discount
Print Status
Email Status
Bill Email
Create Payment
Create a payment.
Customer Ref
Total Amt
Line
Create Purchase
Create a purchase.
Account Ref
Payment Type
Credit
Total Amt
Purchase Ex
Domain
Sparse
ID
Sync Token
Meta Data
Custom Field
Txn Date
Currency Ref
Exchange Rate
Line
Create Purchase Order
Create a purchase order.
Line
Vendor
Accounts Payable (A/P) Account
Currency Ref
Total Amt
Global Tax Calculation
Txn Date
Custom Field
POEmail
Class Ref
Sales Term Ref
Linked Txn
Memo
POStatus
Transaction Location Type
Due Date
Meta Data
Doc Number
Private Note
Ship Method Ref
Txn Tax Detail
Ship To
Exchange Rate
Ship Addr
Vendor Addr
Email Status
Recur Data Ref
Department Ref
Create Sales Receipt
Create a sales receipt.
- Line
Create Tax Agency
Create a tax agency.
- Display Name
Create Tax Service
Create a tax service.
Tax Code
Tax Rate Details
Create Time Activity
Create a time activity.
Name Of
Employee Ref
Start Time
End Time
Create Transfer
Create a transfer.
From Account Ref
To Account Ref
Amount
Delete Employee
Remove an employee.
Delete Vendor Credit
Remove vendor credit.
Query Account List Report
Request an account list report.
Query Aged Payable Detail Report
Request an aged payable detail report.
Query Aged Payables Report
Request an aged payables report.
Query Aged Receivable Detail Report
Request an aged receivable detail report.
Query Aged Receivables Report
Request an aged receivables report.
Query Balance Sheet Report
Request a balance sheet report.
Query Cash Flow Report
Request a cash flow report.
Query Class Sales Report
Request a class sales report.
Query Credit Memo
Query for credit memos.
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
Query Customer
Query for customers.
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
Query Customer Balance Detail Report
Request a customer balance detail report.
Query Customer Balance Report
Request a customer balance report.
Query Customer Income Report
Request a customer income report.
Query Customer Sales Report
Request a customer sales report.
Query Department Sales Report
Request a department sales report.
Query for Invoice
Query for invoices.
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
Query for Item
Query for items.
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
Query General Ledger Report
Request a general ledger report.
Query Journal Entry
Query for journal entries.
ID
Sync Token
Txn Date
Doc Number
Private Note
Adjustment
Total Amt
Domain
Sparse
Currency Ref
Txn Tax Detail
Meta Data
Line
Query Profit and Less Report
Request a profit and less report.
Query Profit and Loss Detail Report
Request a profit and loss detail report.
Query Report
Request a report.
Query Sales by Product Report
Request a sales by product report.
Query Transaction List Report
Request a transaction list report.
Query Transfer
Query for a transfer.
Query Trial Balance Report
Request a trial balance report.
Query Vendor Balance Detail Report
Request a vendor balance detail report.
Query Vendor Balance Report
Request a vendor balance report.
Query Vendor Expenses Report
Request a vendor expenses report.
Retrieve Account
Grab all details about an account.
Retrieve Attachable
Grab all details about an attachable.
Retrieve Bill
Grab all details about a bill.
Retrieve Bill Payment
Grab all details about a bill payment.
Retrieve Class
Grab all details about a class.
Retrieve Company Information
Grab all details about the company.
Retrieve Credit Memo
Grab all details about a credit memo.
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
Retrieve Customer
Grab all details about a customer.
Retrieve Department
Grab all detail about a department.
Retrieve Deposit
Grab all details about a deposit.
Retrieve Employee
Grab all details about an employee.
Retrieve Estimate
Grab all details about an estimate.
Retrieve Exchange Rate for Individual Currency Code
Grab all details about an exchange rate for a specific currency code.
Retrieve Invoice
Grab all details about an invoice.
Retrieve Item
Grab all details about an item.
Retrieve Journal Entry
Grab all details about a journal entry.
Retrieve Payment
Grab all details about a payment.
Retrieve Payment Method
Grab all details about a payment method.
Retrieve Preference
Grab all details about a preference.
Retrieve Purchase
Grab all details about a purchase.
Retrieve Purchase Order
Grab all details about a purchase order.
ID
Doc Number
Sync Token
Domain
Sparse
Txn Date
Total Amt
POStatus
Private Note
A P Account Ref
Currency Ref
Vendor Ref
Ship Addr
Vendor Addr
Line
Custom Field
Meta Data
Retrieve Refund Receipt
Grab all details about a refund receipt.
Retrieve Sales Receipt
Grab all details about a sales receipt.
Retrieve Tax Agency
Grab all details about a tax agency.
Retrieve Tax Code
Grab all details about a tax code.
Retrieve Tax Rate
Grab all details about a tax rate.
Retrieve Term
Grab all details about a term.
Retrieve Transfer
Grab all details about a transfer.
Retrieve Vendor
Grab all details about a vendor.
Retrieve Vendor Credit
Grab all details about a vendor credit.
Update Bill Payment
Modify a bill payment.
Vendor
Pay Type
Check Payment
Total Amt
Private Note
Line
Update Credit Memo
Modify a credit memo's details.
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
Update Deposit
Modify a deposit.
Deposit To Account Ref
Total Amt
Domain
Sparse
ID
Sync Token
Txn Date
Currency Ref
Exchange Rate
Line
Update Journal Entry
Modify a journal entry's details.
Sparse
ID
Sync Token
Transaction Date
Journal Number
Memo
Adjusting Entry
Currency
Exchange Rate
Tax Calculation
Tax Details
Lines
Update Payment Method
Modify a payment method.
Name
Active
Type
Domain
Sparse
ID
Sync Token
Meta Data
Update Preference
Modify a preference.
Accounting Info Prefs
Product And Services Prefs
Sales Forms Prefs
Email Messages Prefs
Vendor And Purchases Prefs
Time Tracking Prefs
Tax Prefs
Currency Prefs
Report Prefs
Other Prefs
Domain
Sparse
ID
Sync Token
Meta Data
Update Purchase Order
Modify a purchase order's details.
Sparse
ID
Sync Token
Accounts Payable (A/P) Account
Vendor
Line
Currency Ref
Global Tax Calculation
Txn Date
Custom Field
POEmail
Class Ref
Sales Term Ref
Linked Txn
Memo
POStatus
Transaction Location Type
Due Date
Meta Data
Doc Number
Private Note
Ship Method Ref
Txn Tax Detail
Ship To
Exchange Rate
Ship Addr
Vendor Addr
Email Status
Recur Data Ref
Department Ref
Update Refund Receipt
Modify a refund receipt.
Domain
Sparse
ID
Sync Token
Meta Data
Custom Field
Doc Number
Txn Date
Currency Ref
Exchange Rate
Line
Txn Tax Detail
Total Amt
Home Total Amt
Apply Tax After Discount
Print Status
Balance
Payment Ref Num
Deposit To Account Ref
Update Term
Modify a term.
Name
Active
Type
Discount Percent
Due Days
Domain
Sparse
ID
Sync Token
Update Vendor
Modify a vendor.
Bill Addr
Tax Identifier
Balance
Acct Num
Vendor1099
Currency Ref
Domain
Sparse
ID
Sync Token
Title
Given Name
Family Name
Suffix
Company Name
Display Name
Print On Check Name
Active
Primary Phone
Mobile
Primary Email Addr
Web Addr
Upload Attachments
Upload and link new attachments.
Assign Serial Numbers to Resource
Assign serial numbers to a resource.
ID
Transaction ID
Serial Number
Resource Type
Resource ID
Transaction Date
Quantity Change
Change Product Operation's Rank
Modify the product operations's rank.
Create Customer
Create a customer.
Name
First Name
Last Name
Company
Email
Phone
Currency
Reference ID
Comment
Discount Rate
Addresses
Create Customer Address
Add an address to an existing customer. A customer can have one billing address and multiple shipping addresses. If the new address is the first of its type, it is assigned as the default.
Customer ID
Entity Type
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Create Make-to-Order Manufacturing Order
Create a manufacturing order that is linked to a specific sales order row.
Sales Order Row ID
Create Subassemblies
Create Manufacturing Order
Create a manufacturing order. Manufacturing order recipe and operation rows are created automatically based on the product recipe and operations.
Status
Order No
Variant ID
Location ID
Planned Quantity
Actual Quantity
Order Created Date
Production Deadline Date
Additional Info
Batch Transactions
Create Manufacturing Order Operation Row
Add an operation row to an existing manufacturing order. Operation rows cannot be added when the manufacturing order status is DONE.
Manufacturing Order ID
Operation ID
Operation Name
Resource ID
Resource Name
Planned Time Per Unit
Cost Per Hour
Status
Assigned Operators
Create Manufacturing Order Production
Create a manufacturing order production.
Manufacturing Order ID
Completed Quantity
Completed Date
Is Final
Ingredients
Operations
Serial Numbers
Create Manufacturing Order Recipe Row
Add a recipe row to an existing manufacturing order. Recipe rows cannot be added when the manufacturing order status is DONE.
Manufacturing Order ID
Variant ID
Notes
Planned Quantity Per Unit
Total Actual Quantity
Batch Transactions
Create Material
Create a material.
Name
Uom
Category Name
Default Supplier ID
Additional Info
Batch Tracked
Purchase Uom
Purchase Uom Conversion Rate
Configs
Variants
Create Outsourced Purchase Order Recipe Row
Add a recipe row to an existing outsourced purchase order. Recipe rows cannot be added when the order status is RECEIVED.
Purchase Order Row ID
Ingredient Variant ID
Planned Quantity Per Unit
Notes
Batch Transactions
Create Product
Create a product.
Name
Uom
Category Name
Is Producible
Is Purchasable
Default Supplier ID
Additional Info
Batch Tracked
Serial Tracked
Operations In Sequence
Purchase Uom
Purchase Uom Conversion Rate
Configs
Custom Field Collection ID
Variants
Create Product Operations
Create one or many new product operation rows for a product.
Keep Current Rows
Rows
Create Purchase Order
Create a purchase order. /purchase_orders
Order No
Entity Type
Supplier ID
Currency
Status
Expected Arrival Date
Order Created Date
Location ID
Tracking Location ID
Additional Info
Purchase Order Rows
Create Purchase Order Additional Cost Row
Add a purchase order additional cost row to an existing group.
Additional Cost ID
Group ID
Tax Rate ID
Price
Distribution Method
Create Purchase Order Row
Create a purchase order row.
Purchase Order ID
Quantity
Variant ID
Tax Rate ID
Group ID
Price Per Unit
Purchase Uom Conversion Rate
Purchase Uom
Create Recipes
Create a recipe.
Keep Current Rows
Rows
Create Sales Order
Create a sales order.
Order No
Customer ID
Sales Order Rows
Tracking Number
Tracking Number URL
Addresses
Order Created Date
Delivery Date
Currency
Location ID
Status
Additional Info
Customer Ref
Ecommerce Order Type
Ecommerce Store Name
Ecommerce Order ID
Create Sales Order Address
Create a new sales order address.
Sales Order ID
Entity Type
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Create Sales Order Fulfillment
Create a sales order fulfillment.
Sales Order ID
Picked Date
Status
Conversion Rate
Conversion Date
Tracking Number
Tracking URL
Tracking Carrier
Tracking Method
Sales Order Fulfillment Rows
Create Sales Order Row
Create a sales order row.
Sales Order ID
Quantity
Variant ID
Tax Rate ID
Attributes
Price Per Unit
Total Discount
Create Sales Order Shipping Fee & Add it to Sales Order
Create a sales order shipping fee and add it to sales order.
Sales Order ID
Description
Amount
Tax Rate ID
Create Stock Adjustment
Create a stock adjustment.
Stock Adjustment Number
Stock Adjustment Date
Location ID
Reason
Additional Info
Stock Adjustment Rows
Create Stock Transfer
Create a stock transfer.
Stock Transfer Number
Source Location ID
Target Location ID
Transfer Date
Additional Info
Stock Transfer Rows
Create Stocktake
Create a stocktake.
Stocktake Number
Location ID
Reason
Additional Info
Created Date
Set Remaining Items As Counted
Stocktake Rows
Create Stocktake Row
Add one or many new rows for a stocktake.
Stocktake ID
Stocktake Rows
Create Supplier
Create a supplier.
Name
Currency
Email
Phone
Comment
Addresses
Create Supplier Address
Create a supplier address.
Supplier ID
Line 1
Line 2
City
State
Zip
Country
Create Tax Rate
Create a tax rate.
Name
Rate
Create Variant
Create a variant.
Sku
Sales Price
Purchase Price
Product ID
Supplier Item Codes
Internal Barcode
Registered Barcode
Material ID
Config Attributes
Custom Fields
Delete Customer
Remove a customer.
Delete Customer Address
Remove a customer's address.
Delete Manufacturing Order
Remove a manufacturing order.
Delete Manufacturing Order Operation Row
Remove a manufacturing order operation row.
Delete Manufacturing Order Production
Remove a manufacturing order production.
Delete Manufacturing Order Recipe Row
Remove a manufacturing order recipe row.
Delete Material
Remove a material.
Delete Outsourced Purchase Order Recipe Row
Remove an outsourced purchase order recipe row.
Delete Product
Remove a product.
Delete Product Operation Row
Remove a product operation row.
Delete Purchase Order
Remove a purchase order.
Delete Purchase Order Additional Cost Row
Remove a purchase order additional cost row.
Delete Purchase Order Row
Remove a purchase order row.
Delete Recipe
Remove a recipe.
Delete Recipe Row
Remove a recipe row.
Delete Sales Order
Remove a sales order.
Delete Sales Order Address
Remove a sales order address.
Delete Sales Order Fulfillment
Remove a sales order fulfillment.
Delete Sales Order Row
Remove a sales order row.
Delete Stock Adjustment
Remove a stock adjustment.
Delete Stock Transfer
Remove a stock transfer.
Delete Stocktake
Remove a stocktake.
Delete Stocktake Row
Remove a stocktake row.
Delete Storage Bin
Remove a storage bin.
Delete Supplier
Remove a supplier.
Delete Supplier Address
Remove a supplier address.
Delete Variant
Remove a variant.
Deletes Shipping Fee & Remove from Attached Sales Order
Remove shipping fee and remove it from the attached sales order.
Get List of Current Inventory
Obtain a list for current inventory.
Variant ID
Location ID
Reorder Point
Average Cost
Value In Stock
Quantity In Stock
Quantity Committed
Quantity Expected
Quantity Missing Or Excess
Get List of Custom Fields Collections
Obtain a list of custom fields collections.
ID
Name
Updated At
Created At
Deleted At
Get List of Customer Addresses
Obtain a list of customer addresses you’ve previously created. The customer addresses are returned in sorted order, with the most recent customer addresses appearing first.
ID
Customer ID
Entity Type
Default
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Created At
Updated At
Get List of Customers
Obtain a list of all customers.
ID
Name
First Name
Last Name
Company
Email
Phone
Comment
Currency
Reference ID
Discount Rate
Created At
Updated At
Default Billing ID
Default Shipping ID
Addresses
Get List of Inventory Movements
Grab a list of inventory movements created by your Katana resources.
ID
Variant ID
Location ID
Resource Type
Resource ID
Caused By Order No
Caused By Resource ID
Movement Date
Quantity Change
Balance After
Value Per Unit
Value In Stock After
Average Cost After
Rank
Created At
Updated At
Get List of Locations
Obtain a list of locations.
ID
Name
Legal Name
Address ID
Address
Is Primary
Sales Allowed
Manufacturing Allowed
Purchase Allowed
Created At
Updated At
Deleted At
Get List of Manufacturing Order Operation Rows
Obtain a list of manufacturing order operation rows.
ID
Status
Rank
Manufacturing Order ID
Operation ID
Operation Name
Resource ID
Resource Name
Assigned Operators
Completed By Operators
Active Operator ID
Planned Time Per Unit
Total Actual Time
Planned Cost Per Unit
Total Actual Cost
Cost Per Hour
Group Boundary
Is Status Actionable
Completed At
Created At
Updated At
Deleted At
Get List of Manufacturing Order Recipe Rows
Obtain a list of manufacturing order recipe rows.
ID
Manufacturing Order ID
Variant ID
Notes
Planned Quantity Per Unit
Total Actual Quantity
Ingredient Availability
Ingredient Expected Date
Batch Transactions
Cost
Created At
Updated At
Deleted At
Get List of Manufacturing Orders
Obtain a list of manufacturing orders.
ID
Status
Order No
Variant ID
Planned Quantity
Actual Quantity
Batch Transactions
Location ID
Order Created Date
Done Date
Production Deadline Date
Additional Info
Is Linked To Sales Order
Sales Order ID
Sales Order Row ID
Sales Order Delivery Deadline
Ingredient Availability
Total Cost
Total Planned Time
Total Actual Time
Material Cost
Subassemblies Cost
Operations Cost
Created At
Updated At
Deleted At
Serial Numbers
Get List of Manufacturing Orders
Obtain a list of manufacturing orders.
ID
Manufacturing Order ID
Quantity
Production Date
Created At
Updated At
Deleted At
Ingredients
Operations
Serial Numbers
Get List of Materials
Obtain a list of materials.
ID
Name
Uom
Category Name
Default Supplier ID
Type
Additional Info
Purchase Uom
Purchase Uom Conversion Rate
Batch Tracked
Variants
Created At
Updated At
Configs
Get List of Operators
Obtain a list of operators.
ID
Operator Name
Get List of Outsourced Purchase Order Recipe Rows
Obtain a list of outsourced purchase order recipe rows.
ID
Purchase Order ID
Purchase Order Row ID
Ingredient Variant ID
Planned Quantity Per Unit
Ingredient Availability
Ingredient Expected Date
Notes
Batch Transactions
Cost
Created At
Updated At
Deleted At
Get List of Product Operations
Obtain a list of product operations.
Product Operation Row ID
Product ID
Product Variant ID
Operation ID
Operation Name
Resource ID
Resource Name
Cost Per Hour
Planned Time Per Unit
Planned Cost Per Unit
Rank
Group Boundary
Created At
Updated At
Get List of Products
Obtain a list of products.
ID
Name
Uom
Category Name
Is Producible
Default Supplier ID
Is Purchasable
Type
Additional Info
Purchase Uom
Purchase Uom Conversion Rate
Batch Tracked
Serial Tracked
Operations In Sequence
Variants
Created At
Updated At
Configs
Get List of Purchase Order Accounting Metadata
Obtain a list of purchase order accounting metadata entries.
ID
Integration Type
Bill ID
Created At
Purchase Order ID
Received Items Group ID
Get List of Purchase Order Additional Cost Rows
Obtain list of purchase order additional cost rows you’ve previously created.
ID
Additional Cost ID
Group ID
Name
Distribution Method
Tax Rate ID
Tax Rate
Price
Price In Base
Currency
Currency Conversion Rate
Currency Conversion Rate Fix Date
Updated At
Created At
Deleted At
Get List of Purchase Order Rows
Obtain a list of purchase order rows.
ID
Quantity
Variant ID
Tax Rate ID
Price Per Unit
Purchase Uom
Purchase Uom Conversion Rate
Batch Transactions
Total
Total In Base Currency
Conversion Rate
Conversion Date
Received Date
Created At
Updated At
Get List of Purchase Orders
Obtain a list of purchase orders.
ID
Status
Billing Status
Last Document Status
Order No
Entity Type
Supplier ID
Currency
Expected Arrival Date
Order Created Date
Additional Info
Location ID
Ingredient Availability
Ingredient Expected Date
Tracking Location ID
Total
Total In Base Currency
Purchase Order Rows
Created At
Updated At
Get List of Recipes
Obtain a list of recipes.
Recipe ID
Recipe Row ID
Product ID
Product Variant ID
Ingredient Variant ID
Quantity
Notes
Created At
Updated At
Get List of Sales Order Accounting Metadata
Obtain a list of sales order accounting metadata.
Get List of Sales Order Addresses
Obtain a list of sales order addresses.
ID
Sales Order ID
Entity Type
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Created At
Updated At
Get List of Sales Order Fulfillments
Obtain a list of sales order fulfillments.
ID
Sales Order ID
Picked Date
Status
Conversion Rate
Conversion Date
Tracking Number
Tracking URL
Tracking Carrier
Tracking Method
Sales Order Fulfillment Rows
Serial Numbers
Packer ID
Created At
Updated At
Get List of Sales Order Rows
Obtain a list of sales order rows.
ID
Quantity
Variant ID
Tax Rate ID
Price Per Unit
Price Per Unit In Base Currency
Total
Total In Base Currency
Attributes
Batch Transactions
Serial Numbers
Linked Manufacturing Order ID
Conversion Rate
Conversion Date
Created At
Updated At
Get List of Sales Orders
Obtain a list of sales orders.
ID
Customer ID
Order No
Source
Order Created Date
Delivery Date
Picked Date
Location ID
Status
Currency
Conversion Rate
Conversion Date
Invoicing Status
Total
Total In Base Currency
Additional Info
Customer Ref
Sales Order Rows
Ecommerce Order Type
Ecommerce Store Name
Ecommerce Order ID
Product Availability
Product Expected Date
Ingredient Availability
Ingredient Expected Date
Production Status
Created At
Updated At
Tracking Number
Tracking Number URL
Billing Address ID
Shipping Address ID
Addresses
Get List of Serial Numbers
Obtain a list of serial numbers.
ID
Transaction ID
Serial Number
Resource Type
Resource ID
Transaction Date
Quantity Change
Get List of Shipping Fees
Obtain a list of shipping fees.
ID
Sales Order ID
Description
Amount
Tax Rate ID
Get List of Stock Adjustments
Obtain a list of stock adjustments.
ID
Stock Adjustment Date
Location ID
Stock Adjustment Number
Reason
Additional Info
Stock Adjustment Rows
Created At
Updated At
Get List of Stock Serial Numbers
Obtain a list of serial numbers with in-stock status which references to the linked resources.
ID
Serial Number
In Stock
Transactions
Get List of Stock Transfers
Obtain a list of stock transfers.
ID
Stock Transfer Number
Source Location ID
Target Location ID
Transfer Date
Additional Info
Stock Transfer Rows
Created At
Updated At
Get List of Stocktake Rows
Obtain a list of stocktake rows.
ID
Variant ID
Batch ID
Stocktake ID
Notes
In Stock Quantity
Counted Quantity
Discrepancy Quantity
Created At
Updated At
Deleted At
Get List of Stocktakes
Obtain a list of stocktakes.
ID
Stocktake Number
Location ID
Status
Reason
Additional Info
Stocktake Created Date
Started Date
Completed Date
Status Update In Progress
Set Remaining Items As Counted
Stock Adjustment ID
Created At
Updated At
Deleted At
Get List of Storage Bins
Obtain a list of storage bins.
ID
Name
Location ID
Updated At
Created At
Deleted At
Get List of Supplier Addresses
Obtain a list of supplier addresses.
ID
Supplier ID
Line 1
Line 2
City
State
Zip
Country
Updated At
Created At
Get List of Suppliers
Obtain a list of suppliers.
ID
Name
Email
Comment
Created At
Updated At
Get List of Tax Rates
Obtain a list of tax rates.
ID
Name
Rate
Is Default Sales
Is Default Purchases
Display Name
Created At
Updated At
Get List of Variants
Obtain a list of variants.
ID
Product ID
Material ID
Sku
Sales Price
Purchase Price
Config Attributes
Type
Created At
Updated At
Get List of Variants with Negative Stock
Obtain a list of all variants with negative stock.
Variant ID
Location ID
Latest Negative Stock Date
Name
Sku
Category
Link Variant Default Storage Bins
Link variants with the default storage bins.
ID
Bin Name
Variant ID
Storage Bin ID
Created At
Updated At
Deleted At
List All Additional Costs
Obtain a list of all additional costs you’ve previously created.
ID
Name
Updated At
Created At
Deleted At
Receive Purchase Order
Grab all details about a purchase order.
Retrieve Current Factory
Grab all details about the current factory.
Line 1
Line 2
City
State
Zip
Country
Retrieve Location
Grab all details about a location.
ID
Name
Legal Name
Address ID
Address
Is Primary
Sales Allowed
Manufacturing Allowed
Purchase Allowed
Created At
Updated At
Deleted At
Retrieve Manufacturing Order
Grab all details about a manufacturing order.
ID
Status
Order No
Variant ID
Planned Quantity
Actual Quantity
Batch Transactions
Location ID
Order Created Date
Done Date
Production Deadline Date
Additional Info
Is Linked To Sales Order
Sales Order ID
Sales Order Row ID
Sales Order Delivery Deadline
Ingredient Availability
Total Cost
Total Planned Time
Total Actual Time
Material Cost
Subassemblies Cost
Operations Cost
Created At
Updated At
Deleted At
Serial Numbers
Retrieve Manufacturing Order Operation Row
Grab all details about a manufacturing order operation row.
ID
Status
Rank
Manufacturing Order ID
Operation ID
Operation Name
Resource ID
Resource Name
Assigned Operators
Completed By Operators
Active Operator ID
Planned Time Per Unit
Total Actual Time
Planned Cost Per Unit
Total Actual Cost
Cost Per Hour
Group Boundary
Is Status Actionable
Completed At
Created At
Updated At
Deleted At
Retrieve Manufacturing Order Production
Grab all details about a manufacturing order production.
ID
Manufacturing Order ID
Quantity
Production Date
Created At
Updated At
Deleted At
Ingredients
Operations
Serial Numbers
Retrieve Manufacturing Order Recipe Row
Grab all details about a manufacturing order recipe row.
ID
Manufacturing Order ID
Variant ID
Notes
Planned Quantity Per Unit
Total Actual Quantity
Ingredient Availability
Ingredient Expected Date
Batch Transactions
Cost
Created At
Updated At
Deleted At
Retrieve Material
Grab all details about a material.
ID
Name
Uom
Category Name
Default Supplier ID
Type
Additional Info
Purchase Uom
Purchase Uom Conversion Rate
Batch Tracked
Variants
Created At
Updated At
Configs
Retrieve Outsourced Purchase Order Recipe Row
Grab all details about an outsourced purchase order recipe row.
ID
Purchase Order ID
Purchase Order Row ID
Ingredient Variant ID
Planned Quantity Per Unit
Ingredient Availability
Ingredient Expected Date
Notes
Batch Transactions
Cost
Created At
Updated At
Deleted At
Retrieve Product
Grab all details about a product.
ID
Name
Uom
Category Name
Is Producible
Default Supplier ID
Is Purchasable
Type
Additional Info
Purchase Uom
Purchase Uom Conversion Rate
Batch Tracked
Serial Tracked
Operations In Sequence
Variants
Created At
Updated At
Configs
Retrieve Purchase Order
Grab all details about a purchase order.
ID
Status
Billing Status
Last Document Status
Order No
Entity Type
Supplier ID
Currency
Expected Arrival Date
Order Created Date
Additional Info
Location ID
Ingredient Availability
Ingredient Expected Date
Tracking Location ID
Total
Total In Base Currency
Purchase Order Rows
Created At
Updated At
Retrieve Purchase Order Additional Cost Row
Grab all details about an existing purchase order additional cost row.
ID
Additional Cost ID
Group ID
Name
Distribution Method
Tax Rate ID
Tax Rate
Price
Price In Base
Currency
Currency Conversion Rate
Currency Conversion Rate Fix Date
Updated At
Created At
Deleted At
Retrieve Purchase Order Row
Grab all details about a purchase order row.
ID
Quantity
Variant ID
Tax Rate ID
Price Per Unit
Purchase Uom
Purchase Uom Conversion Rate
Batch Transactions
Total
Total In Base Currency
Conversion Rate
Conversion Date
Received Date
Created At
Updated At
Retrieve Sales Order
Grab all details about a sales order.
ID
Customer ID
Order No
Source
Order Created Date
Delivery Date
Picked Date
Location ID
Status
Currency
Conversion Rate
Conversion Date
Invoicing Status
Total
Total In Base Currency
Additional Info
Customer Ref
Sales Order Rows
Ecommerce Order Type
Ecommerce Store Name
Ecommerce Order ID
Product Availability
Product Expected Date
Ingredient Availability
Ingredient Expected Date
Production Status
Created At
Updated At
Tracking Number
Tracking Number URL
Billing Address ID
Shipping Address ID
Addresses
Retrieve Sales Order Fulfillment
Grab all details about a sales order fulfillment.
ID
Sales Order ID
Picked Date
Status
Conversion Rate
Conversion Date
Tracking Number
Tracking URL
Tracking Carrier
Tracking Method
Sales Order Fulfillment Rows
Serial Numbers
Packer ID
Created At
Updated At
Retrieve Sales Order Row
Grab all details about a sales order row.
ID
Quantity
Variant ID
Tax Rate ID
Price Per Unit
Price Per Unit In Base Currency
Total
Total In Base Currency
Attributes
Batch Transactions
Serial Numbers
Linked Manufacturing Order ID
Conversion Rate
Conversion Date
Created At
Updated At
Retrieve Shipping Fee
Grab all details about a shipping fee.
ID
Sales Order ID
Description
Amount
Tax Rate ID
Retrieve Variant
Grab all details about a variant.
ID
Product ID
Material ID
Sku
Sales Price
Purchase Price
Config Attributes
Type
Created At
Updated At
Unassign Serial Numbers from Resource
Remove serial numbers from a resource.
Unlink Manufacturing Order from Sales Order Row
Unlink a manufacturing order from a particular sales order row.
Unlink Variant Default Storage Bins
Unlink variants from the default storage bins.
Update Customer
Modify a customer's information.
Name
First Name
Last Name
Company
Email
Phone
Currency
Comment
Discount Rate
Default Shipping ID
Update Customer Address
Modify a customer's address.
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Update Manufacturing Order
Modify a manufacturing order.
Status
Order No
Variant ID
Location ID
Planned Quantity
Actual Quantity
Order Created Date
Production Deadline Date
Additional Info
Done Date
Batch Transactions
Update Manufacturing Order Operation Row
Modify a manufacturing order operation row.
Operation ID
Operation Name
Resource ID
Resource Name
Planned Time Per Unit
Total Actual Time
Cost Per Hour
Status
Assigned Operators
Completed By Operators
Update Manufacturing Order Production
Modify a manufacturing order production.
- Production Date
Update Manufacturing Order Production Ingredient
Update a specified manufacturing order production ingredient. Any fields not provided will be left unchanged. A manufacturing order production ingredient cannot be updated when the manufacturing order status is DONE.
- Batch Transactions
Update Manufacturing Order Recipe Row
Modify a manufacturing order recipe row.
Variant ID
Notes
Planned Quantity Per Unit
Total Actual Quantity
Batch Transactions
Update Material
Modify a material.
Name
Uom
Category Name
Default Supplier ID
Additional Info
Batch Tracked
Purchase Uom
Purchase Uom Conversion Rate
Configs
Custom Field Collection ID
Update Outsourced Purchase Order Recipe Row
Modify an outsourced purchase order recipe row.
Ingredient Variant ID
Planned Quantity Per Unit
Notes
Batch Transactions
Update Product
Modify a product's details.
Name
Uom
Category Name
Is Producible
Is Purchasable
Default Supplier ID
Additional Info
Batch Tracked
Operations In Sequence
Serial Tracked
Purchase Uom
Purchase Uom Conversion Rate
Configs
Custom Field Collection ID
Update Product Operation Row
Modify a product's operation row.
Operation ID
Operation Name
Resource ID
Resource Name
Cost Per Hour
Planned Time Per Unit
Update Purchase Order
Modify a purchase order.
Order No
Supplier ID
Currency
Tracking Location ID
Status
Expected Arrival Date
Order Created Date
Location ID
Additional Info
Update Purchase Order Additional Cost Row
Modify a purchase order's additional cost row.
Additional Cost ID
Tax Rate ID
Price
Distribution Method
Update Purchase Order Row
Modify a purchase order row.
Quantity
Variant ID
Tax Rate ID
Group ID
Price Per Unit
Purchase Uom Conversion Rate
Purchase Uom
Received Date
Update Recipe Row
Modify a recipe entry.
Quantity
Notes
Ingredient Variant ID
Update Reorder Point
Modify the reorder point for a certain location and variant combination.
Location ID
Variant ID
Value
Update Sales Order
Modify a sales order.
Order No
Customer ID
Order Created Date
Delivery Date
Picked Date
Location ID
Status
Currency
Conversion Rate
Conversion Date
Additional Info
Customer Ref
Tracking Number
Tracking Number URL
Update Sales Order Address
Modify a sales order's address.
First Name
Last Name
Company
Phone
Line 1
Line 2
City
State
Zip
Country
Update Sales Order Fulfillment
Modify sales order fulfillment's details.
Picked Date
Status
Conversion Rate
Packer ID
Conversion Date
Tracking Number
Tracking URL
Tracking Carrier
Tracking Method
Update Sales Order Row
Modify a sales order row.
Quantity
Variant ID
Tax Rate ID
Price Per Unit
Total Discount
Batch Transactions
Serial Number Transactions
Attributes
Update Shipping Fee
Modify a shipping fee.
Description
Amount
Tax Rate ID
Update Stock Adjustment
Modify a stock adjustment.
Stock Adjustment Number
Stock Adjustment Date
Location ID
Reason
Additional Info
Update Stock Transfer
Modify a stock transfer.
Stock Transfer Number
Transfer Date
Additional Info
Update Stocktake
Modify a stocktake.
Stocktake Number
Location ID
Status
Reason
Additional Info
Created Date
Completed Date
Set Remaining Items As Counted
Update Stocktake Row
Modify stocktake row information.
Variant ID
Batch ID
Notes
Counted Quantity
Update Storage Bin
Modify a storage bin.
- Bin Name
Update Supplier
Modify a supplier.
Name
Email
Phone
Currency
Comment
Update Supplier Address
Modify a supplier's address.
Line 1
Line 2
City
State
Zip
Country
Update Variant
Modify a variant.
Sku
Sales Price
Purchase Price
Product ID
Supplier Item Codes
Internal Barcode
Registered Barcode
Material ID
Config Attributes
Custom Fields
Not just software—partnership
Expert support included
MESA includes hands-on support from automation experts who know how to get things done.
Free workflow setup
We'll build your first workflow with you live. Most merchants walk away with automation saving 5+ hours/week.
Fast response times
Average first response: Same day. Critical issues: Immediate escalation. Complex builds: 24-48 hours.
Managed services available
Personalized workflow reviews, and quarterly check-ins to identify new opportunities as your business grows.
Real humans, always
Chat with real automation experts (not bots). Email support 9am-5pm PST. Google Meet sessions for complex workflows.
Integrate Katana with QuickBooks today.
Enjoy a 7-day free trial. Get your first workflow in minutes.
MESA AI assistant
+×
Describe your task...
You've known what your store should be doing. Now it can. Describe the task then MESA handles it from there.