Hiring our Chief Marketing Officer!

Published on by Joannes Vermorel.

We are hiring a lead generation wizard!

Lokad is a software company that specializes in quantitative optimization for commerce. We help merchants, and a few other verticals, to forecast their inventory and to optimize their prices. We are profitable; we are still small but growing fast. We are closing deals North America, Europe and Asia. The vast majority of our clients are not in France.

Lokad is sold through the web, almost exclusively relying on inbound marketing. We have hundreds of leads per month, but we are aiming for thousands. So far marketing was done part time by the founder, but it's time to put marketing in more capable hands.

As the Chief Marketing Officer at Lokad, you will have one metric: the number of qualified leads; and we expect you to own a lead commit as well. At this stage, we do not care about corporate marketing, only lead generation matters. The web is the native marketing channel of Lokad. While other channels can be leveraged, we expect you to steadily increase the presence of Lokad on the web to generate the bulk of lead growth.

Our technology is very noticeable, and we need you to make sure that decision makers do notice. Our reach is the world. Lokad is already available in many languages beyond English.

We are located 50m from Place d'Italie, Paris, France.

Desired Skills and Experience

You have two years or more in lead generation marketing for a B2B SaaS company. With a bit of help from a graphic designer, you can deliver awesome web marketing materials. Your written communication skills are top notch, and big bonus to you if you have a blog with some audience. B2B stuff is usually boring, and non-viral, and yet, you can make things happen: you can vanquish the market inertia and make people pay attention. Naturally, you are perfectly fluent in English. Speaking French is a bonus but not a requirement.

Categories: Tags: hiring

SkuVault natively integrated

Published on by Joannes Vermorel.

SkuVault is a warehouse management software tailored for eCommerce. We are pleased to announce that SkuVault is now natively supported by Lokad. Importing the SkuVault historical data into Lokad can now be done with a single click - or no clicks at all using our scheduling feature. Now SkuVault-powered businesses can get advance inventory forecasts as well as powerfull commerce analytics within minutes.

Categories: Tags: partners

Competitive intelligence with Competera

Published on by Joannes Vermorel.

Starting from today, Lokad-powered merchants can obtain the prices of their competitors by using their own Lokad account, thanks to our new partner Competera. The app benefits from a native integration within Lokad.

Competera is a competitive price monitoring app. Give them the domain names of your competitors, the domain name of your own store, and Competera will begin extracting prices right from the web. Competera takes care of generating a price matrix where each one of your products gets matched with the prices of your competitors. Competera works pretty much like Lokad: no software to install and a monthly subscription. You can get a trial and demo as well.

By combining Competera and Lokad, it becomes possible:

  • to stop wasting time with manual and infrequent competitor surveys
  • to monitor how your market share reacts to competitors' pricing moves,
  • to craft pricing strategies that leverage both in-house data and competitors' data
  • to fine-tune the trade-off between profitability and growth

The Competera team is here to deliver all the support your company needs as far as monitoring your competition is concerned. In turn, Lokad is here to turn this data into better margins, better stocks and more growth depending on your strategic targets.

Interested? Just drop us an email, and we will make sure your setup goes smoothly.

Categories: Tags: pricing, partners

Currency exchange rates with Envision

Published on by Joannes Vermorel.

Merchants frequently buy with one currency and sell using another. As online commerce is becoming more and more a global commerce, it's not unusual to encounter merchants who are buying in multiple currencies, and selling in multiple currencies as well. From a business analytics viewpoint, it soon becomes rather complicated to figure out where the margins stand exactly. In particular, margins depend not only on the present currency conversion rates, but also on those that have been in place 6 months ago.

As part of our commerce analytics technology, we have recently introduced a new forex() function that is precisely aimed at taking into account historical currency conversion rates for almost 30 currencies - including all the major ones.

Lokad's built-in dashboards have already been updated to take advantage of this function. Now, when Lokad carries out a gross-margin analysis for example, all the sales orders and purchase orders are converted into a single currency, applying the correct historical rates used at the time the transactions were made.

Categories: Tags: envision

In the end, there can be only one

Published on by Joannes Vermorel.

When it comes to the optimization of stock levels, or prices, or assortments … merchants need to look at many business performance indicators to be able to make the correct operational decisions. However, numerical optimization, much like statistical forecasting, is deeply counter-intuitive. In particular, there is a deep and subtle catch when using indicators to optimize an aspect of your business: in the end, there can be only one. Maintaining multiple indicators to drive the final decision that results from an optimization process is a recipe for picking a posteriori the metric that makes the management looks good, while damaging the business in the process. Let’s review how the whole thing unfolds.

There are many indicators that are typically found in commerce. For example, we have the total stock value (the lower, the better), the average inventory service level (the higher, the better), the total sales volume (the higher, the better), the average gross margin (the higher, the better), etc. When looking at just one indicator in isolation, everything is simple: there is an obvious “improvement” direction (e.g. the higher, the better). However, as soon as we consider multiple indicators at the same time, things get more complicated – a lot more complicated.

Indeed, all these indicators are conflicting: lowering the stock value negatively impacts the service levels, increasing the gross margin (nearly always) has a negative impact on the sales volume… Thus, the whole idea of improving one indicator at a time is bunk: this one improvement nearly always comes at the expense of a deterioration. Then, for larger companies, the problem is amplified by the corporate structure itself: the supply chain division is held accountable for any increase in stock, but it’s the contact center division that is rewarded for the improvements in customer satisfaction.

However, the problem does not stop at simply managing conflicting indicators, time is also of the essence, since market conditions are changing all the time and there is a lot of noise involved. As a result, whatever the management might be doing, there are (nearly) always some indicators that will improve from one quarter to the next. Thus, in order to avoid looking bad, it is extremely tempting to cherry pick the indicators deemed as most relevant. With the risk of sounding very technical, it’s a case of ex-post-facto rationalization: we (un)consciously tend to build some good narrative after stuff happens to explain why everything went according to plan.

Therefore, whenever a business optimization initiative is at stake, there can only be “one” indicator that consolidates all the relevant business drivers. For example, as far as inventory optimization is concerned, the pinball loss function is a first step forward towards building an indicator that properly reflects the asymmetry existing between over-forecasting and under-forecasting the future demand. While the pinball loss is far from telling everything about your inventory situation, it can already give sensible results as far as the trade-off between “stock value” vs “service levels” is concerned. Having this “master” indicator is the only way of optimizing just about anything, because as we have seen, when you get the luxury of hand-picking conflicting indicators, everything becomes blurred.

Nevertheless, it is important to clarify that while a “master” indicator is essential, there is no need to discard all the other indicators. Commerce typically tends to be complex, and in order to apprehend this complexity, it typically takes many indicators to gain all the necessary insights. However, these indicators should be used precisely for that: gaining insights, not driving operational decisions.

Coming up with one efficient master indicator is difficult. This indicator should properly balance all the different business drivers intertwined in the problem being addressed. In practice, it is frequently a composite indicator built from a combination of conflicting indicators with strategic “weighting” variables. These variables represent the best strategic understanding that management can produce about their business. Indeed, there is no “quantitative” answer to highly ambiguous questions like: do we want more growth or more margin?

A common pitfall that we frequently observe when designing master indicators is “naïve rationalism”. This refers to indicators that, while being perfectly formalized, do not capture one or more of the essential drivers of a business. As a result, improving such indicators is like accelerating while driving in the wrong direction. Naïve rationalism is dangerous because it gives a false sense of confidence to the people involved. As the saying goes, it’s better to be roughly right than precisely wrong.

Categories: Tags: insights

Document your folders with MarkDown

Published on by Joannes Vermorel.

Whenever Lokad produces a dashboard or a forecasting report, under the hood, the input data is stored as tabular files within your Lokad account. Those files are accessible through the Files tab of the top navbar.

Screenshot file listing

However, when you're account grow large, with many files and many folders, it might also become a bit messy too. Keeping the data well organized and well documented is a critical part of a good data-driven commerce optimization initiative. Thus, we have been working new features to make it easier.

All the folders of your Lokad account can now be documented with notes written in the CommonMark flavor of MarkDown. When a file named ReadMe.md is found in a folder, then its content gets displayed just above the list of files, as illustrated above.

Screenshot MarkDown editor

Then, if you click the ReadMe.md file, you get a MarkDown editor where you can see side-by-side your notes and their rendered counterpart. If you folder don't have a ReadMe.md, you can create one just by clicking the button Add ReadMe.md button that appears below the file list when your folder doesn't contain such a file yet.

Categories: Tags: bigfiles, markdown, technical, release

Forecasting 3.0 with Quantile Grids

Published on by Joannes Vermorel.

Delivering better forecasts has always been the core focus for Lokad. Today, we are unveiling the third generation of our forecasting technology based on quantile grids. In layman’s terms, quantile grids demonstrate an unprecedented level of performance which means that your company can service more clients, more reliably, and with less inventory. Unlike all the existing forecasting methods available on the market, quantile grids do not provide one demand forecast per product, but provide the entire probability distribution for (nearly) all possible futures. Quantile Grids are made possible through the combination of Machine Learning, Big Data, Cloud Computing plus some commerce-driven insights.

Quantile Grids are now available in production for all our clients, accessible through a new Quantile Grid option for any inventory forecasting project.

Forecasting 1.0: classic forecasts

When Lokad was founded back in 2008, we started with what we call now classic forecasts, our version 1.0, that is, a forecasting methodology where each product or SKU is associated with a periodic value; for example weekly forecasts of up to 13 weeks ahead. Implicitly, these forecasts are median forecasts: unbiased forecasts are expected to have 50% chances to be above or below the future demand. For the rest of the market, these forecasts are not referred to as the classic forecasts, they are the only forecasts because most of our competitors never even considered any alternatives.

However, as far commerce is concerned, no matter how accurate the classic forecasts, they work poorly in practice. Intuitively, classic forecasts are simply not looking at what really matters. The average or median demand is the easy and uninteresting case where everything goes according to plan. The tough cases however are concerned with unexpectedly high or unexpectedly low demand because they respectively create stock-outs and dead inventory. These types of extreme situations are the ones that really cost money. Classic forecasts work poorly, not because the algorithms are not good, but because they do not look at the business from the correct angle. Thus, no matter how much R&D investment a company can put into classic forecasts, it just fails. This was one of the toughest lessons for Lokad to learn in our early days.

Forecasting 2.0: quantile forecasts

In 2012, we made our first breakthrough with quantile forecasts. Despite a name that might sound downright scary, quantile forecasts are something that is much closer to what executives are doing in for their companies: they are scenarized forecasts. Instead of looking at the average case, quantile forecasts have the following objective: let’s look at the Top 5% of our most optimistic demand prospects, will we suffer from a stock-out? Then, let’s look at the Worst 5% of our most pessimistic demand prospects, will we have to deal with dead inventory? Quantile forecasts directly tackle the tough questions that actually matter from a business perspective. As engineers say, it’s better to be approximately correct than to be exactly wrong, and while quantile forecasts also suffer from all the inaccuracies associated with the classic forecasts, quantile forecasts massively outperform classic forecasts from an operational perspective whenever inventory is involved.

Yet, quantile forecasts are not the pinnacle of forecasting either. On the surface, our quantile forecasting technology was suffering from numerical oddities such as quantile crossing and quantile instabilities. However, since those oddities are quite visible, they can be efficiently mitigated. However, on a deeper level, we realized that our quantile forecasts were still not perfectly aligned with the actual business tough spots. In particular, quantile forecasts are leaving the burden of optimizing the service levels to the Supply Chain Manager. This is cheating - in a way - because a considerable part of inventory performance is actually delivered via a very precise tuning of the most profitable service levels that adequately balance inventory costs and quality of service.

Forecasting 3.0: quantile grids

In February 2015, we are now releasing our second forecasting breakthrough: quantile grids. Over the years, we came to terms with the fact that forecasts can be nothing but imperfect. Accurate forecasts are a fairytale, conveniently repeated within a market overrun by underwhelming vendors. Since we cannot predict the exact future, what about trying to assign a probability to every single possible future? That is, the probability of selling zero units, one unit, two units, etc. This is exactly what quantile grids are about: delivering not only one forecast per product, but delivering the entire probability distribution of demand for every product. Under the hood, quantile grids are a little bit like quantile forecasts, except that a demand forecast is simultaneously computed at all service levels.

Optimizing inventory or managing supply chain is all about balancing risks and opportunities: inventory levels vs service levels, purchase price vs supplier lead time, bulk purchase vs made to order, and so on. While quantile forecasts can pinpoint one or two troublesome scenarios, in the end, it is just one forecast value per product, and no matter how good this value can be, this one value cannot capture all the diversity of possible business outcomes. In contrast, quantile grids tackle the problem head-on: all outcomes are computed and associated with their respective probabilities. For every scenario, such as for the future demand of 3 units, we have bought only 2 units, it then becomes possible and straightforward to compute the net business result – like 2 units sold, and 1 unit missed. As a result, every purchase decision can be assessed by simply unrolling all the scenarios and applying the calculated probability to each scenario.

A breakthrough coming from aerospace

While Lokad primarily services retailers, we do such other industries as well, such as aerospace. One year ago, we started working for a large joint venture between AirFrance Industries and Lufthansa Technik, and realized that our quantile forecasting technology was not entirely up to the challenge. Each quantile forecast is like a single business scenario. While it is possible to combine 3, 4 or 5 different business scenarios, it takes great effort to implement the rules that glue all of these scenarios together in order to produce optimized supply decisions.

A much more elegant solution, and one which also yields much better inventory performance, consists of forecasting and evaluating all future business scenarios. No more ad-hoc scenarios that we desperately try to weld together, but a listing of (nearly) all possible scenarios (granted, it is a long listing), all treated in a simple and uniform way. This approach comes with the downside of being brutally more demanding as far computing resources are concerned. However, thanks to our favorite cloud computing platform - Microsoft Azure - computing resources have never been cheaper, and prices are still in free fall.

The results that we obtained through quantile grids for aerospace proved to be dwarfing the performance of our flagship quantile forecasting technology. It was time to bring back the rocket science (well, not rockets, jet airliners actually) to merchants, and the multiple experiments that we had performed over the last couple of months confirmed the decisive superiority of quantile grids compared to our original quantile forecasts.

Future of predictive commerce optimization

When we first released quantile forecasts three years ago, I predicted that within 10 years, quantile forecasts would be the default tool for any supply chain practitioner serious about her inventory performance. Well, it turned out that the efforts of the entire Lokad team, including my own, proved me wrong. As we have uncovered an approach superior to our initial quantile forecasts, we came to the conclusion that the long-term future of quantile forecasting is brittle. Yet, the future of the descendant of quantile forecasts is brighter than ever, as quantile grids solve the challenges that had been eluding us for years, such as the optimization of service levels, container shipments or multi-sourcing strategies.

Also, for years, inventory forecasting and pricing optimization have been treated in strict isolation, as if they were parts of two separate puzzles: the demand forecasting engine ignored what happens on the pricing side, and to make them even, the pricing engine did not care about the supply chain constraints either. However, stocks and prices are two sides of the same coin; and we now realize that any optimization attempt that blindly ignores the other side of the coin is a naive attempt at best.

Thus, while I will avoid making the same mistake and predicting that quantile grids are the long-term future of forecasting only to be proved wrong by Lokad’s team later on, I will now more safely bet that whatever predictive technology emerges from our efforts, pricing analysis will probably become unified with stock analysis along the way. We are not quite there yet, but we are making steady progress in this direction.

New methodology: purchasing prioritization

All inventory optimization systems (Lokad 2.0 included) compute reorder points. By comparing reorder points with quantities on hand and on order, these systems also compute suggested reorder quantities. Over the years, we have discovered two major limitations of this approach. First, those systems do not say anything about the target service levels, and their optimization. Second, reorder points prove to be somewhat inflexible whenever purchase constraints are involved.

Inventory optimization systems traditionally produce a static set of reorder points (one per SKU), primarily driven by their respective user-defined service levels. However, this is cheating because the burden of figuring out the "optimal" service level falls back to supply chain planner; and not only does figuring out the correct service levels proves to be a very time-consuming exercise, it is also a source of major inefficiencies if the service levels are inadequately chosen.

With quantile grids, the picture is very different: a master purchase priority list is calculated. Technically, it is a list where each SKU appears on numerous lines, each line being associated with a suggested order quantity – typically 1 unit if no supply constraints are present. The list is prioritized, and this prioritization criterion is of primary importance.

For most businesses, this prioritization answers the question: for $1 of extra inventory what is the next unit which gives the company the highest returns? This can also be formulated as the expected gross margin minus the expected inventory carrying costs. Naturally, as we go through down the list, the expected gross margin sharply decreases, because the probability of having a demand sufficiently high to absorb the stock becomes very thin. Similarly, when going down the list, the inventory carrying cost sharply increases, as each extra unit of inventory is expected to remain in the warehouse for longer. In theory, the list has no end, as it goes down to infinity. In practice however, we simply stop at a point well beyond what would constitute "reasonable" inventory levels. When a purchase is made, the goal is not to go down the list but to buy items according to their respective priorities, and to stop buying once the spending target is reached.

Consequently, this entirely removes the need to specify the service levels. Once a spending budget is defined, a company purchases their goods based on the priorities established by the master purchase priority list. Purchasing goods in this order ensures that the company’s revenues or profits are maximized, following the specified prioritization criteria.

Quantile grids are also much more versatile in their capacity to address scenarios that involve supply constraints. While quantile forecasts are indeed powerful, as soon as you have minimal order quantities, either per SKU or per supplier, and possibly some container volume capacity constraints too, the suggested quantities do not match the supply constraints. And it is then up to the supply chain planner to deal with all the adjustments, namely removing certain SKUs or increasing the units for other SKUs, in order to compose a complex order batch that fulfills all the constraints.

With quantile grids, we have a much more compelling and a much more straightforward user experience to propose. The master list makes it simple to accommodate ordering constraints. If minimal ordering quantities per SKU are present, then, the ineligible lines can be removed from the list. Similarly, if a target capacity constraint exists to accommodate container shipments, then purchase entries can be processed in following the order of the list until the target capacity is reached.

What’s next?

While quantile grids are already live and accessible to all companies who have an open Lokad account, we are still lacking documentation that outlines both the technical aspects, but also the supply chain best practices relating to this new technology. This material is coming. Stay tuned.

Categories: Tags: forecasting, release

Wanted: competitive price monitoring partner

Published on by Joannes Vermorel.

We are seeking an awesome competitive price monitoring app that would be natively integrated into Lokad. Our goal is to offer a 1-click solution to Lokad-powered merchants to allow them to obtain their competitors' prices.

If you happen to know such a solution that you would like to see implemented in Lokad, don’t hesitate to forward this post to a relevant contact. If you happen to work in such a company, well, read on.

A bit of context

Lokad specializes in helping merchants to improve their prices and their stocks, the two challenges being fairly entangled in practice. In order to do this, we leverage advanced predictive analytics, packaged in a way that make them accessible even to very small companies.

What we don’t do, however, is to retrieve prices from competitors by directly crawling the web. Thus, many of our clients sent us their competitors' price data that they obtain from other software companies. Since competitive intelligence is a basic need in commerce, Lokad is ought to provide something better than Bring Your Own Data. However, it turns out that crawling the web is a very specific challenge: our existing technology would not help one bit.

As there are dozens of price monitoring solutions out there, let’s not reinvent the wheel. We would like to integrate one of these apps, the best we can find, into our existing solution so that competitive intelligence becomes a 1-click upgrade at Lokad.

Properties of the partnership

The partner gets a super-qualified sales channel: the Lokad user base. Other data challenges have already been taken care of, and prices are ready to be consumed.

The price monitoring app is an option available to all our users; and Lokad actively promotes this option not only on our website, but directly on our own app as well.

We don't expect this service to be free. We don't plan to interfere with what you, as a partner, charge our mutual clients either. Finally, we are not asking for revenue share.

The DNA of our awesome partner

We seek an awesome price monitoring app. Naturally, it would be in SaaS mode and subscription-based, but we feel it should also have the following properties:

  • Free trial: technology is sufficiently automated to open up the possibility of free trials. For us, the absence of a free trial is a clear indication of consultingware solutions where the provider starts coding the day a client signs up for the service.
  • Focus on scale: just about any coder can hack a price scrapping bot in a week targeting a small ecommerce; however, this does not scale. Our “dream” user experience: a merchant asks for “contoso.com” and more than a year of prices is already available; then, the merchant asks for a comparison with “frabrikam.com”, and within 60 minutes, the full comparative price list is compiled and ready for download.
  • API: we are looking for 1-click integrations, well maybe a bit more than 1-click, but it has to be dead simple. Thus, Lokad needs to be able to programmatically interact with the app so that our users don’t have to deal with integration technicalities themselves. If no API exists yet, we expect our partner to provide an API when we start working together.

We are seeking a partner that thinks of their company as the (future) Google but for price search. If you are interested (or know someone who might be), drop us an email at contact@lokad.com.

Categories: Tags: pricing, partners

Salescast and Priceforge have been merged

Published on by Joannes Vermorel.

Innovation is a messy process. If we knew the final destination from the start, the path to getting there would be a lot less convoluted. Lokad is no exception. Over the last year, we constantly kept innovating, right from the beginning of the year as far as inventory forecasting is concerned, and have moved on to pricing optimization more recently. And along the way, we introduced a series of apps, Salescast and Priceforge being the most important ones.

Over the last couple of months, our apps were gradually converging, unlocking multiple synergies along the way. Today, we are proud to announce that the user interfaces of both Salescast and Priceforge have been unified into a single Projects view.

This new design reflects the fact that Salescast and Priceforge are intended to be used together, both for inventory forecasting and also for pricing optimization. Our old marketing message Salescast is for forecasting and Priceforge is for pricing had become misleading because in practice, all of our best accounts were using both apps together.

The user interface has been merged, but our website and our documentation are still lagging behind. In the coming weeks, we will revisit our website in its entirety in order to present the app as it is now available.

Categories: Tags: priceforge, salescast

Advance scheduling of your forecasting reports

Published on by Joannes Vermorel.

It was already possible to schedule the refresh of an inventory forecasting report through the usage of a WebCron, however, the actual walkthrough was somewhat convoluted. Thus, we decided to make things simpler, and starting from today, Lokad supports a built-in integration with EasyCron.com.

The Configure Project section has been expanded with a new subsection named Schedule the project runs as illustrated in the screenshot below.

In order to get started, you should start by opening an account on EasyCron.com; they have an Express Plan, free of charge, sufficient to get started. Once you are registered, clicking the link within the Configure Project page will redirect you to EasyCron.com, which all the relevant settings pre-configured for you.

Just save your job, and it's done!. Then, if you want to go further, EasyCron.com provides extensive scheduling capabilities.

This new setup is more secure. EasyCron does not get any access to your Lokad account. EasyCron is merely granted the power to start the refresh of one forecasting project, and nothing else.

Scheduled executions are restricted to one execution per day maximum for a given project; in practice, it's vastly sufficient for inventory optimization purposes.

Categories: Tags: salescast, release

Local management of inventory settings

Published on by Joannes Vermorel.

As far as data management is concerned, Lokad's philosophy is to keep data centralized in the original business app whenever this is possible. We do not want to be an ABC management software (replace ABC by commerce, warehouse, store or entreprise), because our clients already have this software in place. Yet, it is not always possible - or practical - to stick to this principle; so we need to adjust.

More specifically, in order to generate an inventory forecasting report, Lokad needs domain-specific settings such as the desired service level and the applicable lead time, which are typically not built-in within most business apps. Certain apps like Brightpearl or Linnworks already support the notion of custom properties to enrich existing data with domain-specific settings, but many other apps do not support such a feature.

So far, companies using TradeGecko, Unleashed Software or Vend could only rely on the Salescast default inventory settings, which are rather crude as they apply to all of the data if no alternative settings are provided.

Yesterday, we have released an updated version of Salescast which now offers the possibility to manage the inventory settings within your Lokad account by uploading a specific Excel sheet acting as the repository of your settings. It is now possible to manage fine-grained inventory settings for all of our supported apps.

Categories: Tags: release, salescast, inventory optimization, technical

Unleashed Software natively supported by Lokad

Published on by Joannes Vermorel.

A few weeks ago, we announced our native support for Vend, a very nice POS app coming from New Zealand. Today, we are proud to announce that Lokad also provides native support for Unleashed Software, another great piece of software, and also from New Zealand!

Unleashed Software delivers a powerful inventory SaaS service, and thanks to their great API (Application Programming Interface), it is now possible to import all the relevant data into Lokad in one single click. Below, you can see the screenshot of the Salescast default view after importing data from the Unleashed demo account.

This connector is read-only. Lokad does not, in any way, modify the data that exists in your Unleashed account. This ensures that Lokad will not disrupt the activity of an account that is already used for production.

This connector is still in its early stages, so don't hesitate to get back to us if you notice anything that could be improved. Don't hesitate to give it a try too!

Categories: Tags: unleashed, integration, salescast, partners, release

Scheduling your Salescast executions

Published on by Joannes Vermorel.

Update 2015-02-10: we have now a built-in WebCron integration which is now the approach we recommend as it is more secure.

Inventory optimization should be business as usual. Yet, Salescast, our inventory forecasting app, does not natively support scheduled executions yet. However, it is possible to obtain scheduled executions with 15min setup. In order to do that, we are going to combine the API of Salescast which offers a programmatic control on Salescast with webcron service.

A webcron is a generic name to refer to an app that behaves like an online task scheduler. If you look for webcron on your favorite search engine, you will get plently of software companies who support such a service. In this post, we will use setcronjob.com that comes with a free subscription plan (as of January 2015) vastly sufficient for our need.

Thus, in order to get daily or weekly execution of Salescast, you should start by creating an account on setcronjob.com. Once, you have your SetCronJob account, go to the Users page whithin your Lokad account, and then click on then Add user button. Creating a distinct Lokad user dedicated to the webcron is important for security purposes. Lokad will offer you two options, click Enter Username and Passwordand proceed. Then you can create a new user with:

  • SetCronJob Robot for the full name
  • setcronjob@example.com for the login. You should replace example with the actual domain name of your company. It does not matter if the email address does not actual exists.
  • a long random password. Just stick to number and letters for simplicity, but make the password long (say 20 characters long). You won't have to actually every type this password, so keeping it short and practical is irrelevant.

Click Add user, and now that you have created a dedicated Lokad user, go back to setcronjob.com and log into your account. Here click Create CronJob. In the field Url to call, enter the following URL (detailed below):

https://setcronjob%40example.com:pwd@salescast2.lokad.com/rest/basicstartrun?folder=fld

Finally pick Every day or Every week in SetCronJob to run Salescast with the desired frequency. You can also adjust the actual time of the day when Salescast will be run if you click the More options button.

Composing this URL is a bit tricky, let's have a look at the detail. The first part is setcronjob%40example.com. Notice that the @ sign of the email address has been replaced by %40. It's because characters in the URL needs to be URL-encoded. In practice, latin letters and numbers remain the same, but more advance characters like the @ are replaced by their encoded counterparts.

The second part that comes after the semicolon (:) is pwd. Replace this part with your actual password. If your password is just letters and numbers as suggested above, then the password does not need any special URL-encoding treatment, so cut-and-paste should work just fine.

Finally, the last part fld should be replaced with the output folder of your Salescast project. The output folder is displayed in your Salescast page. If your Salescast project is loading its files from the root folder, then your URL should just end with ?folder= (with nothing after the = sign).

Once you have finalized your CronJob, just run it once to make sure it's working. You should be able to see Salescast running in your Lokad account.

You're done. Congratulations! From now on, Salescast will be executed according the schedule.

Caveat: SetCronJob let you pick executing frequencies like Every minute; yet make sure not to pick a for Salescast that is shorter than 1 execution per day, as this would most likely result having your Lokad account put on hold. If this were to happen, just mail us at contact@lokad.com and we will help you restore the access to your Lokad acccount.

Categories: Tags: salescast, technical

Orchestrating Priceforge projects with Salescast

Published on by Joannes Vermorel.

One of our key goals for 2015 is to deliver a better integration of our apps, namely Salescast and Priceforge, so that it feels like using Lokad rather than using Salescast plus using Priceforge.

The built-in dashboards of Salescast were already a step in this direction, and today, we take another step. It's now possible to configure a Salescast project to execute a specific sequence of Priceforge projects.

Just go to the Priceforge runs section within the configuration view of your Salescast project to get started. We have already published more extensive documentation about this specific feature.

Through this feature, it's now possible in 1-click to have you data refreshed (imported from a third-party app), your forecasts refreshed and all your dashboards refreshed as well.

Categories: Tags: salescast, priceforge

Vend natively supported by Lokad

Published on by Joannes Vermorel.

This list of apps natively supported by Lokad is growing, and today, we are proud to announce that our native support (beta) for Vend is live starting from today.

Vend is a very nice POS software, very affordable too, and, and we have been impressed by the overal level of polish for all the parts of the app (technical documentation included!).

Managing a couple of outlets via Vend? Now, in just a few clicks, you can connect your Lokad account to your Vend account, and get inventory forecasting reports, pricing optimization and overall commerce intelligence through Lokad. This add-on supports both Salescast and Priceforge.

This add-on is strictly read-only, so your Vend data will not be modified in any way by Lokad. We merely import your orders and your stock movements into Lokad. Thus, even if our logic happens not to cover 100% of the Vend situations, it won't have any impact on your daily usage of Vend.

For Vend merchants, Lokad will remain completely free for the duration of the Vend beta; and this beta will last as long as it takes to ensure a really smooth user experience. Just give it a try.

Categories: Tags: vend, salescast, priceforge, integration

New pricing based on business turnover

Published on by Joannes Vermorel.

Our last major pricing evolution took place almost 2.5 years ago, and since that time, Lokad has been making steady and constant progress in developing its business. As a result, our old pricing had simply become out of sync compared to what Lokad has become; and an extensive revision was long due.

Originally, Lokad only had a single app Salescast. Then, we introduced BigFiles - a file hosting service, followed by Sync - our data integration service and finally, we released Priceforge, a full-fledged data processing engine. As the number of apps served by Lokad gradually increased, we introduced new subscription plans for these apps; however, in the process, Lokad's pricing became rather complex.

Moreover, in the last few months, we have been working hard to bring all of these apps together. Today, thanks to Sync, your business data is directly copied as flat files into BigFiles and then loaded by Salescast to generate inventory forecasting reports, and also commerce intelligence dashboards composed with Priceforge. While these interactions might seem quite complex, a single button click can now trigger a full refresh that brings together all these moving parts within Lokad.

Flat monthly fees based on turnover

Our new pricing follows a short list of guiding principles:

  • All features are available for all plans. We listened to our user community and realized that disabling certain features, like the access to Lokad's API, was a pain for many small companies. It is not because a company is small that it is not seeking a very high level of automation. We want all our clients to be benefit from all of Lokad's technology.
  • Flat monthly fees. A metered, consumption-based pricing model is appealing on paper because it captures the exact service usage. However, metered pricing also means that the client is charged a different amount every month, which may turn out to be quite complicated for some of our customers. Moreover, it may often give the wrong incentives to our users such as reducing the frequency of forecasts in order to reduce their Lokad bill - all at the expense of degraded forecasts. Lokad now charges flat monthly fees, with a discount for annual prepayments.
  • Thresholds based on turnover. Our new subscription plans are diffentiated based on the maximal turnover of the client company. For example, our new Basic plan at $150 per month is available for any company with up to $1.5M of turnover. As the exact turnover calculation may vary from one company to the next, we have decided to trust our clients and to primarily rely on a declarative process.
  • The Express Plan remains free. For any company with up to $450,000 of turnover, our Express Plan remains free and does not expire. Moreover, as indicated above, the Express Plan now gives you access to all of the features. Lokad remains committed to delivering a free service to all emerging companies.

Impact for current clients

Current clients will be granted access to all Lokad features, no matter what they were already entitled to under their initial plan. No client will lose access to any particular feature because of the upgrade in our pricing terms.

Once a contract has been signed between Lokad and the client, Lokad will naturally keep honoring the terms of this contract. Clients can also request an amendment in their existing contract in order to reflect Lokad's new pricing terms.

When no contract had been signed, as it is usually the case with the Express Plan, then, your company may or may not remain eligible for our Express Plan depending on its size.

Rest assured that Lokad will not cut off the service for any client before taking the time to engage in a discussion with someone from your company, which will take place over the coming months. Here, our primary goal will be to be fair with the expectations of our long time users.

As usual, our Lokad team is here to address your questions and concerns, don't hesitate to drop us a mail at contact@lokad.com if you seek more details about our new pricing.

Categories: Tags: pricing, service status, salescast, priceforge

Built-in dashboards for Salescast

Published on by Joannes Vermorel.

For years, Salescast has been delivering the best demand forecasts we could compute, but from the user experience angle, Salescast was plain, very plain. For every product or SKU, you would get the reorder point and the reorder quantity; and that was it.

Over the last couple of months, we have been steadily developing new ways to have our apps working better together, and today, we are happy to announce that Salescast now delivers built-in dashboards. For third-party apps that we natively integrate like Brightpearl, Linnworks and TradeGecko, those dashboards have been tailored to take advantage of the exact scope of data that Lokad is capable to import.

Under the hood, those dashboards are writtin in Envision, our data visualization & data processing script and executed by Priceforge. Through those templates, you can get a sense of what Envision is capable of. Those dashboards are fully customizable: it's possible to add tiles or resize them, to create new tables or new linecharts.

Those dashboards are not just for data visualization however; it's possible to use Envision to generate complex tables to be re-imported into other apps. For example, it's possible to implement an advance reordering strategy on top of the results delivered by Salescast. In this scenario, the reorder quantities proposed by Salescast could be refined in order to take into account complex price breaks offered by suppliers.

The scenarios supported by Envision that can be made as complex as they need to be to really capture the specific complexity of your business. However, you don't need to be a seasoned software developer to get started as we have designed Envision to be accessibe to anyone with decent Excel skills.

Want a specific analysis to be performed for your business? The Lokad staff can take care of that, just contact us.

Categories: Tags: salescast, release, priceforge

Auto-refresh your data from Salescast

Published on by Joannes Vermorel.

The user interface of Salescast had barely changed since the last major upgrade we shipped two years ago. However, under the hood, Salescast had been undergoing steady changes to improve reliability and performance.

This summer, we released native support for Brightpearl, Linnworks and TradeGecko. However, those new capabilities of Lokad were not integrated into Salescast, and, as a result, generating a new forecast report required 4 steps:

  1. Go to Sync in Lokad, and trigger a refresh.
  2. Wait until the data refresh is completed.
  3. Go to Salescast in Lokad, and trigger a run.
  4. Wait until the forecast reported is generated.

Obviously, the steps 1 and 2 were less than desirable. Thus, we opted for a more drastic revision of the Salescast user interface. The webapp has now a Project creation wizard that let you directly bind a data source with your Salescast project.

Once the data source is bound to the project, any Salescast run will start by automatically refreshing the data source. This entirely removes the two convoluted steps 1 and 2 as detailed above.

If you have been using Salescast already and if you wish to benefit from this new feature, you need to delete your existing Salescast project - look for the Delete button below the settings in the project view - and then to re-create a project. If you have already configured a data source in the Sync tab, then Salescast will offer you the possibility to use this data source directly, leveraging the existing configuration.

We have another major evolution for the user interface of Salescast in the development pipeline. Stay tuned.

Categories: Tags: salescast, release

Job: Quantitative Business Analyst

Published on by Joannes Vermorel.

Once again the Lokad team needs to expand. This time we are seeking a quantitative business analyst.

Job description

Your goal will be to drive commerce companies - our clients - to improve their performance when tackling a variety of quantitative challenges such as inventory forecasting or pricing optimization. In order to achieve this goal, you will benefit from the technologies that Lokad has developed, and you will also benefit from a direct mentoring from the Lokad founding team. You will be reporting to the COO of the company.

Your contributions will be varied:

  • deciphering ins and outs of businesses and assist the clients in extracting the data actually relevant to the resolution of their challenge.
  • communicating a vision of how to best address the business goals considering the technologies available and through a realistic use of the data.
  • exploring the data of the client and assessing both potential data problems and potential data usages aligned with the clients’ business goals.
  • implementing some quantitative optimization logic, along with the corresponding workflows to consume the results produced by Lokad.

The quality of your contributions will have a significant impact on the business value generated by Lokad for the client.

Most of our clients operate either in North America or Europe. You will primarily communicate with them by email and phone. Once in a while, a large client may require an actual meeting to take place, but this is rather the exception than the norm. From the client perspective, Lokad will train you to become the Lokad expert who manages their account.

This position is in our office in Paris (13th arrondissement). This job is not eligible for remote work. Salary depends on the experience and subject to negotiation. We’d prefer at least 1 or 2 years of experience.

Desired Skills

Excellent communication skills, both oral and written, and both in English and in French, are necessary. Most businesses are satisfied with abysmal writing, producing documents so boring and confusing that the documents are not even worth the time it takes to read them. You will be expected to be able to produce sharp, technical and well-written reports.

We do not expect you to have any prior knowledge on commerce optimization. However, you will be dealing with a lot of data. If you happen to be a wizard at Excel calculations, this will strongly play in your favor. Also, while programming skills are not required, even modest skills in this area would already be a big plus.

We do not expect you to have much prior knowledge on statistics, especially about the modern statistics flavor favored by Lokad, however, we expect you to have a sharp analytical mind, and to be “good with numbers” in general. “Fixing” a broken quantitative optimization process frequently boils down to pinpointing the one incorrect calculation step among a dozen steps or more.

To apply just drop a mail to contact@lokad.com with your resume.

Categories: Tags: job

Inventory forecasting for Aerospace

Published on by Joannes Vermorel.

While the core focus of Lokad’s activity has been on commerce since the very beginning, over the years, we have also delivered forecasts and optimized stock levels for a variety of other verticals. Some verticals prove to be more challenging than others as far forecasting is concerned, and the aerospace industry with its low rotations, its highly expensive parts and its costly stock-out incidents - i.e. grounded aircrafts waiting for a missing part - is certainly one of the most challenging verticals in terms of forecasting. In particular, classic inventory forecasting models tend to work very poorly for aerospace, primarily because the underlying assumptions behind these classic models (normal distributions, Poisson distributions, weekly or monthly forecasts) completely misfit the actual statistical patterns observed in aerospace.

Over the last 6 months, we have re-engineered a brand new forecasting engine purely dedicated to aerospace. At its core, this forecasting engine also leverages quantile forecasts, because this type of forecasting is about the only class of statistical models that actually works for aerospace. However, unlike our initial forecasting engine targeted at commerce, this variant natively integrates the logistics associated with high-cost repairable parts where components are first changed and then repaired. In particular, the TAT (turn-around times) are also modeled through quantile forecasts. In addition, among other industry-specific factors, fleet composition over time, including known future evolutions, is also natively integrated into the forecasting engine.

Considering the complex structure of the aerospace market, Lokad does not offer a packaged inventory forecasting solution readily accessible online as we do for commerce. However, if you are interested in forecasting for aerospace, don’t hesitate to drop us an email anytime at contact@lokad.com.

Categories: Tags: aerospace