EXCEL IMPORT
      Back to home
      1. Knowledge Base
      2. MODULES
      3. EXCEL IMPORT

      Is it possible to assign multiple vendors to a product via Excel Import?

      To be able to assign multiple vendors to a product via Excel Import, you would have to import the same excel sheet as many times as you have different vendors.   
      • Create a Spreadsheet as you would for your regular import filling all the related columns
      • When you get to the "Vendor" column, you would enter the primary vendor
        • Same procedure should be done with
          • "Vendor_Account_No"
          • "Vendor_SKU"
          • "Vendor_Product_Name"
          • "Vendor_Min_Order_Qty" 
      • Then you would create another column called "Vendor_2" and enter related Vendor information in that column.
      • Then you would create another column called "Vendor_3" and enter related Vendor information in that column.
      • Same would apply for all vendors that you want to add...
      • Once all data  is present in the spreadsheet you are ready to import it
      • You would go to Admin --> Utilities --> Excel Import Tab --> Click on [Import Products]
      • Then browse for the excel file and map the column names from your spreadsheet (right side) to the column names offered in AdvancePro (left side)
      • On the right side you will see all the vendor column names like "Vendor", "Vendor_2", "Vendor_3", "Vendor_4", etc (as many times as you are assigning vendors to one product) where as on the left side you will only see one  "Vendor"
      • First:
        • Map all corresponding fields to each other, 
        • When you would reach vendors you would map "Vendor" (Right Side) with the "Vendor" (Left Side), 
        • Then Proceed with the Import
        • This will import and assign the first set of vendors to your products
      • Second:
        • Since all data already exists in your excel
        • Browse for the file again
        • Since the main data already exist in AdvancePro you don`t have to map ALL fields again
        • Map the required fields, which are "Product_Name" and "Product_SKU"
        • Then map Secondary Vendor Info, which is "Vendor_2" (Right Side) with the "Vendor" (Left Side)
        • Then Proceed with the Import again
        • This will import and assign the second set of vendors to your products
      • Third:
        • Proceed with the second step for each outstanding Vendor Columns from your Spreadsheet (Right Side)
      • When done multiple vendors will be assigned to your products.