HELP: Where would I go for this solution?
When it is time to renew my Item pricing in QuickBooks, I always export to Excel. I will paste a copy of the old price list below it and compare them - very manual for 9000 items. There must be a better way!!
I need an easy way to compare the old Price List and the new Price List whereby a) a match of the new and old SKU would indicate that SKU is still Active b) a mismatch would indicate that SKU is either Discontinued on the old list or New on the new list c) the Active and New SKUs be captured in a new List with the new prices, ready for Import to QuickBooks.
Bookmarks