How to Run Sales by Editing Prices and Compare-at Prices

In addition to showing a product's price, Shopify lets you display a compare-at price which shows the original, higher, price of a product.

Ablestar Bulk Product Editor allows you to edit sales and compare-at prices in bulk.

How Sales Work on Shopify

Every Shopify variant has two pricing fields: 'Price' and 'Compare-at price'.

If the product is on sale, you might want to display the original and new prices by specifying the product's original price in the 'Compare-at Price' field and the sale price in the 'Price' field. Now your product pages will now show the sale price similar to:

This view, where the Compare-at price has a line through it, is only activated if the Compare-at price is higher than the Price. If the Compare-at price is not higher than the Price, the product will show as being priced normally.


Creating a Sale with Our App

In order to create a sale using Ablestar Bulk Product editor, you need to do two things:

  1. Set the 'Compare-at price' field to the value of the current 'Price' field
  2. Change the 'Price' field to reflect the discount

You can do both of these at once using two methods. Choose if you prefer the 'In-App Edit' or 'Spreadsheet' method:

1. In-App Edits

The advantage using this method is you can set rounding rules on prices.

Once you have a set of filtered products, from the 'Configure modifications' view, specify the following fields:

  • Field to edit: "Price"
  • How to edit: "Decrease by percent" or "Change by fixed amount" if you want to change all prices by a constant amount. Read about other number options in this article.
  • Number or Amount field: specify the price change amount
  • (Optional) Rounding: specify how you would like to round prices
  • Modifications to compare-at price: "Set the compare-at price to the current price" option. This will make the current price show as the compare-at price so your theme displays it.
  • (Optional) + Add modification: choose other fields to edit (ie. tags) if needed

Confirm the preview at the bottom of the page with the specified changes and click the Run edit button to start processing.

Learn how to quickly Undo Bulk edits, view your complete Edit History or Schedule edits to run at midnight while you are sleeping.

2. Spreadsheet Edits

We will prep our variant-level spreadsheet with at least three columns.

The first column will require the SKU or Variant ID and the other two columns specify the 'Price' and 'Compare-at price' fields:

From the Spreadsheet menu, click to upload and map your spreadsheet. Follow this article if your are uploading for the first time.

✅ Tips and Troubleshooting

  • With an In-App Edit you can also configure rounding rules without needing a spreadsheet.
  • You can Undo Bulk edits easily and quickly if you feel you made an error.
  • If the Compare-at price is not higher than the Price, the product will show as being priced normally.

(07.30)

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us