How to Edit the Cost Field

You can use Ablestar Bulk Product Editor to modify cost fields in bulk. The cost field will allow you to track the cost of goods sold.

Choose if you prefer the 'In-App Edit' or 'Spreadsheet' method:

1. In-App Edits

How to Edit Options

From the 'Configure modifications' view, there are several 'How to edit' options available to bulk edit your cost, either by percentages, fixed amounts or based on other fields:

Go more in depth with specific 'How to Edit' Number Field options.

Rounding Options

The 'Rounding' dropdown gives you several ways to round your cost. Read more detail on the specific rounding options.

2. Spreadsheet Edits

For this spreadsheet edit we are working with variants, so you will need to variant-level identifier such as Variant ID or SKU in the first column and the action items in the 2nd and subsequent columns, similar to:

• An identifier column (SKU or Variant ID)
• An action column that contains the text to be modified

The app will use the following rules to update a price from a given cell in a spreadsheet:

• Text around the numbers, like currency names or symbols, are removed
• The comma is treated as a thousands separator
• The period is interpreted as the decimal separator
• Spreadsheet values are case-insensitive
• Leading/trailing spaces will be removed during processing

Click the related article to see more advanced spreadsheet detail.

Get in touch and chat with us below if you need assistance extracting the correct number for a price.

✅ Tips and Troubleshooting

• Cost fields are optional and only visible to the store admin
• Cost is a variant field and requires a variant-level identifier for spreadsheet edits
• Spreadsheets treat the comma as a thousands separator and a period as the decimal separator

(04.269)