Katana x Shopify integration pulls all open Sales Orders from Shopify to Katana, syncs changes made to orders in Shopify to Katana, and syncs the fulfillment status two ways.

  1. Syncing Sales Orders from Shopify to Katana

  2. Shopify order changes are synced to Katana

  3. Syncing fulfillment statuses in two-ways

Syncing Sales Orders from Shopify to Katana

After the initial connection, all your existing open Sales Orders will be synced from Shopify to Katana. Later, when a new Sales Order is created in Shopify, it will be automatically pulled to Katana.

  • Only Sales Orders with "Unfulfilled" status will be imported from Shopify.

  • During the integration connection setup, you can choose whether to import orders with "Paid" payment status only or also import orders with "Payment pending" status. Read more

  • Draft Sales Orders will not be synced from Shopify.

  • Sales Orders will be pulled to the mapped Location in Katana. Read more

  • Advanced, Professional, and Enterprise plans only: If your Sales Orders are in foreign currencies, then Katana will import your orders in the currencies that are in Shopify and will convert order totals to Katana 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

Delivery date is not available in Shopify (only via 3rd party apps), thus Katana uses the "Created date + Default delivery time" for calculating the delivery date. You can edit the "Default delivery time" in Settings -> 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

Line item properties for products on Shopify sales orders (e.g. additional options when using any product options add-ons in Shopify) will be also pulled to Katana. Read more

Custom items on Shopify Sales Orders are imported to Katana if you have enabled this functionality in the Shopify connection configuration (this could be chosen either during the initial connection or reconfigured afterward). Read more

Quantity

Quantity

-

Price

Price per unit

If taxes are included in Shopify price then: Katana Price per unit = Shopify (Price - discount amount)/(1+ tax rate).
If taxes are not included in Shopify price then: Katana Price per unit = Shopify (Price - discount amount).

Tax rate

Tax %

-

Currency

Currency

Advanced or higher only. Read more


When a Sales Order 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 make sure 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 are synced to Katana

You can choose to sync Shopify order changes to Katana. If you do so, then Shopify Sales Order and Sales Order line item changes done in Shopify are synced to Katana.

List of changes that are synced from Shopify to Katana:

  • adjust quantity

  • added line item

  • refund

  • cancel

  • delete

  • archive

In Katana, these are reflected as adjusted quantity or deleted line item or order.

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 Sales Order changes are not synced to Shopify

Changes to the Sales Order in Katana are not synced to Shopify, except 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 synced two ways between Katana and Shopify:

  • When the Delivery status for a Sales Order is changed to "Delivered" in Katana, the fulfillment status in Shopify will change to "Fulfilled".

  • When the fulfillment status for a Sales Order 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 Sales Orders there are batch trackable items, batches are automatically assigned to your order using 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 either the same or a different Katana Location to each Shopify store. You can select another Location when you are connecting to your next store.

Did this answer your question?