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 going to use, whether it is for Multiple Vendors or Single Vendor

All fields in red are required fields in black can be skipped or left empty if there is no data to populate.

Sub-Categories are now required, If you do not have sub-categories created you can truncate the Category to accommodate this requirement. 

Click in the Sub Category Column and move to the Formula Bar, or Type Directly in Cell H2 - the formula will always be =Left or =Right and then the first Populated Category Cell In this case, =Left(G2,3) this is telling the file to take the first 3 letters of the column to the left. (You can change this depending on the location of the column you are trying to truncate)

After typing that in you can double click on the + in the bottom corner of the box

This will adjust the formula all the way down to every instance that category is populated. 

After completing this step you will want to Save As - Name the file and select a csv file. 

Click OPEN THE FILE BROWSER or drag and drop the csv file you had created and saved. Click NEXT.

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.

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

• 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 ...

• 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 ...

• How to add Products into the POS - Video

  Below is a video that will walk you through step by step how to create products to receive and sell in the POS How to Receive Products into the POS

• Beta Release: New Manage Products Page

  The new Manage Products page comes with not just a new look, but major functionality updates including the ability to select which columns display by default and in what order. All features and available actions defined below. The most obvious change ...

• Q2S7.24 Release Notes - Orchid POS/eComm™

  Q2S7.24 Release Notes This program, printed documentation and documents should not be used as a substitute for professional advice in specific situations. The procedures, images and examples in this document are for illustrative purposes only and may ...