Shopify integration

Shopify + Le New Black integration overview

Shopify is a popular e-commerce solution for small and medium businesses, that can be used for basic inventory and invoicing management. Le New Black acts as a collaborative B2B portal for your team and resellers and a sales rep facing iPad app that sends B2B orders back to Shopify.

	The connector uses Shopify REST & GraphQL admin APIs to exchange data (read docs)
	Le New Black is the master system for all data flows (eg. triggers all push/pull operations)
	The connector requires basic configuration in Le New Black and Shopify (see global prerequisites)

Data flows

Data flow: Products

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB
• Shopify's API endpoints used:
  • Get products

Facilities

• Your product data will reflect the master product data hosted in Shopify
• You will click a button in Le New Black to trigger the import (this may automated on demand)
• You will decide whether to import products from a specific sales channel (see Sales channel section in global prerequisites) or from all custom and smart collections in Shopify

Callouts

• A filter is applied to only import products with "active" status in Shopify (this may be customised)
• The following fields will be used as identifiers by the connector to decide whether to create or update the data. If some data has been established into Le New Black prior to the connector setup, these identifiers should be carefully checked to match Shopify data:
  • collection: code
  • category: name
  • product: model
  • fabric: code

Prerequisites

• Add permissions to your Shopify private app (see global prerequisites): read_products

Image flow: Product images

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB

Facilities

• Your product images set will reflect the product and variant images hosted in Shopify
• Product image URLS will be imported into Le New Black, you will then click a button in Le New Black to dispatch them in products / variants

Callouts

• A filter is applied to only import images for products with "active" status in Shopify (this may be customised)
• A limit is applied to only import the first 8 images at product variant on Le New Black

Prerequisites

• Add permissions to your Shopify private app (see global prerequisites): read_products

Data flow: Inventory stock levels

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB
• Shopify's API endpoints used:
  • Get inventory items 
  • Get inventory levels

Facilities

• Your inventory data will reflect the available-to-sell quantities from Shopify
• You will click a button in Le New Black to trigger the import (this may automated on demand)
• You will define whether to match your inventory items on EAN13s or SKU codes
• You may filter stocks to import from a specific location in Shopify

Callouts

• A filter is applied to only import stocks from products with "active" status in Shopify (this may be customised)

Prerequisites

• Add permissions to your Shopify private app (see global prerequisites): write_inventory, read_inventory, read_products, read_locations

Data flow: Inventory stock movements

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB
• Shopify's API endpoints used:
  • Get inventory items
  • Get inventory levels
  • Get inventory locations
  • Post inventory level

Facilities

• Your inventory movement due to orders placed on Le New Black will be subtracted to the available-to-sell quantities in Shopify
• You will click a button in Le New Black to trigger the import (this may automated on demand)

Prerequisites

• Add permissions to your Shopify private app (see global prerequisites): write_inventory, read_inventory, read_products, read_locations

Data flow: Orders

Reference 

• Full file template: see in Google Drive
• Data flow: from LNB to ERP
• Shopify's API endpoints used:
  • Post order 
  • Put customer

Facilities

• You will be able to select orders to export from Le New Black
• You will click a button in Le New Black to trigger the export (this may automated on demand)
• You may define the "inventory behaviour" that Shopify will apply on ordered products (see Shopify docs)
• You may add a custom "tag" to your Le New Black customers to easily identify them in Shopify

Callouts

• Products without a valid EAN13/SKU code will block the order export
• After the order has been exported from Le New Black, further changes must be done in Shopify

Prerequisites

• Add permissions to your Shopify private app (see global prerequisites): write_orders, read_products

Global prerequisites

You must create a private app in Shopify (see Shopify documentation) and follow these 2 steps: 

1. Generate API keys (see Shopify documentation) that you will provide Le New Black with and that look as follows:
   • API key: verylongstringwithlettersandnumbers
   • API secret: otherlongstringwithlettersandnumbers
   • Shopify URL: https://mysubdomain.myshopify.com/
2. Set API scope with the following permissions (see Shopify documentation): 
   • Product and product image flows: read_products
   • Inventory flows: write_inventory, read_inventory, read_products, read_locations
   • Order flow: write_orders, read_products

If you wish to use the sales channel filter when importing products/images/stocks, add the following permission to your application: unauthenticated_read_product_listings ... you will see a new sales channel with the application's name when editing products and collections in Shopify.

Integration project

Who's assigned from your team

Your Shopify administrator, or someone technical who is familiar with your specific setup. A Sales Manager who understands your business, and your merchandising strategies. 

Who's in charge at Le New Black

Your account manager will be taking care of the whole process from day 1. He/she'll be doing:

• Asking questions about your specific Shopify setup and sales process.
• Generating and exporting test orders to Shopify.
• Making sure your team is updated throughout the process and addressing delays occurring on either side.
• Working with you and Shopify support to troubleshoot any unexpected issues that arise after launch.

Timeline

A standard integration of the inventory stock levels and orders data flows will take 2-4 weeks to get up and running. 

Integration monitoring

Once the connector is set up, you will have access to the Integration center to manage and monitor your integration with a set of tools:

• access to task logs files for continuous monitoring and troubleshooting (e.g. see if a missing EAN13 or retailer reference is preventing an order from being exported)
• triggers task manually to push and pull data on-demand
• preview data before actual import (only available on some connectors)