How to Create a Basic Pivot Table in Google Sheets

Google Sheets has a "Pivot table" option which allows you to create summary reports from your existing data.

In this tutorial, we'll show you how to create a basic pivot table from a list of individual order data.

The pivot table will group the data by the "Created At" column and will display the following:

  1. Number of orders per day.
  2. Total quantity of all line items ordered per day.
  3. Average order value per day.

Step 1: Select the range of data to summarize. …

Read more

How to Generate QR Codes in Google Sheets

A QR code (short for Quick Response code) is a two-dimensional barcode that allows you store a lot more data compared to standard UPC barcodes.

You can easily scan it with your smartphone's camera and because almost everyone now has a smartphone, it's becoming more and more popular.

Because QR codes can store more data, this also allows for many more use cases.  They're especially very helpful as a shortcut for entering long texts where it's easy to make …

Read more

Google Sheets Tip: Compare Two Columns and Extract Missing Values

You may run into a situation where you  need to compare two spreadsheets and figure out which values exist in one but not the other.

For example, if you run an ecommerce store where your supplier provides you a spreadsheet of their inventory that's constantly changing, you may need to figure out which new products exist in the data feed that you currently don't have published in your store.

One way to figure this out is to export the current product data …

Read more

Google Sheets Tip: Generate JSON Data from Rows and Columns

You may encounter a scenario where you need to convert data from your Google Sheets spreadsheet to JSON format.  You may need this to use as input to another app or system.

For example, our EZ Exporter app supports a function that takes a raw JSON string that can be used for looking up values (like a lookup table).

JSON data can have complex nested structure but a typical format you'll see is an array that looks like this:

["Alice", "Bob", "Eve", …
Read more

Shopify Tip: How to Retrieve Product Images in Different Sizes Via the Image URL

Did you know that you can specify the image dimensions of your Shopify product images via its URL?  This could come in handy for generating product feeds that require specific image dimensions.

For example, you may need to generate a product feed that requires a field for the image thumbnail URL.  Instead of re-uploading the thumbnail version of the images, you can actually just add a width and height parameter directly in the original full image URL.

To demonstrate this, …

Read more