Completed work
Bulk promotional price updates
A new promotion should not mean editing every product. Apply the known changes and separate the records that need another look.
The problem behind the job
If a promotion affects a lot of products, the goal is to change the intended prices quickly without turning a temporary offer into a permanent catalogue mess.
What I was working with
A supplier promotion required a batch of product prices to be updated. The work also exposed changed or new product identifiers, so the job was not simply replacing one column of numbers. Those product-identity differences needed to stay visible.
Keep the promotion tied to the correct items
The important relationship was between the supplier's current product reference and the website record. A product range can change between price sheets, even when much of the wording looks familiar.
That is why manufacturer price matching sits behind a useful bulk update.
Apply the supported changes
I updated the promotional prices across the matched range and flagged the changed or new identifiers.
The result was a completed price update with the uncertain items separated from the ordinary changes.
Do not combine separate milestones
The same project discussion also referred to a stock-checking process as a next step. That did not make the price update a completed live-stock integration.
Price, stock and product-range changes may use related data, but they still need separate acceptance checks.
Have a range of prices that needs updating?
If your problem looks similar, send me the current setup and the outcome you need. The implementation may be different, but the same kind of thinking usually applies.
What I'd check next time
For another promotion, I'd confirm the effective dates, the intended price field, the matching rules and how the promotion ends. A change preview should show which records will be altered and which will be left alone.
The price-update checklist explains the wider checks.
Useful beyond a single campaign
Once the identifiers and field rules are clear, later updates are easier to scope. The benefit is a more controlled process, not a promise that pricing never needs review again.
This work sits within product data and imports.
HAVE SOMETHING AWKWARD?
Have a range of prices that needs updating?
Send me the URL, what is happening, what you have already tried and what a useful result would look like. A small anonymised sample is enough to start - do not send passwords, credentials or sensitive customer data.
