How To: Import Manual Sales
When sales occur outside of Yellow Dog, importing them in bulk helps you quickly and accurately add those transactions to Yellow Dog.
Find an import template attached below
You must have permission to:
View and edit manual sales
Import manual sales
- Go to Item Management > Manual Sales.
- Select Import Records in the bottom-right corner.
- Next to Import File, select the three-dot menu and choose the sales file from your computer.
Yellow Dog recommends importing CSV files instead of Excel files to avoid formatting issues.- Configure the column headers:
- Right-click each column header.
- Select the corresponding Yellow Dog field.
- Required fields include Date, SKU, Quantity, and Retail.
- Optional fields include Discount and Reference.
Discounts should be entered as a negative value
- Review the data to confirm it’s mapped correctly.
Figure: Example of the import screen with columns mapped
- Select Import in the bottom-right corner.
- When the import completes, select Close.
- Select Refresh Data at the top of the page to view the imported manual sales.
Related Articles
Feature Overview: Manual Sales Entry
Use manual sales to keep on-hand quantities and sales reports accurate when Yellow Dog can’t capture sales automatically. Common scenarios include trunk shows, off-site catering, promotional events, and employee purchases. Go to Item Management > ...How To: Import Brand New Item Data
Admin/End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT Yellow Dog Inventory lets you import items directly into the database from a spreadsheet, so you can add new items in bulk instead of creating them one at a time. Use this feature with ...How To: Import Items with Multiple Sizes
End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT Yellow Dog Inventory lets you import items directly into the database, which saves significant time when adding large numbers of new parent and child items at once. Parent/child imports run in ...How To: Assign Sales Channels
To appear in the correct SkyTab Venue (VenueNext) menu, each POS item must be assigned to a corresponding Sales Channel in Yellow Dog. These steps should be taken by Concessions Client with a SkyTab Venue (VenueNext) integration. Item needs to be ...How To: Reprocess Sales after Mapping Recipes on the POS Item Map
If sales have already been rang in on an item before recipe mapping is completed on the POS Item, ingredient depletion will not be applied on previous sales until the recipe is mapped and sales are reprocessed. Recipe created and attached to the POS ...
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 ...Feature Overview: Par & Re-Order Points
Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...How To: Install the Zebra ZD411 Printer Driver
End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...FAQs: What are Bins?
End user · Yellow Dog Inventory 2026 Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. The Bin field is free text, so you can use letters or numbers. You don’t need to create bins in ...Food and Beverage User Manual
The Food & Beverage User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory system. Download ...