Operation, interfaces and process for your merchandise management
Whoever keeps articles, stock and orders in SelectLine and runs a Magento shop does not want to maintain anything twice. This guide explains how you connect SelectLine to Magento, which ways exist and what determines the effort.
Table of contents
- 1. What it means to connect SelectLine to Magento
- 2. Which data flows between shop and SelectLine
- 3. Die Wege, um connect SelectLine to Magento
- 4. Typical pitfalls when you connect SelectLine to Magento
- 5. Ready-made product or individual development: how you decide
- 6. The process when you connect SelectLine to Magento
- 7. Effort and costs when you connect SelectLine to Magento
- 8. How we support you with the integration
- 9. Summary
- 10. FAQ
1. What it means to connect SelectLine to Magento
SelectLine is a merchandise management and business software for small and mid-sized businesses that bundles trade, warehouse, purchasing, sales and accounting. When you connect SelectLine to Magento, the shop becomes a sales channel of the ERP: articles, prices and stock go from there into the shop, orders and new customers go from the shop into SelectLine, and shipping and invoice status come back.
The benefit shows in daily work. Your employees keep working in SelectLine, orders do not have to be retyped, and the stock in the shop matches that in the warehouse. This is especially valuable if your employees work in the merchandise management all day anyway and the shop should cause no additional manual work there.
This guide is aimed at merchants and managing directors who use SelectLine. A general overview of the technical ways is given by the guide to ERP integration, the system types are classified by the guide merchandise management, ERP and PIM, and we describe the service on our page Magento SelectLine.
2. Which data flows between shop and SelectLine
| Data | Leading system | Direction | Typical rhythm |
|---|---|---|---|
| Articles and variants | SelectLine | SelectLine to shop | regularly or on change |
| Prices | SelectLine | SelectLine to shop | regularly or on change |
| Stock | SelectLine | SelectLine to shop | often, depending on need |
| Orders | Shop | Shop to SelectLine | immediately or at short intervals |
| New customers | depending on concept | Shop to SelectLine | on creation |
| Shipping status and invoices | SelectLine | SelectLine to shop | on status change |
Before planning technically, you define which system leads for which data. Whatever can be changed in both systems leads to contradictions sooner or later. Therefore define exactly one leading system per type of data and record the rule for the conflict case in writing.
Especially with variants, units and tax rates an assignment table that the department and the developers review together is worthwhile. The same terms do not always mean the same: a variant in the ERP must correspond to exactly one product with options in the shop.
3. Die Wege, um connect SelectLine to Magento
There are essentially four ways for the connection. The first is the direct connection through a programming interface, if your version provides one. In our research we found no publicly accessible documentation of such an interface of SelectLine. There are interfaces from third-party vendors for other shop systems, and a forum post describes SelectLine as locally operated software. What your version offers and where it runs you should therefore clarify early with the vendor or your SelectLine partner.
The second way is a file exchange with fixed formats such as CSV or XML, which is simple and robust but not in real time. The third way is an interface or platform of a third-party vendor, for Magento we found none, the fourth an individual development. We did not find an official Magento module from the vendor in our research. Which way fits depends on data volume, timeliness and your processes. You should avoid direct access to the database because it bypasses the rules of the software and can break on updates. With local operation it also holds that the shop must not reach into the internal network unprotected.
4. Typical pitfalls when you connect SelectLine to Magento
Five points we always address
- ✓Local operation: it is settled late how the shop securely reaches the internal system.
- ✓Several sales channels: the stock is sold for marketplaces and shop at the same time.
- ✓Unclear data ownership: prices or texts are changed in both systems.
- ✓Missing monitoring: a failed transfer is noticed only after days.
- ✓Reachability: the system runs only during office hours or behind a firewall, and transfers stay behind.
Most of these points can be avoided with planning and a log that makes errors visible. Whoever wants to connect SelectLine to Magento should also demand that the integration withstands short outages: transfers are buffered and caught up later instead of being lost. An integration is ongoing operation, so care belongs from the start, best within a maintenance contract.
5. Ready-made product or individual development: how you decide
Whoever wants to connect SelectLine to Magento will find products from third-party vendors. If one covers your requirements, it is often the more economical choice. Before buying, check how it is maintained, which way it uses, what happens on updates of Magento or SelectLine and how far it can be adapted.
An individual development pays off if your processes deviate from the standard: special price rules, several warehouses, bundles, own attributes or processes that a ready-made product does not know. It is more expensive at the start but fits exactly, and it needs someone who looks after it later. Have the costs over several years calculated before you decide.
6. The process when you connect SelectLine to Magento
Anyone who wants to connect SelectLine to Magento is best advised to proceed in four steps. First the inventory: which version of SelectLine do you use, how is it operated, which access exists, which data flows are desired and which special cases are there? From this a short concept arises that also records which system leads for which data. Then the work is done on a test system, never first against live data.
In the third step you check with real examples whether everything is correct: articles, orders, special cases. In the fourth step the start is made step by step, first the simple data flows, then the others. In the first weeks you look at the log together, which shows every transfer and every error. After that the integration runs in operation, and an agreement on updates prevents it from failing at the next update.
7. Effort and costs when you connect SelectLine to Magento
Whoever wants to connect SelectLine to Magento asks for the costs first, but a figure without an inventory would be a guess. Whoever has to connect SelectLine to Magento should also include hosting and maintenance. The effort depends on the number of data flows, the quality of the data in SelectLine, the special cases with prices, warehouses and customers and the desired timeliness. A data flow in one direction is built faster than a comparison in both directions with conflict rules. Besides the development, include the running items: hosting, maintenance and, where applicable, licenses.
A flat figure would be unreliable. We estimate in writing after the inventory, the hourly rate is 30 euros net, see pricing. General hints on costs are in the guide Magento costs.
8. How we support you with the integration
We are a web agency in which fixed freelancers work together, all from home offices. We develop the integration project by project, according to your processes and with documented rules, and we do not sell a ready-made connector off the shelf. Source code and access stay with you. More about our approach is on the page Magento SelectLine integration.
This guide gives general orientation. For a first conversation a short message through our contact page is enough. Please name your system, the version and the desired data flows, then we can assess the feasibility specifically.
9. Summary
Whoever wants to connect SelectLine to Magento makes the shop a sales channel of the ERP. Decisive are clear data ownership, the current interface and planning for ongoing operation.
Connect SelectLine to Magento at a glance
Clarify first
Version, operation and data flows
Data ownership
Exactly one leading system per type of data
Ways
Programming interface, file exchange, third-party vendor or individual development
Operation
Plan log, buffering on outages and care
Note: This article offers general orientation. The concrete feasibility depends on version, operation and configuration of your system.