New Product Fields

Enhanced Product Data Fields for Planufac

To enhance traceability, regulatory compliance, sustainability reporting, and logistics efficiency, Planufac now includes the following product data fields, fully integrated into the system.

Implemented Data Fields

Supplier Code

• Purpose: Uniquely identifies the product supplier for procurement and tracking.
• Type: Text field
• Details:
  • Located in the "Advanced Information" section of the product edit form.
  • Added as supplier_code column in the products database table.
  • Supports bulk import.

Main Commodity ID

• Purpose: Maps products to their primary commodity classification for reporting and categorisation.
• Type: Text field
• Details:
  • Added to the product edit form.
  • Added as commodity_id column in the products database table.
  • Supports bulk import.

Shelf Life

• Purpose: Indicates the product’s usable lifespan from the date of manufacture.
• Type: Number (months or years)
• Details:
  • Added to the "Advanced Information" tab of the product edit form.
  • Added as shelf_life column in the products database table.
  • Supports bulk import.

% Plastic

• Purpose: Supports Extended Producer Responsibility (EPR) reporting.
• Type: Percentage (e.g., 35)
• Details:
  • Added to the new "Packaging" tab in the product edit form.
  • Added as plastic column in the products database table.
  • Supports bulk import.

Plastic Weight (grams)

• Purpose: Specifies the exact weight of plastic in product packaging.
• Type: Number (grams)
• Details:
  • Added to the Packaging tab in product edit form.
  • Added as plastic_weight column in the products database table.
  • Supports bulk import.

% Cardboard

• Purpose: Supports EPR reporting.
• Type: Percentage (e.g., 65)
• Details:
  • Added to the Packaging tab in products edit form.
  • Added as cardboard column in the products database table.
  • Supports bulk import.

Cardboard Weight (grams)

• Purpose: Specifies the exact weight of cardboard in product packaging.
• Type: Number (grams)
• Details:
  • Added to the Packaging tab in products edit form.
  • Added as cardboard_weight column in the products database table.
  • Supports bulk import.

Ti

• Purpose: Indicates the number of cases per layer on a pallet for logistics planning.
• Type: Number
• Details:
  • Added to the Packaging tab in products edit form.
  • Added as "ti" column in the products database table.
  • Supports bulk import.

Hi

• Purpose: Specifies the number of layers per pallet for storage and transport calculations.
• Type: Number
• Details:
  • Added to the Packaging tab in products edit form.
  • Added as "hi" column in the products database table.
  • Supports bulk import.

Flavour Group

• Purpose: Enables reporting on flavour-based sales.
• Type: Dropdown (Options: Confectionery, Beverage, Fruit, Menthol, Fruit Menthol, Tobacco)
• Details:
  • Added to the "Advanced Information" section of the product edit form.
  • Added as groups_flavour_id column in the products database table.
  • Supports bulk import for flavour data.