Getting Started

User Guide

Set the cost per item for your Shopify products, individually or in bulk

You can set the cost per item for your Shopify products via Mixtable, doing so for an individual product or in bulk. In Shopify the cost per item lives with the Variant object, not the Product object (similar to price, inventory, etc.). How you set up the column to edit the cost per item in Mixtable depends on whether you want to update the cost for the first variant of a product (i.e., you don't use variants so we are updating the default variant for a product), or whether you want to view/edit the cost for multiple variants of a product.

Case 1 - You want to add a Cost Per Item column to a worksheet storing your variants

This is for stores that make use of variants in Shopify. Here are the steps to get cost information into your worksheets.

  1. Add a Product Variants worksheet if you haven't already
  2. Find a column that is currently empty, and right-click on the header of the column (the header contains the column's letter)
  3. Click on the Shopify Sync Settings option
  4. In the window that opens, select the Core Field field type, and then Cost from the dropdown menu. Click the Save button to save the new column mapping.
  5. You'll see the new column start populating almost immediately with any existing cost per item values for the variants.

Case 2 - You want to add a Cost Per Item column to a worksheet storing your products

In the case where your store does not make use of variants, you can map the cost column directly onto a worksheet holding your Shopify products. Even if it appears that your products do not have variants, Shopify always creates at least one variant for a product under the hood. So, in effect, here we are mapping the cost of this single, default variant.

  1. Add a Products worksheet if you haven't already
  2. Find a column that is currently empty, and right-click on the header of the column (the header contains the column's letter)
  3. Click on the Shopify Sync Settings option
  4. In the window that opens, select the Core Field field type, and then First Variant - Cost from the dropdown menu. Click the Save button to save the new column mapping.
  5. You'll see the new column start populating almost immediately with any existing cost per item values for the first variant of every product.
© 2020 Intelaria Corporation