Integrations
ERPs & Operations
Cin7 Core
requirements plan merchants must be signed up to the professional or enterprise plan platform merchants must be using shopify introduction cin7 core is a powerful inventory management system designed for retailers, wholesalers, and manufacturers from inventory and stock control, to order management and fulfilment, cin7 core helps automate and streamline your ecommerce operations you can learn more about cin7 core here https //www cin7 com/solutions/core/?utm term=cin7%20core\&utm campaign=mm search brand emea\&utm source=google\&utm medium=cpc\&hsa acc=9060130901\&hsa cam=18133732967\&hsa grp=149955377884\&hsa ad=655886024565\&hsa src=g\&hsa tgt=kwd 1942910059907\&hsa kw=cin7%20core\&hsa mt=e\&hsa net=adwords\&hsa ver=3\&gad source=1\&gbraid=0aaaaabis0phonutzfraddoqy0k8dbkfvx\&gclid=cj0kcqjwzrzabhd8arisanlswnmwimmv0asbe ckr02ksmped1 cxtjx8k6gg jafkfxpd2zucwp8dkaarzfealw wcb how it works the cin7 core integration for sparklayer is available for all shopify merchants https //docs sparklayer io/integrations/shopify introduction#introduction that already use cin7 core and allows you to bring b2b pricing and b2b ordering into sparklayer and your shopify store the integration works in the following ways item details customers cin7 becomes the 'master' of your b2b customer data, and any changes to customer records that have the assigned customer type will automatically be synchronised to shopify and sparklayer orders orders placed via sparklayer are synchronised from shopify into cin7 using your existing cin7 integration prices that show on orders will be the special b2b pricing as set up in cin7 pricing price lists and product prices are imported into sparklayer via pricing rules you set up in cin7 sync the automatic sync is carried out every 6 hours please note we recommend also familiarising yourself with the "known limitations" below configuring the integration before you begin you'll need to have an approved account with cin7 core please visit the cin7 website to learn more to get started, the integration needs to be enable within the sparklayer dashboard https //app sparklayer io/configuration/integrations/partners go to the settings section, click integrations , and then click the partner integrations tab under multi channel management , click the toggle on the right to activate the cin7 core integration you'll then be prompted to enter the following details item details api id you can find this within your unleashed admin under integration, api api key you can find this within your unleashed admin under integration, api customer tags the customer tag should match a customer group that exists in sparklayer this would be the customers within cin7 that sparklayer will synchronise to shopify please note the tag must match the sparklayer customer group exactly and be seperated by a comma with no space (e g group1,group2) for the purposes of testing, we recommend creating a new group and testing with a dummy customer first before using an existing group tax exempt codes this is the code that you want to sync across the customer across as tax exempt configuring customers broadly speaking, cin7 core is your central location for managing b2b customer data when customers are configured in cin7 as b2b customers, sparklayer can automatically retrieve this data and then enable the b2b ordering experience on your shopify site step 1 setting up a customer when you have set up the integration with sparklayer within your cin7 dashbaord, go to sale and then customer in this page you are able to set up the customer account next, navigate to your sparklayer dashboard and customer groups here you'll need to create the customer groups and once you have done this, you are then able to create the same tags within your customer in cin7 under "tags" in our example below, we have base and gold within cin7, and add the tag "b2b gold" you will also need to select the tax rule once you have done this, take the tax exemption rule and add this into the final stage of the sparklayer integration this means any customers that have been set as tax exempt in cin7 will automatically be tax exempt in shopify next, go to the partner integrations section of sparklayer and click modify within the cin7 integration finally, add the customer tags you have created for your customer groups that you want to sync across the customer from cin7 to sparklayer/shopify in our example, we've added them for b2b and b2b gold please note customer tags must be seperated by a comma with no spacing to sync correctly e g b2b,b2b gold step 2 syncing your customers to sync your customers, you'll need to create your customers in your cin7 dashboard if you haven't already when doing this you are able to allocate them add a tag this will assign them into the specific customer group within sparklayer when they are synced across the tag that you assign must match a customer group that you have created in your sparklayer dashboard already for example, if you are using the tags in the above screenshots, your customer groups would look like th below please note the customer would not be tagged with this customer group as the normal sparklayer function this will be assigned to them through a metafield (which is automatically created in your shopify) when setting up your customers in cin7, please ensure you set up general name currency sale price tier tax rule tags addresses a full address contacts name assign a valid email address this must be set up in order to sync to sparklayer and shopify tick main contact as "default" syncing across to sparklayer and shopify first, you'll need to add the customer tag to match that entered in the customer tag field (as noted above) sparklayer is then configured to synchronise every 6 hours , and any new and updated records will automatically be synchronised with shopify customers are mapped between the systems based on the default contact email set within cin7 core once this is mapped, sparklayer will then synchronise the following data into shopify cin7 core shopify / spark layer address shows against customer record in shopify primary telephone shows against customer record in shopify first / last name shows against customer record in shopify customer group shown via metafields in shopify (see above) credit limit / on hold shown via metafields in shopify tax codes (using the mapping in config) shows against customer record in shopify cin7 core price list tier / customer specific prices shown via metafields in shopify to show the correct pricing for the customer please note all customer data is managed via cin7 and any amends made directly in shopify will not synchronise back to cin7 step 3 giving access & notifying new customers since cin7 is the central source for customer data, any new customers created in cin7 will automatically be added to shopify (following the above steps) when new customer records are added to shopify, they will by default be added as pending customer accounts and receive an automatic email to enable their account by setting a password this uses the customer account invite notification email which can be edited in the notifications section within shopify if you prefer not to send the customer account invite automatically, you can easily check if this option has been activated simply go to your sparklayer dashboard, navigate to partner integrations when modifying your cin7 integration, you can enable or disable this via the setting at the bottom configuring pricing in cin7, you can utilise up to 10 price lists , allowing you to create multiple pricing tiers tailored to your various customer levels on top of this limit, you have the flexibility to set customer specific and product specific discounts, providing even more granular control over your pricing strategy step 1 price list setup in cin7, navigate to settings > general settings > sell price tier names here, you can customise the names of your price tiers, which are initially labelled as "sell price tier 1" through to "sell price tier 10" please note sparklayer does not support the custom names meaning they will show in sparklayer as "sell price tier x" step 2 viewing price lists when you view a product within your cin7 dashboard, under the prices tab you’ll see the available price tiers listed for products offered to your wholesale customers, you can specify the exact price for each tier, depending on which pricing list is assigned to the customer step 3 assigning a price list within your cin7 dashboard, navigate back to the customer account that you are working on you are then able to assign them a price list directly to the customer account within sell price tier this means when they login they will see the product pricing you've assigned to them please note these price lists will be asigned directly to the customer account through the sparklayer price list metafield which is set up differently to standard price lists you can learn more in metafields docid\ otlhhi8sq6os4pat23 8h setting up product specific discounts within the cin7 dashboard, navigate to a customer record and click product prices here you are able to set product specific pricing for this customer account you are able to search for a product, specify a fixed price on the product when doing this, it will create a new price list within the sparklayer price lists section assiging prices to the shopify customer account once you have finished configuring your customers pricing and a sync has taken place, you can then check the customer account in shopify to ensure they have been assigned the correct pricing the price list will be assigned directly to the customer account in a price list metafield (this gets added automatically when you first set up the sparklayer integration) it will also create the price list within your sparklayer dashboard > price lists as an "integration" price list with this metafield it will always work in a hierarchy order, which means when a customer searches a sku it will check the first price list and will cascade through the price lists untill it finds a price in the example below you are able to see a number of price lists any customer product specific discounts you have created within the customer in cin7 the normal price list that you have assigned to the customer data mapping we've detailed how data is mapped between sparklayer and unleashed item details creating price lists sparklayer generates several types of price lists based on the product prices available in cin7 sell price tiers if cin7 has specific sell price tiers set up (e g , "sell price tier 1", "sell price tier 2", etc ), sparklayer creates separate price lists for these tiers unleashed supports up to 10 sell price tiers that you can assign to different groups of customers customer specific prices if any customer has unique prices specified under the customer/product price tab in cin7, sparklayer creates a customer specific price list for that customer this ensures that individual customer agreements or special pricing arrangements are captured handling different currencies if a customer uses a currency other than the base currency, sparklayer will automatically create alternative currency price lists based on the existing price lists assigning price lists to customers when assigning prices to customers, sparklayer follows this order of priority first, the customer specific price list (if available) then, a sell price tier (if assigned in cin7) if a customer has multiple currencies or discounts, they will get additional price lists accordingly why prefixed price lists? sparklayer may apply generic "prefixed" price lists to every customer this is to ensure that a basic sell price tier is always in place, even if the customer’s unleashed configuration doesn’t explicitly assign one known limitations the following limitations apply internally sparklayer will use the internal sellpricetier naming for simplicity between mapping, not the custom naming that can be setup via the unleashed settings changing the customers email address, will create an additional customer in shopify the old account will need to be disabled manually primary customer contacts will only be synced if a new primary contact is selected, the existing shopify customer on the store should be manually disabled a customer that is removed by removing the tag will not be disabled within shopify default addresses in cin7 core will be mapped to shipping and billing address in shopify (shopify doesn't support independent addresses) addresses are a 1 way sync from cin7 core into shopify it's recommended to not allow address editing in sparklayer otherwise new addresses added won't appear in cin7 core and will be replaced on next integration run troubleshooting my customers are not appearing in shopify ensure that customers in cin7 core have been assigned the correct tags matching the sparklayer customer groups confirm the tag formatting tags must be separated by commas without spaces (e g , b2b,b2b gold) check that the customer has a valid default contact with a valid email address customer account invites are not being sent by default, shopify will send a customer account invite email when a new customer is created check if automatic invitations are disabled in the sparklayer partner integration settings customer specific pricing is not displaying after updating pricing, allow up to 6 hours for the next sync to complete verify that the correct price list metafield exists against the shopify customer record changes made in shopify are not reflected in cin7 core the integration is one way (cin7 core ➔ shopify) changes must always be made in cin7 core if you update customer information directly in shopify, it will be overwritten by the next sync product pricing appears incorrect for customers double check that the customer is assigned to the correct sell price tier or product specific pricing in cin7 core, ensure that price tiers have the expected values for your products confirm that no old price lists or tags are incorrectly linked to the customer in sparklayer customer duplicates appear in shopify double check that the customer is assigned to the correct sell price tier or product specific pricing in cin7 core, ensure that price tiers have the expected values for your products confirm that no old price lists or tags are incorrectly linked to the customer in sparklayer