Top-Selling Products

With eCommix, you can seamlessly export your Shopify sales data to Google Sheets, enabling you to generate comprehensive reports that break down sales by product, variant, and vendor.

Export Results

The exported results include detailed breakdowns of sales by product, variant, and vendor, giving you a granular view of your store's performance. This data allows you to track which products and variants are performing best, identify top vendors, and uncover trends that can inform your inventory and marketing strategies.


Order Filters

If necessary, you have the option to restrict the number of returned items by applying filters to the export. The following fields are available for this purpose:

  • Status (Order) - Mandatory: any, open, closed, cancelled.

  • Created At (Order): Date and time when the order was created in Shopify.

  • Updated At (Order): The date and time when the order was modified last.

  • Processed At (Order): The date and time when the order was processed.

  • Fulfillment Status (Order): any, unfulfilled, shipped, partial, unshipped,

  • Financial Status (Order): any, authorized, pending, paid, partially_paid, refunded, voided, partially_refunded, unpaid.


Order Metafields

Metafields can be utilized to tailor the functionality and look of your Shopify store by enabling you to store specific information that is not typically recorded in the Shopify admin. These metafields can serve for internal tracking or to showcase specialized details on your online store in various formats.

To export metafields for orders, simply input the metafield namespace and key values:

You can get these values from the Order metafield definitions page in your Shopify Admin:

For the given example, you would need to input these namespaces and keys, along with a descriptive header name to locate it in the sheet:

Last updated