Exporting your EzyPO Vendors to Excel, making the necessary changes, and pasting them back into EzyPO is a good way to do mass updates to your vendors.
1. Go into the Suppliers section in EzyPO from the left hand navigation bar.
2. Tick the vendor you want to change Then click the Export button.
3. If you want to Export all vendors in your production, click the Export Button without selecting any vendors (do not tick the Select All button as it will result in a blank report).
4. A new tab will open up with an excel sheet. Click Save -> Microsoft Excel.
5. Open the excel sheet that downloads and make any necessary changes to your vendors.
For example, changing the Active column from 1 to 0 will disable that vendor from having POs written to it.
6. Then highlight and copy the ENTIRE excel sheet.
7. Then paste it into the paste pad on the supplier screen and press the TAB key on your keyboard.
8. Your changes will then be committed to the system.
