The Scenario
Price revision time. Every service in the Lexoffice catalog is going up 10% starting next month. Someone on the team has already done the math: all 45 article IDs are in an Excel workbook alongside the new net prices and the version numbers pulled from Lexoffice last week. The only step left is applying 45 updates. In the Lexoffice UI that means opening each article, clicking Edit, changing the price, saving, and confirming — 45 times. At two minutes each, that's an hour and a half before the new prices are live.
The bad version:
- Open Lexoffice, find the first article by name, click Edit, enter the new price, save — repeat for all 45 articles
- Hit article 31 and get a version conflict error because someone edited that article last week and the version number in the workbook is stale — stop to re-fetch it manually before continuing
- Finish, announce that prices are live, and get a message 30 minutes later from someone on the billing team saying article 17 still shows the old price because it was in a different worksheet tab you didn't see
A catalog-wide price revision should not take an afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the article IDs, new prices, and version numbers from the workbook and applies each update to Lexoffice in sequence.
Open the price revision workbook 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 from the workbook
- A confirmation written into column D for each row that succeeded
- Error notes for any article where the version number was stale — so you know exactly which ones to re-fetch before re-running
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 in column A with the new net price in column E using the version number in column C
Version numbers are missing and need to be fetched 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
Prices in the workbook are gross and Lexoffice requires net
For each row, calculate the net price from the gross 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 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, update the Lexoffice article to the calculated net price — write the confirmation into column G and flag any failures in column H
One prompt fetches versions, calculates net prices, and applies all 45 updates.
Try It
Get the 7-day free trial of SheetXAI and open the price revision workbook — ask it to apply the Lexoffice article updates and the new pricing will be live across the full catalog before the next invoice run. You can also look at how to bulk-create service articles from scratch, or return to the full Lexoffice integration overview.