OOLP

Keeping a book catalog in sync with WooCommerce, with zero external dependencies

For Libreria OOLP I worked on both the website and a very concrete problem: the book catalog is managed as an Excel file, but it needs to stay in sync with the WooCommerce online store without anyone having to manually update hundreds of product listings every time a new list arrives.

So I built OOLP Product Importer, a WordPress plugin that reads XLSX files directly (with a custom-built reader, no external libraries to maintain) and syncs the catalog automatically: it inserts new titles, marks removed ones out of stock, and sets each listing’s publish date to match the book’s own release date — so the online store always reflects the real assortment, with no repetitive manual work.