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 |
|---|---|
| Addresses, with the phone number on each | Customer record in Shopify |
| First and last name | Customer record in Shopify |
| Customer category | Customer group in SparkLayer, and the group's tag in Shopify |
| 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
- 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,Companies,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,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 Katana | Customer group | Tags in Shopify |
|---|---|---|
b2b | Base customer group | b2b |
b2b-ca | The group with the tag b2b-ca | b2b 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
- 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.
- 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
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 customer's category matches a customer group's tag, such as
b2borb2b-ca. See Set up customers in Katana. - The Katana integration is turned on and authorised in
SparkLayer Wholesale,Integrations,Partners (in your Shopify admin).
Katana decides the customer group. Each sync sets the group from the customer's Category in Katana and replaces any group tag added in Shopify. A customer with the category b2b goes back to the Base customer group, and their other b2b- tags are removed.
Set the category in Katana to the group's tag instead, for example b2b-ca. The next sync adds the tag back in Shopify.
SparkLayer skips an address whose country or region it doesn't recognise, and reports it as a sync error for that customer. Check the spelling of the country and region on the address in Katana.
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