Product numbers

Hello!

Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them.

Is there a way to wholesale change part numbers where, for example:

  • export part numbers
  • apply changes
  • import new part number and retain sales history, inventory et al - and retain the old number in another field, ie: Mfr#, etc

Thanks much for any help,

Dave

  • 0

    You may have to do it in multiple steps to get the results. The sales history may not work the way you want though. Try to export 1 or 2 items with the inventory export using excel, make your changes, as for the old part #'s use "alternate" column in excel, import them after your changes. If the old items can be rendered inactive then do so to keep any history associated with them. You mat have to change some of the quantities to zero first.

  • 0

    We ended up buying MK Powertools to do this.  It's an extremely expensive third party add on but it allows you to change or merge part numbers while retaining all the history.

  • 0 in reply to ScottB115
    You can also use BVEssentials Limited Edition for free, but it only allows you to Change part numbers and not merge them.
    It will change the part number in every table that it exists. Very handy.