Hi all,
I have submitted this as a support case #6159599 as that seems appropriate and will update here with any answers.
A number items with custom prices on customer records have broken and aren't being applied to orders, I don't yet know the extent as I haven't been able to think of a way to search for the damages.
We have been doing CSV uploads to customer pricing, but not with any of the items that have been affected. So, as of yet, I don't know what caused this issue either.
——————————————————————
On the customer records are items like 75OHGPK and 75OHGPK-C which are Kit items (I haven't found any other items types affected). These items have custom pricing but when creating a Sales Order for the customer and the item, the custom pricing is not applied anymore, this is in production and has been working for a long time.
If I add the item to the customer record again with custom pricing, this fixes the issue and the pricing now works on the SO. However, this is a duplicate item and shouldn't be possible to begin with. If I try to add a 3rd copy of the item, that does flag as a duplicate and will not save.
I also ran a saved search for customers that have custom pricing on 75OHGPK and that returned 25 results (this be much more). I then tested both 75OHGPK and 75OHGPK-C on SOs for those customers and got:
- GTC3417 - 75OHGPK and 75OHGPK-C working
- KEL433 - 75OHGPK working, 75OHGPK-C not working
- MAG470 - Both working
- MIL2681 - Both working
But, by running the same search instead for 75OHGPK-C, KEL433 doesn't show up. When looking at this customer record 75OHGPK-C is again an affected item, it shows in the list with custom pricing, doesn't work on SOs and will allow me to create a duplicate. This means that the saved search also doesn't think KEL433 has a custom price for this item, it does and this is the error. So not only is this entirely broken, but I also can't think of any kind of saved search for the broken items that I can use to repair all the issues.
——————————————————————-I do appear to be able to search for the customers that have these items with custom pricing on them. To test if they're working, I think I need to build a Scheduled Script that will attempt to add a duplicate of the item pricing to the record and report back if there is not an error?
Or perhaps I'll just download a CSV of all these pricings and reupload it, that will probably also just error out if it recognizes a duplicate when trying to replace it and fix all the broken ones.