Simply Touch for Retail > User Manual >How do I Import from Excel?

Simply Touch allows users to import products from MS Excel; this could be handy if you're looking at adding multiple products at once or migrating to Simply Touch from another point‐of‐sale software.

First, you must download a "customized" version of the excel file. Visit this link to download a copy:
http://www.simplysoftware.com.au/updateSimplyTouch/simplyproducts.xls
(right click on file, save link as, and then select a target location)

1. Open the file name: simplyproducts.xls. By default, the file should have 3 sample products.
There are 15 column headers by default. Here's a quick definition of each of these columns.

Product: This is the product description. Maximum 200 characters Barcode: Product Barcode. Maximum 150 characters. (optional) Line 1: This could be product size, style, colour etc... Maximum 150 characters. (optional) Line 2: This could be product size, style, colour etc... Maximum 150 characters. (optional) Category: Product Category. Maximum 150 characters. (optional) Location: Location of the product. Maximum 150 characters. (optional) Stock: Product Stock. Numbers Only! Ignore Stock: Enter 0 to monitor stock, 1 to ignore stock. (0 or 1 only) Notify: This is the notify quantity field. Numbers Only! Tax Cost: Tax value on cost: e.g: 10. Numbers Only! Ex Tax Cost: Product cost Value Before tax. Numbers Only! Inc Tax Cost: Product cost Value After tax. Numbers Only! Tax Selling: Product Tax value: e.g: 10. Numbers Only! Ex Tax Selling: Product Value Before tax. Numbers Only! Inc Tax Selling: Product Value After tax. Numbers Only! Populate the excel file with your products (remove the default 3 sample products).

4. Save your file, anywhere on your computer.
5. Start Simply Touch. General > Add Product > Import Products from MS Excel
6. Locate your saved file (in step 4) then click open.
7.A message will appear after the import process is complete notifying your of the outcome.

back to user manual homepage ››