Product

Field Code

Description

ProductCode

Product SKU

Name

Product name

ShortDescription

Product Short Description

Category

Product category

Type

“Stock” or “Service”

Company

Company name

DatePrinted

Date when the document is generated

CostingMethod

Product costing method

Length

Product length dimension value

Width

Product width dimension value

Height

Product height dimension value

DimensionUnits

Dimension Unit of measure

Weight

Product weight

UnitofMeasure

Product unit of measure

Barcode

Product Barcode value

MinimumBeforeReorder

Product stock level below which Reorder function becomes active for this product

ReorderQuantity

Quantity of the product to reorder when it’s available quantity falls below Minimum Before Reorder level. If 0 is specified then Product is not included in reorder. Has no effect on Reorder Backordered stock function

DefaultLocation

Product location by default

PriceTier1Name

Name of Price tier 1 as defined in General Settings

PriceTier2Name

Name of Price tier 2 as defined in General Settings

PriceTier3Name

Name of Price tier 3 as defined in General Settings

PriceTier4Name

Name of Price tier 4 as defined in General Settings

PriceTier5Name

Name of Price tier 5 as defined in General Settings

PriceTier6Name

Name of Price tier 6 as defined in General Settings

PriceTier7Name

Name of Price tier 7 as defined in General Settings

PriceTier8Name

Name of Price tier 8 as defined in General Settings

PriceTier9Name

Name of Price tier 9 as defined in General Settings

PriceTier10Name

Name of Price tier 10 as defined in General Settings

Price1

Product Tier 1 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price2

Product Tier 2 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price3

Product Tier 3 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price4

Product Tier 4 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price5

Product Tier 5 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price6

Product Tier 6 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price7

Product Tier 7 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price8

Product Tier 8 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price9

Product Tier 9 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

Price10

Product Tier 10 Price. Will be 0 if no access to Prices information is granted for current user on Product page.

HasBOM

“Yes” if product has Bill of Materials, otherwise “No”

AverageCost

Product average cost

FamilyName

Product family name

Description

Product Description (multiline)

AttributeSet

Name of the product additional attribute set

AdditionalAttribute1Name

Name of the attribute 1 of the attribute set assigned to product

AdditionalAttribute2Name

Name of the attribute 2 of the attribute set assigned to product

AdditionalAttribute3Name

Name of the attribute 3 of the attribute set assigned to product

AdditionalAttribute4Name

Name of the attribute 4 of the attribute set assigned to product

AdditionalAttribute5Name

Name of the attribute 5 of the attribute set assigned to product

AdditionalAttribute6Name

Name of the attribute 6 of the attribute set assigned to product

AdditionalAttribute7Name

Name of the attribute 7 of the attribute set assigned to product

AdditionalAttribute8Name

Name of the attribute 8 of the attribute set assigned to product

AdditionalAttribute9Name

Name of the attribute 9 of the attribute set assigned to product

AdditionalAttribute10Name

Name of the attribute 10 of the attribute set assigned to product

AdditionalAttribute1

Value of the product additional attribute 1

AdditionalAttribute2

Value of the product additional attribute 2

AdditionalAttribute3

Value of the product additional attribute 3

AdditionalAttribute4

Value of the product additional attribute 4

AdditionalAttribute5

Value of the product additional attribute 5

AdditionalAttribute6

Value of the product additional attribute 6

AdditionalAttribute7

Value of the product additional attribute 7

AdditionalAttribute8

Value of the product additional attribute 8

AdditionalAttribute9

Value of the product additional attribute 9

AdditionalAttribute10

Value of the product additional attribute 10

DiscountRule

Product Discount rule name. “No Discount” if no rule is assigned

Status

“Active” or “Deprecated”

Tags

Product Tags

FamilyOption1Value

Product family option 1 value. Only filled in when Product is part of the family

FamilyOption2Value

Product family option 2 value. Only filled in when Product is part of the family

FamilyOption3Value

Product family option 3 value. Only filled in when Product is part of the family

QuantityToProduce

Specified number of units of the product that will be manufactured when specified quantities in BOM are used

StockLocator

Product stock locator

KitAutoAssembly

Kit / Auto-assembly option. “Yes” or “No”.

COGSAccount

[Account Code]: [Account Name] for COGS account if selected for the product. Only for Stock type

RevenueAccount

[Account Code]: [Account Name] for Revenue account if selected for the product

ExpenseAccount

[Account Code]: [Account Name] for Expense account if selected for the product. Only for Service type.

InventoryAccount

[Account Code]: [Account Name] for Inventory account if selected for the product. Only for Stock type

DropShipMode

Product Drop Ship mode. “No Drop Ship”, “Optional Drop Ship” or “Always Drop Ship”

PurchaseTax

Tax Rule used when purchasing the product

SaleTax

Tax Rule used when selling the product

AutoDisassembly

Auto-disassembly option. “Yes” or “No”

Image:ProductImage

Default product image. Assumes size of its container table cell

BOMComponentsCount

Number of lines in BOMComponents child table

BOMComponentsAverageCostTotal

Summary of AverageCostTotal field in BOMComponents child table

BOMComponentsFixedPriceTotal

Summary of FixedPriceTotal field in BOMComponents child table

BOMComponentsLatestPriceTotal

Summary of LatestPriceTotal field in BOMComponents child table

BOMServicesCount

Number of lines in BOMServices child table

BOMServicesTotal

Summary of Cost field in BOMServices child table

SuppliersCount

Number of lines in Suppliers child table

BOMAverageCostTotal

BOMComponentsAverageCostTotal + BOMServicesTotal

BOMFixedPriceTotal

BOMComponentsFixedPriceTotal + BOMServicesTotal

BOMLatestPriceTotal

BOMComponentsLatestPriceTotal + BOMServicesTotal


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.