Overview of Importing Products and Product Groups

To import products and product groups for the Sales Catalog you use Excel files containing macros that Oracle has provided. Using the macros greatly speeds up the creation of your product data.

Here's an overview of the steps:

Step Where to Find More Information
Step 1

Download the import files.

Download the Product Import Files
Step 2

Enter product data and import the products.

Enter Data into the Product Import Macro and Import
Step 3

As a checkpoint, you verify the imported products and optionally add images to products.

Verify Imported Products and Add Product Images
Step 4

Import the product groups.

Enter Data into the Product Import Macro and Import
Step 5

Import the relationship between the products and product groups. In this step, you specify which products belong in which product groups.

Import the Relationships Between Product Groups and Products
Step 6

Find the reference number to use when you import the product group structure.

Get the Reference Number for the Root Product Group
Step 7

Import the product group hierarchy.

Import Product Group Hierarchy Information