Katana to Mailgun Integration | MESA
Connect Katana to Mailgun and automate your tasks
Describe to build
Activity reports
Fully supported
MESA's Katana to Mailgun 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 Mailgun
The Katana to Mailgun 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 transactional emails from Shopify order events automatically
When an order is placed, updated, or fulfilled in Shopify, MESA triggers the right Mailgun transactional email with the relevant details already populated. Your customers get accurate, timely messages without anyone manually initiating them or maintaining a separate send schedule.
Trigger Mailgun emails from any Shopify customer milestone
When a customer hits a threshold in Shopify — a first purchase, a loyalty tier, a win-back window — MESA sends the signal to Mailgun and fires the right email at the right moment. Your transactional and lifecycle messaging runs on the full range of what happens in your store, not just native Shopify triggers.
Send fulfillment and shipping notifications the moment status changes
When an order ships, is delayed, or is delivered in Shopify, MESA passes the event to Mailgun and fires the corresponding email at the right moment. Your post-purchase communication stays accurate and timely without custom development connecting the two platforms.
Build any Katana and Mailgun 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.
Clicked Created
Starts when a recipient clicks on a link in your message.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Complained Created
Starts when a recipient complains that a message is spam.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Delivered Created
Starts when a message is delivered.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Opened Created
Starts when a recipient opens an email.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Permanent Fail
Starts when Mialgun stops attempting to deliver messages and drops them.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Temporary Fail
Starts when Mailgun gets a soft bounce.
Tags
Timestamp
Storage
Recipient-domain
Event
Campaigns
User-variables
Flags
Log-level
Envelope
Message
Recipient
ID
Delivery-status
Unsubscribed Created
Starts when a recipient requests to be unsubscribed from your mailings.
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.
Add a Member to Mailing List
Add one member to a mailing list.
Add Bounce
Add a bounce record to a domain's bounce list.
Add Complaint
Adds an address to the complaints list.
- Message
Add Multiple Members to a Mailing List
Add multiple members to a mailing list.
Add Unsubscribe
Add an address to the unsubscribed list.
- Message
Assign IP to a Domain
Allocate a dedicated IP to a specific domain. Only dedicated IPs can be assigned to a domain.
- Message
Create Mailing List
Create a mailing list.
Address
Name
Description
Access Level
Create Route
Create a new route.
Create SMTP Credentials
Create a new set of SMTP credentials for a specific domain.
Login
Password
Create Template
Store a new template.
Name
Description
Template
Tag
Engine
Comment
Create Webhook
Create a new webhook. When adding a clicked or opened webhook, ensure that you also have tracking enabled.
Delete an Unsubscribed Record
Removes an address from the unsubscribed list.
- Message
Delete Bounce
Remove a bounce from a bounce list.
- Message
Delete Bounce List
Remove a bounce list from a domain.
- Message
Delete Complaint
Remove a specific spam complaint.
- Message
Delete Domain
Remove a domain from your account.
Delete Mailing List
Remove a mailing list.
Delete Member from Mailing List
Remove a member from a specific mailing list.
Delete Route
Remove a route.
Delete SMTP Credentials
Remove SMTP credentials.
Delete Stored Messages
Remove all stored messages.
Delete Tag
Remove a tag from a specific domain. The tag's statistics are not deleted.
Delete Webhook
Remove a webhook.
Get List of Bounces
Obtain a list of bounces for a specific domain.
Get List of Complaints
Obtain a list of complaints for a specific domain.
Address
Created At
Get List of Domain Countries
Obtain a list of countries of origin for a specific domain for different event types.
Get List of Domain Devices
Obtain a list of devices for a specific domain that have triggered event types.
Get List of Domain Providers
Obtain a list of email providers for a specific domain and for different event types.
Get List of Domain Stats
Obtain a list of total stats for a specific domain.
End
Resolution
Start
Stats
Get List of Domain Tags
Obtain a list of tags for a specific domain.
Get List of Domains
Obtains a list of domains under your account.
Created At
ID
Is Disabled
Name
Require Tls
Skip Verification
Smtp Login
Spam Action
State
Type
Web Prefix
Web Scheme
Wildcard
Get List of Event Statistics
Obtain a list of event statistics for a specific domain.
Get List of Events
Obtain a list of events for a specific domain.
Get List of IPs for a Domain
Obtain a list of IPs currently assigned to a specific domain.
- Items
Get List of IPs for an Account
Obtain a list of IPs assigned to your account.
- 0
Get List of Mailing List Members
Obtain a list of members in a specific mailing list.
Get List of Mailing Lists
Obtain a list of mailing lists under your account.
Access Level
Address
Created At
Description
Members Count
Name
Get List of Routes
Obtain a list of routes.
Total Count
Items
Get List of Tag Stats
Obtain a list of statistics for a specific tag.
Get List of Templates
Obtain a list of stored templates for a specific domain.
Created At
Description
Name
Get List of Unsubscribes
Obtain a list of recipients who have unsubscribed from your emails.
- Message
Get List of Webhooks
Obtain a list of webhooks.
Parse Email Address List
Parses a delimiter-separated list of email addresses into two lists: parsed addresses and unparsable portions.
- 0
Parse Email Address List (Private)
Parses a delimiter-separated list of email addresses into two lists: parsed addresses and unparsable portions.
Retrieve an Unsubscribed Record
Grab all details about a single unsubscribe record.
- Message
Retrieve Bounce
Grab all details about a specific bounce event by a specific email address.
Address
Code
Error
Created At
Retrieve Complaint
Grab all details about a single spam complaint by a specific email address.
Address
Created At
Retrieve Domain
Grab all details about a domain, including credentials and DNS records.
Retrieve Domain Connection Settings
Grab all details about the delivery connection settings for a specific domain.
Retrieve Domain Tag
Grab all details about a tag from a specific domain.
Retrieve Domain Tracking Settings
Grab all details about the tracking settings for a specific domain.
Retrieve IP
Grabs all details about the specific IP.
Ip
Dedicated
Rdns
Retrieve Mailing List
Grab all details about a single mailing list by a specific address.
Retrieve Mailing List Member
Grab all details about a mailing list member.
Retrieve Route
Grab all details about a route.
Description
Created At
Actions
Priority
Expression
ID
Retrieve SMTP Credentials for a Domain
Grab all details about the domain's SMTP credentials.
Retrieve Stored Message
Grab all details about a stored message.
Retrieve Template
Grab all details about the specific template, including metadata information.
Created At
Description
Name
Retrieve Webhook
Grab all details about a webhook
Send Message
Send a message.
Message
ID
Unassign IP from a Domain
Disconnect an IP from a specific domain.
- Message
Update Click Domain Tracking Settings
Modify click tracking settings for a specific domain.
- Active
Update DKIM Authority
Modify DKIM authority for a specific domain.
- Self
Update Domain Delivery Connection Settings
Modify specified delivery connection settings for a specific domain.
Require Tls
Skip Verification
Update Mailing List
Modify a mailing list such as address, description or name.
Name
Description
Access Level
Update Mailing List Member
Modify a mailing list member.
Name
Vars
Subscribed
Update Open Domain Tracking Settings
Modify open tracking settings for a specific domain.
- Active
Update Route
Modify a route.
Update SMTP Credentials
Modify an existing SMTP credentials. Currently, only the password can be changed.
- Password
Update Tag
Modify a tag for a specific domain.
Domain
Description
Update Unsubscribe Domain Tracking Settings
Modify unsubscribe tracking settings for a specific domain.
Active
HTML Footer
Text Footer
Update Webhook
Modify an existing webhook.
Validate Email Address
Verifies an email address based off defined checks.
Address
Did You Mean
Is Disposable Address
Is Role Address
Is Valid
Mailbox Verification
Parts
Reason
Validate Email Addresses
Verify email addresses based off defined checks.
Verify Domain
Validates a domain. If the domain is successfully validated, you should see the following in a workflow's Logs: Domain DNS records have been updated.
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 Mailgun 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.