Shopify released the new feature where you can set the “Cost Per Item” value for your product Variants.
You can export and import this field using Matrixify now.
Export
To export, you have the separate checkbox to include it – because it takes additional time to get this data for each product, so export it only when you need it.
Update Cost by SKU
When importing, there is a column “Variant Cost” for Product variants.
So to update just the cost by SKU, import just the table with the following two columns:
- Variant SKU
- Variant Cost
Update Cost for Products with Variants
If you don’t have SKUs to identify product variants across your store, you can import an update table to identify the product, and then identify which variant you need to update.
In that case, you can import the columns:
- ID
- Handle
- Variant ID
- Variant Cost
Update Cost by Handle
If you don’t have variants for products, then you can update just simply by columns:
- ID
- Handle
- Variant Cost
Or if you don’t know your product ID, then just those columns also will work (given that you don’t have variants):
- Handle
- Variant Cost
The most important thing to understand is that you need to identify the Product (by ID or by Handle), and then you need to identify the Variant inside that Product (by Variant ID, or Variant SKU, or Options, or Barcode).
Where to go from here?
- Read the full documentation of Products sheet.
- Go to the Matrixify app and start bulk updating your cost.
