CCM Catalog Mass upload problem

[Former Member]

Dear Experts,

Could you please help me to find an answer to the below issue?

We are doing a mass catalog upload in CCM 2.0 => we are uploading our CSV file as follows:

Supplier ID A => Supplier name A => Item details A

Supplier ID B => Supplier name B => Item details B

etc.

Usually, I give the first Supplier ID when creating the Supplier catalog.

The upload process is working fine, BUT...

When the catalog has been uploaded, from the Procurement Catalog side there is only the first "Supplier ID A" what's beeing uploaded to all of the items instead of all the other respective Supplier IDs.

Therefore we have to change the rest of the Supplier IDs by mass changing the respective Proc Cat.

Do you know how we could keep all the other Supplier IDs?

Thanks a lot - imre

Edited by: Imre Matyas on Feb 8, 2010 11:09 AM

[masa_139 · Accepted solution]

Hi,

How about this solution?

1. Create Dummy Supplier Catalog

2. Create a custom field for Supplier

3. For UI, hide the standard supplier field and make visible for the custom supplier field

4. Map the custom supplier field to NEW_ITEM-VENDOR

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

I have uploaded the dummy supplier catalog and found that already supplier catalog is wrong: only the supplier ID given at the catalog creation has been uploaded to all of the items.

Do you have an idea for this one as well?

Thanks imre

[masa_139 · Accepted solution]

Hi,

Don't worry about it. My solution does not use standard supplier ID when supplier catalog was created. The correct supplier ID is stored in custom field(characteristics).

Regards,

Masa

[Former Member · Accepted solution]

Did I understand well: you want me to upload already the Supplier CSV file with a new characteristic which can be retrieved afterwards.

My only problem is that when I've created such an upload file, I have received from SRM :

"A characteristic value for catalog item ITEM1 (ID) is incorrect / Catalog update was terminated".

Thanks.

[masa_139 · Accepted solution]

Hi,

I think I misunderstood your issue.

Does your CSV file have mixed items from all suppliers ? or 1 CSV file for each supplier?

Regards,

Masa

[Former Member · Accepted solution]

I am doing mass upload with only one CSV file => mixed items from Supplier A, Supplier B, etc.

In transaction "Create catalog" SRM asks me to fill Supplier ID => this is the ID which will be copied to all items with no regards

to the original CSV file.

I was wondering if there is a solution for that, but seems it is not possible. I can anyway find solutions to circumvent this feature of the system (mass changes after the upload).

If you still have any idea on this, it is welcome - otherwise thanks for your help!!

imre

[masa_139 · Accepted solution]

Hi,

In that case my solution will help.

Here is sample schema with custom characteristics. Please look at Z_SUPPLIER_ID and Z_SUPPLIER_NAME.

-

---

SAP CATALOG CSV 2.0 <;>

Defaults;EN

Model

Catalog;Master;;Master Catalog Characteristic;Z_ACTION;/CCM/NAME;false;Action

Characteristic;/CCM/PRODUCT_ID;/CCM/ID;false;Part Number Characteristic;/CCM/SHORT_DESCRIPTION;/CCM/DESCRIPTION;false;Description

Characteristic;Z_MATERIAL_TYPE;/CCM/ID;false;Material Type Characteristic;/CCM/MINIMUM_QUANTITY;/CCM/MINIMUM_QUANTITY;false;Order Unit

Characteristic;Z_CONTENT;/CCM/MINIMUM_QUANTITY;false;Content Characteristic;/CCM/LEAD_TIME;/CCM/LEAD_TIME;false;Lead Time

Characteristic;Z_SUPPLIER_ID;/CCM/ID;false;Supplier Number Characteristic;Z_SUPPLIER_NAME;/CCM/NAME;false;Sup Name

Characteristic;Z_P_GROUP;/CCM/ID;false;Purchasing Group Characteristic;Z_P_ORG;/CCM/ID;false;Purchasing Org

Characteristic;/CCM/CONTRACT_ID;/CCM/ID;false;Contract Number Characteristic;/CCM/CONTRACT_ITEM_ID;/CCM/ID;false;Contract Item

Characteristic;/CCM/PRODUCT_GROUP;/CCM/ID;false;Product Category Characteristic;/CCM/PRICE;/CCM/PRICE;true;Price

Characteristic;Z_DATE;DATE;false;Date Characteristic;Z_UPDATE_BY;/CCM/ID;false;Updated By

Characteristic;/CCM/LONG_DESCRIPTION;/CCM/LONG_DESCRIPTION;false;Long Description Characteristic;/CCM/PICTURE;/CCM/ATTACHMENT;false;Picture

Characteristic;Z_BUYER;/CCM/ID;false;Buyer Characteristic;Z_BUYER_CONTACT;/CCM/ID;false;Buyer Contact Number

Schema;Master;Z_ACTION;Z_MATERIAL_TYPE;Z_CONTENT;Z_SUPPLIER_ID;Z_SUPPLIER_NAME;Z_P_GROUP;Z_P_ORG;Z_DATE;Z_UPDATE_BY;Z_BUYER;Z_BUYER_CONTACT;Master Schema

...

-

---

Regards,

Masa

[Former Member · Accepted solution]

Great!

And what about error "A characteristic value for catalog item ITEM1 (ID) is incorrect / Catalog update was terminated" ?

Is it due to something I made wrong during the upload? What are the prequisites to avoid it please?

[masa_139 · Accepted solution]

Hi,

The error message says that some value is wong in your data, CSV contents. or The data did not match with schema definition.

Please check your schema definition and CSV data.

Regards,

Masa