The Bulk Update Items feature is a powerful tool designed to save you time by allowing you to update information for multiple items simultaneously. Instead of editing each item one by one, you can download a customized template, make your changes in Excel, and upload it to apply all updates at once.

Go to Update Items into Localizebook system:

1. Go to the Accounting menu.
2. Click on Bulk Update > Update Items.
3. Click on the “Columns Update” dropdown menu. A list of available item 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. *ITEM: (Mandatory Field) The unique identifier for the item (e.g., a specific item name or code). The system uses this exact value to find the correct item record to update.
2. ITEM_NAME: The standard display name for the item.
3. ITEM_CODE: A unique internal code assigned to the item (e.g., F-001, Co-001).
4. LOCAL_NAME: The item’s name in a local language (in this example, Khmer).
5. ITEM_GROUP: The category or group the item belongs to (e.g., “Beverages,” “Snacks”).
6. ITEM_BRAND: The brand associated with the item.
7. DESCRIPTION: A detailed description of the item.
8. NEGATIVE_SALE: A flag to control inventory. Enter TRUE to allow selling this item even if the stock quantity is zero or negative. Enter FALSE to prevent it.
9. FOR_PURCHASE: A flag indicating if the item can be included on purchase orders. TRUE means it can be purchased; FALSE means it cannot.
10. FOR_SALE: A flag indicating if the item is available for sale. TRUE means it can be sold; FALSE means it cannot.
11. ALARM_QTY: The reorder point. This is the minimum stock quantity that, when reached, will trigger a low stock alert.
12. COST: The standard purchase cost per single unit of this item.
13. ACCOUNT_ASSET_CODE: The general ledger account code from your Chart of Accounts where the value of this inventory item is tracked.
14. ACCOUNT_COGS_CODE: The account code for the Cost of Goods Sold (COGS). When this item is sold, its cost is posted to this account.
15. ACCOUNT_REVENUE_CODE: The account code for Revenue. When this item is sold, the revenue is posted to this account.
16. MEMO: An internal notes field for any additional information about the item.
17. ACTIVE: A status flag. TRUE means the item is active in the system. FALSE deactivates it, hiding it from most transactions.
18. UNITSET_NAME: Defines the unit of measure for the item (e.g., “case/2L”, “Box”, “Each”).
19. PRICE_1, PRICE_2, PRICE_3: These columns represent different selling price tiers (e.g., Retail Price, Wholesale Price, VIP Price). This allows for flexible pricing strategies.
20. BARCODE_1, BARCODE_2, BARCODE_3: The barcode numbers corresponding to each price level or unit of measure. For example, BARCODE_1 would be scanned to sell the item at PRICE_1.

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.