Check out Microsoft Azure Essentials Azure Web Apps for Developers Azure Marketplace Example
Look at example from the Microsoft Azure Essentials Azure Web Apps for Developers
Examples from the FREE Microsoft Azure Essentials Azure Web Apps for Developers Kindle Edition contain a operation to NEW-> Manage -> Resource Group-> Add item Azure Marketplace ->Web +SQL. Which pulls in a template which uses the retired pricing WEB Tier. Further this CANNOT be manually change, because its a template.
So we have a Azure Learning aid in the Azure Marketplace broken and its the most heavily advertise, easy to use?. Now Azure Billing cant fix this, but its generating some support calls!
You need to fix "Web + SQL" template so its contains current pricing plans or at least allows you to change the pricing to B - Basic or other pricing structure's. When the resource "SQL" is added manually it works, and no retired plans exist!!.