Technical partner for web systems and infrastructure.
6 Mitropolit Serafim Slivenski Str.
Sofia, Bulgaria
Scan for contacts
An internal system with Google Sheets and Apps Script for more convenient management of products, variations, attributes, sizes and prices for the WooCommerce catalog of Palisandar Ltd.
201
products as of 1 October 20265800+
active product variationsThis project is a natural continuation of the WooCommerce platform for Palisandar Ltd.. After structuring the large product catalog, it became clear that standard management through the WooCommerce administration was not convenient enough for the scale and specifics of the catalog. An internal working system was needed to support the preparation and management of product data without every change requiring manual editing of individual variations.
Managing single products is relatively straightforward. At Palisandar, however, some products have many variations by size, thickness, length, quality, processing, packaging and other characteristics. The additional complexity comes from the fact that one characteristic can be a variation in one product, but only an attribute in another. This makes manual work slow, risky and difficult to check when working with large amounts of data.
We used Google Sheets as a more accessible and convenient working environment for both the client and the administrator. The table format allows easier review of large data sets, faster value checks and clearer work with product combinations. Instead of searching for every change inside an individual product or variation, the information can be reviewed and prepared centrally.
Apps Script was used to add logic around the work with data. The goal was not just to have a spreadsheet, but a system that supports the process - with formulas, checkboxes, automatic filling of selected fields and a more structured preparation of variations, attributes, sizes and prices. This moves part of the repetitive work away from manual editing and makes the process more consistent.
One of the important parts of the system is the ability to activate specific product combinations more easily through checkbox logic. This is useful for products with many potential variants, where only some combinations need to be prepared or published. This gives the administrator clearer control over which combinations are needed, without working chaotically across thousands of rows.
The system is aligned with the WooCommerce structure of the main website. It helps the data be prepared more logically - with attributes, variations, prices, sizes and other product parameters that can later be used in the catalog. This reduces the risk of duplication, incorrect specifications and inconsistent naming.
We built a Google Sheets and Apps Script system for Palisandar Ltd. that makes the management of over 200 products and over 5800 active product variations more structured through a clear product matrix, checkbox logic, automated fields and better data preparation before work in WooCommerce.
These are the people who worked on this project and the role each of them had in the delivery.
Our client feedback reflects the way we work — with clarity, responsibility, and a strong focus on real business results. For us, a successful project is not just a website that looks good, but a reliable and effective solution that improves processes, saves time, and helps businesses grow with confidence.
Изключителни професионалисти! С тях е удоволствие да се работи. Изпълниха ми всички изисквания по проектите и ще продължавам да работя с тях.
Explore other projects in the same category and see how we help businesses achieve their digital goals.
Google Ads project for a product catalog with a focus on Search campaigns, more precise queries, negative keywords and better budget distribution.
SEO development for a WooCommerce product catalog with technical structure, product categories, content and tracking through Google Search Console.
