Catalog data upload : mdm catalog

[Former Member]

Hi All,

The supplier wants to provide the data in the below format:

Qty Price

100 40.00

500 30.00

1000 25.00

PLease let me know how can i achieve the aboove requirement in SRM MDM Catalog 3.0. Which field in SRM MDM Catalog repository needs to mapped for this . And, i also would like to know, if an end User shops in SRM SC, how can the price will be handled for Per/QTY.

For e.g... we have loaded the 100 QTY of Price: 40.00. What we want , if a end user selects this item and enters the QTY as 1, then the Price for 1 item should be 0.40 USD.

Please advise.

Thanks a lot,

SK

[masa_139 · Accepted solution]

Hi,

It is better to store the data in SKU level. The data should be like this.

Supplier, Supplier Parts No, Lower Bound, Price, Currency, UOM,

ABC ABC1000 1 0.40 ; USD EA

ABC ABC1000 500 0.30 ; USD EA

ABC ABC1000 1000 0.25 ; USD EA

I have not tested but the value conversion filter may help you.

http://help.sap.com/saphelp_mdm550/helpdata/en/43/2A61E6BE8A6025E10000000A422035/frameset.htm

I would prefer executing conversion in Excel level before calling Import Manager.

Regards,

Masa

[Former Member · Accepted solution]

Masa,

Thanks for your response.

You mentioned, that you will carry the conversion in Excel only. Could you please let me know, how you will do the same.

And do we need to map the Qty source filed to Lower Bound (Destination) feild in SRM MDM repository.

Plz advise.

Thanks ............... aaaaaaaaaaa Lot.

[masa_139 · Accepted solution]

Hi,

My comment was,

If supplier send the data like this.

Qty Price

100 40.00

500 30.00

1000 25.00

I will manually update the data like following before importing or I will simply ask supplier to provide data with this format.

Supplier, Supplier Parts No, Lower Bound, Price, Currency, UOM,

ABC ABC1000 1 0.40 USD EA

ABC ABC1000 500 0.30 USD EA

ABC ABC1000 1000 0.25 USD EA

If you do not want to update manually, you should use MDM advanced function like value conversion filter.

The scale price needs lower bound mapping.

Regards,

Masa