We would like to offer a way to let customers and internal users choose between standard and promo-priced versions of the same item, where the promo price applies only to specific lot numbers (e.g., near-expiry stock).
Our products are lot-numbered assembly items with a parent/child structure, and the child SKUs are what we add to Sales Orders.Key requirements:
- Track inventory correctly at the lot level
- Apply promo pricing only when a specific lot is selected
- Allow simple selection on NetSuite Sales Orders then our website (e-commerce frontend) will show same as Netsuite sales order
Has anyone implemented a clean approach for:
- Selling the same lot-numbered item at different prices
- Letting users select “promo lot” vs “standard lot”
- Still maintaining proper lot tracking and costing in NetSuite?
Thanks.