Creating a CSV File to Import Products 

Use

To import a list of products to the selling via eBay® (SVE) application, you can create a Comma Separated Values (CSV) file, also known as a flat file. When creating auctions, sellers can select products from the imported file.

To identify products for auction, you run a report in your back-end system (SAP CRM or SAP ERP) on your product master. You generate the report in CSV format and store it in a location accessible to the SVE application. You then configure the file path in Extended Configuration Management (XCM) so that the products are available to sellers when they create auctions.

Prerequisites

You have created a product master. From the SAP Menu:

·        In SAP CRM, choose Master Data ® Products ® Maintain Products.

·        In SAP ERP, choose Logistics ® Sales and Distribution ® Master Data ® Products ® Material ® Trading Goods ® Create.

Procedure

...

       1.      Create a CSV file from your product master and arrange the columns in the following order:

¡        Product name

¡        Product description

¡        Quantity

¡        Unit

¡        Price

¡        Currency

¡        Image URL

¡        Sales organization

Sales organization for the product

¡        Distribution channel

Distribution channel for the product

¡        Division

Division for the product

¡        Storage

Storage code assigned to the product

¡        Shipping plant

P111,test product 1,10,PC,100,USD,http://www.yahoo.com/x.jpg,3000,1,0,TGHJ,DFSC

       2.      Name the file products.csv.

       3.      Specify the file location in XCM:

                            a.      Log on to XCM using the following URL:

http://<servername:port>/sve/admin/xcm/init.do

                            b.      Choose Start ® Components ® Customer ® upload.

                            c.      In the UploadSource parameter field, enter the path and file name of the CSV file, for example, \\server\upload\products.csv.

                            d.      Save the configuration.

       4.      Specify the component configuration for your application in XCM:

                            a.      Choose Start ® Application Configurations ® Customer.

Select your application configuration and choose Display Advanced Settings.

                            b.      In the uploaddata parameter field, select the component configuration for your application and choose Upload.

The system displays the configured UploadSource parameter field from step 3.

                            c.      To return to the application configuration, choose Save Configuration and then Back to Configuration.

Result

When you log on to the SVE application as a seller you can select products from an imported list by either:

·        Choosing Products ® Browse Imports

·        Choosing Auction Management ® Create Auctions, and then selecting Imported Product List and choosing Continue