Katana's BigCommerce integration pulls all open Sales Orders from BigCommerce to Katana, syncs changes made to orders in BigCommerce to Katana, and implements a two-way sync of fulfillment statuses.

  1. Syncing Sales Orders from BigCommerce to Katana

  2. Two-way sync of fulfillment statuses

Syncing Sales Orders from BigCommerce to Katana

After the initial connection, all your existing open Sales Orders will sync from BigCommerce to Katana and when a new Sales Order (SO) is created in BigCommerce, it will automatically pull into Katana.

  • Sales Orders with an "Awaiting fulfillment" status will always import from BigCommerce.

  • During the integration connection setup, you can choose whether to only import orders with "Awaiting fulfillment" status or also import orders with "Awaiting payment" status.

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

  • Advanced, Professional, and Enterprise plan only: If your Sales Orders are in foreign currencies, then Katana will import your orders in the currencies that are in BigCommerce and convert order totals to Katana base currency.

Sales Order data from BigCommerce is imported to Katana data fields as follows:

BigCommerce

Katana

Comments

Order number

Sales order #

-

Created date

Created date

-

-

Delivery date

The delivery date is not available in BigCommerce (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

Custom items on BigCommerce Sales Orders are imported to Katana if you have enabled this functionality in the BigCommerce 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 BigCommerce price then: Katana Price per unit = BigCommerce (Price - discount amount)/(1+ tax rate).
If taxes are not included in BigCommerce price then: Katana Price per unit = BigCommerce (Price - discount amount).

Tax rate

Tax %

-

Currency

Currency

Available on Katana Advanced, Professional or Enterprise only. Read more


When a SO is pulled from BigCommerce to Katana, a BigCommerce 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 BigCommerce, Katana will not import this order again in the future.

Syncing fulfillment statuses in two-ways

You can choose to have fulfillment statuses sync two ways between Katana and BigCommerce:

  • When the Delivery status for a SO is changed to Partially Delivered in Katana, the fulfillment status in BigCommerce will not change.

  • When the Delivery status for a SO is changed to Delivered in Katana, the fulfillment status in BigCommerce will change to "Completed".

  • When the fulfillment status for a SO is changed to "Completed" in BigCommerce, the Delivery status in Katana will change to Delivered.

  • When fulfillment is initiated from the BigCommerce 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 BigCommerce stores are connected to Katana

If you have connected more than one BigCommerce 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 BigCommerce store.

If you have multiple BigCommerce stores, you can map either the same or a different Katana Location to each BigCommerce store. You can select another Location when you are connecting to your next store.

Did this answer your question?