Download the Product Import Files

Download the product and product group import files. These four Excel spreadsheets contain macros that let you do the product data import.

Note: This section focuses on importing your product data using Excel files with macros. See the Understanding Import and Export Management guide to learn how to import product data without the macros.

Importing products and product groups applies to both classic Sales and Sales in the Redwood UX.

For information about how to create individual products in the UI, start with Sales Products High-Level Setup Steps.

Here's how to download the import files:

1. Sign in to My Oracle Support.
2. Search for the document, Oracle Sales: Download the Import Files (KB171529).
3. Download the files shown in the following table to a folder on your computer. You can create different folders for the different files, as long as the Product Import Macro folder includes the .jar file.

   File Name	Description
   oracle_ucm_client_11.1.1.jar	You must include this file in the same directory as the import macro.
   Product_Import_Macro.xslm	Import products.
   ProductGroup_Import_Macro.xslm	Import product groups.
   ProductGroupRelationSetup_Import_Macro.xslm	Import the product group hierarchy.
   ProductGroupItem_Import_Macro.xslm	Import the relationship between product groups and products.