by Usama Ahmad | Oct 20, 2017 | New Features
Over the past 18 months, we have had many support tickets questioning the accuracy of our revenue numbers, as they are not matching Amazon’s.
While we have an excellent knowledge base article about the subject, many of you were left incredulous, but were willing to give us the benefit of the doubt. Thank you for your trust.
Many others cancelled their subscription before the end of the trial, giving us the reason that they did not trust our numbers.
With the advent of the P&L report, we are now able to vividly demonstrate why our revenue numbers are (were) not matching SellerCentral’s dashboard numbers.
Below is a screenprint of a medium-sized account P&L Statement. Notice the large uplift in revenue when looking at the P&L over two and a half years of trading.
While we have demonstrable justification, many people will not care to ask why the difference and will just decide to cancel their subscription anyway during their trial. So, we have decided to do something about this.
To be continued ….
by Usama Ahmad | Oct 18, 2017 | New Features
Deployed earlier today, under the menu Sales->Profit And Loss Report.
This is a report based on your settlement periods (Amazon Payments). It, therefore, reports on SETTLED orders.
You can now see settlement amounts across settlement periods. Indeed, you can view any time period and show the results by Day, Week, Month, Quarter, Year, and by settlement period within the time period.
I took the opportunity to take a screen print with our new default skin (not yet publicly available), however, if you preferred the old skin, it will still be available and you can choose your preferred colours.
The Knowledgebase article is being written as we speak, but this screen is quite self-explanatory.
by Usama Ahmad | Oct 8, 2017 | News & Events
Amazon introduced about a year ago a new recurring burden onto sellers using automated systems accessing the MWS API (SL is one of those systems).
It used to be that when you signed-up to an API service provider (like SL), you would grant authority to the provider just once and you were good forever and ever.
Amazon now requires sellers to renew the authorization once a year.
If your SL account has stopped updating, it is very likely because your authorization has expired. In which instance you should see the below message in the My Accounts widget of the Dashboard.
If so, please go to your SellerCentral account and re-authorize SL. Once done, SellerLegend will resume updating and will catch up any data it had missed.
|
The detailed procedure is available in the knowledgebase article here.
by Usama Ahmad | Aug 26, 2017 | Roadmap
We were sent us a support ticket today asking:
“Is there a way to filter for repeat customers by specific ASIN?”
And we had to reluctantly respond that we do not have such facility.
This is not the first time such a question was asked and every time I bend my head in shame. Important as this function is, I have been resisting distracting Yasir and his team to develop it, as they are currently working on a very important piece of functionality which we have been yearning for, for ages.
So, as a stopgap measure, I have developed a Google sheet which provides the facility.
Don’t get me wrong, we will eventually add this functionality natively into SL, but for the moment, this will help those of you who want to create FaceBook custom and lookalike audiences from your customer data or use the info for marketing purposes.
In conjunction with the existing SL filters, this Google sheet will allow you to find customers with repeat orders for several use cases:
– By specific ASIN or by a list of specific ASINs
– By specific date range
– Excluding customers who have refunded
– By City, State or ZIP code
– Customers who participated in a specific promotion ID
– Or by any combination of the above
Please make a copy of the following Google sheet onto your own Google Drive and follow the instructions on the “Read Me First” tab of the sheet.
https://docs.google.com/…/1O1-kx4faMvLPLgvSySyFyQO4Sy…/edit…
by Usama Ahmad | Aug 17, 2017 | New Features
The sales statistics screen can now show the following combination of product sales data, over a user-selectable period of time:
– Sales By SKU
– Sales By ASIN
– Sales By Parent ASIN
– Sales By Product Group
– Sales By Brand
Moreover, for each of the above entities (SKU, ASIN, Parent ASIN, Product Group and Brand), you can show aggregate results by:
– Individual day during the selected period
– Individual week during the selected period
– Individual month during the selected period
– Individual quarter during the selected period
– Individual semester during the selected period, and
– Individual year during the selected period.
The screen now sports:
– A Period Selector
==> (Today, Yesterday, Last 7 Days, Last 30 Days, Last 90 Day, This Month, Last Month, Last 3 Months, Last Year, Year To Date, One Year, Custom)
– A Scope Selector
==> (By SKU, By ASIN, By Parent ASIN, By Brand, By Product Group)
– An Interval Selector
==> (By Day, By Week, By Month, By Quarter, By Semester, By Year)
– A button to view the results via a Chart View
As already advised earlier, the By Interval screen now shows red/green table rows to indicate a downtrend or uptrend.
Please note that as a consequence of this update, the Product Statistics screen will be retired in 30 days time, as all its functions can now be provided through this new Sales Statistics screen
