Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.
Got a question? We're here to help! Reach out at [email protected], and we'll get back
to you promptly.
Bulk update Shopify product cost per item
Efficiently tracking the cost per item for products is crucial for managing your Shopify inventory and profitability. Mixtable makes this process simple by allowing you to add a Cost Per Item column to your Products - Complete (with Variants) worksheet.
Add a Cost Per Item column to a Products - Complete (with Variants) worksheet
- If you haven’t already, make sure to add a Products - Complete (with Variants) worksheet to your Mixtable workbook
- Find an empty column in the worksheet and right-click on the column header (which contains the column letter).
- Click on the Shopify Sync Settings option in the context menu that appears after right-clicking the column header
- In the window that opens, select Core Field as the field type. Next, choose Cost from the dropdown menu to map the column to the cost per item field
- Click the Save button to confirm and apply the new column mapping
- You’ll notice that the new column begins to populate with the existing cost per item values for the product variants
- Make any changes you need to the relevant cost per item cells, and start a sync to send the data to Shopify.
