Katana's WooCommerce integration pulls all open Sales Orders from WooCommerce to Katana and establishes a two-way sync for fulfillment statuses.
Syncing Sales Orders from WooCommerce to Katana
After the initial connection, all existing open Sales Orders will sync from WooCommerce to Katana and when a new Sales Order is created in WooCommerce, it will be automatically pulled into Katana.
Only Sales Orders in the Processing status will import from WooCommerce.
Sales Orders with other statuses (e.g. Payment pending, On hold, Completed, Cancelled) will not sync from WooCommerce.
Advanced, Professional, and Enterprise plans only: If your Sales Orders are in foreign currencies, Katana will import your orders in the currencies that are in WooCommerce and convert order totals to Katana's base currency. Read more about multi-currency.
Sales Order data from WooCommerce is imported to Katana data fields as follows:
Sales order #
Delivery date is unavailable in WooCommerce, thus Katana default value of "Created date + 14 Days" is used in Katana.
If a customer already exists in Katana then it is matched. If the customer doesn't exist, a new customer is created in Katana. Read more
If a product already exists in Katana, then it is matched. If the product doesn't exist, a new product is created in Katana. Read more
Price per unit
If taxes are included in the WooCommerce price: Katana Price per unit = WooCommerce (Cost - discount amount)/(1+ tax rate).
Advanced, Professional, and Enterprise plans only. Read more
When a Sales Order is pulled from WooCommerce to Katana, a WooCommerce 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 WooCommerce, Katana will not import this order again in the future.
Editing or deleting a Sales Order is not synced
Editing data in either WooCommerce or Katana for a Sales Order (SO) that has already synced will not reflect in the other system. Any changes to the customer, sales order number, dates, or line items are not synced. This does not apply to the fulfillment status, please see below.
Deleting a SO in either Katana or WooCommerce does not delete the SO automatically in the other system.
Two-way fulfillment status syncing
Fulfillment statuses sync two-way between Katana and WooCommerce:
When the Delivery status for a SO is changed to Delivered in Katana, the fulfillment status in WooCommerce will change to "Completed". Please note that the Partially Delivered status doesn't sync with WooCommerce. The order status will sync to WooCommerce when it reaches Delivered.
When the fulfillment status for a SO changes to "Completed" in WooCommerce, the Delivery status in Katana will change to Delivered.
For now, Katana doesn't support partial delivery for 3rd-party extension apps available for WooCommerce.
When fulfillment is initiated from WooCommerce and you have batch trackable items on the Sales order, batches are automatically assigned to your order using the FIFO (first in first out) method. See more here.
Sales order sync if there are multiple locations in Katana
If you have created multiple locations in Katana your WooCommerce store is mapped to a location in the integration configuration. Your orders from WooCommerce are imported to the defined Katana location. Read more
Sales order sync if multiple WooCommerce stores are connected to Katana
If you have connected more than one WooCommerce store to Katana, you can map these to the same or different Katana locations. Orders and inventory levels are synced between these mapped locations and stores. Read more
If you do not have multiple locations in Katana or if you map multiple WooCommerce stores to the same Katana location, the integration works exactly in the same way for each store. Sales order sync, product and customer import and matching, and stock sync work identically for all stores. For example, if the same product (i.e. same SKU code) exists at multiple stores, then the stock levels would be synced from Katana to all the WooCommerce stores that include that product.