Hacker News new | past | comments | ask | show | jobs | submit login

You could create a new table that keeps track of the logistics of the product. If the product is sent to supplier, a new row appears in this table with the date. If it hasn't been sent yet, no row is present.



Handles the cases where an order had to be resent to the supplier better as well.


And when a supplier returns a shipment, and when new things happen that you haven’t thought of so a new column isn’t needed.




Consider applying for YC's Summer 2025 batch! Applications are open till May 13

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: