Rounding out the end of summer with another monthly update, today we're here to talk about our latest feature - adding metafield data to Report Toaster!
For merchants who use metafield data in their storefront, this is a great addition to be able to include as a column or field in our reports.
Better yet, you can even combine the metafields with filters & calculated fields to generate some very specific custom reports for your store.
Let's dive in!
For those of you who have been using Metafields in Shopify for some time now, feel free to skip to the next section.
Otherwise, here's a quick primer :)
The short version is that metafields are a way to store additional specialized information (e.g. on products, variants, customers, orders etc.) that isn't typically captured by the Shopify admin.
Merchants can use metafields:
1.) On the front-end storefront, to provide extra details to the customers (e.g. suppose I sell cookies and want to display the ingredients) and
2.) On the back-end in the Shopify admin, for internal tracking purposes (e.g. suppose I want to track certain product dimensions or part numbers for shipping purposes).
For more information on Metafields, check out Shopify's basic guide here
and their developer resource here
This information can be almost anything, so metafields are very powerful and can be customized to suit the needs of any particular business.
Here's an example of product metafields from our demo store:
Here you can see we have several metafields stored for this product on the back-end that would make it easier for our inventory and fulfillment staff to manage this product.
In this case, these attributes include things like the specific dimensions (for packing), the direction (which coast it's shipped from) and whether it is classified as a digital good or not.
Think of metafields as 'extra information about X' (be it a product, customer, order, etc.) and you won't be far wrong!
So where does Report Toaster come into this?
Well, just like any other field in Shopify, Report Toaster can now capture this stored metafield data and include it in a report via our Calculated Fields
Let's take a look at this in practice.
Here we can see a report we created for a customer that includes metafield data in the highlighted column:
Basically, they had their storefront setup to track the codes associated with each product, as well as for their shipping, refunds, and credits/payments.
By pulling this metafield data together into a report, this helps their internal teams record sales revenue and upload the results to their 3rd party accounting system for ease of use.
As well as tracking metafield data on overall sales reports, this can also be utilized on an order-by-order basis.
For instance, one of our other customers had information stored on every order that could track the Payment Date, Estimated # of Days to Deliver, and the Date of Delivery:
This information is crucial to manage their inventory and fulfillment. With this report, they can easily see the pertinent delivery information and then use that to prioritize fulfillment accordingly.
Of course, simply adding raw metafield data to a report is really just the foundation. Let's look at how you can use this to further customize a report...
Like any other field in Report Toaster, once you've included metafields on a report, you can utilize both filters and calculated fields to further segment your data.
Using the examples above, we could easily imagine a variety of useful situations where it's important to narrow down a report based on certain metafields.
For example, show me orders where the estimated days of delivery is less than 3. These might be utilizing a premium shipping option and thus need to be handled as a priority at the warehouse.
The use cases here are limited only by your imagination. Here are just a few other suggestions:
- Listing ingredients in certain products and then preparing a pick list for a food provider. That way, they know exactly how many of each ingredient they need when preparing the orders.
- Storing premium subscription tier information on certain customers. This lets you segment them differently for marketing purposes.
- Associating similar products on your site. This means that users purchasing one product can be recommended others that are deemed relevant to what they're looking at.
- Filtering fabrics by size, material, thread count, allergens, and so on.
You get the idea.
Setting This Up
Including metafield data in Report Toaster is easy. All you need to do is:
- Have metafields set up in your Shopify admin.
- Have a paid copy of Report Toaster.
- Contact us via firstname.lastname@example.org to let us know which metafields you want to include on which reports and
- We'll take care of it :)
Nice and simple. In fact, as you can see, we've already implemented metafield data in a number of our merchants' reports already! So if you need help setting this up for your storefront, feel free to let us know!
Until next time!