Migration to new SKU code

GauravT_*15211

Hi All,

 

One of my client is under IT systems restructuring and migrating to new ERP system. Because of that the SKU codes for ~6000 SKUs will change to 18 digit in a couple of month. In Anaplan we currently have old codes for SKU and there is another numbered list of SKU-Customer combination code of around ~100000. 

 

What is the best way to undertake such kind of migration to new codes without losing the data we currently have.It is important to note that there is some data which is manually entered against an SKU and client wants to retain that information when migrating to new codes

 

Thanks in advance

a.dilieto

Hi @GauravT ,

 

I have recreated the case with an example that you can follow (it works for both non-numbered and numbered lists):

 

In a module wih SKU as dimension, you need to have the Line Items NAME, CODE, NEW CODE (in which you add the necessary 0s);

than save the view applying a filter on SKUs only (no parents);

in the SKU list, import from this saved view, mapping the CODE with the line item NEW CODE and select as "items uniquely identified by:" NAME ONLY;

run the action.

(find the screenshots attached)

In this way you will only replace the codes without creating new items or erasing any data. Anyway, I suggest to create a backup copy of the model before doing this process.

 

I hope this helps,

 

Best

Antonio

 

 

Import_Mapping_60437.png

SKU_Module_60437.png

SKU_List_60437.png

Saved_View_60437.png

New_Codes_60437.png