Learn how to keep keep your product database clean and up to date - helping to minimise ordering and stock on hand issues. This topic will show you how to:
- Import and action MNPN product merges
- Merge duplicate products in Product Maintenance
- Identify and remove duplicate PDEs
Product Merges
At times you may discover duplicated stock cards in your product database. Whether this is caused by simple human error, or by superseded products or packaging, it is important to remove these duplications to avoid stock on hand and ordering issues. Duplicated stock cards can be removed by merging the 2 stock cards together.
This topic will demonstrate how to merge products supplied in Minfos Master Database Product Merge files, as well as how to merge products as required in Product Maintenance.
Video - Automatically import MNPN Product Merges
Watch the video
Learn how to set up your Minfos to automatically import MNPN product merges as they become available in this video tutorial.
Further reading
If you would like to learn more about functions mentioned in this video, please refer to the articles below.
MNPN Product Merge overview Set up Automatic Merge File Import & Automatic Product Merges
Video - Automatically apply MNPN Product Merges
Watch the video
Learn how to set up your Minfos to automatically apply eligible MNPN product merges in this video tutorial.
Further reading
If you would like to learn more about functions mentioned in this video, please refer to the articles below.
Set up Automatic Merge File Import & Automatic Product Merges MNPN Product Merge overview
Video - Manually import MNPN Product Merges
Watch the video
Learn how to manually import MNPN product merges in this video tutorial.
Further reading
If you would like to learn more about functions mentioned in this video, please refer to the article below.
Manually import the Merge file
Video - Action MNPN Product Merges
Watch the video
Learn how to set up your Minfos to review and action MNPN product in this video tutorial.
Further reading
If you would like to learn more about functions mentioned in this video, please refer to the articles below.
Action MNPN Product Merges Review MNPN Product Merges further
Video - Merge products in Product Maintenance
Watch the video
Learn how to merge local or MNPN products in this video tutorial.
Further reading
If you would like to learn more about functions mentioned in this video, please refer to the article below.
Merge Products from Product Maintenance
Identify & Remove Duplicate PDEs
Duplicate PDEs in your database may cause issues with stock on hand accuracy and ordering. It is recommended to action this process monthly to remove any duplicate PDEs and avoid stock issues.
Video - Identify Duplicate PDEs
Watch the video
Learn how to identify multiple products that have the same Supplier PDE in this video tutorial.
Further reading
If you would like to learn more, please refer to the article below.
Remove Duplicate PDEs: Overview
Remove Duplicate PDEs
After running the Product Exceptions Report, complete the 6 steps described below to correct any duplications. It is important to note that products displayed on the report may not be duplicated products; they may just share the same PDE listed for the supplier.
It is not necessary to complete all 6 steps on the same day.
Step 1. Merge the duplicated non MNPN products.
If a product has been added at store level and collected in a Minfos MNPN update, there is a possibility of duplicated stock cards. If these are not merged, you run the risk of receiving the product under one stock card and selling on the other stock card. This can cause issues with SOH and GP%. Click here for instructions.
Step 2. Clear products attached to unused suppliers.
Sometimes suppliers re-use the PDE previously belonging to an old product on a new (unrelated) product. This will create duplicate PDEs in your store database. For this reason it is best to clear supplier details for suppliers that your store does not order from. Click here for instructions.
Step 3. Clear the supplier from the products the direct supplier no longer supplies.
Note: All parts of Step 3 should be completed on the same day for each supplier.
As some suppliers re-use PDEs this process will ensure the correct product is ordered and invoiced into your database. Clearing the Supplier will not delete the product from the database, it only removes that supplier listed against the product. Click here for instructions.
Step 4. Clear the wholesaler from the products the wholesaler no longer supplies.
To avoid duplicated PDEs it is recommended that you clear historical wholesaler supplier data from products the wholesaler is no longer supplying. Click here for instructions.
Step 5. Update any incorrect PDEs.
Products displaying a single digit, double digit or barcode in place of a PDE are generally incorrect. These can be identified and corrected or removed to avoid potential issues. Click here for instructions.
Step 6. Merge any remaining products.
Examine the products remaining on the report after Steps 1 to 5 have been completed. Merge any products that appear to be duplicated stock cards. The lower MNPN number should always be the Master product in a merge. Click here for instructions.
Further reading
If you would like to learn more about these processes, please refer to the article below.
Remove Duplicate PDEs: Overview
Congratulations! You are now ready to progress to the next topic.
Track your progress Don't forget to mark off your progress on the checklist before you move onto the next topic.