Katana's Shopify integration pulls all open sales orders (SOs) from Shopify to Katana, syncs changes made to orders in Shopify to Katana, and implements a two-way sync of fulfillment statuses.
Syncing SOs from Shopify to Katana
After the initial connection, all existing open SOs will sync from Shopify to Katana, and when a new SO is created in Shopify, it will automatically pull into Katana.
Only SOs with an "Unfulfilled" status will import from Shopify.
During the integration connection setup, you can choose whether to only import orders with a Paid payment status or also import orders with a Payment pending status. Read more
Draft SOs will not be synced from Shopify.
SOs will be pulled to the mapped location(s) in Katana. Read more
Standard, Professional, and Professional Plus plans only: If your SOs are in multiple currencies, Katana will import the orders from Shopify and convert order totals to Katana's base currency. Read more about multi-currency.
Sales order data from Shopify is imported to Katana data fields as follows:
Shopify | Katana | Comments |
Order number | Sales order # | - |
Created date | Created date | - |
- | Delivery date | The delivery date is not available in Shopify (only via third-party apps), so Katana calculates it using the Created date + Default delivery time. You can edit the Default delivery time in the Settings screen > General in Katana. |
Customer name | Customer name | If the customer already exists in Katana, then the customer is matched. If the customer does not yet exist, a new customer is created in Katana. Read more |
Billing address | Bill to | - |
Shipping address | Ship to | - |
Line item | Line item | If the product already exists in Katana, then the product is matched. If the product does not yet exist, a new product is created in Katana. Read more |
Quantity | Quantity | - |
Price | Price per unit | If taxes are included in Shopify price then: Katana Price per unit = Shopify Price/(1+ tax rate). |
Tax rate | Tax % | - |
Currency | Currency | Standard or higher only. Read more |
PO number | Customer reference # | - |
Discount on line item, promotions, discount on sales order | Discount % | If there are promotions applied at the order's basket level, such as "$10 off the order", "buy 2 get 1 free", etc., the amount discounted on the order will be allocated proportionally between the products on the SO. |
When an SO is pulled from Shopify to Katana, a Shopify ID (hidden from the user) is added to the order in Katana for future identification. This way, we ensure that we do not import the same order more than once. Even if you delete an order in Katana that was imported from Shopify, Katana will not import this order again in the future.
Shopify order changes sync to Katana
You can choose to sync Shopify order changes to Katana. If you do so, then Shopify SO and SO line item changes are done in Shopify and are synced to Katana.
List of changes that sync from Shopify to Katana:
adjust quantity
added/deleted line item
cancel
delete
archive
In Katana, these are reflected as adjusted quantity or deleted line items or orders.
Please note that:
Shopify returns are not synced to Katana.
changes to the customer, addresses, sales order number, dates, and product customization options are not synced from Shopify to Katana.
Changes synced to Katana sales orders will automatically reflect in your production schedule and will change the Manufacturing orders in case you are making to order. Read more.
Katana SO changes don't sync to Shopify
Changes to the SO in Katana are not synced to Shopify, except for fulfillment status, for which you can choose if it is synced two ways or not.
Syncing fulfillment statuses in two ways
You can choose to have fulfillment statuses sync two ways between Katana and Shopify:
When the Delivery status for a SO is changed to Partially Delivered in Katana, the fulfillment status in Shopify will change to "Partially fulfilled".
When the Delivery status for a SO is changed to Delivered in Katana, the fulfillment status in Shopify will change to "Fulfilled".
When the fulfillment status for a SO is changed to "Partially fulfilled" in Shopify, the Delivery status in Katana will change to Partially delivered.
When the fulfillment status for a SO is changed to "Fulfilled" in Shopify, the Delivery status in Katana will change to Delivered.
When fulfillment is initiated from the Shopify side and on the SO there are batch trackable items, batches are automatically assigned to your order using the FIFO (first in first out) method. See more here.
Sales order sync if multiple Shopify stores are connected to Katana
If you have connected more than one Shopify store to Katana, the integration works exactly in the same way for each store. Sales order sync and product and customer import and matching work identically for all stores.
For example, if the same product (i.e. same SKU code) exists at multiple stores, then products will be matched (i.e. duplicates not created) in Katana if the same product has already been imported from another Shopify store.
If you have multiple Shopify stores, you can map the same or a different Katana location to each Shopify store. You can select the location when connecting your next store.