Mintsoft is a UK-based cloud Warehouse Management System (WMS) and order management platform used by third-party logistics providers (3PLs) and e-commerce brands to manage inventory, stock locations, and fulfillment operations. The Daton connector for Mintsoft replicates your product master data and warehouse-level inventory data into your data warehouse. This lets you combine fulfillment and stock data with the rest of your business data for reporting and analysis.
Prerequisites
An active Mintsoft account.
A Mintsoft user account with API access enabled.
The Username and Password for that user account.
How to Obtain Your Credentials
Mintsoft API authenticates with your regular Mintsoft account credentials: you send your Username and Password to Mintsoft's Auth endpoint, and it returns an API key that's valid for 24 hours before it needs to be renewed. Daton handles this exchange automatically — you just supply your Username and Password once.
Confirm the Mintsoft user account you plan to use has the permissions needed to read product and inventory data (an admin can check or adjust this under Settings > Users in Mintsoft).
Provide that account's Username and Password when you reach the authentication step in the Daton setup wizard.
Verified against Mintsoft's public API reference (api.mintsoft.co.uk/swagger), which documents POST /api/Auth taking {"Username": "...", "Password": "..."} and returning a 24-hour API key. If your account has restricted API access, confirm with your Mintsoft account manager.
Steps to Integrate
Integration Name: Enter a name to identify this integration.
Description (optional): Enter a description to help identify the integration. You can change this at any time.
Replication Frequency: Choose how often Daton should sync data. Options are 1h, 2h, 3h, 6h, 8h, 12h, and 24h.
Replication Start Date: Select how far back you want Daton to pull historical data.
Advanced Configuration Options:
Loading Mode: Choose Append to add new rows to the destination table, or Upsert to insert new rows and update existing ones based on primary key.
Loading Nested Objects: Choose how nested objects are flattened in the destination — Inherit from Warehouse Settings, Do not unnest, Upto one level, or Upto two levels.
Authenticate: Enter your Mintsoft Username and Password.
Select Tables: Choose the tables you want Daton to replicate (products and/or inventory).
Configure Schema/Columns: Choose the columns to include in the destination schema for each selected table.
Submit: Complete the setup to start replication.
Supported Tables
Table
Full Load Supported
Description
products
Yes
Product master/catalog data, including SKU, dimensions, weight, and customs/commodity information.
inventory
Yes
Warehouse-level stock data, including quantities on hand, allocated, in transit, and by location.
Table Schemas
products
Column
Type
Description
SKU
STRING
Stock keeping unit identifier for the product.
Name
STRING
Product name.
CountryOfManufactureId
NUMERIC
Identifier of the country where the product is manufactured.
CountryOfManufacture
RECORD (nested object)
Details of the product's country of manufacture.
UPC
STRING
Universal Product Code (barcode) for the product.
LowStockAlertLevel
NUMERIC
Stock quantity threshold that triggers a low-stock alert.
Weight
NUMERIC
Product weight.
Height
NUMERIC
Product height.
Width
NUMERIC
Product width.
Depth
NUMERIC
Product depth.
BackOrder
BOOLEAN
Indicates whether the product can be back-ordered.
Bundle
BOOLEAN
Indicates whether the product is a bundle of other products.
DisCont
BOOLEAN
Indicates whether the product is discontinued.
Price
NUMERIC
Selling price of the product.
CostPrice
NUMERIC
Cost price of the product.
VatExempt
BOOLEAN
Indicates whether the product is exempt from VAT.
AdditionalParcelsRequired
NUMERIC
Number of additional parcels required to ship the product.
UnitsPerParcel
NUMERIC
Number of units packed per parcel.
HasBatchNumber
BOOLEAN
Indicates whether the product is tracked by batch number.
HasSerialNumber
BOOLEAN
Indicates whether the product is tracked by serial number.
HasExpiryDate
BOOLEAN
Indicates whether the product is tracked by expiry date.
BestBeforeDateWarningPeriodDays
NUMERIC
Number of days before the best-before date that a warning is raised.
HandlingTime
NUMERIC
Time required to handle and process the product for fulfillment.
Subscription
BOOLEAN
Indicates whether the product is sold on a subscription basis.
SubscriptionLength
NUMERIC
Length of the subscription period.
ClientId
NUMERIC
Identifier of the client (3PL customer) that owns the product.
ID
NUMERIC
Unique identifier for the product. (Primary Key)
LastUpdated
DATETIME
Timestamp the product record was last updated.
LastUpdatedByUser
STRING
User who last updated the product record.
LogBatchInbound
BOOLEAN
Indicates whether batch numbers are logged on inbound stock movements.
LogBatchOutbound
BOOLEAN
Indicates whether batch numbers are logged on outbound stock movements.
LogSerialInbound
BOOLEAN
Indicates whether serial numbers are logged on inbound stock movements.
LogSerialOutbound
BOOLEAN
Indicates whether serial numbers are logged on outbound stock movements.
LogExpiryDateInbound
BOOLEAN
Indicates whether expiry dates are logged on inbound stock movements.
LogExpiryDateOutbound
BOOLEAN
Indicates whether expiry dates are logged on outbound stock movements.
CommodityCode
RECORD (nested object)
Customs commodity/HS code details for the product.
Description
STRING
Product description.
CustomsDescription
STRING
Description used for customs declarations.
inventory
Column
Type
Description
ID
NUMERIC
Unique identifier for the inventory record. (Primary Key)
LastUpdated
DATETIME
Timestamp the inventory record was last updated.
LastUpdatedByUser
STRING
User who last updated the inventory record.
ProductId
NUMERIC
Identifier of the associated product. (Primary Key)
StockLevel
NUMERIC
Current total stock level.
Allocated
NUMERIC
Quantity allocated to open orders.
OnHand
NUMERIC
Quantity physically on hand.
OffHand
NUMERIC
Quantity off hand (not physically available).
AwaitingReplen
NUMERIC
Quantity awaiting replenishment.
OnOrder
NUMERIC
Quantity on order from suppliers.
RequiredByBackOrder
NUMERIC
Quantity required to fulfill back orders.
InQuarantine
NUMERIC
Quantity held in quarantine.
InTransit
NUMERIC
Quantity in transit.
InTransition
NUMERIC
Quantity in transition between locations.
Scrapped
NUMERIC
Quantity scrapped or written off.
SKU
STRING
Stock keeping unit identifier for the product.
WarehouseId
NUMERIC
Identifier of the warehouse holding the stock. (Primary Key)
LocationId
NUMERIC
Identifier of the specific storage location within the warehouse.
ClientId
NUMERIC
Identifier of the client (3PL customer) that owns the stock.
ClientName
STRING
Name of the client that owns the stock.
WarehouseName
STRING
Name of the warehouse.
Breakdown
RECORD (nested object)
Detailed stock breakdown, such as by status or sub-location.
product_stock_flow
Column
Type
Description
ProductId
NUMERIC
Identifier of the product this stock record relates to.
WarehouseId
NUMERIC
Identifier of the warehouse where the stock movement occurred.
WarehouseName
STRING
Name of the warehouse where the stock movement occurred.
SKU
STRING
Stock keeping unit identifier for the product.
StockLevel
NUMERIC
Product's total stock level at the warehouse as of this record.
Allocated
NUMERIC
Quantity allocated to open orders as of this record.
OnHand
NUMERIC
Quantity physically on hand as of this record.
OffHand
NUMERIC
Quantity off hand (not physically available) as of this record.
Quantity
NUMERIC
Quantity involved in this stock movement.
Flow
STRING
Direction of the stock movement (for example, in or out).
Reason
STRING
Reason for the stock change (for example, sale, goods-in, stock take, or damage).
BestBefore
DATETIME
Best-before/expiry date associated with the stock, if tracked.
OrderId
NUMERIC
Identifier of the order associated with this stock movement, if applicable.
ID
NUMERIC
Identifier of the product/warehouse stock summary record this movement belongs to.
LastUpdated
DATETIME
Timestamp the product/warehouse stock summary record was last updated.
LastUpdatedByUser
STRING
User who last updated the product/warehouse stock summary record.
stock_flow_id
NUMERIC
Unique identifier for this individual stock movement entry. (Primary Key)
stock_flow_LastUpdated
DATETIME
Timestamp this stock movement entry was last updated.
stock_flow_LastUpdatedByUser
STRING
User who last updated this stock movement entry.
stock_flow_Quantity
NUMERIC
Quantity for this specific stock movement entry, at the batch/location level.
stock_flow_BestBefore
DATETIME
Best-before/expiry date for this specific stock movement entry.
stock_flow_BatchNo
STRING
Batch number associated with this stock movement entry.
stock_flow_Location
STRING
Warehouse location or bin associated with this stock movement entry.
stock_flow_LocationId
NUMERIC
Identifier of the warehouse location or bin associated with this stock movement entry.
Each row represents one stock movement/adjustment event (for example, a single batch or location within a larger stock change), not a point-in-time snapshot. The stock_flow_* columns describe the individual movement; the remaining columns describe the product/warehouse stock summary the movement rolled up under at the time it was pulled.
