Katana
Applies toShopify
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.
Katana
SparkLayer
Shopify
What syncs and in which direction
Customers and prices sync one way, from Katana. SparkLayer's Katana integration doesn't send orders to Katana.
| Data | Direction | Details |
|---|---|---|
| Customers | Katana to Shopify and SparkLayer | Katana is the master of your B2B customer data. Changes to customer records sync to Shopify and SparkLayer automatically. |
| Prices | Katana to SparkLayer | Price 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.
| Katana | Shopify and SparkLayer |
|---|---|
| Address | Customer record in Shopify |
| Primary telephone | Customer record in Shopify |
| First and last name | Customer record in Shopify |
| Customer category | Customer record in Shopify, matched to a customer group |
| Company name | Shopify metafield |
| Discount rate | Shopify metafield |
| Price list | Shopify 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 SparkLayer | Field in Katana |
|---|---|
| Handle / ID | Price list ID |
| Name | Price list name |
| Currency | Currency |
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
- The Pro or Enterprise plan. See Plans and features.
- A Shopify store connected to SparkLayer. See Shopify.
- An approved Katana account. See the Katana website (opens in a new tab).
Connect Katana
- In the SparkLayer Dashboard, go to
SparkLayer Wholesale,Integrations,Partners (in your Shopify admin). - Under Multi-channel management, turn on the switch next to Katana.
- Authorise SparkLayer to access your Katana account.
To change the settings later, open Katana at
SparkLayer Wholesale,Integrations,Partners (in your Shopify admin).
| Setting | What it does |
|---|---|
| Send customers an invite email when activated in Katana | Sends 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.
- In SparkLayer, go to
SparkLayer Wholesale,Customers,Customer groups (in your Shopify admin) and note the tag of the group you want, for example b2b-cafor a group called B2B - Canada. - In Katana, create or open the customer and set their Category to that tag, for example
b2b-ca. - 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,Customers,Customer groups (in your Shopify admin).
Set up B2B prices in Katana
- In Katana, go to Price lists and click + Price list.
- Enter a Price list name, for example
UKVIP. - 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.
- 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.
- Shopify doesn't support separate addresses, so the default address in Katana is used as both the shipping and billing address in Shopify.
- If you remove a customer from the customer group, also remove their
b2btag 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
Check that:
- The customer has a primary email address in Katana. It's used to match them.
- The Katana integration is turned on and authorised in
SparkLayer Wholesale,Integrations,Partners (in your Shopify admin).
Addresses sync one way, from Katana to Shopify, so changes made in SparkLayer don't reach Katana. To keep data consistent, turn off address editing in SparkLayer.
Check that:
- The Katana integration is turned on and authorised.
- New customers have all the required fields, especially the email address.
- The invite email settings are right: Send customers an invite email when activated in Katana, and Shopify's Customer account invite email.
- Create and update price lists in Katana, not in SparkLayer.
- Prices deleted in Katana don't sync. Remove old prices manually in SparkLayer.
Check that:
- The customer is assigned to the right price list in Katana.
- The right currency is set on the customer, if they use a different currency from your base currency.
Check the price list is saved in Katana, then allow time for SparkLayer to import it.
In the Shopify admin, go to Settings,Notifications (opens in your Shopify admin in a new tab) and edit the Customer account invite template. SparkLayer uses it when activating new accounts created from Katana.
Last updated