Product Group Upload

This integration uploads product groups.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Product Group Upload

User role permission must be turned on for Upload Data and Download Data.

Predecessors

N/A

Related Connectors

Event Hierarchy Upload

Event Hierarchy Completion Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload file type

Product Group Upload

Send Notification?

No

Can be set to True, False, or left blank.

True, False

True = Email will be sent.

False = Email will not be sent.

If blank, will default to True.

Language

No

Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.

The valid language values are:

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Number Format

No

Determines the number format to be used in the file.

The valid values are:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be "#,##9.99" (Example: "1,234,567.99").

Comments

No

Upload Comments

This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Column Header Name

Data Type

Field Length

Required?

Value(s)/Format

Description/Use/Field Rules

Modification Type

Char

1

Yes, for Deletes only.

Valid values are:

  • A

  • U

  • D

  • Blank (no value)

A – Add

U – Update

D – Delete

Blank – When an existing Product Group Code is entered, SAP Fieldglass identifies it as an update, whereas, when a new Product Group Code is entered, SAP Fieldglass identifies it as an Add.

Code

Text

100

Yes

A valid SAP Fieldglass Product Group Code.

Example:

  • 1001

Code that uniquely identifies the purchase unit.

Name

Text

100

Yes

Valid SAP Fieldglass Product Group Name.

Example:

  • Delivery

Value that uniquely describes the product group in more recognizable terms than the Product Group Code.

Description

Text

1000

No

Optional long text description of the product group.

Unique Identifier

  • Product Group Code field

Assumptions/Known Issues

  • N/A