How can I add a column to my Shopify order export showing the order status?
The Shopify Order API doesn't have a field for the order's current status, but what we can do instead is look at the closed_at and cancelled_…
The Shopify Order API doesn't have a field for the order's current status, but what we can do instead is look at the closed_at and cancelled_…
Shopify doesn't have a "Sale Price" field in the backend. It instead uses a field called "Compare At Price" which basically m…
You might want to pad your data with zeros to make sure it's of a certain length. This could come in handy when sorting string data or for …
EZ Exporter has a direct Google Sheets integration where you can push new orders directly to an existing Google Sheets spreadsheet. 1. Create…
You can use the formula below in the Calculated Fields to automatically include the country dial code (e.g. +44) to the shipping address' phone n…
Note: Google Merchant Center also supports reading from an existing Google Sheets spreadsheet. Since EZ Exporter also has a direct Google Sheet…
You can use the formula below in the Calculated Fields section of the Data Settings to calculate the number of days from when an order…
You can use the formula below in the Calculated Fields section of the Data Settings to calculate the number of days from when an order…
In EZ Exporter, it's possible to subtract 2 dates and get the number of days between them using Calculated Fields.For example, you might want a custo…
The shipping discount applied to the order is stored in the discount_applications field, which is an array of discounts. You can use this formula …
By default, EZ Exporter will put each line item in the order in a separate row in the CSV export, duplicating the data at the order level like this: …
To create a shared link in Dropbox: 1. Log in to your Dropbox account and select the file you'd like to share. 2. Click the Share button. …
1. Log in to Google Drive and locate the file you'd like to share. 2. Right click on the file and choose Get link. 3. Choose Anyon…
Click the "Share" button on the right. Set the sharing settings. Also check out our guide here for creating "direct down…
EZ Exporter has a starter template for a ShopperTrak POS Transaction File you can use to help you get started with this. It's already confi…