we use dropship/special order items. normally PO gets generated with item rate = default purchase price, per agreement with vendor.
but now vendor doesn't want to use static price. vendor wants item rate = some % of the sales price.
how would y'all approach this? i'm not allowed to yell at vendor.
c
creece
12/03/2025, 3:51 PM
Seems like you can script this. If the vendor is the one you need to do a % on, then you can spin through the lines, get the item rate and calculate the % and set the custom item rate. You can store the % on the vendor so you can update it and read it as needed.
šļø 1
z
zengs
12/03/2025, 3:55 PM
luckily the % is static that can even be hardcoded
c
creece
12/03/2025, 3:58 PM
Yeah but that's kind of the "famous last words" type scenario. It would be a "better" design to not hardcode it as it will inevitably be updated at some point. If you have to hardcode it, it still works, but would require a code change if/when it updates.
šļø 1
z
zengs
12/03/2025, 4:03 PM
yeah you're right, guess it's up to how dangerous i wanna live. (i'm the only admin.) in our particular case another change would require a lot of big yapping between the merchant/exec side which is unlikely but not impossible
c
creece
12/03/2025, 4:09 PM
I gotcha. Hardcode works then.
š 1
m
Marissa Nolan
12/03/2025, 7:03 PM
Iād just add a field on the vendor record to store the % markup that way if you need to change it later or have another vendor who wants to do this you can just update/add then use that logic in your script where if vendor has a value in that field THEN update otherwise use native defaulting logic. Makes it scalable now vs reworking later
š 1
šÆ 1
z
zengs
12/03/2025, 7:07 PM
ive asked the merchant side to confirm if this is a weird unique case type thing (very very likely) so i'll work off what they say