Pennys website data

Workbook in.
Clean JSON out.

Upload the mixed and inert pricing workbook. Both sheets are standardised and combined into the exact object shape used by the website.

Publishing instructions

Update the Pennys pricing matrix

Follow every step in order so the website uses the newly generated prices.

01
Upload the XLSX workbook
Choose the latest workbook above and check that both Mixed and Inert sheets are listed after conversion.
02
Set the new object name
Use csv_YYYYMMDD, replacing YYYYMMDD with today’s date, for example csv_20260728.
03
Copy all the JavaScript
Use “Copy JavaScript” and copy the complete output, including the opening variable declaration and closing semicolon.
04
Open the Pennys theme files
Log in to Pennys, open the theme file editor and edit the main JavaScript file, currently /js/rmp-new.js.
05
Replace the existing pricing object
Find the complete csv_YYYYMMDD object and replace the whole object with the JavaScript copied from this tool.
06
Update the transformer variable
Directly beneath the object, update the variable passed to transformPricingMatrix() so it matches the new object name exactly.
07
Save and purge the cache
Save rmp-new.js, then purge the Pennys website cache so the updated pricing is served immediately.