Last updated: Oct 21, 2020 07:01:39 PM
Use this tool to set up the spreadsheets used by the Products Import and Export tool. You can choose which fields you want to appear in the blank product template and the field data. A configured product spreadsheet template allows you to quickly set up products in the spreadsheet. It also reduces the time it takes to process the imported or exported spreadsheet.
Note: To get a configured the Product Import and Export spreadsheet template for your company, contact your Store Operations team. They can help you determine what changes to make and configure it for you. (This feature is only available to Internal UsersAn internal Digital River user of Global Commerce. Internal users have access to features or settings that clients do not. These features or settings could really affect commerce on the store or is complicated to set up or manage.).
The Product Import and Export spreadsheet template is similar to the Product Template. You can use it to define which settings and attributes appear when you create or edit a product with the spreadsheet. There is one configured Product Import and Export template per company. The spreadsheets for all sites/stores within your company use the same template.
Best Practices: Ensure any configuration changes you applied to the Product Import and Export spreadsheet template you also applied to the Product Template. See Product Setup for more information. This ensures the fields that appear in the spreadsheet match the fields in the user interface (UI). This also reduces confusion and possible configuration errors when you create or edit products using both methods.
|Import and Export Products||Allows you to use a spreadsheet to import and export products in bulk. See Importing and exporting products for more information.|
Required Role: Catalog ManagerThis user role allows the user to access to the catalog, including product features, categories, subscriptions, and tags. and Company ManagerThis user role allows the user to define company defaults, use the Import and Export Hierarchy feature, and use the SKU Mapping Import and Export feature.
- Select Catalog and click Job Queue. The Job Queue page appears.
- Click Import and Export Products. The Products Import and Export page appears.
- Click Configure Product Import & Export Spreadsheet. The Configure Product Import and Export Spreadsheet page appears.
Choose one of the following options:
- Select or clear the check boxes for the fields or data you want to include in the spreadsheets under each tab.
- To select or clear all check boxes, select Select/Clear All check box under each tab.
An asterisk marks the required fields that you cannot hide or change in the spreadsheet.
- Click Save.
© 2020 Digital River, Inc. Digital River® is a registered trademark of Digital River, Inc.