Applying Profit Margin Percentage to Items in Bulk

Topic summary

Bulkly updating product costs based on a desired margin/percentage. The requester has correct prices set and wants to set each item’s cost as a percentage of its price (e.g., $30 price → $18 cost; $40 price → $24 cost) across a category without editing one by one.

Proposed solution: Use Ablestar’s Bulk Product Editor app to edit ‘cost’ and ‘price’ fields in bulk via in-app or spreadsheet edits.

  • Cost field options: set as percent of price or compare-at price, decrease/increase by percent, set fixed value, set lowest price from last X days, change by percentage.
  • Price field options: set as percent of cost or compare-at price, decrease/increase by percent, set fixed value, set lowest price from last X days, change by percentage.

Resources provided: Video walkthroughs for in-app and spreadsheet edits, a free starter version (edit 10 products at a time), and support contact email.

Notes: “Compare at price” is Shopify’s field for the original/regular price used for crossed-out pricing. No confirmation yet from the requester; resolution status appears open.

Summarized with AI on December 27. AI used: gpt-5.

I am wanting to use bulk editor, or something equivalent to easily apply a profit margin to each product in that category. We need to update our item costs for each item, and doing them all one by one is taking too long.

We have the correct price listed on the item, but we need to apply the correct cost, which is simply just a percentage.

For instance, we have several products that we need to apply a 60% profit margin to, the price is already listed, we just want to select all of the products that should be 60% and have shopify auto add the correct cost (if it’s $30 item, update cost to $18; if it’s $40 item, update cost to $24). Currently updating every cost one at a time and it’s taking forever!

Hello!

My name is Alison, I’m the Customer Success Specialist for Ablestar. I just wanted to reach out and let you know our Bulk Product Editor app is capable of editing both the ‘price’ and the ‘cost’ field in bulk with either an in-app edit, or a spreadsheet edit.

When editing the ‘cost’ field with an in-app edit, you have the option to:

  • set as percent of ‘price’ field
  • set as percent of ‘compare at price’ field
  • decrease by percent
  • increase by percent
  • set to a fixed value
  • set to lowest price from last X days
  • change by percentage

When editing the ‘price’ field with an in-app edit, you have the option to:

  • set as percent of ‘cost’ field
  • set as percent of ‘compare at price’ field
  • decrease by percent
  • increase by percent
  • set to a fixed value
  • set to lowest price from last X days
  • change by percentage

We have some videos that help explain the process for in-app edits here, and the process for spreadsheet edits here. The app also currently has a free starter version available that allows you to edit 10 products at a time so you can try it our without incurring any costs.

If you have any questions or need help you can reach out to us directly at support@ablestar.com, we would be happy to help.

Best,

Alison