Changing one price in a spreadsheet is easy. Changing three hundred prices while keeping variants, compare prices and categories consistent is where catalogs break. A missed row sells at the old price. A pasted formula overwrites a description. A find-and-replace on "199" silently changes a product name that contained the same number. CSV Pilot applies bulk price changes described in plain language, with the math done exactly in code and every result shown before export. This guide covers the requests that work, how the calculations stay exact, and how to review a price change safely.
The requests that work
Type what you want in the chat, the way you would describe it to a colleague. These patterns cover most real price work:
- "Make all products 15% cheaper."
- "Increase prices by 10% for the Pizza category only."
- "Set every product under ₹100 to ₹99."
- "Add a compare price of ₹599 to every product priced above ₹500."
- "Set the cost price of all Beverages to 40% of the selling price."
The agent finds the matching products, computes the new values and shows the result in the preview before anything is exported. You can combine conditions — category, price range, tags, status — in one sentence.
Why the math is exact
Percentage changes are where hand-editing fails. Three failure modes show up repeatedly in spreadsheet edits:
- Rounding drift. 15% off ₹499 is ₹424.15. Hand-calculated values get rounded to ₹424 or ₹425, and the drift compounds across a catalog.
- Wrong scope. A find-and-replace on "199" hits descriptions and SKUs that contain the same digits.
- Variant confusion. Changing a base price by hand often forgets that variant deltas sit on top of it.
CSV Pilot separates concerns: the AI decides which products and which field to change; the engine computes the value. A 15% discount on ₹499 becomes ₹424.15, always. The model never does arithmetic.
How variant prices behave
Bulk edits respect the delta pricing model. When you change a product's base price:
- The base price changes by the exact amount or percentage you asked.
- Variant deltas stay the same, so Small/Medium/Large differences are preserved.
If you ask to change variant prices specifically — "make all Large sizes ₹50 extra" — only the matching variant records change, and the preview shows each affected variant.
Review before you export
The preview is the safety net. A disciplined review takes two minutes:
- Check the changed rows — the grid shows every affected product with its new value.
- Look at validation — errors and warnings update live. A compare price below a selling price, for example, is flagged.
- Fix outliers in place — click any cell and adjust. The export matches the preview exactly.
- Export once — the downloaded file is what you reviewed.
A safe workflow for price changes
Keep the original CSV until the new one is verified. Upload the original, describe the change, review the preview, export the updated file, and import it into Hyperzod as the replacement. If the import looks wrong, your original file is untouched and you can redo the change with different wording.
For recurring changes — monthly cost updates, seasonal discounts — the same sentence pattern works every time. The workflow does not grow with the catalog: 50 products and 5,000 products use the identical process.
Bulk price changes are the most common catalog task, and also the most damaging when done wrong. One sentence in CSV Pilot replaces an hour of spreadsheet formulas — with the math guaranteed and the review built in.