How To: Update Retail Prices using the Balto Import Tool

How To: Update Retail Prices using the Balto Import Tool

The Balto Import Tool lets users quickly bulk update items retail prices 

Before beginning, ensure the following:
  1. Items already exist in Yellow Dog (YD).
  2. Items are not marked as Removed.
  3. The store exists in YD.
  4. You have a Yellow Dog user account with Mobile access.

Required Fields: 

  1. Item SKU: SKU of the item to update.

  2. Initial Store Code: Store code to apply updates to.

    • Retail prices can only be updated for one store per import file.

    • To update multiple locations, run a separate import for each store.

  3. Default Retail: New retail price for the item.

    • This value also becomes the default retail price applied to any new stores created later.

Optional Fields: 

These fields can be included on their own or combined with Default Retail updates.
  1. Default Vendor Code: Required when updating Vendor Cost. The vendor code must already exist in YD.
  2. Default Vendor Cost: Requires Default Vendor Code to identify which vendor’s cost to update.
  3. Vendor Part Number: Sets or updates the default vendor part number.
  4. Level Code: Existing level codes in the format Code/Description, e.g., 30 Food/10 Meat/15 Beef.
  5. Description: Full item description.
  6. Dimensions 1–10: Dimension labels. Dimensions must already exist in YD.
  7. Short Description: Shortened item description.
  8. POS Description 1 or 2: Description sent to the POS, often abbreviated.
  9. Reference 1–3: Free-text fields for notes or identifiers.
  10. UPC1: Updates only the UPC1 field.
    1. Existing data in UPC1 will be overwritten.
    2. Additional UPCs must be added manually.


  1. Access Balto; Navigate to 'Item', click Configure &  Download the import template file.
  2. Configure the file. Ensure all required fields are complete

WarningDo not edit column headers in the import template. You may remove unused columns, but the remaining headers must stay unchanged 
      3.  In Balto, choose “Add File.”
      4.  Click Submit.
  1.  If the file processes successfully, verify the results in your YD client.
  2.  If the file fails, review the error entries below the failure message to identify the issue.
     5.  Fix any errors, then:
  1.  Click Clear.
  2.  Remove the file.
  3. Add the corrected file again.
  4. Re-submit.
  6. After successful processing, confirm in YD that the items Retail price has updated as expected  


Figure1: Example of how a failed import will appear in Balto


    • Related Articles

    • How To: Import Interfaces by Level using the Balto Import Tool

      The Balto Import Tool lets users quickly bulk assign item interfaces to levels in Yellow Dog (YD). Before running an import, make sure: All levels already exist in YD. The stores exist in YD. A ClientID and a Yellow Dog user account with access to ...

    • How To: Update Par & Re-Order Points via the Balto Import Tool

      The Balto Import Tool lets users quickly and efficiently bulk-update par levels and reorder points for items across stores Before you begin, make sure the following are true: The items already exist in Yellow Dog (YD). The items are not marked as ...

    • How To: Update Items Store Availability via the Balto Import Tool

      The Balto Import Tool lets users quickly bulk update the stores a group of items is available to Before you begin, ensure the following: All items already exist in Yellow Dog (YD). Items are not marked as removed. All referenced stores already exist ...

    • Feature Overview: Balto Web App

      Balto is a web-based tool from Yellow Dog that makes it easier for clients to manage and update their Yellow Dog Inventory. It provides a secure way to import, create, and update data in bulk, saving time and reducing manual entry. You can access ...

    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...

    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...

    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...

    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...

    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...

    • What are Bins and how can I use them?

      Bins are supplemental location markers. Unlike flags they do not have to be created prior to assigning them to items and are primarily used in in the stores tab to identify more precisely where an item is located. They can also be used in Physicals ...