Problem: When importing a new eCAD electrical package that includes an Excel spreadsheet, Upchain automatically deletes and replaces all BOM items under that package, which results in two issues. First, if the package BOM has an older version of an item and the spreadsheet is reuploaded, Upchain will delete the item and re-import it, automatically upgrading it to the latest version. This causes unintended version changes, even if you don’t want the item to be updated. The second issue is that if an item is marked as REF ONLY in Upchain or if project-specific metadata is modified outside the spreadsheet, those changes don’t carry over. Upchain essentially grabs a new, "blank" copy of the item, ignoring any customizations made to that package’s BOM. Fix: Instead of Upchain deleting all items and replacing them with the same ones, Upchain should process each item in the spreadsheet individually. It should first check if the item already exists in the BOM under the electrical package. If the item is found, Upchain should keep it and compare any differences (e.g., QTY, Notes, Item Type, etc.) between the BOM version and the version in the Excel spreadsheet. The item should only be updated to the latest version if the version change is in the spreadsheet. If an item is found in the BOM but not in the spreadsheet, Upchain should remove it from the BOM. Conversely, if an item appears in the spreadsheet but not in the BOM, Upchain should add the newest version of that item to the BOM.
Show More