It is advised to re-print the Duplicate PDE report for this step. Refer to Remove Duplicate PDEs: Overview for guidance.
Any products remaining on the report after Steps 1 to 5 have been completed are likely to be duplicated products and need to be merged.
The lower MNPN number is the Master product. In the above example the product on the left is the Master product.
1. From Stock Manager, click Product Maintenance.
The Product Maintenance window is displayed.
2. Click Find.
The Search window is displayed.
3. Enter the Master product’s Product No (the product with the lower MNPN number) from the Duplicate PDE report.
4. Click Okay.
The Product Maintenance window is displayed, and shows the Master product highlighted.
5. Click Merge.
The Product Merge window is displayed.
6. Enter the slave product’s Product Number (this is the product with the higher MNPN number), press [TAB].
The Product Merge window is updated; it now has both the Master and the Slave product information.
7. Select the radio buttons against either the Master or Slave options and then review the Merged Product (Preview), which shows the details that will be retained in the merge. The SOH and Last Purch. fields will assist in this decision.
- If both products are not stocked and have no SOH, check the Confirm Preview check box and click Merge. If the product is still maintained in the Minfos Master Database, the correct information will flow down into your database when that supplier update is collected next.
- If one of the products contains a negative SOH, is is likely that this product will have the correct barcode and the correct retail price.
- If one of the products contains a positive SOH and has the most recent Last Purch date, that product should have the correct Unit Cost, GST, Preferred Supplier, and category details e.g. Department, Class etc.
- If both products are marked as stocked and have a positive or negative stock on hand quantity, it may be necessary to do review each product in Product Maintenace before confirming the merge.
8. Click either Merge & Queue Label or Merge, to merge the products.
It is recommended that Merge & Queue Label is selected if there has been a change in Retail Price.
Note: This process cannot be reversed. Ensure all details are correct before merging.
9. Repeat steps 2 to 8 for all other merges.
Review Merges further
If you were unable to merge duplicated products based on the information from the Product Merge window, you may need to investigate the products in Product Maintenance.
It may be necessary to go and get the product and the shelf label to help with reviewing the master and the slave product stockcards.
- If the slave product has a SOH, check when it was last sold or purchased to decide what information—for example, retail price, barcode, categories and unit cost—you will keep from the slave. This information can be found by clicking Sales or Purchases on the Product Maintenance window.
- If the slave product has a negative SOH, it is likely that it has the correct barcode and retail price.
- If the slave product has a positive SOH, it is likely that is has the correct unit cost and categories.
From Product Maintenance:
1. Click Find.
The Search window is displayed.
2. Enter the Slave product Product No (the product with the higher MNPN number) from the Duplicate PDE report.
3. Click Okay.
The Product Maintenance window is displayed, and shows the Slave product highlighted.
4. Click Sales to check if and when the Slave product has been sold, this will help determine if the Slave product has the correct Retail Price.
5. Click Cancel, to close the Product Sales Enquiry window.
6. Click Purchases to check if & when the Slave product has been invoiced into the database, this will help determine if the Slave product has the correct unit cost.
7. Click Cancel, to close the Product Purchased Enquiry window.
8. Click Change.
The Product Edit window is displayed.
9. Make of note of what attributes from the Details and Categories tabs that will need to be used during this merge.
10. Click OK or Cancel, to close Product Edit window.
11. Repeat steps 2 to 10 for the Master product.
12. Now based on the information you were able to collect, merge the duplicated products.
13. The process is complete.