Connect Product schemas

Entities, enums and methods for importing products and product related information.

Entities

CompetitorSku

CompetitorCode
required
string

Unique code for competitor.

CompetitorPartNo
required
string

Competitor part number.

IsInStock
required
boolean

Specifies if the SKU is in stock at the competitor.

IsPricesInclVat
required
boolean

Specifies if prices are incl. VAT (true) or excluding VAT (false).

PartNo
required
string

Part number in Norce to which the competitor data is referencing.

PriceSale
required
number

The sale price from the competitor.

PriceSaleInclFreight
required
number

Competitor sale price incl. freight, same as PriceSale if no freight.

Source
required
string

Source of competitor data.

CompetitorName
string

Name of the competitor.

CurrencyCode
string

ISO 4217 code for the currency that prices are in.

object <ExternalPopularity> (ExternalPopularity)

Represents a popularity ranking from an external source.

ProductName
string

Product name for competitor data.

SalesArea
string

Specifies target sales area.

Enum: "Sweden" "Norway" "Denmark" "Finland" "UnitedKingdom" "Estonia" "Greenland" "Germany" "Italy" "Austria" "Spain" "Netherlands" "Belgium" "France" "Switzerland" "USA" "Ireland" "Canada" "Lithuania" "Latvia" "Japan" "SouthKorea" "Australia" "Europe" "Poland" "CzechRepublic" "Russia" "NoVAT" "Bulgaria" "Croatia" "Cyprus" "Greece" "Hungary" "Luxembourg" "Malta" "Portugal" "Romania" "Slovakia" "Slovenia"
VatRate
number

VAT rate in percentage.

CompetitorSkuHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

CompetitorSkuFieldsThatAreSet
required
Array of strings

Array of strings representing competitor fields to be processed.
(Use the integer instead of the name for the xml content type)

0 = CompetitorName
1 = ProductName
2 = VatRate
3 = ExternalPopularities (Deprecated, not supported any longer)

Items Enum: "CompetitorName" "ProductName" "VatRate" "ExternalPopularities"
FullFile
required
boolean

Flag that specify how Norce Commerce Connect will handle the import. If true, all prices from the competitors not in this import will be deactivated. If false, the import will be handled as an update only, and other products already having prices will be ignored.

JobId
string

Norce Commerce Connect job id. Only exists in import logs. Should be omitted in the import request.

SerializationType
Array of strings

Request serialization type.(Use the integer instead of the name for the xml content type)

0 = JSON, 1 = XML

Items Enum: "JSON" "XML"
StorageName
string <uri>

Location of the import file on Norce's file area. Can be used instead of sending data directly in payload.

SupplierId
integer <int32>

Derived from base header. Ignored in competitor import.

DeliveryMethod

Code
required
string

Delivery method code. Used for delivery method matching in Norce Commerce.

IsActive
boolean

Sets product delivery method to active or inactive. Default true.

PackagePercentage
number

Package percentage.

ExternalPopularity

PartNo
required
string

Part number in Norce Commerce to which the popularity information is referencing.

PopularityValue
number

The popularity valu for the SKU.

Source
string

The name of the external source. This name must correlate to a configured source in Norce Commerce.

Flag

Code
required
string

Product flag code. Used for product flag matching in Norce Commerce.

IsSet
required
boolean

Determines if a product flag is to be set or unset.

IsCreateOnly
boolean

If true, data is only saved if flag record is new. Default: false.

IsLimitedUpdate
boolean

If true, data is only saved if flag record is new or last updated by the same account as the one initiating the update. Default: false

StopDate
string <DateTime>

Shows when flag was disabled for product.

Image

ExternalCode
required
string

External identifier for image matching.

FileTypeName
required
string

File type code. Should match file info set up in Norce Commerce, e.g. "MainImage", "Additional", "Embedded".

Url
required
string <uri>

Url to where the image is located. Must be a publically accessible endpoint.

FileName
string

Image file name. If omitted it will be parsed from the url. Max length: 50

LastModified
string <DateTime>

Time when image was last updated. Deprecated.

Info

Code
required
string

External code for additional information field to be matched in Norce Commerce.

Value
required
string

Value to be set or updated on the information field.

ParametricValue

ParametricCode
required
string

External parametric code configured in Norce Commerce. Used to match parameter.

Array of objects <ParametricValueCulture> (ParametricValueCulture)

List of parametric translations.

Array of objects <ParametricValueList> (ParametricValueList)

List of possible values to set for parametrics with multiple value choice.

ValueBoolean
boolean

Boolean value to set.

ValueDateTime
string <DateTime>

Date/time value to set.

ValueDecimal
number

Decimal value to set.

ValueInteger
integer

Integer value to set.

object <ParametricValueList> (ParametricValueList)

Parametric value for list of choices.

ParametricValueCulture

CultureCode
required
string

Culture code, e.g. "sv-SE".

ValueText
required
string

Translated text parametric value. Max length 255 chars for text-values, unlimited for HTML-values.

ParametricValueList

Code
required
string

Parametric value code. Use for parametric value matching in Norce Commerce.

Value
required
string

Value to set

Description
string

Description of the value

Array of objects <ParametricValueListCulture> (ParametricValueListCulture)

Array with localized versions of value and description

PriceList

Code
required
string

Externally defined price list code. Used to match price list in Norce Commerce.

CurrencyCode
string

Currency code in ISO 4217 format, e.g. "SEK", "EUR", "USD".

DefaultPriceRule
integer <int32>

Price rule to be set as default.
1 = Cost plus
2 = Fixed price
3 = Margin (purchase cost)
4 = Use recommended price
5 = Cost plus (unit cost)
6 = Margin (unit cost)
7 = Use standard price (pct discount)
8 = Competitive (purchase cost)
9 = Competitive (unit cost)
10 = Use standard price (fixed discount)
11 = Structure calculation
12 = Use catalog price

DefaultPriceRuleCode
string

Deprecated

DefaultPriceRuleValue
number

Default price list value.

Description
string

Price list description

EndDate
string <DateTime>

End date/time when price list is no longer valid.

IsErpIntegrated
boolean

Deprecated

IsPrimary
boolean

Determines if price list is primary. Only one price list can be primary on an application.

IsPublic
boolean

Determines if price list is public and active.

IsFavorite
boolean

Determines if price list is favorite for the current application.

Name
string

Price list name. Max length: 50

StartDate
string <DateTime>

Start time when price list is valid and applied.

TypeCode
string

Price list type code

Array of objects <Warehouse> (Warehouse)

List of warehouses where this price list is applicable.

SalesArea
integer <int32>

Sales area identifier.
1 = Sweden
2 = Norway
3 = Denmark
4 = Finland
5 = UnitedKingdom
6 = Estonia
7 = Greenland
8 = Germany
9 = Italy
10 = Austria
11 = Spain
12 = Netherlands
13 = Belgium
14 = France
15 = Switzerland
17 = USA
18 = Ireland
19 = Canada
20 = Lithuania
21 = Latvia
22 = Japan
23 = SouthKorea
24 = Australia
25 = Europe
26 = Poland
27 = CzechRepublic
28 = Russia
29 = NoVAT
36 = Bulgaria
37 = Croatia
38 = Cyprus
39 = Greece
40 = Hungary
41 = Luxembourg
42 = Malta
43 = Portugal
44 = Romania
45 = Slovakia
46 = Slovenia

DefaultMinMarginPercent
number

Default minimum product margin percentage.

LimitToRecPrice
boolean

Limit to recommended price.

ParentPriceListCode
string

Code of parent price list.

DefaultSupplementalChargeFixed
number

Default supplemental charge (fixed)

DefaultSupplementalChargePercent
number

Default supplemental charge (percentage)

Array of objects <PriceListPriceRule> (PriceListPriceRule)

List of price rules.

object <PriceListPopulation> (PriceListPopulation)

Price list population.

PriceListHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

PriceListFieldsThatAreSet
required
Array of strings

Array of strings representing price list fields to be processed.
(Use the integer instead of the name for the xml content type)

0 = Name
1 = CurrencyCode
2 = StartDate
3 = EndDate
4 = IsPublic
5 = IsPrimary
6 = TypeCode
7 = Warehouses (required if you have WarehouseFieldsThatAreSet and WarehouseLocationFieldsThatAreSet values)
8 = DefaultPriceRule
9 = Description
10 = IsErpIntegrated (Deprecated, not supported any longer)
11 = DoNotCreateApplicationPriceList (Will not automatically create a relation to the application)
12 = SalesArea
13 = DefaultMinMarginPercent
14 = LimitToRecPrice
15 = ParentPriceListCode
16 = DefaultSupplementalChargeFixed
17 = DefaultSupplementalChargePercent
18 = PriceRules
19 = PriceRulesCleanup (Remove all price rules before import starts)
20 = PriceRulesLimitedUpdate
21 = Population
22 = PopulationCleanup (Remove all populations before import starts)

Items Enum: "Name" "CurrencyCode" "StartDate" "EndDate" "IsPublic" "IsPrimary" "TypeCode" "Warehouses" "DefaultPriceRule" "Description" "IsErpIntegrated" "DoNotCreateApplicationPriceList" "SalesArea" "DefaultMinMarginPercent" "LimitToRecPrice" "ParentPriceListCode" "DefaultSupplementalChargeFixed" "DefaultSupplementalChargePercent" "PriceRules" "PriceRulesCleanup" "PriceRulesLimitedUpdate" "Population" "PopulationCleanup" "IsFavorite"
JobId
string

Norce Commerce Connect job id. Only exists in import logs. Should be omitted in the import request..

SerializationType
Array of strings

Request serialization type.(Use the integer instead of the name for the xml content type)

0 = JSON, 1 = XML

Items Enum: "JSON" "XML"
StorageName
string <uri>

Location of the import file on Norce's file area. Can be used instead of sending data directly in payload.

SupplierId
integer <int32>

Derived from base header. Ignored in price list import.

WarehouseFieldsThatAreSet
Array of strings

Array of strings representing warehouse fields to be processed.
(requires values in WarehouseLocationFieldsThatAreSet as well)
(Use the integer instead of the name for the xml content type)

0 = Type
1 = Name
2 = LeadTimeDayCount

Items Enum: "Type" "Name" "LeadTimeDayCount"
WarehouseLocationFieldsThatAreSet
Array of strings

Array of strings representing warehouse location fields to be processed.
(requires values in WarehouseFieldsThatAreSet as well)
(Use the integer instead of the name for the xml content type)

0 = Name
1 = LeadTimeDayCount
2 = IsIncludedInStockCalculation

Items Enum: "Name" "LeadTimeDayCount" "IsIncludedInStockCalculation"
PriceListPriceRuleFieldsThatAreSet
Array of strings

Array of strings representing price list rule fields to be processed.
(Use the integer instead of the name for the xml content type)

0 = Type
1 = Value
2 = LimitToRecPrice

Items Enum: "Type" "Value" "LimitToRecPrice"

Product

Code
string

Product code. Used for product cluster matching in Norce Commerce.

ManufacturerCode
string

Manufacturer code.

Array of objects <Image> (Image)

List of additional product images.

Alias
string

Product alias.

AssortmentCode
string

Product assortment code. If set, assortment with this code will be associated to product.

Array of objects <ProductCategory> (ProductCategory)

List of categories product shall be placed in.

Array of objects <ProductCulture> (ProductCulture)

List of translated product information fields.

object <ProductFamily> (ProductFamily)

Product family information. Families that can not be matched will not be created but give a warning in the logs.

object <Image> (Image)

Product image information.

ManufacturerName
string

Manufacturer name. If manufacturer doesn't exist this field is required to create a new manufacturer.

Array of objects <Flag> (Flag)

List of flags applied to product.

Array of objects <ParametricValue> (ParametricValue)

List of parametrics applied to product.

object <VariantDefinitionGroup> (VariantDefinitionGroup)

Variant definition information.

Array of objects <Variant> (Variant)

List of product variants.

ProductCategory

Code
required
string

Category code. Used for category matching in Norce Commerce.

SortOrder
integer <int32>

Determines in which order this category shall be applied to product. Use sort order 1 for primary category.

ProductCulture

CultureCode
required
string

Culture code, e.g. "en-GB".

Description
string

Translated product description.

DescriptionHeader
string

Translated product description header. Max length: 255

IsUniqueUrlNameManuallyMaintained
boolean

Determines if UniqueUrlName is manually maintained.

MetaDescription
string

Translated product meta description.

MetaTags
string

Translated product meta tags.

Name
string

Translated product name. Max length: 255

SubDescription
string

Translated additional product description.

SubHeader
string

Translated additional product header. Max length: 255

Synonyms
string

Translated product synonymous names.

Tags
string

Translated product tags.

Title
string

Translated product title. Max length: 255

UniqueUrlName
string

Language specific unique prodct url name, called 'Unique url' in administration gui.

ProductFamily

Code
required
string

Externally defined product family code. Used for product family matching in Norce Commerce.

Name
string

Product family name.

ProductHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

FullFile
required
boolean

If set to true all products that are not imported here will be inactivated. Missing variants will be disconnected from the product as well.

ProductFieldsThatAreSet
required
Array of strings

Specifies which product fields shall be updated.
(Use the integer instead of the name for the xml content type)

0 = ManufacturerCode
1 = ManufacturerName
2 = Alias
3 = Code
4 = Variants (required if you have VariantFieldsThatAreSet values)
5 = Cultures (required if you have ProductCultureFieldsThatAreSet values)
6 = Categories
7 = MainImage
8 = AdditionalImages
9 = Family
10 = ProductParametrics
11 = ProductParametricsCreateOnly (Value is only set if the product parametric entity is created by the import)
12 = VariantDefinitionGroup
13 = VariantDefinitionGroupCreateOnly (Value is only set if the variant definition entity is created by the import)
14 = Assortment
15 = CategoriesCreateOnly (Value is only set if the product category entities is created by the import)
16 = CategoriesLimitedUpdate (If category is manually changed in the Admin UI import is ignored)
17 = AdditionalImagesCleanUp (Remove all additional images not included in import)
18 = ParametricsCleanUp (Remove all parametrics from the entity, not included in the import)

Items Enum: "ManufacturerCode" "ManufacturerName" "Alias" "Code" "Variants" "Cultures" "Categories" "MainImage" "AdditionalImages" "Family" "ProductParametrics" "ProductParametricsCreateOnly" "VariantDefinitionGroup" "VariantDefinitionGroupCreateOnly" "Assortment" "CategoriesCreateOnly" "CategoriesLimitedUpdate" "AdditionalImagesCleanUp" "ParametricsCleanUp"
IgnoreSkuPriceListFieldsWhenEmpty
Array of strings

Specifies which SKU price list fields that are mandatory. If this field is missing in the import this specific price entity will be ignored.
Required settings: StandardPrice in (SkuFieldsThatAreSet) and all fields added here must be in SkuPriceListFieldsThatAreSet as well
(Use the integer instead of the name for the xml content type)

3 = PriceSale
4 = CostPurchase
5 = CostUnit
6 = PriceRecommended
7 = PricePrevious
8 = PriceCatalog
10 = IsActive

Items Enum: "PriceSale" "CostPurchase" "CostUnit" "PriceRecommended" "PricePrevious" "PriceCatalog" "IsActive"
JobId
string

Norce Commerce Connect job id. Only exists in import logs. Should be omitted in the import request.

ProductCultureFieldsThatAreSet
Array of strings

Specifies which product culture fields to be updated.
Required settings: Culture (in ProductFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = Name
1 = NameCreateOnly (Value is only set if the product culture entity is created by the import)
2 = SubHeader
3 = SubDescription
4 = DescriptionHeader
5 = Description
6 = DescriptionCreateOnly (Value is only set if the product culture entity is created by the import)
7 = Synonyms
8 = Title
9 = Tags
10 = MetaTags
11 = MetaDescription
12 = NameLimitedUpdate (If name is manually changed in the Admin UI, import is ignored)
13 = UniqueUrlName
14 = IsUniqueUrlNameManuallyMaintained
15 = UniqueUrlNameCreateOnly (Value is only set if the product culture entity is created by the import)

Items Enum: "Name" "NameCreateOnly" "SubHeader" "SubDescription" "DescriptionHeader" "Description" "DescriptionCreateOnly" "Synonyms" "Title" "Tags" "MetaTags" "MetaDescription" "NameLimitedUpdate" "UniqueUrlName" "IsUniqueUrlNameManuallyMaintained" "UniqueUrlNameCreateOnly"
SerializationType
Array of strings

Request serialization type.(Use the integer instead of the name for the xml content type)

0 = JSON, 1 = XML

Items Enum: "JSON" "XML"
SkuCultureFieldsThatAreSet
Array of strings

Specifies which SKU culture fields to be updated.
Required settings: Culture (in SkuFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = Name
0 = ErpName
1 = ErpNameCreateOnly (Value is only set if the SKU culture entity is created by the import)
2 = Comment
3 = CommentCreateOnly (Value is only set if the SKU culture entity is created by the import)

Items Enum: "ErpName" "ErpNameCreateOnly" "Comment" "CommentCreateOnly"
SkuFieldsThatAreSet
Array of strings

Specifies which SKU fields to be updated.
Required settings: Skus (in VariantFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = Name
1 = Status
2 = Type
3 = IntegrationPartNo
4 = CommodityCode
5 = EanCode
6 = TrackingCode
7 = UnitOfMeasurementType
8 = UnitOfMeasurementCount
9 = IsDropShipOnly
10 = IsBuyable
11 = DiscountClass
12 = RecommendedSalesQty
13 = IsRecommendedSalesQtyFixed
14 = ActualWeight
15 = VolumeWeight (Deprecated, not supported any longer)
16 = LogisticWidth
18 = LogisticHeight
19 = LogisticDepth
20 = StandardPrice (required if you have SkuPriceListFieldsThatAreSet values)
21 = VatRate
22 = StatusCreateOnly (Value is only set if the SKU entity is created by the import)
23 = StartDate
24 = StopDate
25 = StructureItems (required if you have SkuStructureItemFieldsThatAreSet values)
26 = PartNoCreateWhenMissing (Let's Norce automatically assign a unique PartNo)

Items Enum: "Status" "Type" "IntegrationPartNo" "CommodityCode" "EanCode" "TrackingCode" "UnitOfMeasurementType" "UnitOfMeasurementCount" "IsDropShipOnly" "IsBuyable" "DiscountClass" "RecommendedSalesQty" "IsRecommendedSalesQtyFixed" "ActualWeight" "VolumeWeight" "LogisticWidth" "LogisticHeight" "LogisticDepth" "StandardPrice" "VatRate" "StatusCreateOnly" "StartDate" "StopDate" "StructureItems" "PartNoCreateWhenMissing"
SkuPriceListFieldsThatAreSet
Array of strings

Specifies which SKU price list fields to be updated.
Required settings: StandardPrice in (SkuFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

3 = PriceSale
4 = CostPurchase
5 = CostUnit
6 = PriceRecommended
7 = PricePrevious
8 = PriceCatalog
9 = IsPriceDiscountable
10 = IsActive
11 = IsPriceDiscountableCreateOnly (Value is only set if the SKU price list entity is created by the import)
12 = PriceRule

Items Enum: "PriceSale" "CostPurchase" "CostUnit" "PriceRecommended" "PricePrevious" "PriceCatalog" "IsPriceDiscountable" "IsActive" "IsPriceDiscountableCreateOnly" "PriceRule"
SkuStructureItemFieldsThatAreSet
Array of strings

Specifies which SKU structure item fields to be updated.
Required settings: StructureItems in (SkuFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = SortOrder
1 = StandardStructureItemPrice
2 = AdditionalInfo

Items Enum: "SortOrder" "StandardStructureItemPrice" "AdditionalInfo"
StorageName
string <uri>

Location of the import file on Norce's file area. Can be used instead of sending data directly in payload.

SupplierId
integer <int32>

Derived from base header. Ignored in product import.

VariantCultureFieldsThatAreSet
Array of strings

Specifies which variant culture fields to be updated.
Required settings: Cultures (in VariantFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = CultureCode
1 = Name
2 = NameCreateOnly (Value is only set if the variant cluster culture entity is created by the import)
3 = NameLimitedUpdate (If name is manually changed in the Admin UI, import is ignored)
4 = UniqueUrlName
5 = IsUniqueUrlNameManuallyMaintained
6 =UniqueUrlNameCreateOnly (Value is only set if the variant cluster culture entity is created by the import)

Items Enum: "CultureCode" "Name" "NameCreateOnly" "NameLimitedUpdate" "UniqueUrlName" "IsUniqueUrlNameManuallyMaintained" "UniqueUrlNameCreateOnly"
VariantFieldsThatAreSet
Array of strings

Specifies which variant fields to be updated.
Required settings: Variant (in ProductFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

0 = ManufacturerPartNo
1 = SortOrderValue
2 = StockDisplayBreakPoint
3 = IsDangerousGoods
4 = Cultures (required if you have VariantCultureFieldsThatAreSet values)
5 = Skus (required if you have SkuFieldsThatAreSet values)
6 = MainImage
7 = AdditionalImages
8 = VariantParametrics
9 = VariantParametricsCreateOnly (Value is only set if the variant cluster entity is created by the import)
10 = NonParametricVariantDefinitions
11 = NonParametricVariantDefinitionsCreateOnly (Value is only set if the variant cluster entity is created by the import)
12 = DeliveryMethods
13 = DeliveryMethodsCreateOnly (Value is only set if the variant cluster entity is created by the import)
14 = AdditionalImagesCleanUp (Remove all AdditionalImages from the entity, not included in the import)
15 = ParametricsCleanUp (Remove all Parametrics from the entity, not included in the import)
16 = TranslationRequested

Items Enum: "ManufacturerPartNo" "SortOrderValue" "StockDisplayBreakPoint" "IsDangerousGoods" "Cultures" "Skus" "MainImage" "AdditionalImages" "VariantParametrics" "VariantParametricsCreateOnly" "NonParametricVariantDefinitions" "NonParametricVariantDefinitionsCreateOnly" "DeliveryMethods" "DeliveryMethodsCreateOnly" "AdditionalImagesCleanUp" "ParametricsCleanUp" "TranslationRequested"

Relation

PartNo
required
string

Part number for the SKU with relations.

RelatedPartNo
required
string

Part number for the related SKU.

RelationTypeCode
required
string

Code for the desired client defined relation type.

Array of objects <RelationCulture> (RelationCulture)

List of cultures for the relation.

IsActive
boolean

Sets the relation to active or inactive.

IsRelatedVariantUnique
boolean

True if the related product is variant unique.

IsVariantUnique
boolean

True if the relation is variant unique.

SortOrder
integer <int32>

Sort order for this relation on the SKU.

RelationCulture

CultureCode
required
string

Culture code for this specific culture (e.g. "en-US")

Description
string

Description for the relation.

DescriptionHeader
string

Description header for the relation.

Name
string

Relation name

SubDescription
string

Sub description for the relation.

SubHeader
string

Sub header for the relation.

RelationHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

FullFile
required
boolean

If set to true. Relations not in the file will be deactivated.

RelationFieldsThatAreSet
required
Array of strings

Specifies which relation fields that should be created/updated.
(Use the integer instead of the name for the xml content type)

0 = ManufacturerPartNo
1 = SortOrderValue
2 = StockDisplayBreakPoint
1 = IsActive
2 = IsVariantUnique
3 = IsVariantUniqueCreateOnly (Value is only set if the relation entity is created by the import)
4 = IsRelatedVariantUnique
5 = IsRelatedVariantUniqueCreateOnly (Value is only set if the relation entity is created by the import)
6 = DefaultName
7 = DefaultSubHeader
8 = DefaultSubDescription
9 = DefaultDescriptionHeader
10 = DefaultDescription
11 = Cultures (required if you have RelationCultureFieldsThatAreSet values)
12 = SortOrder

Items Enum: "IsActive" "IsVariantUnique" "IsVariantUniqueCreateOnly" "IsRelatedVariantUnique" "IsRelatedVariantUniqueCreateOnly" "DefaultName" "DefaultSubHeader" "DefaultSubDescription" "DefaultDescriptionHeader" "DefaultDescription" "Cultures" "SortOrder"
RelationCultureFieldsThatAreSet
Array of strings

Specifies which relation culture fields that should be created/updated.
Required settings: Culture (in RelationFieldsThatAreSet)
(Use the integer instead of the name for the xml content type)

1 = Name
2 = NameCreateOnly (Value is only set if the relation culture entity is created by the import)
3 = SubHeader
4 = SubDescription
5 = DescriptionHeader
6 = Description
7 = DescriptionCreateOnly (Value is only set if the relation culture entity is created by the import)

Items Enum: "Name" "NameCreateOnly" "SubHeader" "SubDescription" "DescriptionHeader" "Description" "DescriptionCreateOnly"

Sku

PartNo
required
string

SKU part no.

ActualWeight
number

SKU weight. If null is imported will be set to inherit from category.

CommodityCode
string

Commodity code.

Array of objects <SkuCulture> (SkuCulture)

List of SKU information translations.

DiscountClass
string

Discount class.

EanCode
string

EAN code, or GS1 code.

IntegrationPartNo
string

The replaceable sku in other systems than Norce Commerce. Used when Norce Commerce has SKU's other systems does not recognize and the integration partno is sent instead.

IsBuyable
boolean

Determines if SKU can be bought.

IsDropShipOnly
boolean

Determines if SKU can only be sold using drop shipment.

IsRecommendedSalesQtyFixed
boolean

Determines if recommended sales quantity is fixed.

LogisticDepth
number

SKU depth

LogisticHeight
number

SKU height

LogisticWidth
number

SKU width

RecommendedSalesQty
number

Recommended sales quantity

object <SkuPriceList> (SkuPriceList)

SKU price information. Send to Norce Commerce the price information that should be updated. Use the header fields to control what is updated. Any values that are null or 0 will be ignored (not overwrite current value in Norce), but if the field (e.g. PriceSale) is listed in IgnoreSkuPriceListFieldsWhenEmpty will cause the entire price entity to be ignored.

StartDate
string <DateTime>

SKU activation time.

Status
integer <int32>

SKU status.
1 = Active
2 = Coming
3 = Expiring
4 = Hidden
5 = Inactive
6 = NotActivated

StopDate
string <DateTime>

SKU deactivation time.

Array of objects <SkuStructureItem> (SkuStructureItem)

List of items included in SKU structure.

TrackingCode
string

Tracking code.

Type
integer

SKU type.
1 = ErpStandard
2 = ErpRefurbished
3 = Freight
4 = Insurance
8 = Structure
9 = Invoice
11 = Service
14 = Standard
15 = ErpExtended
16 = ErpStandardNoStock
17 = ErpPackage
19 = ErpTempOutOfStock
20 = EnvironmentalFee
21 = PackingFee
24 = ErpPackageWithCalc
25 = DisplayOnly
29 = ErpStandard2
33 = License

UnitOfMeasurementCount
number

Number of units in the specified type.

UnitOfMeasurementType
integer

Unit of measurement type.
1 = Pieces
2 = Hour
3 = Kilogram
4 = Litre
5 = Pair
6 = SquareMeter
7 = Meter

Array of objects <VatRate> (VatRate)

List of VAT rates applicable for SKU.

VolumeWeight
number

Deprecated. If required add as parameter instead.

SkuCulture

CultureCode
required
string

Culture code, e.g. "en-GB"

Comment
string

Translated comment.

ErpName
string

Translated ERP name.

SkuOnhand

LocationCode
required
string

Location code. Used for SKU location matching in Norce Commerce.

PartNo
required
string

SKU part number.

WarehouseCode
required
string

Warehouse code. Used for warehouse matching in Norce Commerce.

IncomingValue
number

Quantity of items that is purchased from a supplier but not yet recevied to the warehouse.

Array of objects <Info> (Info)

Additional on hand information defined by 3rd party and configured in Norce Commerce administration GUI.

IsActive
boolean

Sets warehouse SKU information to active or inactive.

LeadTimeDayCount
integer <int32>

Indication of time required for delivery from this warehouse for this product.

MaximumValue
number

Target stock level (max value)

MinimumValue
number

Reorder point (min value)

NextDeliveryDate
string <DateTime>

Determines when the next delivery of items to warehouse is expected to occur.

OnOrderValue
number

Deprecated

OnhandValue
number

Quantity of items on the shelf in the specified warehouse.

SkuOnhandHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

FullFile
required
boolean

If set to true, all onHand records for the warehouses and locations in the import that is NOT included, will be deactivated.

SkuOnhandFieldsThatAreSet
required
Array of strings

Specifies which SKU on hand fields to be updated.
(Use the integer instead of the name for the xml content type)

3 = OnhandValue
4 = IncomingValue
5 = NextDeliveryDate
6 = LeadTimeDayCount
7 = OnOrderValue (Deprecated, not supported any longer)
8 = MinimumValue
9 = MaximumValue
10 = IsActive
11 = Infos

Items Enum: "OnhandValue" "IncomingValue" "NextDeliveryDate" "LeadTimeDayCount" "OnOrderValue" "MinimumValue" "MaximumValue" "IsActive" "Infos"
JobId
string

Norce Commerce Connect job id. Only exists in import logs. Should be omitted in the import request.

SerializationType
Array of strings

Request serialization type.(Use the integer instead of the name for the xml content type)

0 = JSON, 1 = XML

Items Enum: "JSON" "XML"
StorageName
string

Location of the import file on Norce's file area. Can be used instead of sending data directly in payload.

SupplierId
integer <int32>

Derived from base header. Ignored in on hand import.

SkuPriceList

PartNo
required
string

SKU part number.

PriceListCode
required
string

Agreement code on the price list. Used for matching in Norce Commerce.

CostPurchase
number

Purchase cost from supplier.

CostUnit
number

Unit cost.

CurrencyCode
string

Currency code in ISO 4217 format, e.g. "SEK", "EUR", "USD".

IsActive
boolean

Sets SKU price to active or inactive.

IsPriceDiscountable
boolean

Determines if discounts can be applied to the price.

PriceCatalog
number

Catalog price.

PricePrevious
number

Previous price. Can be used to show discounts.

PriceRecommended
number

Recommended sale price.

PriceRule
integer <int32>

Price rule for this SKU.
1 = CostPlus_PurchaseCost
2 = FixedPrice
3 = Margin_PurchaseCost
4 = UseRecommendedPrice
5 = CostPlus_UnitCost
6 = Margin_UnitCost
7 = UseStandardPrice_PctDiscount
8 = Competitive_PurchaseCost
9 = Competitive_UnitCost
10 = UseStandardPrice_FixedDiscount
11 = StructureCalculation
12 = UseCatalogPrice

PriceRuleValue
number

Value to apply for selected Price Rule.

PriceSale
number

Sale price.

QuantityBreak
integer <int32>

Threshold which determines minimum quantity of items required for specified price list to be applied.

SkuPriceListHeader

AccountId
required
integer <int32>

Account which initiated the import. Learn about system accounts here.

FullFile
required
boolean

If set to true, all price records for the price lists in the import that is NOT included, will be deactivated.

IgnoreSkuPriceListFieldsWhenEmpty
Array of strings

Specifies which SKU price list fields that are mandatory. If this field is missing in the import this specific price entity will be ignored.
Required settings: All fields added here must be in SkuPriceListFieldsThatAreSet
(Use the integer instead of the name for the xml content type)

3 = PriceSale
4 = CostPurchase
5 = CostUnit
6 = PriceRecommended
7 = PricePrevious
8 = PriceCatalog
10 = IsActive

Items Enum: "PriceSale" "CostPurchase" "CostUnit" "PriceRecommended" "PricePrevious" "PriceCatalog" "IsActive"
SkuPriceListFieldsThatAreSet
required
Array of strings

Specifies which SKU price list fields to be updated.
(Use the integer instead of the name for the xml content type)

3 = PriceSale
4 = CostPurchase
5 = CostUnit
6 = PriceRecommended
7 = PricePrevious
8 = PriceCatalog
9 = IsPriceDiscountable
10 = IsActive
11 = IsPriceDiscountableCreateOnly (Value is only set if the sku price list entity is created by the import)
12 = PriceRule
13 = FullfileResetInheritance

Items Enum: "PriceSale" "CostPurchase" "CostUnit" "PriceRecommended" "PricePrevious" "PriceCatalog" "IsPriceDiscountable" "IsActive" "IsPriceDiscountableCreateOnly" "PriceRule" "FullfileResetInheritance"
JobId
string

Norce Commerce Connect job id. Only exists in import logs. Should be omitted in the import request.

SerializationType
Array of strings

Request serialization type.(Use the integer instead of the name for the xml content type)

0 = JSON, 1 = XML

Items Enum: "JSON" "XML"
StorageName
string <uri>

Location of the import file on Norce's file area. Can be used instead of sending data directly in payload.

SupplierId
integer <int32>

Derived from base header. Ignored in SKU price list import.

SkuStructureItem

PartNo
required
string

Part number of item to add to structure

Quantity
required
number

Quantity of items included in structure

StructurePartNo
required
string

Structure item part number, the parent package part number.

Array of objects <Info> (Info)

List of additional 3rd party information fields.

SortOrder
integer <int32>

Item sort order in structure.

object <SkuStructureItemPriceList> (SkuStructureItemPriceList)

Structure item price list information.

SkuStructureItemPriceList

CurrencyCode
required
string

Currency code in ISO 4217 format, e.g. "SEK", "EUR", "USD".

ItemPriceListCode
required
string

Structure item price list code. Used for price list matching in Norce Commerce.

PartNo
required
string

This item part number.

PriceListCode
required
string

Structure price list code (parent). Used for price list matching in Norce Commerce.

PriceSale
required
number

Structure item sale price

StructurePartNo
required
string

Structure item part number, the parent package part number.

QuantityBreak
integer <int32>

Minimum quantity required for a price rule to be applied.

Variant

ManufacturerPartNo
required
string

Manufacturer part number.

Array of objects <Image> (Image)

List of additional images.

Array of objects <VariantCulture> (VariantCulture)

List of translated variant information fields.

Array of objects <DeliveryMethod> (DeliveryMethod)

List of delivery methods applicable to variant. Use this to restrict which delivery methods that is allowed on the product.

IsDagerousGoods
boolean

Determines if a variant is dangerous goods.

object <Image> (Image)

Product image information.

Array of objects <VariantDefinition> (VariantDefinition)

List of variant definitions.

Array of objects <Sku> (Sku)

List of SKUs associated to variant.
NOTE: Only one SKU is allowed, multiple SKUs creation for the same product is deprecated, use variantization instead.

SortOrderValue
integer <int32>

Sort order of variant among all the variants.

Array of objects <Flag> (Flag)

Stock display break point. Can be used to change the stock value that is displayed.

Array of objects <Flag> (Flag)

List of flags applied to variant.

Array of objects <ParametricValue> (ParametricValue)

List of parametrics applied to variant.

VariantCulture

CultureCode
required
string

Culture code, e.g. "en-GB".

IsUniqueUrlNameManuallyMaintained
boolean

Determines if UniqueUrlName is manually maintained.

Name
string

Translated variant name.

UniqueUrlName
string <uri>

Unique URL

VariantDefinition

TypeCode
required
string

Variant type code. Used for variant type matching in Norce Commerce.

Array of objects <VariantDefinitionCulture> (VariantDefinitionCulture)

List of translated variant definitions.

VariantDefinitionCulture

CultureCode
required
string

Culture code, e.g. "en-GB"

Value
required
string

Translated definition value.

VariantDefinitionGroup

Code
required
string

Variant definition group code.

Name
string

Variant definition group name.

Array of objects <VariantDefinitionType> (VariantDefinitionType)

List of variant definition types.

VariantDefinitionType

Code
required
string

Variant definition type code. Used for variant type matching in Norce Commerce.

Name
string

Type name.

ParametricCode
string

Variant definition type parametric code.

SortOrder
integer <int32>

Sort order.

VatRate

Rate
number

VAT rate

SalesArea
required
integer <int32>

Sales area identifier.
1 = Sweden
2 = Norway
3 = Denmark
4 = Finland
5 = UnitedKingdom
6 = Estonia
7 = Greenland
8 = Germany
9 = Italy
10 = Austria
11 = Spain
12 = Netherlands
13 = Belgium
14 = France
15 = Switzerland
17 = USA
18 = Ireland
19 = Canada
20 = Lithuania
21 = Latvia
22 = Japan
23 = SouthKorea
24 = Australia
25 = Europe
26 = Poland
27 = CzechRepublic
28 = Russia
29 = NoVAT
36 = Bulgaria
37 = Croatia
38 = Cyprus
39 = Greece
40 = Hungary
41 = Luxembourg
42 = Malta
43 = Portugal
44 = Romania
45 = Slovakia
46 = Slovenia

Warehouse

Code
required
string

Warehouse code. Used for warehouse matching in Norce Commerce.

required
Array of objects <WarehouseLocation> (WarehouseLocation)

List of warehouse locations.

LeadTimeDayCount
integer <int32>

Indication of time required for delivery

Name
string

Warehouse name.

Type
integer <int32>

Warehouse type.
1 = Warehouse
2 = Store
3 = Transport
4 = Other

WarehouseLocation

Code
required
string

Location code. Used for location matching in Norce Commerce.

IsIncludedInStockCalculation
boolean

Determines if a location is part of central warehouse stock calculation.

LeadTimeDayCount
integer <int32>

Indication of time required for delivery.

Name
string

Location name.