Create a product catalog from flat fiile

[Former Member]

Hello All,

I have a requirement to create a product catalog from a flat file. Basic requirement is to add products under product catalog. Further requirement can be extended to add views and add images to product catalog.

I want to know steps or function modules which will be used in order to achieve basic requirement first and then extended requirement.

Any sample example explaining the same will be more useful.

Thanks in advance

Madhura

[Former Member]

Hi,

There is a need to of two programs for upload complete product catalog.

1. Custom program - To create Product catalog, Variant, view and Catalog areas.

Function modules used are:

COM_PCAT_HDR_CREATE_O - Create Header

COM_PCAT_VRT_CREATE_O - Create Variant

COM_PCAT_CTY_CREATE_O - Create Catalog area

COM_PCAT_VIEW_CREATE_O - Create view

2. COM_PCAT_MASS_DOC_IMPORT

To assing product to Catalog area and Upload Images for Products.

Hope this information will be helpful to those who want to create product catalog through file.

Thank you.

Madhura

[Former Member]

By uploading images to a Product Catalog, the program below will also add the item to the catalog area specified.

SE38 - Run Program COM_PCAT_MASS_DOC_IMPORT

It has it's own Program Information to explain how it works.

Here's the first portion of the that information:

Title
Mass Import of Multimedia Documents for Product Catalogs
Purpose
This report enables you to automatically import multimedia documents that are already available in a file system and assign these documents to product catalog items. The items are identified using a product number. An item is created if a corresponding one is not available.
A simple text file, which can be created using the normal spreadsheet programs or simple text editors, is used as a basis for the import.

We have used this in the past, but it has some performance issues, so experiment to be sure you don't try to upload too many images at once...it can bog down after a few batches and begin crawling.

[Former Member]

Hi,

I am uploading the file using this program in testing server . For testing purpose I have taken only four products. The reports runs sucessfully and I dont see any error log. But I can not see Area, Product and Images uploaded into Product Catalog.

Also in development server in selection screen Document type is showing error that its has no document type as CRM_THUMB.

In debugging I could see that for Object Type BUS2300002 , document type CRM_THUMB and CRM_IMAGE is not assigned.

How and where I should configure this in SPRO.

Thanks in advance,

Madhura

[Former Member]

Hi Madhura,

Go to SPROSAP NetWeaverApplication ServerBasis ServicesArchiveLinkBasic CustomizingEdit Document Types. Here you customize your CRM_IMAGE and CRM_THUMB.

Thanx

Chinmaya