What syncs between Katana and Pimento
The table below summarizes each data flow between Katana and Pimento.
Data | Direction | Status |
Orders | Pimento → Katana | Available |
Products | Pimento → Katana | Available |
Inbound stock transfers | Pimento → Katana | Available |
Inventory sync | Pimento → Katana | Available |
Locations and mapping
After Pimento approves the connection, the configuration screen opens on the Location tab. Each Pimento warehouse maps 1:1 to its own dedicated Katana location. Click Add to Katana to create that location automatically.
Not mapped: the warehouse has never been mapped. Click Add to Katana to create its location.
Unlinked: you paused a mapped warehouse with Unlink. Click Relink to resume syncing it.
Only mapped warehouses sync.
Products sync
Product mapping creates a required link between each Pimento product and a Katana item. Choose how SKUs are matched: direct 1:1 or via SKU aliases.
Products are imported by SKU:
An existing Katana product with the same SKU is matched.
An unknown SKU creates a new Katana product just-in-time.
Kits and bundles become Katana products. Add a bill of materials (BOM) with their components in Katana. A kit order line stays a single sales order row.
SKU aliases
A SKU alias links a Pimento SKU to a different Katana SKU. Use one when the same product has a different SKU in each system. Upload your SKU alias mapping before importing products, so mismatched SKUs match existing Katana items instead of creating new products.
Orders sync
Orders flow one way, from Pimento into Katana.
Import: orders import once they reach the configured import-from status. The default is the "Open" state.
Status updates: after import, each order keeps updating automatically through every later status change in Pimento.
Structure: each Pimento order becomes one Katana sales order, and each order line becomes one row. The order source is shown as Pimento.
Fulfillments and tracking
Each shipped package becomes a Katana fulfillment with its carrier and tracking number. A multi-package shipment creates one fulfillment per package, so one order can show several fulfillments. Together they never exceed the ordered quantities.
Cancellations
When an order is canceled in Pimento, it's deleted in Katana only if the sales order is still open.
Inventory sync
Pimento's stock numbers appear in Katana as read-only External inventory at each warehouse's mapped location. The number shown is Pimento's On hand quantity.
Reconciliation compares Katana's in-stock quantity with Pimento's on-hand quantity. It runs on a schedule or on demand, and it creates stock adjustments in Katana for any differences. This keeps Katana's stock aligned with Pimento's physical counts.
Inbound shipments
Each Pimento inbound shipment becomes one Katana stock transfer. The transfer number is the PO number when one exists. Otherwise, it's the inbound ID.
Destination: the Katana location mapped 1:1 to the inbound's Pimento warehouse.
Origin: the location assigned to each destination warehouse. This location must be mapped.
The stock transfer follows the inbound's status, and received quantities update the transfer. Katana stock transfers move from in transit to received in one step. Partial receipts show as updated expected and received quantities until the shipment is fully received. If an inbound is canceled in Pimento, its stock transfer is deleted.
What does not sync
Sending orders from Katana to Pimento. Orders flow from Pimento into Katana only.
Pushing products or stock changes from Katana to Pimento.
Returns and RMAs.
Serial number tracking. Lot and batch data is read-only, where Pimento provides it.
Disconnecting
To disconnect, open the Pimento integration from Katana's Integrations page. Once disconnected, orders, fulfillments, inventory, and inbound shipments no longer sync from Pimento. Records already imported into Katana stay in Katana, including sales orders, fulfillments, products, stock transfers, and stock adjustments.