Skip to main content
Answer

Remove Price Breaks on on the Sales Price Worksheet

  • March 4, 2025
  • 4 replies
  • 72 views

In our system, we utilize sales price breaks (1, 10, 14, 28, 42), we are getting rid of an old price break (56). How can we get rid of that price break when updating pricing using the sales price worksheet or another method? Prefer not manually as we have 3,000 SKUs to update for pricing.

Thank you.

Best answer by meganfriesen37

You should be able to put an end/expiration date on all those lines so that they stop being utilized.  You may have to do this on the Sales Prices form via an import scenario to do a mass updated, since it’s the largest qty.

4 replies

meganfriesen37
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Answer
  • March 10, 2025

You should be able to put an end/expiration date on all those lines so that they stop being utilized.  You may have to do this on the Sales Prices form via an import scenario to do a mass updated, since it’s the largest qty.


  • Author
  • Freshman I
  • March 10, 2025

@meganfriesen37 Thank you! I tested the expiration date, and it worked.


Forum|alt.badge.img+1
  • Semi-Pro I
  • March 10, 2025

You should be able to put an end/expiration date on all those lines so that they stop being utilized.  You may have to do this on the Sales Prices form via an import scenario to do a mass updated, since it’s the largest qty.

Do you have an example of doing this with an import scenario?  We’ve been struggling expiring old pricing records; every attempt we make at an import scenario winds up attempting to create new records (and immediately expire them).  Sales Prices is a tough screen to do an import scenario on because there’s no unique key in the listing.


meganfriesen37
Captain II
Forum|alt.badge.img+12

@lairdtim I haven’t used an import scenario to update prices before.  The system does seem to have a key record in the background, but no way to select that in the import scenario.