EZ Exporter Report Templates
Below is a list of currently available report templates for exporting different types of Shopify data to help get you started very quickly with EZ Exporter.
These templates can be modified for further customization.
| All Collections |
| All Products and Variants Includes fields such as the product URL, variant URL, image URLs, product ID, variant ID, description with HTML tags removed, SKU, barcode, cost per item, and more. |
| ApparelMagic - Order Export (Last 7 Days) Visit website |
| Cancelled Orders |
| Cash on Delivery (COD) Orders (Last 30 Days) |
| Completed Draft Orders |
| Customer Addresses |
| Customer Lifetime Value |
| Customer Metafields Export all available metafields for each customer in a single column. To export only specific metafields in separate columns, edit the Data Settings and specify the "key" in the Metafields section. Please note that if you have a lot of customers, the export process could be very slow as pulling metafields data requires an additional API call per customer. |
| Customers Grouped by Country |
| Customers Grouped by Province/State |
| Customers Subscribed to Email Marketing |
| Customers Subscribed to SMS Marketing |
| Customers With an Active Account |
| Customers With Over 10 Orders |
| Customers With Total Spent Over 1000 |
| Customily - Open Orders (Last 30 Days) Starter template that already includes common Customily fields such as the image URLs. You can customize it further and add additional fields or adjust the filters. |
| EZ Inventory by Highview Apps (All Products) Sync the inventory quantity of this store with another Shopify store using our EZ Inventory app. |
| Facebook Product Data Feed This is a starter template for generating a Facebook Product Feed for Dynamic Ads & Commerce. Most required fields are already set. You'll probably need to modify this to add/edit fields specific to your store/industry/country. Also see Facebook's Data Feed Specifications. |
| Google Shopping Order History (Last 30 Days) Starter template for the Google Shopping Order History. You'll need to edit the Data Settings and enter your merchant id and product language in the Custom Fields section. You may also need to adjust the mappings for some fields depending on how you store data in your Shopify store. |
| Google Shopping Product Feed This is a starter template for generating a Google Shopping Feed. Most required fields are already set. You'll probably need to modify this to add/edit fields specific to your store/industry/country. Also see Google's Product Data Specification. |
| Grailed - Published Products Starter template for Grailed. Edit the Data Settings to map additional fields specific to your store such as the condition, exact_size, and shipping prices (if you use Metafields, you can specify them in the Data Settings as well). |
| High Risk Orders (Last 7 Days) |
| Infinite Options by ShopPad - Open Orders (Last 30 Days) The export will include all Line Item Properties (custom options) created by Infinite Options in one column. To place each line item property in a separate column, you can follow our guide here. |
| Inventory Report |
| Inventory Report (Multiple Locations) Export the available quantity by location in one column. To split them up into separate columns, please see our guide. |
| Inventory Summary at Product Level Shows number of variants for each product, total quantity across variants, min/max variant price, and more. |
| Invoice Sent Draft Orders |
| Items Fulfilled Today (Detailed) Detailed view of items fulfilled today, showing the order date, order number, item name, quantity, etc. Assumes an order is fulfilled within 30 days, adjust Filters > Created to a longer date range if it will take longer than this to fulfill an order. |
| Items Fulfilled Today (Summary) Data grouped by item, displaying total quantity fulfilled for each item. Assumes an order is fulfilled within 30 days, adjust Filters > Created to a longer date range if it will take longer than this to fulfill an order. |
| Line Items for Local Delivery (Last 7 Days) |
| Line Items for Local Pickup (Last 7 Days) |
| Line Items with Fulfillment On Hold (Last 14 Days) |
| MyRegistry - Published Products Product template for MyRegistry. |
| OnBuy - All Products Inventory template for OnBuy. |
| Open Draft Orders |
| Order Fulfillment Cycle Times (Last 30 Days) Display the number of days between the order date, fulfillment date, and delivery date for orders created in the last 30 days. Note that the date of when the package was delivered may not be available for all shipping carriers. |
| Order Pick List with Images for Google Sheets Open the generated file with Google Sheets to display the images and print the report. See our blog post for more details. If you're using our Google Sheets integration to push the data directly to Google Sheets, change the file format in the Export Profile settings to CSV. |
| Orders Containing Gift Card (Last 30 Days) |
| Orders Excluding Removed/Refunded Line Items (Last 30 Days) Fully refunded or removed line items due to an order edit are excluded in this template. This template also includes columns showing the original line item quantity and the current quantity. The original total price and current total price are included as well. |
| Orders Grouped by Referring Site (Last 30 Days) |
| Orders Grouped by Shipping Country (Year to Date) |
| Orders Grouped by Shipping Province/State (Year to Date) |
| Orders Grouped by Source (Last 30 Days) |
| Orders Paid with Gift Card (Last 7 Days) |
| Orders Paid with Klarna (Last 7 Days) |
| Orders Paid with PayPal (Last 7 Days) |
| Orders Placed From an Android Device (Last 30 Days) |
| Orders Placed From an iPhone Device (Last 30 Days) |
| Order Summary in Customer's Currency (Last 30 Days) |
| Order Summary (Last 30 Days) |
| Orders with Overdue Payments |
| Order Tracking Numbers (Last 30 Days) |
| Out of Stock Items |
| Partially Fulfilled Orders |
| Partially Refunded Orders |
| Pinterest Product Data Feed This is a starter template for generating a Pinterest Product Feed. Most required fields are already set. You may need to modify this to add/edit fields specific to your store/industry/country. Also see Pinterest's Data Feed Specifications. |
| POS Orders (Last 30 Days) |
| Product Cost, Price and Margin |
| Product Metafields Export all available metafields for each product in a single column. To export only specific metafields in separate columns, edit the Data Settings and specify the "key" in the Metafields section. Please note that if you have a lot of products, the export process could be very slow as pulling metafields data requires an additional API call per product. |
| Product Personalizer by Zepto Apps - Open Orders (Last 30 Days) The export will include all Line Item Properties (custom options) created by Product Personalizer in one column. To place each line item property in a separate column, you can follow our guide here. |
| Products Not Part of Any Collection Please note that this export could take a long time to run due to additional API calls required to pull the collection data. |
| Product Summary by Product Type |
| Product Summary by Vendor |
| Products with Customs Information Contains information such as the Country Code of Origin and Harmonized System Code. |
| Product URL QR Codes for Google Sheets Includes a formula for Google Sheets to auto-generate QR codes for the product URL. See our blog post for more details. If you're using our Google Sheets integration to push the data directly to Google Sheets, change the file format in the Export Profile settings to CSV. |
| Product URLs by Collection Includes a column of a comma-separated list of product URLs for each collection that each product belongs to. Please note that if you have a lot of products, the export can be very slow as pulling the collection data will require at least 2 additional API calls per product (since Shopify has 2 different types of collections which have separate API endpoints). If you'd like to split up the URLs into separate rows, please click here for a guide on how to quickly do this in Google Sheets. |
| Published Collections |
| Published Products and Variants |
| Quantity Sold by SKU (Last Month) |
| Refunded Items (Last 30 Days) |
| Refunded Orders |
| Refunded or Partially Refunded Orders |
| Refund Transactions Breakdown Export a breakdown of all successful refund transactions for each order, showing the date and amount of each transaction. |
| Remco - Unfulfilled Orders Visit website |
| RIF Logistics - Open Orders (Since Last Run) Visit website |
| Sales by Billing Country (Last 90 Days) |
| Sales by Billing State/Province (Last 90 days) |
| Sales by Customer and Product Variant (Year to Date) |
| Sales by Customer (Year to Date) |
| Sales by Day (Last 30 Days) |
| Sales by Gift Card (Year to Date) |
| Sales by Month (Year to Date) |
| Sales by Payment Terms (Last 90 Days) |
| Sales by Product Variant (Last 30 Days) |
| Sales by Shipping Country (Last 90 Days) |
| Sales by Shipping State/Province (Last 90 days) |
| Sales by SKU (Last 30 Days) |
| Sales by Week (Year to Date) |
| Shopify Default Format (All Customers) |
| Shopify Default Format (Similar But Not Exact, All Products and Variants) Some columns from the Shopify default such as the "Standardized Product Type" and Google Shopping columns are not available in this template. |
| Shopify Default Format (Similar But Not Exact, Last 7 Days Orders) Report format similar to Shopify's default order CSV export. There are some columns our app can't export such as the "Employee" column. Certain columns such as the "Payment Method" may also be in a slightly different format. Click here for more info about the fields included in this report. |
| Shopify Default Format With Repeated Order-Level Data (Last 7 Days Orders) Report format similar to Shopify's default order CSV export, but with order-level data repeated for each line item row (such as the shipping info). Note that there are some columns our app can't export such as the "Employee" column. Certain columns such as the "Payment Method" may also be in a slightly different format. Click here for more info about the fields included in this report. |
| ShopperTrak POS Transaction File This is a starter template to generate a ShopperTrak POS Transaction File. You may need to modify this depending on your store's specific requirements. |
| Smart Warehousing - Unfulfilled or Partially Fulfilled Orders Starter template for Smart Warehousing. You'll need to edit the Data Settings to specify the values for the "Bill Transportation To" and "Order Type" fields and possibly make additional adustments specific to your store. |
| Snapchat Product Catalog This is a starter template for generating a Snapchat Product Catalog. Most required fields are already set. You'll probably need to modify this to add/edit fields specific to your store/industry/country. Also see Snapchat's Product Catalog Field List. |
| Store Pickup + Delivery by Zapiet - Open Orders (Last 30 Days) The export will include Cart Attributes created by the app. Visit app page. |
| Total Biz Fulfillment - Unfulfilled Orders (Since Last Run) Visit website |
| Total Biz Fulfillment - Wholesale - Unfulfilled Orders (Since Last Run) Visit website |
| Tradesy - Inventory Feed Starter template for Tradesy. Edit the Data Settings to make adjustments specific to your store. Click here to learn more about their feed requirements. |
| Unfulfilled Orders |
| Unfulfilled or Partially Fulfilled Orders |
| Unfulfilled or Partially Fulfilled Orders by SKU Group the orders by the Lineitem SKU and export a comma-separated list of order names for each SKU. |
| Unpublished Collections |
| UTM Parameters (Last 30 Days) Export the referral code and individual UTM parameters from the order's landing page URL into separate columns for quicker analysis. Please note that our app won't be able to pull additional UTM data from the Conversion Details/Session Details as shown in the Shopify Admin. |
| Variant Inventory Quantity by Product Type |
| Variant Inventory Quantity by Vendor |
| Variant Metafields Export all available metafields for each variant in a single column. To export only specific metafields in separate columns, edit the Data Settings and specify the "key" in the Metafields section. Please note that if you have a lot of variants, the export process could be very slow as pulling metafields data requires an additional API call per variant. |
| Variant URL QR Codes for Google Sheets Includes a formula for Google Sheets to auto-generate QR codes for the variant URL. See our blog post for more details. |
| Vestiaire Collective - Published Products Starter template for Vestiaire Collective. Edit the Data Settings to map additional fields specific to your store such as the size, material, color, and condition. |
| Weekly Sales by Discount Code (Year to Date) |
| Xero Sales Invoice Starter template for a Xero sales invoice with most required fields already mapped. You'll need to edit the Data Settings to enter data specific to your store such as the account code, tax type, and branding theme. |
| ZIP Fulfillment - Unfulfilled Orders (Since Last Run) Visit website |
Related Articles:
App: EZ Exporter