The Products Namespace in Norce Commerce Query has the entities and methods of all product related data.
ProductId. Key property.
FlagId. Key property.
ClientId.
IsActive.
StoppedDate. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Id. Key property.
ClientId.
ManufacturerId.
ManufacturerPartNo. MaxLength: 50. Nullable.
DefaultName. MaxLength: 255. Nullable.
DefaultSubHeader. MaxLength: 255. Nullable.
DefaultSubDescription. Nullable.
DefaultDescriptionHeader. MaxLength: 255. Nullable.
DefaultDescription. Nullable.
DefaultImagePath. MaxLength: 255. Nullable.
DefaultThumbnailImagePath. MaxLength: 255. Nullable.
DefaultCampaignImagePath. MaxLength: 255. Nullable.
DefaultLargeImagePath. MaxLength: 255. Nullable.
DefaultSynonyms. MaxLength: 500. Nullable.
SortOrderValue. Nullable.
AssortmentId. Nullable.
AssortmentLastUpdated. Nullable.
AssortmentLastUpdatedBy. Nullable.
IsVariant.
VariantId. Nullable.
Alias. MaxLength: 255. Nullable.
DefaultTitle. MaxLength: 255. Nullable.
DefaultTags. Nullable.
DefaultMetaTags. Nullable.
DefaultMetaDescription. Nullable.
HideInTopList. Nullable.
IsActive.
StoppedDate. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
InsuranceCurrencyId. Nullable.
InsuranceStartPrice. Nullable.
InsuranceRunningPercentage. Nullable.
Key.
ManufacturerPartNo2. MaxLength: 50. Nullable.
ImageKey. Nullable.
DefaultUniqueUrlName. MaxLength: 500. Nullable.
StockDisplayBreakPoint. Nullable.
IsDangerousGoods.
Code. MaxLength: 50. Nullable.
IsRecurringOrderable. Nullable.
DefaultExternalDescription. Nullable.
UnspscCode. MaxLength: 50. Nullable.
TranslationRequested. Nullable.
TranslationRequestedBy. Nullable.
Skus.
Categories.
Cultures.
SupplierSkus.
Parametrics.
ParametricMultiple.
Flags.
Families.
Accessories.
Upsell.
Crossell.
VariantTypes.
Files.
Popularities.
ProductRelations.
ProductId. Key property.
ClientId.
AccessoryProductId.
TypeId.
SortOrder. Nullable.
PopulationRuleId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsProductVariantUnique.
IsAccessoryProductVariantUnique.
Cultures.
ProductId. Key property.
AccessoryProductId. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId.
Name. MaxLength: 255. Nullable.
SubHeader. MaxLength: 255. Nullable.
SubDescription. Nullable.
DescriptionHeader. MaxLength: 255. Nullable.
Description. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ProductId. Key property.
CategoryId. Key property.
ClientId.
IsPrimary.
SortOrder. Nullable.
ProductSortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ProductId. Key property.
ClientId.
CrossellProductId.
SortOrder. Nullable.
PopulationRuleId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsProductVariantUnique.
IsCrossellProductVariantUnique.
ProductId. Key property.
CultureCode. MaxLength: 16. Key property.
Name. MaxLength: 255. Nullable.
NameLastUpdated. Nullable.
NameLastUpdatedBy. Nullable.
SubHeader. MaxLength: 255. Nullable.
SubHeaderLastUpdated. Nullable.
SubHeaderLastUpdatedBy. Nullable.
SubDescription. Nullable.
SubDescriptionLastUpdated. Nullable.
SubDescriptionLastUpdatedBy. Nullable.
DescriptionHeader. MaxLength: 255. Nullable.
DescriptionHeaderLastUpdated. Nullable.
DescriptionHeaderLastUpdatedBy. Nullable.
Description. Nullable.
DescriptionLastUpdated. Nullable.
DescriptionLastUpdatedBy. Nullable.
ImagePath. MaxLength: 255. Nullable.
ThumbnailImagePath. MaxLength: 255. Nullable.
CampaignImagePath. MaxLength: 255. Nullable.
LargeImagePath. MaxLength: 255. Nullable.
ImageLastUpdated. Nullable.
ImageLastUpdatedBy. Nullable.
Synonyms. MaxLength: 500. Nullable.
SynonymsLastUpdated. Nullable.
SynonymsLastUpdatedBy. Nullable.
Title. MaxLength: 255. Nullable.
Tags. Nullable.
MetaTags. Nullable.
MetaDescription. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
UniqueUrlName. MaxLength: 500. Nullable.
IsUniqueUrlNameManuallyMaintained.
ImageKey. Nullable.
ExternalDescription. Nullable.
ClientId.
ProductId. Key property.
FamilyId. Key property.
ClientId.
IsPrimary.
SortOrder. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Id. Key property.
ProductId.
ClientId.
FileId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. Nullable.
DefaultPath. Nullable.
DefaultThumbnailPath. MaxLength: 255. Nullable.
DefaultSize. MaxLength: 50. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
FileKey. Nullable.
IsVariantUnique.
Code. MaxLength: 255. Nullable.
SortOrder. Nullable.
ProductId. Key property.
ParametricId. Key property.
ClientId.
DefaultVarcharValue. MaxLength: 255. Nullable.
DefaultHtmlValue. Nullable.
IntegerValue. Nullable.
DecimalValue. Nullable.
BooleanValue. Nullable.
DateValue. Nullable.
ListId. Nullable.
NormalizedValue. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsVariantUnique.
Cultures.
ProductId. Key property.
ParametricId. Key property.
ClientId.
CultureCode. MaxLength: 16. Nullable.
VarcharValue. MaxLength: 255. Nullable.
HtmlValue. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
ProductId. Key property.
ParametricId. Key property.
MultipleId. Key property.
ClientId.
Updated. Nullable.
UpdatedBy. Nullable.
ProductId. Key property.
SourceId. Key property.
ClientId.
CategoryRank. Nullable.
CategoryRankMax. Nullable.
TotalRank.
Rating. Nullable.
Updated.
UpdatedBy.
Value. Nullable.
Id.
ApplicationId. Nullable.
Id. Key property.
ClientId.
ProductId. Nullable.
RelatedProductId.
TypeId.
SortOrder. Nullable.
PopulationRuleId. Nullable.
IsProductVariantUnique.
IsRelatedProductVariantUnique.
DefaultName. MaxLength: 255. Nullable.
DefaultSubHeader. MaxLength: 255. Nullable.
DefaultSubDescription. Nullable.
DefaultDescriptionHeader. MaxLength: 255. Nullable.
DefaultDescription. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Cultures.
RelationId. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId.
Name. MaxLength: 255. Nullable.
SubHeader. MaxLength: 255. Nullable.
SubDescription. Nullable.
DescriptionHeader. MaxLength: 255. Nullable.
Description. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
PartNo. MaxLength: 50. Key property.
ProductId.
ClientId.
StatusId.
StatusLastUpdated. Nullable.
StatusLastUpdatedBy. Nullable.
TypeId.
IntegrationPartNo. MaxLength: 50. Nullable.
ErpName. MaxLength: 255. Nullable.
DefaultComment. MaxLength: 255. Nullable.
CommodityCode. MaxLength: 50. Nullable.
EanCode. MaxLength: 50. Nullable.
TrackingCode. MaxLength: 50. Nullable.
GrossWeight. Nullable.
NetWeight. Nullable.
FreightClassId. Nullable.
UnitOfMeasurementId. Nullable.
UnitOfMeasurementCount.
PackageId. Nullable.
TrackingCodeTypeId. Nullable.
Url. MaxLength: 255. Nullable.
ImagePath. MaxLength: 255. Nullable.
IsDropShipOnly. Nullable.
IsPublished.
PublishedLastUpdated. Nullable.
PublishedLastUpdatedBy. Nullable.
IsBlocked.
BlockedLastUpdated. Nullable.
BlockedLastUpdatedBy. Nullable.
PopulationRuleId. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
LastChecked. Nullable.
TrackingModeTypeId. Nullable.
IsStatusLocked.
StatusLockedDate. Nullable.
StatusLockedBy. Nullable.
RecommendedSalesQty. Nullable.
LogisticWidth. Nullable.
LogisticHeight. Nullable.
LogisticDepth. Nullable.
IsBuyable.
BuyableLastUpdated. Nullable.
BuyableLastUpdatedBy. Nullable.
DiscountClass. MaxLength: 50. Nullable.
IsRecommendedSalesQtyFixed. Nullable.
StartDate. Nullable.
EndDate. Nullable.
Cultures.
PriceLists.
SalesAreas.
OnHands.
StructureItems.
BestPrices.
PartNo. MaxLength: 50. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId.
ErpName. MaxLength: 255. Nullable.
Comment. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
PartNo. MaxLength: 50. Key property.
WarehouseId. Key property.
LocationId. Key property.
ClientId.
OnHandValue.
OnHandLastChecked. Nullable.
OnHandLastUpdated. Nullable.
OnHandLastUpdatedBy. Nullable.
IncomingValue. Nullable.
IncomingLastChecked. Nullable.
IncomingLastUpdated. Nullable.
IncomingLastUpdatedBy. Nullable.
NextDeliveryDate. Nullable.
NextDeliveryLastChecked. Nullable.
NextDeliveryLastUpdated. Nullable.
NextDeliveryLastUpdatedBy. Nullable.
IsReturnable.
LeadTimeDayCount. Nullable.
OnOrderValue. Nullable.
MinimumValue. Nullable.
MaximumValue. Nullable.
IsActive.
StoppedDate. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ReservationValue.
IsActiveLastUpdated. Nullable.
IsActiveLastUpdatedBy. Nullable.
Info.
PartNo. MaxLength: 50. Key property.
WarehouseId. Key property.
LocationId. Key property.
TypeId. Key property.
Id.
ClientId.
Value. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
PartNo. MaxLength: 50. Key property.
PriceListId. Key property.
QtyBreak. Key property.
TypeId. Key property.
Id.
ClientId.
Value. MaxLength: 255. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
PartNo. MaxLength: 50. Key property.
PriceListId. Key property.
QtyBreak. Key property.
ClientId.
CurrencyId.
PriceSale.
PriceSaleLastUpdated. Nullable.
PriceSaleLastUpdatedBy. Nullable.
PriceRuleId. Nullable.
PriceRuleValue. Nullable.
CostPurchase.
CostPurchaseLastUpdated. Nullable.
CostPurchaseLastUpdatedBy. Nullable.
CostUnit.
CostUnitLastUpdated. Nullable.
CostUnitLastUpdatedBy. Nullable.
SupplementChargePercentage. Nullable.
PriceStandard. Nullable.
PriceRecommended. Nullable.
PriceRecommendedLastUpdated. Nullable.
PriceRecommendedLastUpdatedBy. Nullable.
PricePrevious. Nullable.
PricePreviousLastUpdated. Nullable.
PricePreviousLastUpdatedBy. Nullable.
PriceCatalog. Nullable.
PriceCatalogLastUpdated. Nullable.
PriceCatalogLastUpdatedBy. Nullable.
IsPriceDiscountable.
ChosenSupplierId. Nullable.
ChosenSupplierPartNo. MaxLength: 50. Nullable.
ChosenSupplierPriceListId. Nullable.
ChosenSupplierQtyBreak. Nullable.
IsChosenSupplierLocked.
IsActive.
StoppedDate. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
LastChecked. Nullable.
MinimumMarginPercentage. Nullable.
PriceRuleLastUpdated. Nullable.
PriceRuleLastUpdatedBy. Nullable.
PricingId. Nullable.
SupplementCharge. Nullable.
LimitToPriceRecommended. Nullable.
IsActiveLastUpdated. Nullable.
IsActiveLastUpdatedBy. Nullable.
Info.
PartNo. MaxLength: 50. Key property.
SalesAreaId. Key property.
ClientId.
VatCodeId. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
StructurePartNo. MaxLength: 50. Key property.
PartNo. MaxLength: 50. Key property.
ClientId.
Qty.
SortOrder. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
GroupId. Nullable.
PriceLists.
Info.
StructurePartNo. MaxLength: 50. Key property.
PartNo. MaxLength: 50. Key property.
Code. MaxLength: 50. Key property.
ClientId.
Value. MaxLength: 255. Nullable.
Updated.
UpdatedBy.
StructurePartNo. MaxLength: 50. Key property.
PartNo. MaxLength: 50. Key property.
PriceListId. Key property.
QtyBreak. Key property.
ClientId.
ItemPriceListId.
CurrencyId.
PriceSale.
PriceRuleId. Nullable.
PriceRuleValue. Nullable.
CostPurchase.
CostUnit.
SupplementChargePercentage. Nullable.
PriceStandard. Nullable.
PriceRecommended. Nullable.
MinimumMarginPercentage. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
SupplementCharge. Nullable.
LimitToPriceRecommended. Nullable.
ProductId. Key property.
ClientId.
UpsellProductId.
DefaultDescription. Nullable.
SortOrder. Nullable.
PopulationRuleId. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
IsProductVariantUnique.
IsUpsellProductVariantUnique.
Cultures.
ProductId. Key property.
UpsellProductId. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId.
Description. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
Id. Key property.
ClientId.
DefaultName. MaxLength: 50. Nullable.
DefaultDescription. MaxLength: 500. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Code. MaxLength: 50. Nullable.
Cultures. Nullable.
ProductId. Key property.
TypeId. Key property.
ClientId.
DefaultValue. MaxLength: 50. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
Cultures.
ProductId. Key property.
TypeId. Key property.
ClientId.
CultureCode. MaxLength: 16. Nullable.
Value. MaxLength: 50. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
Id. Key property.
SupplierId.
ManufacturerId. Nullable.
ManufacturerCode. MaxLength: 50. Nullable.
DefaultName. MaxLength: 50. Nullable.
Code. MaxLength: 50. Nullable.
Description. MaxLength: 100. Nullable.
EndCustomer. MaxLength: 100. Nullable.
StartDate. Nullable.
EndDate. Nullable.
TransferMethodId. Nullable.
TransferMethodValue. MaxLength: 255. Nullable.
LastImported. Nullable.
NextExpectedDate. Nullable.
IsPrimary.
ParentSupplierPriceListId. Nullable.
Contact. MaxLength: 50. Nullable.
Comment. MaxLength: 50. Nullable.
IsSpecialTerms. Nullable.
IsManuallyMaintained.
IgniteSourceId. Nullable.
IgniteSourceLastImported. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
CurrencyId. Nullable.
TraderaStockCodeSeed. Nullable.
TraderaExternalStockCodeSeed. Nullable.
ClientId. Nullable.
PartNo. MaxLength: 50. Key property.
SupplierId. Key property.
Name. MaxLength: 500. Nullable.
ManufacturerId. Nullable.
ManufacturerCode. MaxLength: 50. Nullable.
ManufacturerPartNo. MaxLength: 50. Nullable.
CategoryId. Nullable.
CategoryCode. MaxLength: 255. Nullable.
CommodityCode. MaxLength: 50. Nullable.
EanCode. MaxLength: 50. Nullable.
GrossWeight. Nullable.
NetWeight. Nullable.
VatCodeId. Nullable.
UnitOfMeasurementId.
UnitOfMeasurementCount.
Url. MaxLength: 255. Nullable.
ImagePath. MaxLength: 255. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ImagePathLastUpdated. Nullable.
IsUsed.
LogisticWidth. Nullable.
LogisticHeight. Nullable.
LogisticDepth. Nullable.
ClientId. Nullable.
ProductId. Nullable.
SupplierProductSkuClient.
OnHands.
PriceLists.
Info.
PartNo. MaxLength: 50. Key property.
SupplierId. Key property.
ClientId.
ProductId. Nullable.
ManufacturerId. Nullable.
CategoryId. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
PartNo. MaxLength: 50. Key property.
SupplierId. Key property.
Code. MaxLength: 50. Key property.
Value. MaxLength: 255. Nullable.
Updated.
UpdatedBy.
PartNo. MaxLength: 50. Key property.
SupplierId. Key property.
WarehouseId. Nullable. Key property.
LocationId. Key property.
OnHandValue.
OnHandLastChecked. Nullable.
OnHandLastUpdated. Nullable.
OnHandLastUpdatedBy. Nullable.
IncomingValue. Nullable.
IncomingLastChecked. Nullable.
IncomingLastUpdated. Nullable.
IncomingLastUpdatedBy. Nullable.
NextDeliveryDate. Nullable.
NextDeliveryLastChecked. Nullable.
NextDeliveryLastUpdated. Nullable.
NextDeliveryLastUpdatedBy. Nullable.
IsReturnable. Nullable.
LeadTimeDayCount. Nullable.
IsActive.
StoppedDate. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ExternalStockValue. Nullable.
PackageValue.
MinimumOrderValue.
ClientId. Nullable.
PartNo. MaxLength: 50. Key property.
SupplierId. Key property.
SupplierPriceListId. Nullable. Key property.
QtyBreak. Key property.
CurrencyId.
CostPurchase.
CostPurchaseLastChecked. Nullable.
CostPurchaseLastUpdated. Nullable.
CostPurchaseLastUpdatedBy. Nullable.
CostPurchaseValidTo. Nullable.
PriceRecommended. Nullable.
PriceRecommendedLastUpdated. Nullable.
PriceRecommendedLastUpdatedBy. Nullable.
PriceMax. Nullable.
PriceMaxLastUpdated. Nullable.
PriceMaxLastUpdatedBy. Nullable.
PriceDealer. Nullable.
PriceDealerLastUpdated. Nullable.
PriceDealerLastUpdatedBy. Nullable.
IsActive.
IsActiveLastUpdated. Nullable.
StoppedDate. Nullable.
IsPromotion. Nullable.
IsFocus. Nullable.
PriceRanking. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
FreightCost. Nullable.
CostFee. Nullable.
CostFeeLastUpdated. Nullable.
CostFeeLastUpdatedBy. Nullable.
DiscountPct. Nullable.
DiscountPctLastUpdated. Nullable.
DiscountPctLastUpdatedBy. Nullable.
PriceCatalog. Nullable.
PriceCatalogLastUpdated. Nullable.
PriceCatalogLastUpdatedBy. Nullable.
ClientId. Nullable.
Id. Key property.
ClientId.
DefaultName. MaxLength: 255. Nullable.
DefaultImagePath. MaxLength: 255. Nullable.
DefaultThumbnailImagePath. MaxLength: 255. Nullable.
DefaultCampaignImagePath. MaxLength: 255. Nullable.
DefaultLargeImagePath. MaxLength: 255. Nullable.
GroupId. Nullable.
Alias. MaxLength: 255. Nullable.
DefaultTitle. MaxLength: 255. Nullable.
DefaultTags. Nullable.
DefaultMetaTags. Nullable.
DefaultMetaDescription. Nullable.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
ImageKey. Nullable.
Code. MaxLength: 50. Nullable.
DefaultUniqueUrlName. MaxLength: 500. Nullable.
Key.
Cultures.
Products.
VariantId. Key property.
CultureCode. MaxLength: 16. Key property.
ClientId. Key property.
Name. MaxLength: 255. Nullable.
ImagePath. MaxLength: 255. Nullable.
ThumbnailImagePath. MaxLength: 255. Nullable.
CampaignImagePath. MaxLength: 255. Nullable.
LargeImagePath. MaxLength: 255. Nullable.
Title. MaxLength: 255. Nullable.
Tags. Nullable.
MetaTags. Nullable.
MetaDescription. Nullable.
Updated. Nullable.
UpdatedBy. Nullable.
UniqueUrlName. MaxLength: 500. Nullable.
IsUniqueUrlNameManuallyMaintained.
ImageKey. Nullable.
NameLastUpdated. Nullable.
NameLastUpdatedBy. Nullable.
Id. Key property.
DefaultName. MaxLength: 50. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.
Id. Key property.
DefaultName. MaxLength: 50. Nullable.
IsActive.
Created.
CreatedBy.
Updated. Nullable.
UpdatedBy. Nullable.