Client Overview
by Mayur Patel
Our client, the leading seller and marketer of refurbished electronics in the Netherlands and across Europe, provides various services, including Asset Recovery, HP Renew, Parts Selling, and Returned Goods. Passionate about ERP systems, they always seek automated and robust solutions. We've been working with them for many years and are currently building a large, automated, and robust system to support their growing business.
The Requirement
The client required an automated SKU generation system for both Product Templates (parent products) and Product Variants (child products). To streamline operations and maintain consistency, they requested that SKUs be generated in a fixed sequence and remain uneditable, ensuring every product follows a standardised SKU format.
Numla’s Solution
After analysing the client’s business process, management practices, and goals, we proposed a custom workflow for SKU generation. Here’s how we implemented the solution:
Automatic SKU for Product Templates
An SKU is generated at the Product Template level based on a dynamic sequence pattern. This setup allows the SKU structure to adjust to any pre-defined pattern while maintaining consistency across products.
Automatic SKU for Product Variants
For Product Variants, Odoo’s default Internal Reference field is utilised. Each variant SKU combines the Product Template’s SKU, followed by a hyphen and a unique sequential integer (e.g., SKU-1, SKU-2, SKU-3). When adding or removing product variants, the next available number is assigned to the variant, ensuring that existing SKUs remain unchanged.
Impact: Efficiency and Consistency
The SKU generation solution was successfully deployed in the client’s live environment. This automation is aimed at significantly reducing manual input and errors, enhancing efficiency in inventory and sales management. The client is pleased with the solution, as it has met their expectations.
Want to customise Odoo for your business?
We can tailor Odoo to meet your specific needs.