RIP Daily Email Attachment

We regret that we have had to remove the daily email attachment.

During the data security risk assessment, which we are required to conduct to comply with the new EU Data Protection Regulations, we evaluated the delivery of the spreadsheet via email as too much of a security risk.

Because email is not a secure delivery method, there is a possibility that the spreadsheet could become infected with a virus in transit, after it has left the SL servers and before it reaches your computer.

We are sorry for the inconvenience.

PPC Revamp: Request for Assistance

We have been neglecting our PPC functionality and we have fallen behind our competitors. Additionally, with 1.8 Billion (with a capital B) search terms in our database, performance on the search terms performance/keyword performance widgets is not great.

So, we have vowed to take action and get back in the saddle again.

We will start by restructuring the PPC database and assigning it to a dedicated server, rather than sharing the main servers. We aim to have this done by the end of this month and it should be relatively transparent to you.

The next bit is where we’d like to enrol your assistance: We’d like to work with you if you are an expert in PPC and are willing to share your ideas as to how to improve or transform our current PPC functionality. This will include implementing AMS functionality and automating the bidding and keyword management process. As we now have a budding AI specialist in our development team, we will investigate opportunities to use these new technologies.

If you wish to help, you should be

– Very well versed in PPC management
– Not a white labeller of ours (or, if you are, accept that if we develop according to your specifications, this will be available to all SL users and not exclusive to your white label account)
– Able to participate in regular conference calls to discuss/review design, specification and user interface
– Able to devote time to beta test the developments.

We aim to start sometime in early March and anticipate this will be 6 to 8 weeks of work.

Please let us know whether you’d want to participate.

Subscribe And Save Google Sheets Prototype

If you do Subscribe and Save, it is quite tedious to determine whether the scheme is profitable and whether it does generate repeat sales from a presumed ‘captive audience’ of buyers.

We have no immediate intention of providing S&S functionality in SL, there doesn’t seem to be that much demand for it. But just in case this would change, we have built a prototype to see what S&S KPI’s could be extracted from the data we already hold.

So here is an allegedly working Google sheet that operates off a filtered SL Orders download.

Please make sure you COPY THE SHEET FIRST and follow the instructions in the README FIRST tab.

The sheet shows you a monthly breakdown of S&S sales by ASIN, providing Units, Orders, Revenue, Profit, number of cancellations, cancellation rate per month and overall cancellation rate, as well as +/- monthly units variance.

It also shows per ASIN which customers have ordered regularly every month and provides a view of the reordering pattern by month by customer.

You can find the sheet here:

https://docs.google.com/…/19rPJg63005o_YnQzGZ3e2gSDa8…/edit…

Coming Soon (Still Expected This Month)

– Sales Heatmap (really nice )
– Monthly Storage Fees (really useful)
– Disposal Orders (if that is your cup of tea …)

And sometime later

– Inbound Shipments (that will allow us to start improving the inventory features)

Dashboard-of-Dashboards

For those of you with multiple accounts and/or marketplaces, we have deployed today an aggregate dashboard feature.

This shows the all the dashboard coloured tiles for each marketplace on one single page.

You can get to it by clicking on the link ‘Aggregate Dashboard’ to the right of the ‘Welcome To SellerLegend’ title on the main dashboard.

With this deployment, we have now run out of ways of skirting the issue. So our next step with dashboards will have to be the eagerly awaited aggregate dashboard with currency conversion. But that won’t happen until the end of 2Q18 at the earliest.