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

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:

  1. All items already exist in Yellow Dog (YD).
  2. Items are not marked as removed.
  3. All referenced stores already exist in YD.
  4. You have a Yellow Dog user account with Mobile access.
Required Fields: 
  1. Item SKU: The SKU of the item to configure.
  2. Store Code: The target store’s code. The store must already exist in YD.
  3. Is Available: True to make the item available at the store, or False to remove it from the store.
Optional Fields: 
  1. Bin: Adds a bin assignment for the item at the specified store.
  2. Reorder Point/ Par Level: Sets reorder and par quantities for the item.
    1.  Child sizes requiring their own par or reorder levels must be listed individually. The import does not sync par levels between parent and child sizes.
    2. Par Level must be greater than or equal to the Reorder Point
  3. Is Non Restock: Updates the size behavior for this item at the store. Stands must be enabled in the database for this field to apply.. 
  4. Max Capacity: Sets a maximum capacity. This value must be greater than or equal to the Par Level.
  5. Tariff Code: Sets the item’s tariff code, typically used for e-commerce integrations.

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

Warning
Do 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 store availability has updated as expected 


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