Skip to content

Katana

Applies toShopify

Steps for

What it does

Katana (opens in a new tab) is a manufacturing ERP that gives you a live view of sales, inventory and production.

SparkLayer has a direct integration with Katana. You manage your B2B customers and price lists in Katana, and SparkLayer brings them into Shopify and SparkLayer.

How data flows between Katana, SparkLayer and Shopify

Katana

Customers with a category, and price lists
(this flows forward)

SparkLayer

Imports customers and price lists every 4 hours
(this flows forward)

Shopify

Customer records and metafields; B2B prices on the storefront

What syncs and in which direction

Customers and prices sync one way, from Katana. SparkLayer's Katana integration doesn't send orders to Katana.

DataDirectionDetails
CustomersKatana to Shopify and SparkLayerKatana is the master of your B2B customer data. Changes to customer records sync to Shopify and SparkLayer automatically.
PricesKatana to SparkLayerPrice lists and product prices come from the price lists you set up in Katana.

Customer data

Customers are matched between Katana and Shopify by the primary email in Katana. SparkLayer then syncs this data into Shopify. Some details are stored in Shopify metafields: extra fields on the Shopify customer record that SparkLayer reads. The integration fills them in for you.

KatanaShopify and SparkLayer
Addresses, with the phone number on eachCustomer record in Shopify
First and last nameCustomer record in Shopify
Customer categoryCustomer group in SparkLayer, and the group's tag in Shopify
Company nameShopify metafield
Discount rateShopify metafield
Price listShopify metafield

Price lists

SparkLayer imports each new price list automatically and creates a matching price list in SparkLayer Wholesale,Pricing,Price lists (in your Shopify admin):

Field in SparkLayerField in Katana
Handle / IDPrice list ID
NamePrice list name
CurrencyCurrency

Price lists use Katana's base currency. If you give a customer a different currency in Katana, SparkLayer creates an automatic price list with currency conversion for them.

New customers

New customers created in Katana are added to Shopify as Pending accounts. If Send customers an invite email when activated in Katana is ticked, Shopify sends them an Activate your account email so they can set a password.

This email is Shopify's Customer account invite notification. You can edit it in Settings,Notifications (opens in your Shopify admin in a new tab) in the Shopify admin.

Set up Katana

Check the requirements, connect Katana, then set up your customers and price lists in Katana.

Requirements

Connect Katana

  1. Go to SparkLayer Wholesale,Integrations,Partners (in your Shopify admin).
  2. Under Multi-channel management, turn on the switch next to Katana.
  3. Authorise SparkLayer to access your Katana account.

To change the settings later, open Katana at SparkLayer Wholesale,Integrations,Partners (in your Shopify admin).

SettingWhat it does
Send customers an invite email when activated in KatanaSends new customers Shopify's account invite email, asking them to confirm their account. See New customers.

Set up customers in Katana

Katana uses the customer's Category to decide which customer group they belong to in SparkLayer.

  1. In SparkLayer, go to SparkLayer Wholesale,Companies,Customer groups (in your Shopify admin) and note the tag of the group you want, for example b2b-ca for a group called B2B - Canada.
  2. In Katana, create or open the customer and set their Category to that tag, for example b2b-ca.
  3. Check the customer has a primary email address. It's used to match them in Shopify.

You can then set rules for the group, such as minimum orders and price lists, in SparkLayer Wholesale,Companies,Customer groups (in your Shopify admin).

A customer has only one category in Katana, and the group's tag is enough. SparkLayer adds the b2b tag in Shopify for you:

Category in KatanaCustomer groupTags in Shopify
b2bBase customer groupb2b
b2b-caThe group with the tag b2b-cab2b and b2b-ca

Write the category exactly as the group's tag. Only the b2b part can also be in capitals, as in B2B-ca. Customers whose category doesn't match a customer group aren't synced.

Change groups in Katana, not Shopify

Each sync sets the customer's group from their category in Katana, and replaces any group tag added in Shopify. To move a customer to another group, change their Category in Katana.

Set up B2B prices in Katana

  1. In Katana, go to Price lists and click + Price list.
  2. Enter a Price list name, for example UKVIP.
  3. On the Product pricing tab, add products and set their prices. For each product, choose an Adjustment method (for example Fixed) and an Amount. Katana shows the Final price.
  4. On the Customers tab, assign the price list to customers.

SparkLayer imports the new price list automatically. See Price lists for how its fields map.

Limitations

  • SparkLayer doesn't send B2B orders to Katana. The integration only brings customers and prices in from Katana.
  • Every address in Katana syncs to Shopify. Shopify has only one default address, so it's set to the customer's default shipping address in Katana.
  • If you remove a customer from the customer group, also remove their b2b tag from their customer account in Shopify.
  • Addresses sync one way, from Katana into Shopify. Don't let customers edit addresses in SparkLayer, or new addresses won't reach Katana.
  • Prices you delete in Katana aren't removed from SparkLayer. Delete them manually in SparkLayer Wholesale,Pricing,Price lists (in your Shopify admin).

Troubleshooting

Was this page helpful?

Last updated