All Vendor-Item Relations

List of All Vendors-Item Relations is used in generating PO. Each items should have a Vendors relation and suggested PO Price.

File Preparation

If only a few items has to be updated in the file, the best way to do it is:

1. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations

2. Click 3 dots on the top right side -> Export

3. Check mark Unit Cost / Item No / Vendor and click Export. 

4. In the exported file add new vendor-item relations or update existing. Save file

Import the file

To update the list with a new file:

1. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations

2. Click 3 dots on the top right side -> Import

3. The file mapping will be displayed in next screen. Confirm fields in the file correspond to field names in the Report. 

4. Next close the Columns Mapping and click Settings

5. Be sure such options are selected: 

Import Mode -> Append Rows

On import error -> Do not import records

Execute scripts is on ( this is important as it checks the file on errors)

6.  Next, close the Settings and click Import

7. If there is an error in the file an error list will be shown. In this case check the error and fix the file. You can have the wrong Item No, or Vendor. 

8. When there is no errors, the file will be imported and records will be refreshed

When the file is imported, all previous records are deleted, so be sure to export the current file as a backup and include all Vendor-Item Relations in the new file

• Related Articles

• Create or edit an Item

  Items Items are either goods that you purchase from your vendors and sell to your customers, or, services that you provide for which you get paid. In Zoho Inventory, you can add these items with ease and manage their inventory such that, every time ...

• Generate PO

  Generate SO Items POs can be generated after Sales Orders with today's Expected Shipment Day are created and Confirmed. Go to Zoho Creator -> Generate SO Items Last Synced Status: shows the status of last synchronization of Zoho Analytics Last Synced ...

• Zoho Inventory default features

  Dashboard Inventory Items Composite Items Item Groups Price Lists Transfer Orders Sales Customers Retainer Invoices Sales Orders Invoices Payments Received Sales Returns Credit Notes Cancel Items Purchases Vendors Expenses Purchase Orders Purchase ...

• Price List autoupdate

  A Price List is a convenient way of customizing item rates in Zoho Inventory. It can be used to mass control/modify your item prices for a specific customer/vendor or transaction. There are 5 Price Lists for 5 customers added in Zoho Inventory -> ...

• Purchase Process Overview

  Purchase Order In order to Create Purchase Orders based on Sales Order, refer to Generate PO After Purchase Orders are generated. Go to Zoho Inventory -> Purchase Orders. Select Draft view. Check Purchase Orders. To issue Purchase Orders in bulk: ...