Export Product Cost From Your Shopify Store With EZ Exporter

Shopify recently added a new field called "Cost per item" in the Shopify Admin's product variant page. This is something that we definitely know Shopify merchants have been asking for and they previously had to resort to using Metafields to get this information into their Shopify store.

We're happy to announce that this field can also now be exported using EZ Exporter!

The product cost field can be included both in the Product export and Order export:

  • Product export: under the field labeled variants.inventory_item.cost
  • Order export: under the field labeled line_items.variant.inventory_item.cost

The cost field is also available in the Custom Filters, so you can run reports to include only products that cost a certain amount, for example.

EZ Exporter - Filter Shopify Product Cost

You can also use this new Cost field in the Calculated Fields, so you can enter formulas that factor in the product cost directly in our app. For example, to calculate the margin, you can use the following formula:

(1 - ({{ variants.inventory_item.cost }} / {{ variants.price }})) * 100 if {{ variants.inventory_item.cost }} and {{ variants.price }} else ""

EZ Exporter - Calculated Fields - Margin

In fact, to make things easier for our users, we've even added a built-in template that will generate a CSV report containing the product and variant name, available inventory quantity, cost, price, and margin.

EZ Exporter - Popular Templates

We figured that this is a report many of our customers would want to generate. There are probably many other use cases out there and if you need any assistance coming up with a formula or generating a report involving this new field, please don't hesitate to reach out to us.

Happy selling!

Tags: shopify, ez exporter, metafields, ecommerce, cogs