This guide will walk you through the process of updating multiple vendors at once, saving you significant time and effort. Below is the procedure and steps of the Update Vendors.

Go to Update Vendors in Localizebook system:

1. Go to the Accounting menu.
2. Click on Bulk Update > Update Vendors.
3. Click on the “Columns Update” dropdown menu. A list of available vendor fields will appear. Check the box next to each piece of information you want to update.
4. Click on Click this link to download the working template.

5. Fill in the information for each function and save your Excel file:

1. *VENDOR: (Mandatory Field) This is the unique identifier for the vendor, such as their official name or a primary key. The system uses this exact value to locate the vendor record to update.
2. VENDOR_NAME: The vendor’s name, typically in English.
3. VENDOR_CODE: A unique code assigned to the vendor for easy reference (e.g., V1, V2).
4. LOCAL_VENDOR_NAME: The vendor’s name in the local language (in this case, Khmer script).
5. EMAIL: The primary email address for the vendor.
6. PHONE: The primary phone number for the vendor.
7. CURRENCY: The default currency used for transactions with this vendor (e.g., Dollar, Riel).
8. VATTIN: The Vendor’s Value-Added Tax Identification Number.
9. ACTIVE: A status field. Enter TRUE if the vendor is active and FALSE if they are inactive.
10. HOUSE_NO: The house or building number.
11. STREET: The street name.
12. COMMUNE: The commune or sangkat.
13. DISTRICT: The district or khan.
14. CITY: The city or province.
15. ADDRESS: A field for the complete, formatted address line.
16. LOCAL_HOUSE_NO: The house number in the local language/script.
17. LOCAL_STREET: The street name in the local language/script.
18. LOCAL_COMMUNE: The commune’s name in the local language/script.
19. LOCAL_DISTRICT: The district name in the local language/script.
20. LOCAL_CITY: The city name in the local language/script.
21. MEMO: A free-text field for any internal notes or additional details about the vendor.
22. BRANCHES: Used to associate the vendor with specific company branches (e.g., PP for Phnom Penh, KD for Kandal). This likely uses predefined branch codes from your system.

6. After filling in all the information, please go back to the system:

1. Click on Browse File and select the template with your item data and preview your item details. If data is loaded, you are ready to import. But if there is any error, messages will be shown.
2. Click on Import to import your items into Localize.