Shopify + Le New Black integration overview
Shopify is an e-commerce platform for small and medium businesses, also used for basic inventory and invoicing management. Le New Black offers a collaborative B2B portal for your team and retailers, and an order-taking iPad app for your sales team.
The connector uses the Shopify API to exchange data (read docs) |
|
Le New Black drives all data flows: it triggers every push and pull operation |
|
The connector requires basic configuration in Le New Black and Shopify |
Data flows
| Type | Flow |
| Products | Shopify ⇢ Le New Black |
| Product images | Shopify ⇢ Le New Black |
| Inventory stock levels | Shopify ⇢ Le New Black |
| Orders | Shopify ⇠ Le New Black |
| Inventory stock movements | Shopify ⇠ Le New Black |
Data flow: Products
Products of your Shopify collections are imported with their collection, product type, options, barcodes and SKUs: each Shopify variant becomes one size of one colour, grouped into Le New Black products by Shopify product.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Products with the status "active" (other statuses when set up) that belong to at least one smart or custom collection, or to a collection published on the Le New Black sales channel when set up, and that have both a colour option and a size option. Products can also be filtered by collection title and by tag.
Matching keys: Product: model (the Shopify product id). Variant: fabric name and fabric code, both the value of the Shopify colour option. Size: size name (the value of the Shopify size option), with its EAN13 (the Shopify barcode) and its SKU.
Import mode: Create or update → new products and variants are created, existing ones are updated.
Created on the fly: Collections (by collection title), categories (by product type) and variants
Not synchronised: Prices and stock (stock has its own data flow), and products that are in no collection. A product that is no longer active in Shopify is not removed from Le New Black.
Configuration
| Setting | Values | Type | Comment |
product_create_is_allowed |
true (default) / false | bool | With false, products missing from Le New Black are not created: only existing products are updated |
sizing_create_is_allowed |
true / false (default) | bool | Whether a size range missing from Le New Black is created |
product_sizing_update_is_allowed |
true / false (default) | bool | Whether the import can change the size range of an existing product |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | Shopify field | Comment |
Model |
Product id | |
Name |
Product title | |
Collection |
Collection title | First smart or custom collection of the product, or its collection on the Le New Black sales channel |
Category |
Product type | |
Fabric name / Fabric code |
Value of the colour option | Option named Color by default (setting options_mapping) |
Reference |
Product handle and value of the colour option | Joined by a hyphen |
Description |
Product description | |
Weight |
Variant weight and weight unit | First variant of the colour with a weight |
Size |
Value of the size option | Option named Size by default (setting options_mapping) |
EAN13 / SKU |
Variant barcode / SKU | |
Other product and variant fields |
Product metafields | Optional, set up with your account manager |
Callouts
- The size range of each product must exist in Le New Black, unless the connector is set up to create it.
- A product without a colour option or a size option is not imported.
Data flow: Product images
The images of your Shopify products are saved on each Le New Black variant as image addresses, then imported from the Integration center.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Images of the products read by the Products data flow, with the same filters
Limit: 8 images per variant: the images attached to the variant in Shopify, in their Shopify order, then, for the first variant of each product, the other images of the product
Matching keys: Product: model (the Shopify product id). Variant: fabric name (the value of the Shopify colour option).
Rejected rows: Images of a product or a variant unknown in Le New Black are ignored and reported in the task log: import products first.
Callouts
- Products and variants must already exist in Le New Black: import products before images.
Data flow: Inventory stock levels
Available quantities are imported from Shopify, from all your locations or from the one you select, for each EAN13 or SKU.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Inventory items of the products with the status "active" (other statuses, tags or the Le New Black sales channel when set up)
Quantity imported: The available quantity of each inventory item, summed over every Shopify location, or taken from the location set up
Matching keys: Size: EAN13 or SKU, on both sides. On the Shopify side, the EAN13 is the barcode of the variant.
Import mode: Add by default → only the sizes in the Shopify data are updated, the others keep their quantity. Replace, when set up → the stock of every size is set to 0 before the quantities are applied. Negative quantities are imported as 0.
Rejected rows: A Shopify EAN13 or SKU unknown in Le New Black is ignored and reported in the task log: import products first.
Configuration
| Setting | Values | Type | Comment |
import_mode |
add (default) / replace | string | With replace, the stock of every size is set to 0 before the quantities are applied |
lnb_sku_identifier_column |
ean13 (default) / sku | string | Le New Black key the stock rows are matched against |
lnb_stock_column |
quantity (default) / incoming_quantity | string | Le New Black quantity updated |
sku_identifier_column |
ean13 (default) / sku | string | Shopify key matched against the Le New Black key |
filter_location_id |
Shopify location id / 0 (default) | integer | Location whose available quantities are imported; with 0, the quantities of every location are summed |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are created in Shopify as orders, or as draft orders when set up.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Orders exported: Status Invoicing
Integration status: Only orders whose integration status is Pending are exported, and it becomes Successfully sent after export. The selection can be adapted during set-up.
Status after export: Closed
Blocked orders: An order that fails a check keeps its status and gets the integration status Blocked, with the reason in the task log. It is not sent again until you set its integration status back to Pending from the orders list (action Set integration status to Pending).
Limit: No limit
Sales order: A Shopify order (or draft order) named "PO-" followed by the Le New Black order number, with the order currency, the billing e-mail and address, the delivery address when set up, the tags set up, and one line per ordered size with its quantity and its Le New Black price
Matching keys: Customer: billing e-mail of the LNB order, which Shopify uses to find the customer or to create it. Products: EAN13 (the Shopify barcode) or SKU.
Not synchronised: Delivery dates, comments and shipping costs are not part of the order sent.
Configuration
| Setting | Values | Type | Comment |
sku_identifier_column |
ean13 / sku | string | Shopify key matched against the Le New Black key |
export_type |
order (default) / draft_order | string | Kind of Shopify document each order is exported as |
include_delivery_address |
true / false (default) | bool | Whether the delivery address is sent along with the billing address |
payment_status |
Shopify financial status (paid, pending, …) | string | Payment status of the orders created; without it, Shopify applies its own default |
inventory_behaviour |
bypass / decrement_ignoring_policy / decrement_obeying_policy | string | How Shopify updates its stock for the ordered products, for stock orders only |
tags |
Shopify tags | string | Tags added to the orders created |
customer_tags |
Shopify tags | string | Tags set on the Shopify customer of each exported order |
validate_stock_ats |
true / false | bool | With true, the orders are exported in stock allocation order: by status (Invoicing first), then by date |
Callouts
- An order with a line whose product has no EAN13 or SKU code, or a code unknown in Shopify, is blocked as a whole: none of its lines is exported.
- The payment status and the inventory behaviour are not applied to draft orders.
- After the order has been exported from Le New Black, any further change must be made directly in Shopify.
Data flow: Inventory stock movements
The quantities of the orders you move to the exported status (Invoicing by default) are subtracted from the available quantities of the Shopify location you select, so that Shopify keeps selling only the stock Le New Black has not taken.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Orders exported: Status Invoicing
Integration status: Only orders whose integration status is Pending are exported, and it becomes Successfully sent after export. The selection can be adapted during set-up.
Status after export: Closed
Blocked orders: An order that fails a check keeps its status and gets the integration status Blocked, with the reason in the task log. It is not sent again until you set its integration status back to Pending from the orders list (action Set integration status to Pending).
Limit: No limit
Quantity sent: For each ordered size, the ordered quantity is subtracted from the available quantity of its Shopify inventory item at the location set up. No order is created in Shopify.
Matching keys: Size: EAN13 or SKU, on both sides. On the Shopify side, the EAN13 is the barcode of the variant.
Configuration
| Setting | Values | Type | Comment |
filter_location_id |
Shopify location id | integer | Shopify location whose available quantities are decremented |
lnb_sku_identifier_column |
ean13 (default) / sku | string | Le New Black key sent for each order line |
sku_identifier_column |
ean13 (default) / sku | string | Shopify key matched against the Le New Black key |
Callouts
- An order with a size whose EAN13 or SKU matches no Shopify inventory item at the location is blocked as a whole: none of its quantities is subtracted.
- Once an order has been exported from Le New Black, its quantities are subtracted only once: later changes to the order are not sent to Shopify.
Global configuration
Configuration
| Setting | Values | Type | Comment |
version |
legacy (default) / current / oauth | string | Way Le New Black signs in to your Shopify account: user name and credential (legacy), Admin API access token (current) or app client credentials (oauth) |
store_url |
Shopify shop address | string | Address of your Shopify account |
access_token |
Shopify Admin API access token | string | Credential of your Shopify account, set up with your account manager |
client_id |
Shopify app client id | string | Credential of your Shopify account, set up with your account manager |
client_secret |
Shopify app client credential | string | Credential of your Shopify account, set up with your account manager |
login |
Shopify user name | string | Credential of your Shopify account, set up with your account manager |
password |
Shopify user credential | string | Credential of your Shopify account, set up with your account manager |
is_from_sales_channel |
true / false (default) | bool | With true, only the products and collections published on the Le New Black sales channel of your shop are read (all data flows) |
product_filters |
statuses (active by default), collection titles, tags | list | Products read: by status and tag, and by collection title for the products and images (all data flows) |
options_mapping |
colour option name (Color by default), size option name (Size by default) | list | Names of the Shopify product options holding the colour and the size (all data flows) |
Callouts
- Le New Black connects to your shop through a custom app created in your Shopify admin.
- The app needs these access scopes: read_products for the products and images; read_products, read_inventory and read_locations for the stock levels; write_orders, write_draft_orders, write_customers and read_products for the orders; write_inventory, read_inventory, read_products and read_locations for the stock movements. Reading only the Le New Black sales channel also needs unauthenticated_read_product_listings.
- Shopify caps the number of API requests: a refused request is retried up to three times, one second apart, before the task stops and reports it in its log.
Integration project
Who's assigned from your team?
Your Shopify administrator, or an IT profile within your company who is familiar with your specific setup. A Sales Manager who understands your business and your merchandising strategy.
Who's in charge at Le New Black
Your account manager at Le New Black takes care of the whole process from day 1:
- Asking questions about your specific Shopify setup and sales process.
- Setting up the connection with your Shopify account.
- Generating and exporting test orders to Shopify.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and Shopify to troubleshoot any unexpected issue 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, the Integration center of your back-office gives you a set of tools to manage and monitor the integration:
- Task logs, for continuous monitoring and troubleshooting (for example a missing EAN13 or retailer reference that prevents an order from being exported)
- Running a task on demand, to push or pull data at once
- A preview of the data before the actual import (only available on some connectors)
- E-mail notifications per task, set up on request: exported and blocked orders, import errors
- The integration status of each order in the orders list (Pending, Successfully sent, Blocked), which you can set back to Pending to send an order again
Comments
0 comments
Please sign in to leave a comment.