Repack Conversion Factor

Overview

Repack conversion factor is essential to convert products into different UOM. It allows to set up conversion factors per item, monitor permissible thresholds, and manage SKU relationships efficiently. 


Utility:

  • This helps in ensuring accurate inventory management during repackaging operations. 

  • Allows different conversion rules to be set up for different Site Locations.

  • Supports operational flexibility where repack rules might vary based on regional practices, customer requirements, or infrastructure at specific warehouses.

  • Bulk Import functionality allows rapid setup or modification of multiple SKU.

  • Threshold in percentage allows permissible variances during repack, preventing issues due to minor weight or quantity deviations.

How to search existing Repack Conversion Factor details?

Navigation: Master > SKU Management > Repack Conversion Factor



Fields Description


Fields 

Description

Site Location

Filter conversion based on the specific warehouse.

Bulk SKU Code

Search for conversion linked to a particular bulk SKU code.

Bulk SKU UOM

Filter by the Unit of Measure used for the bulk SKU.

Child SKU Code

Search for rules associated with a specific child SKU code.

Child SKU UOM

Filter based on the Unit of Measure for the child SKU.

Conversion Ratio

Displays the defined conversion ratio between bulk and child SKUs.

Lower Threshold%

Displays the set minimum allowed variance percentage

Upper Threshold%

Displays the set maximum allowed variance percentage

Status

Filter conversion based on whether they are Active or Inactive.


Action Button - 



  1. Search: Retrieves data based on the entered search criteria.

  2. Reset: Clears all entered filters and resets the form to its default state.

  3. Advance Search: In addition to above filters, eRetail provides advanced filters that allow users to filter conversion rules based on Bulk SKU Name and Child SKU Name.


  1. Import: Allow users to create a repack conversion via import. 

  2. Export: Allow users to download the existing repack conversion data for offline review.

  3. Add New: Enables the user to add a new repack conversion entry. 


How to create a Repack Conversion Factor?


In order to create repack conversion faction, users has to click on Add New button as shown below.



On click on add new button, the system displays a form to enter the following information -


Fields 

Description

Site Location

Select physical warehouse or facility location where the repack conversion is applicable.

Bulk SKU Code

Enter code of the bulk SKU that is being repacked into smaller units.

Bulk SKU UOM

Automatically fetched from SKU master

Child SKU Code

Enter SKU code of the resulting product after repacking.

Child SKU UOM

Automatically fetched from SKU master

Conversion Ratio

The qty of bulk SKU required to create one unit of child SKU.

Lower Threshold%

The minimum acceptable conversion variance percentage allowed during repack.

Upper Threshold%

The maximum acceptable conversion variance percentage allowed during repack.

Status

Select whether the conversion rule is Active or Inactive from dropdown.


Note: One parent SKU code can be mapped with multiple child SKU code and vice versa but a combination of bulk SKU and child SU can have only one conversion ratio for a site location.

How to Edit Repack Conversion Factor?


Users can easily edit an existing entry from the system to keep the conversion factor updated.


  • Use a search filter to select an existing conversion rule that needs to be edited. 

  • Now, click on the “Pencil” button from “Actions” as shown in the above image. 

  • A Pop-up form will display, fill the modified details to update the existing records.

  • Users can only update conversion ratio, threshold and status field from the popup.



How to create a Repack Conversion Factor in bulk?


On clicking on the Import action button, a common import window will appear. Here the import type should be Bulk Repack Conversion factor. This import facilitates uploading repack conversion data in bulk via a template file.

Note: Maximum rows can be imported in an attempt of Import: 10000


Download Template: Default XLSX template can be downloaded from here.


XLSX template will have below fields that are required to Create/Update Repack Conversion Factor Masters.


Fill the data with mandatory fields(highlighted in yellow) and save the file.


Upload Template: From here the XLSx will be uploaded.


Once XLSx file is uploaded, click on the import button as highlighted below: