How do I import a manual sales entry?

How do I import a manual sales entry?



**At the bottom you can download a template to use for importing sales**


  1. Navigate to Manual Sales within Item Management 


  1. Select Import Records in the bottom right: 




  1. Select the three black dots to the far right of Import File to select the sales file to be imported from your PC **As a note Yellow Dog recommends importing CSV files rather than Excel files, to avoid issues with formatting**


  1. Select the three black dots to the right of Import Stores to select which store these sales will be applied to



  1. Configure the column headers- Right click in the column header and select the appropriate matching field as demonstrated below: **As a note: in addition to the Date/SKU/QTY & Retail columns, you also have the ability to import Discounts for items, and Reference field information if needed. 


  1. Take a moment to review your data, and once it is all configured correctly select import in the bottom right. 



  1. When the sales have completed Select Close in the bottom right: 





  1. Select Refresh Data at the top of your screen, and you will now see your manual sales appear: 







    • Related Articles

    • What are Manual Sales Entries?

      Manual Sales Entry Manual Sales Entry allows you to create simple, basic sales transactions using your inventory items without going to your POS. This can be useful for offsite sales, like a food truck in the example below.   Choose the Store you ...
    • How To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • How do I create a Full Physical Inventory with a PA520?

      This video will demonstrate how to create Full Physical Physical Inventory Physical Inventory Yellow Dog Inventory gives you the ability to periodically check actual on-hand counts against the counts as reported by Yellow Dog Inventory, and then ...
    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
    • Reporting Explained: Inventory Adjustments - Manual

      Business Need:  This report is helpful for users who want a report to show what manual adjustments were made in the system for a selected period of time. How it Works:  A Manual report shows a detailed list of manual adjustments that were made to ...
    • Recent Articles

    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
    • How To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • How To: Update Items Store Availability via the Balto Import Tool

      This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • Yellow Dog/Jonas File Exchange Overview

      This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...
    • Yellow Dog/Jonas API Overview

      This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...