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

EZ Exporter Update: Multi-Currency / International Pricing Now Supported When Exporting Shopify Product Data

Shopify has recently added international pricing (multi-currency) support to the Product API and we've added support for it in EZ Exporter as well.

The International Pricing feature allows merchants to set different prices based on the the customer's payment currency.  This setting can be enabled via the Shopify Admin > Settings > Payments > Shopify Payments. 

From this page, you can control the exchange rate and additional price adjustments by country/currency.  For example, you can set a rule so prices in CAD will …

Read more

Update Your Shopify Orders Fulfillment Details From Amazon S3

Amazon S3 is an extremely popular object storage service provided by Amazon.   We love Amazon S3 at Highview Apps and use it to securely store all kinds of files (we use encryption both in transit and at rest) for our apps and business.  It's something we rely on heavily and know many of you do as well.

Over the last few months we've been talking to customers and thinking about how we can better support them.  Automatically updating your fulfillment data is …

Read more

How To Move Your Brick-and-Mortar Store Online

While many business operations begin an online store from scratch — as in they have no physical store presence — we’re going to look at some strategies to help already existing stores create an online presence and achieve a Shopify migration when they currently only connect with people at a brick-and-mortar location. We’ll offer you some tried and true strategies about why you need an online store, how to get up and running, pitfalls to watch out for, and how …

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