Update Inventory Using a Spreadsheet

Update Inventory Using a Spreadsheet

Sometimes there are groups of inventory that need adjustments in bulk that Orchid POS does not have a specific function for.

As an example, you have an entire category of inventory that you would like to reduce the Preferred Customer price by $10 instead of using a percentage discount (which is something that can be handled with the Copy Formula tool). Using both the export and import functions in Orchid POS, you can accomplish this change quickly using Excel.

1. Go to Office > Inventory > Products > Manage Products.

2. Filter for the group of inventory that needs editing (like category or manufacturer) and click SEARCH.

  • Orchid POS's product export function only exports current search results.

3. Click EXPORT.



  • If it's a small group of products, the CSV file (which can be opened with or imported to Excel) will be created and directly placed in your Downloads folder.
  • If it's a larger group of inventory, Orchid POS will notify you that the export file is being created and can be found in Tools > Exports within a few minutes.

4. Open the file in Excel and make the edits as needed; save your changes to the csv file.

  • NOTE: It is required that you keep the Part Number column as is; this is how Orchid POS will find the part in your database to make your changes.
  • It is recommended that you remove all columns - except part number - that are not being updated. For example, keeping only Part Number and Preferred Customer Price.

5. On the Products page, click IMPORT / UPDATE.



6. Change the drop down menu from Import New Products to Update Existing.



7. Click OPEN THE FILE BROWSER and find the csv file you had edited and saved. Click NEXT.

8. Map the columns. This means, on the left you will see the column names from your csv/spreadsheet file. On the right, you see the inventory fields offered in Orchid POS. You will see any that match map automatically, but you can change if needed. Click NEXT.

9. Click VALIDATE then, when that is complete, IMPORT.

  • The validation step looks for those existing part numbers and if any errors with the inventory or the spreadsheet are found, they will be displayed during this step.
  • Validation happens on this tab; the tab must remain open during this process. Once the import begins, you can leave the tab and check Tools > Import for progress and status.
    • Related Articles

    • Serial Number Inventory Tool (SNIT)

      Overview The Serial Number Inventory Tool (or “SNIT”) is used to compare your Bound Book inventory against your physical inventory. The SNIT process is modeled after a common ATF Mock Inspection and can be used to identify unwanted on-or-off book ...
    • Import New Products using Spreadsheet

      To import new inventory into your POS system you will want to navigate to | Inventory | Manage Inventory | Manage Products | You will then want to click on | Actions | Import / Update | From here you will want to select the Template that you are ...
    • Orchid POS Inventory Management

      Beta Release: New Create Purchase Order Page Beta Release: New Manage Products Page Beta Release: New Select Parts to Order Page Orchid POS Says Part Number Already Exists, but I Can't Find It Add, Edit, Delete Categories Adjust Inventory in Stock ...
    • Using the Catalog System to Import New and Update Existing Products / Inventory

      Catalog System is currently available for Orchid POS only. This feature allows you to subscribe to vendors and the manufacturer brand lines they offer at your pricing level, in order to view their entire catalogs. You can bulk import their product ...
    • Create Rental Inventory

      How Orchid POS Tracks Rental Parts Orchid POS supports two kinds of rental items: inventoried and non-inventoried. If a rental item is inventoried, that means Orchid POS will track each piece’s status and availability in detail. If a rental item is ...