The Scenario
Your firm is raising prices 10% across the board — effective next month. All 45 services are in Lexoffice as article records. Someone has already done the math: the new prices are calculated in a sheet alongside the Lexoffice article IDs and version numbers. All that's left is applying the updates. But Lexoffice requires a version number in every update request, and applying 45 changes through the UI means opening each article, editing the price, saving, and confirming — one at a time.
The bad version:
- Open Lexoffice, navigate to Products and Services, find the first article by name, click Edit, change the net price, save — repeat 45 times
- Get an error on article 23 because the version number in your sheet is out of date — someone edited that article last week and the version incremented — meaning you have to re-fetch the current version for that record before saving
- Finish the updates, send a message to the team saying prices are live, and get a reply 20 minutes later saying one article still shows the old price because you missed it
A 10% price increase should take ten minutes. Instead it takes the afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the article IDs, new prices, and version numbers from the sheet and applies each update to Lexoffice in sequence — with version handling built in.
Open the price revision sheet and type:
Update each Lexoffice article in column A to the new net price in column B using the version number in column C
What You Get
- All 45 Lexoffice article prices updated to the new values in the sheet
- A confirmation written back into column D for each row that succeeded — plus an error note for any article where the version number was stale so you know exactly which ones need a re-fetch
- The full update applied in the time it takes to write one sentence, not an afternoon
What If the Data Is Not Quite Ready
Only some articles are getting a price change
For all rows where Price Change in column D is "yes", update the Lexoffice article ID in column A with the new net price in column E using the version number in column C
You don't have version numbers in the sheet and need to fetch them first
For each article ID in column A, fetch the current version number from Lexoffice and write it into column C, then update the net price to the value in column B
Some prices in the sheet are gross and need to be converted to net before updating
For each row in this sheet, calculate the net price from the gross amount in column B using the VAT rate in column D, then update the Lexoffice article in column A to the calculated net price using the version number in column C
Full price revision pass: fetch versions, calculate net prices, update, and log in one shot
For all rows where Price Change in column D is "yes": fetch the current version number from Lexoffice for the article ID in column A and write it into column E, calculate the net price from the gross in column B using VAT rate in column F, then update the Lexoffice article to the calculated net price — write the update confirmation into column G and flag any failures in column H
One prompt handles the version fetch, price calculation, and update together.
Try It
Get the 7-day free trial of SheetXAI and open your price revision sheet — ask it to apply all the Lexoffice article updates and your catalog will reflect the new pricing before anyone asks twice. You can also look at how to bulk-create service articles from scratch, or return to the full Lexoffice integration overview.