Product Barcode List carries barcode information which is appended to the product search criteria enabling searching by barcode from either the website or mobile application.

Should be populated with the lowest/smallest selling UOM for the product

Text description of the pack “24x6 packs”  or “500g Bag”: this will display under “PackSize” on the search results.

Optional and not multilingual, Temperature code to use as a filter in the shop search results (DRY, FRZN, CHILL,...)

Deprecated – replaced by the Stock status Code on the Stock File. Must Be ‘S’ until it is removed completely.

Specifies the (Alternate) UOM where items are specified in Pieces, Each or pack where the price is calculated by the weight/length/volume of the picked item(s).  i.e. Item UOM is sold in KG.
This field is also carried on the Stock Item Table.  This entry in the Product Item serves only as a default value if the Alternate UOM is not declared on the stock file

This field has been deprecated – do not use, set the value to NULL

Used By the Planning and Costing module for as a conversion factor.
              If your site does not implement planning and costing (non-food) send ‘PCE’ for this value.
              Base Dimensions are
              G	Grams
              ML	Millilitres
              PCE	Pieces
              NULL	NULL        null is valid

              This can be extended per site, typically the following mappings to the base codes are applied
              EA	PCE	1
              EACH	PCE	1
              G	G	1
              GAL	ML	3785
              GM	G	1
              GRM	G	1
              KG	G	1000
              LB	G	454
              LT	ML	1000
              LTR	ML	1000
              ML	ML	1
              OZ	G	28
              PCE	PCE	1
              QT	ML	946

Unsed by Planning and costing to know the number of packs to order to fulfill a recipie.  1kg may be 1000 and pack sixe dim will them be 'g'

Deprecated in favor of an attribute declaration

Key words that can be added to the searchable test for the product

Restricts the display of the UOM preventing the base unit UOM from being displayed.  If set to “true” and an Alt UOM exists, only the Alt UOMs will be displayed.  This value can be applied at product or stock level.  If applied at Product Level it will replace settings on the stock file for all warehouses

Unique product identifier (site).

The product barcode character representation.

Deprecated at Entity Level..  Please use the separate AttributeList Load File to load entity specific attributes.

The code of the entity these attributes belong t  - i.e. ProductItemCode  Field is mandatory if attributes are ssent on a separate file.

Name of the Attribute

Value of the Attribute, must be the string representation of the appropriate type

Purchasing UOM

Boolean indication product only purchased in the Outer

Not available for purchase.  Mix of this flag and the stock status if a product is being run out of stock (EOL  = end Of Line)r: BIDIQ extension

Identifies the buyer at national level:BIDIQ Extension

Unit of measure shipped on pallets (Case)

e.g. 6 Cases (Pallet UOM’s) per layer

e.g. 36 Cases (Pallet UOM’s) per pallet (implies 6 layers)  : BIDIQ Extension

Whether product is visible on public website pages.  By default all products are visible. Passing false here will remove the product from the public website pages.

Name of product family:BIDIQ Extension

Outer UOM of the product:BIDIQ Extension

Size of the outer UOM of the product:BIDIQ Extension

Used in Menu Planner to convert from Pieces to G or ML.

Used in Menu Planner to provide UOM when converting from Pieces to G or ML

Subcategory of the product:BIDIQ Extension

Subcategory Description of the product:BIDIQ Extension

Companion Product Code

Bidfood businesses are maintaining external classification standards for products. E.g. UNSPC, GPC, etc..

					  These classification standards can be maintained/vary at different level for a product. E.g. Product level, Product Line level, etc..

					  This feature is to support external product standards mapping. It's mainly used for B2B punchout system integrations.

External Standard Product Code mapped for Bidfood Product

is this brand owned by Bidfood

Generic Address Element

Address notes – may be used for special purposes such as delivery address notes

TimeZone Offset. Decimal 9.5 =  “+9:30”  http://wwp.greenwichmeantime.com/info/timezone.htm

Timezone Name, use if Warehouse not in default server timezone - https://support.microsoft.com/en-nz/help/973627/microsoft-time-zone-index-values

RestrictTo, Permit, or Deny

The Global standard the Barcode conforms to GTIN, EAN or NULL

The Product UOM this Barcode applies to or NULL

Public, Private, Admin : defines the visibility of the attribute within the site.  Default determined by the of Entity type.

External Standard Supported Version for the product e.g. Standard: UNSPSC version: 12223.014

External Standard Type maintened by bidfood for products

FULL, FULLBranch, or PARTIAL
Note: partial loads require each record to explicitly declare if it is deprecated or not.  Full loads assume anything not in the load is deprecated.

LoadFilter must indicate the Entity Type.  Only one Entity Type per file is allowed. i.e. “Product”