Skip to Content
Menu
This question has been flagged
1 Reply
7641 Views

Many of our manufacturers will have multiple part numbers for the same part. 

With our current system, we use the part number as the SKU. 

Since we have multiple SKUs for the same part, managing pricing and attributes between these SKUs can be too time consuming and there is much room for error if we update one SKU, but not another for the same part.


Avatar
Discard
Best Answer

The MASTER SKU concept originates in Inventory/Warehouse Management Systems where, for either procurement or sales reasons, a single product is referenced with more than one SKU.  It is essentially an alias for a product. 

In Odoo, you would store you Company SKU in the Internal Reference field of the Product, and the Master SKU in the Product Code field of the Vendor Pricelist associated to the Product.  

The Internal Reference field should not be the UPC of the Product.  Both a UPC and SKU are numeric-based codes assigned to products, but UPC's and are created outside your Company and can change if the Manufacturer of the product changes, if a new Manufacturer ends up making the product moving forward, or if the original Manufacturer is sold to another Manufacturer. With a Company SKU (Internal Reference) you can always maintain a unique and unchanging code to identify a product no matter who manufactures it and/or who sells it to you.

Back to Master / Alternate SKU's:

Procurement:  A product may have more than one SKU when purchased from a Vendor (your situation)

Sales: A product may have more than one SKU when sold.  An “Ebay” SKU, an “Amazon” SKU, etc. These are often known as "listing" SKU's, "seller" SKU's, or "marketplace" SKU's. 

Both can be supported with minor customization:

Procurement:

The Supplier Pricelist can be extended to support the MASTER / ALTERNATE SKU concept:



​​






This POC took just about 3 hours. Your Odoo Consultant or an Odoo Partner can help meet your specific needs within a similar timeframe.  A module was needed to override the name_get of the Vendor Pricelist to show the Alternate SKU, but everything else was done via Odoo Studio. 

Possible additional needs are (1) merging of existing SKU's that are already in Odoo as products; and (2) allowing users to select an alternate on a Purchase Order (instead of just seeing the alternate and transposing the new part into the DESCRIPTION field).


Avatar
Discard
Related Posts Replies Views Activity
1
Apr 22
8063
2
Oct 21
7023
1
Jul 21
18893
6
Aug 20
4309
1
May 20
4258