search

AllSpiceIO / cofactr-cogs

Compute cost of goods sold (COGS) in AllSpice Actions using Cofactr.
MIT License
0 stars 0 forks source link

Multiple part numbers and manufacturers for fallback #1

Open jtran opened 3 months ago

jtran commented 3 months ago

can there be a fall-back or multiple part numbers for a given part? Often, users will include multiple manufacturers or even distributors. Then go with the lowest cost. Those are typically saved as Manufacturer 1, Manufacturer Part Number 1, etc in component attributes.

This requires there to be a way to configure multiple part number and manufacturer column groups. ~bom_part_number_column could be a comma-separated list of part numbers.~

Doing a fallback when a part isn't found using the API is straight-forward.

Using lowest cost or some other reduction function over all prices is out of scope for this issue.

jtran commented 3 months ago

As mentioned in #4, we need both multiple part numbers and manufacturers.