Logic4: merchant plugin guide

This guide describes how to set up a connection between Logic4 and ChannelEngine, including how to install, how to configure it, and more.

Table of contents

Introduction

Features

Requirements

Install Logic4 plugin on ChannelEngine

• Setup
• Plugin-specific settings
• Advanced settings
• Product data
• Important information

How it works

FAQs

Introduction

Logic4 is an enterprise resource planning (ERP) system that helps ecommerce businesses streamline and integrate key processes. It offers solutions for managing finance, inventory, production, sales, and customer relations.

ChannelEngine's plugin for Logic4 uses the latest Logic4 API to synchronize data between the two systems. It automates the management of product offers, orders, shipments, and cancelations.

Features

* You can upload your product data (content and offers) to ChannelEngine using a product feed. To learn more, check out the Product data section of this article. 

Requirements

• Active account on Logic4
• Active merchant account on ChannelEngine

Install Logic4 plugin on ChannelEngine

Setup

On Logic4

To establish a successful connection between Logic4 and ChannelEngine, you need to request the following credentials from Logic4:

• User ID
• Authorization public key
• Authorization secret key
• Authorization company key
• Authorization user name
• Authorization password

On ChannelEngine

1. Click Plugins from the left-hand side menu.
2. Locate the Logic4 plugin and click Add.
3. On the plugin Setup page, go to the Connection section. 
4. Enter the credentials you received from Logic4 in the appropriate fields.
5. Leave the following settings at their default values, without changing them.
   • Administration ID
   • Authorization token URL
   • Authorization scope
   • API base URL

Plugin-specific settings

To retrieve some of the IDs listed below, send requests to the Logic4 API. To learn more, check out the Logic4 Swagger API reference. 

• Invoice address ID - the ID of the invoice address. Set this to '1'.
• Shipping address ID - the ID of the shipping address. Set this to '2'.
• B2C customer relation type - the type of debtor (a.k.a. customer) created on Logic4 for regular customers. Set this to 'Particulier' (Private). To check this, in your Logic4 customer portal, go to Instelllingen, Systeem instellingen, Algemeen, Relatie type.
• B2B customer relation type - the type of debtor created on Logic4 for business customers. This is set to 'Zakelijk met contact' by default. To check this, in your Logic4 customer portal, go to Instelllingen, Systeem instellingen, Algemeen, Relatie type.
• Customer relation status ID - the status of the created debtor (customer). Four options are available: Actief (Active), Geblokeerd (Blocked), Niet actief (Not active), Prospect. To check this via the Logic4 API, send a call to GET /Relations/GetRelationStatuses.
• VAT default high ID [country] - the ID of the VAT rate in Logic4 that applies to products with a high VAT rate for that particular country. To check this via the Logic4 API, send a call to GET /Financial/GetVatCodes.
• VAT default low ID [country] - the ID of the VAT rate in Logic4 that applies to products with a low VAT rate for that particular country. To check this via the Logic4 API, send a call to GET /Financial/GetVatCodes.
• Order status ID for export - the ID of the status that is assigned to newly created orders. To check this, in your Logic4 customer portal, go to in Orders, Inrichten, Order status.
• Order status ID for closed orders - the ID of the status that is assigned to closed orders. Set this to '3'. To check this, in your Logic4 customer portal, go to in Orders, Inrichten, Order status.
• Order status ID for canceled orders - the ID of the status that is assigned to closed orders. Set this to '5'. To check this, in your Logic4 customer portal, go to in Orders, Inrichten, Order status.
• Order user ID (default) - the user account to be linked when creating a new order. To check this via the Logic4 API, send a call to GET /User/GetAllUsers.
• Order branch ID (default) - the branch to be linked when creating a new order. To check this via the Logic4 API, send a call to GET /Company/GetBranches.
• Order website domain ID (default) - the website to be linked when creating a new order. To check this via the Logic4 API, send a call to GET /WebsiteDomains/GetWebSiteDomains.
• Order warehouse ID (default) - the warehouse to be linked when creating a new order. To check this via the Logic4 API, send a call to GET /stock/GetWarehousesForAdministration and include Administration as a number in the request body.
• Matching ledger ID - the ID of the ledger in which the payment is recorded. Logic4 uses both a code and an ID for each matching ledger – use the ID in this field. To check this via the Logic4 API, send a call to GET /Financial/GetLedgers.
• Use the /GetOrders API call for shipments - enable this to use the /GetOrders endpoint to retrieve orders and create shipments. Otherwise, the /GetInvoices endpoint is used.
• Payment method ID [marketplace name] - the ID of the payment method associated with an order created on that particular marketplace. To check this, in your Logic4 customer portal, go to Instellingen, Administratief, Betaalmethoden.
• Payment method description [marketplace name] - if the payment method is required in the description of the order payment, enter it here.
• Booking method ID [marketplace name] - the ID of the ledger where the payment is recorded for orders from that particular marketplace. To check this via the Logic4 API, send a call to GET /Financial/GetFinancialBooks and include "LedgerId": ledgerid in the request body.
• Picklist layout ID [marketplace name] - the ID of the report layout used when picking the order. This can be found under Rapporten beheer (Reports management) on Logic4.
• Website domain ID [marketplace name] - the ID of the website domain. If this value is not set for a marketplace, the default value '1' is used.
• Shipping method ID and delivery [marketplace name] - set the shipping method ID and, optionally, the delivery option ID for each country. To check the IDs via the Logic4 API, send calls to GET /Shippers/GetShippingMethods and POST /Shippers/GetDeliveryOptions respectively. Use one of the following formats to enter the value: [country ISO]=[shipping method ID] or [country ISO]=[shipping method ID],[delivery option ID]. Separate multiple entries with a pipe ( | ). Use 'ZZ' for all countries that are not explicitly listed.
  • Example 1: NL=2|BE=3|ZZ=10
    • Orders delivered to the Netherlands use shipping method ID 2.
    • Orders delivered to Belgium use shipping method ID 3.
    • Orders delivered to all other countries use shipping method ID 10.
  • Example 2: NL=1,1|BE=2,1|ZZ=4,1
    • Orders delivered to the Netherlands use shipping method ID 1 and delivery option ID 1.
    • Orders delivered to Belgium use shipping method ID 2 and delivery option ID 1.
    • Orders delivered to all other countries use shipping method ID 4 and delivery option ID 1.
• Default delivery option ID [marketplace name] - if no delivery option ID is specified for a country, this default delivery option ID is used. It defines the package type (e.g.: letter package or parcel post) for newly created orders. Currently, only PostNL uses this setting. The default value is 1, which corresponds to parcel post.

Advanced settings

• Orders fulfilled by merchant synchronization - if enabled, orders with the status New on ChannelEngine are synchronized with Logic4.
• Synchronization of orders fulfilled by marketplace - If enabled, orders fulfilled by the marketplace are synchronized with Logic4. You can select a specific date from which you want to import marketplace-fulfilled orders. Note that this setting cannot be reverted once enabled.
• Order status ID for fulfilled by marketplace orders - the ID of the status assigned to orders fulfilled by the marketplace. To check this, in your Logic4 customer portal, go to in Orders, Inrichten, Order status.
• Warehouse ID for fulfilled by marketplace orders - the ID of the warehouse assigned to orders fulfilled by the marketplace. To check this on Logic4, send a call to GET /stock/GetWarehousesForAdministration and include Administration as a number in the request body.

Product data

The Logic4 plugin does not support a direct API connection to retrieve product data. Instead, you can import product data into ChannelEngine using a product feed.

This product data should include both product content and offers (prices and stock levels).

To import your product feed from Logic4:

1. Export your product data from Logic4 and publish the export file to the web. Copy its URL.
2. On ChannelEngine, go to Products, Product feeds, and click Add feed.
3. Paste the copied URL into the relevant field and click Load product feed.
4. Map your data attributes on Logic4 to product attributes on ChannelEngine. A full walkthrough of the steps involved can be found in the article ChannelEngine: product feeds. A few recommendations:
   • Map the SKU (Merchant product number) attribute to Artikelcode (product code).
   • Map the Product ID attribute to a custom field named ProductIdLogic4.

Important information

Each debtor (customer) on Logic4 can be linked to only one ChannelEngine order. This limitation ensures that shipments are synchronized correctly.

How it works

Once Logic4 is connected with your ChannelEngine tenant and the product feed has been set up, ChannelEngine starts exporting orders to Logic4 and importing shipments, and cancelations from Logic4. Product content and offers are synchronized via a product feed.

FAQs

How often does each task run on Logic4?

By default, the Logic4 plugin follows the schedule below.