All

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

    Login
English (US)
English (US)
Mandarin
Cantonese
  • Home
  • Merchant Guide

Import Tools

All Product

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

    • Explore Eats365 products
        • Explore the Eats365 POS screens
        • Restaurant service modes
      • Guides by restaurant type
          • Use Eats365 in a fine dining setup
          • Use Eats365 in a fast food setup
          • Use Eats365 in a casual dining setup
          • Use Eats365 in a specialty restaurant setup
          • Use Eats365 in an all-you-can-eat setup
    • Set up and Installation
        • Set up and install the Eats365 POS app
        • List of compatible devices
        • Connect an iPad to a network
        • Log in to the Eats365 Merchant Portal
        • Hardware Setup
    • Menu Setup
        • Set up and manage a Category (Full Service)
        • Set up and manage a Category (Quick Serve)
        • Set up and manage a Category (Food Court)
        • Set up and manage Product and Sub Product Type
        • Set up and manage a Single Item (Full Service)
        • Set up and manage a Single Item (Quick Serve)
        • Set up and manage a Single Item (Food Court)
        • Set up and manage a Combo Item (Full Service)
        • Set up and manage a Combo Item (Quick Serve)
        • Set up and manage a Combo Item (Food Court)
        • Set up and manage Catering Items
        • Set up and manage a Custom Menu
        • Set up a tax-inclusive menu
        • Set up and manage Modifiers
        • Set up and manage Modifier Masters
        • Set up and manage Modifier Presets
        • Set up and manage Tier Pricing Rules
        • Allocate item sales to different sales categories
        • Set up and manage a Kitchen Station
        • Set up a Pickup Station
        • Set up a Pickup Station (Food Court)
        • Customize the menu layout
        • Set up and manage Special Request Quick Keys
        • Set up and manage Menu Tags
        • View and manage Inventory
    • Table Map Setup
        • Set up and manage Areas and Tables
    • Restaurant Settings
        • Set up restaurant information
        • Restaurant Codes
        • Set up and manage Media Group
        • Set up and manage a Reporting Period
    • Dine-In Settings
        • Set up Dine-In settings (Full Service)
        • Set up Dine-In settings (Quick Serve)
        • Set up Dine-In settings (Food Court)
        • Configure Dining Time settings
        • Set up Self Checkout for Dine-in orders
    • Takeout Settings
        • Set up Takeout settings
        • Set up Takeout settings (Food Court)
    • Catering settings
        • Set up Catering settings
    • Queuing Settings
        • Set up Queuing
        • Set up VIP Queuing
        • Set up Online Queuing
    • System Preferences
        • Manage General Preferences
        • Manage System Preferences (Full Service)
        • Manage System Preferences (Quick Serve)
        • Manage System Preferences (Food Court)
        • Set up and manage Ordering Quantity Limit
        • Modify Action Button options
        • Set up a Revenue Center
        • Enable Sequential Order Number
        • Configure Audit Log settings
    • Device Management
        • Set a primary POS
        • Reset the Eats365 POS
        • Update the Eats365 POS
        • Change POS device name
        • Configure POS to sign out automatically
        • Maintain restaurant operations using Offline Mode
        • Configure POS login preferences
        • Available features when in Offline Mode
    • Account Management
        • Change POS password
        • Change the Merchant Portal password
        • Change activation email or phone number
        • Switch between Merchant Portal themes
    • Reservation
        • Set up Reservation
    • Import Tools
        • How to use Import Tools
    • Time Sheets
        • Manage staff time sheet
    • Menu Template
        • Create and manage a Menu Template
        • Set up and manage a Location Group
        • Apply pricing changes to shops in a Location Group
    • Scan to Order
        • Set up Static QR Code
        • Set up Dynamic QR Code
        • Configure Scan to Order settings (Full Service)
        • Configure Scan to Order settings (Quick Serve)
        • Configure Scan to Order settings (Food Court)
    • All You Can Eat Menu
        • Create an All You Can Eat Menu
        • Configure general All You Can Eat Menu settings
        • Enable All You Can Eat mode on the Eats365 POS
        • Set up a Menu Tier for All You Can Eat Menu
    • Food Court Settings
        • Add a vendor to a food court restaurant
        • Assign a vendor to a POS terminal (Food Court)
        • Set up unique menus for each food court vendor (Food Court)
        • Set up a centralized cashier (Food Court)

Table of Contents

How to use Import Tools

Learn how to use Import Tools on the Merchant Portal to perform bulk operations in your restaurant.

To save time when setting up your restaurant, you can use Import Tools to import restaurant information, such as Single Items, Product Names, and more, in bulk. 

In this article, you’ll learn how to perform bulk imports.

Bulk Import for a Single Item

To perform a bulk import for a Single Item, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Single Item.
  3. Select where you want to import the Single Item. You can choose from Dine & Takeout or Catering.
  4. At the top right, click on Add new task.
  5. Choose from the following operations:
    • Add to Menu
    • Edit Menu
    • Delete from Menu
  6. After choosing an operation, click on download template.

  7. To modify the template, enter the data in all of the relevant fields in the Excel file.
    • Add to Menu
      • Sheets titled Category, KitchenStation, and ItemType are only used for reference and don’t need to be modified.
      • The Optional Modifiers used in the SingleItem sheet should be selected from the ModifierGroup sheet.
      • At least one modifier value must be provided in ModifierValue for every modifier group defined in ModifierGroup.
    • Edit Menu
      • Ensure that itemIDs and itemNames match to avoid errors.
      • Modifications made in the KitchenStation and ItemType sheets are only for reference, and any changes don’t update the database.
      • To enter values for Kitchen Station and Item Type, choose from the list of options inside the cell and don’t enter a value that isn’t in the list.
      • To save time, remove the rows that don’t need to be edited.
    • Delete from Menu
      • The downloaded template contains all of the information for all menu items.
      • To delete items in bulk, upload the template containing the records for the menu items you’d like to remove. 
        Note: A menu item can still be removed even if some fields are missing, as long as the ItemID remains. 
  8. (Optional) Enable API User Permission(s).
  9. To upload your modified template file, click on Choose File. Then, select your modified file.

  10. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Single Item.
  3. Select where you want to import the Single Item. You can choose from Dine & Takeout or Catering.
  4. Next to Menu Operation, choose the operation that you want to perform. You can select from the following operations:
    • Add to Menu
    • Edit Menu
    • Delete from Menu
  5. After choosing an operation, click on download template.

  6. To modify the template, enter the data in all of the relevant fields in the Excel file.
    • Add to Menu
      • Sheets titled Category, KitchenStation, and ItemType are only for reference and don’t need to be modified.
      • The Optional Modifiers used in the SingleItem sheet should be selected from the ModifierGroup sheet.
      • At least one modifier value must be provided in ModifierValue for every modifier group defined in ModifierGroup.
    • Edit Menu
      • Ensure that itemIDs and itemNames match to avoid errors.
      • Modifications made in the KitchenStation and ItemType sheets are only used for reference, and any changes don’t update the database.
      • To enter values for Kitchen Station and Item Type, choose from the list of options inside the cell and don’t enter a value that isn’t in the list.
      • To save time, remove the rows that don’t need to be edited.
    • Delete from Menu
      • The downloaded template contains all of the information for all menu items.
      • To delete items in bulk, upload the template containing the records for the menu items you’d like to remove. 
        Note: A menu item can still be removed even if some fields are missing, as long as the ItemID remains. 
  7. (Optional) Enable API User Permission(s).
  8. To upload your modified template file, click on Select File. Then, select your modified file.

  9. Click on Submit to confirm.
Delete

Bulk Import for Product Name

Delete

Note: Eats365 supports multiple languages. You can perform a bulk import of the different names for your Menu Items in their respective languages.

To perform a bulk import of Product Names, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Name.
  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file. 
    Tips:
    • Don’t leave the Category field blank.
    • Only the languages included in the template are supported.
    • To save time, only leave the rows that need to be edited.
  6. To upload your modified template file, click on Choose File. Then, select your modified file.

  7. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Name.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file. 
    Tips:
    • Don’t leave the Category field blank.
    • Only the languages included in the template are supported.
    • To save time, only leave the rows that need to be edited.
  6. To upload your modified template file, click on Upload. Then, select your modified file.

  7. Click on Submit to confirm.
Delete

Bulk Import for Product Description

Delete

Note: Eats365 supports multiple languages. You can perform a bulk import of the different product descriptions for your Menu Items in their respective languages.

To perform a bulk import of Product Descriptions, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Description.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file. 
    Tips:
    • Don’t leave the Category field blank.
    • Only the languages included in the template are supported.
    • To save time, only leave the rows that need to be edited.
  6. To upload your modified template file, click on Choose File. Then, select your modified file.

  7. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Description.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file. 
    Tips:
    • Don’t leave the Category field blank.
    • Only the languages included in the template are supported.
    • To save time, only leave the rows that need to be edited.
  6. To upload your modified template file, click on Upload. Then, select your modified file.

  7. Click on Submit to confirm.
Delete

Bulk Import for Product Tag

To perform a bulk import of Product Tags, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Tag.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file. 
    Tips:
    • The category for the product being modified is required.
    • Columns A to D are for reference only. Do not update the values.
  6. To upload your modified template file, click on Choose File. Then, select your modified file.

  7. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Menu Tag.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file.
  6. To upload your modified template file, click on Upload. Then, select your modified file.

  7. Click on Submit to confirm.
Delete

Bulk Import for Product Tier Pricing

To perform a bulk import for Product Tier Pricing, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Tier Pricing.
  3. Select where you want to import the Product Tier Pricing. You can choose from Dine & Takeout or Catering.

  4. At the top right, click on Add new task.
  5. Click on download template.

  6. To modify the template,  enter the data in all of the relevant fields in the Excel file.
    Note: Due to the limitations of Excel, the Category Name may not be displayed entirely in column A.
  7. To upload your modified template file, click on Choose File. Then, select your modified file.

  8. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. On the left panel, click on Import Tools, then click on Bulk Import for Product Tier Pricing.

  3. Choose the operation that you want to perform. You can select from the following operations:
    • Add / Update Tier Price
    • Change Price
  4. Select where you want to import the Product Tier Pricing. You can choose from Dine & Takeout or Catering.
  5. Click on Next.
  6. For Add/Update Tier Price: 
    1. Select the Category(s) or the specific Item(s) with the Tier Pricing that you want to update and include in the template.

      Note: You can exclude specific Menu Items from a particular Category.
    2. (Optional) Select the additional Tier Pricing that you want to update and include in the template.

    3. Click on download template.

    4. To modify the template, enter the data in all of the relevant fields in the Excel file.
      Tips: 
      • If you leave any blank cell in the Price column, that price tier will be deleted after uploading the modified template file.
      • If you leave any blank cell in the Price with Delivery Platform column, the item's default price will be used after uploading the modified template file.
  7. For Change Price: 
    1. Select the Category(s) and or the specific Item(s) with the Tier Pricing that you want to change and include in the template.

      Note: You can exclude specific Menu Items from a particular Category.
    2. Click on download template.

    3. To modify the template, enter the Tier Price change under the Change column.
      Tips: 

      • Enter a positive value for a price increase or a negative value for price reduction. For example, if the original Tier Price is set to “3” and you enter “2” under the Change column, the new Tier Price will be “5.” If you enter “-2,” the new Tier Price will be “1”. 

      • Leave the cell blank if there is no price change.

  8. To upload your modified template file, click on Upload. Then, select your modified file.

  9. Click on Submit to confirm.

Delete

Bulk Import for Discount Quantity

To perform a bulk import for Discount Quantity, follow the steps below:

Merchant Portal (Classic Theme)

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Experience Merchant Portal 2.0.

  1. Log in to the Merchant Portal.
  2. From the left panel, click on Import Tools, then click on Bulk Import for Discount Quantity.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file.
  6. To upload your modified template file, click on Choose File. Then, select your modified file.

  7. At the top right, click on Submit to confirm.
Delete

Merchant Portal 2.0

Delete

Tip: To switch themes, at the top right, click on the account name. Then, select Back to Classic Theme.

  1. Log in to the Merchant Portal.
  2. From the left panel, click on Import Tools, then click on Bulk Import for Discount Quantity.

  3. At the top right, click on Add new task.
  4. Click on download template.

  5. To modify the template, enter the data in all of the relevant fields in the Excel file.
  6. To upload your modified template file, click on Upload. Then, select your modified file.

  7. Click on Submit to confirm.
Delete
import tools bulk import import single items import product names import product descriptions import product tags import product tier pricing import discount quantity import menu tags

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Set up and manage Menu Tags
  • Set up and manage a Single Item (Full Service)
  • Set up and manage Tier Pricing Rules
  • Create and manage discounts
            • Products
              • POS
              • mPOS
              • Eats365 Biz
              • Eats365 Marketplace
              • Branded Online Store
              • Kitchen Display System
              • Expedite Display
              • Scan-to-Order (BYOD)
              • Self-Service Kiosk
              • PhotoMenu
              • Queue Kiosk
              • Dynamic Digital Menu
              • Queue Display
              • Pickup Display
              • Customer Facing Display
            • Solutions
              • Online Ordering
              • Contactless Dining
              • Front of House
              • Guest Retention
              • Back of House
              • Back Office (Store End)
              • Multi-brand/Location Management (Enterprise)
              • Paperless Operation Experience
              • Payment
            • Restaurant Types
              • Quick Service Restaurant
              • Full Service Restaurant
              • Bars
              • Food Court
              • Cloud Kitchen
              • Food Retail
              • Self-service Restaurant
              • Enterprise
              • All-You-Can Eat (Buffet)
            • Resources
              • Eats365 Knowledge Base
              • Blog
              • Supported Hardware
            • Company
              • About Us
              • Success Stories
              • Referrals
            • Get In Touch
            • Contact Us
              • Eats365, Inc.
              • Sales info@eats365.com
              • Support support@eats365.com
        • Contact Us
          • Eats365, Inc.
          • info@eats365.com
          • www.eats365pos.com
        • Get In Touch
          • Apple Mobility Partner
            twitter facebook eats365 linkedin
        • eats365
          © 2023 Eats365 Incorporated. All rights reserved.

Knowledge Base Software powered by Helpjuice

Expand