How to upload data and images to LightSpeed Point of Sale Pro?

LightSpeed Point of Sale supports uploading and downloading data and images using CSV files. 

A CSV file is very similar to a text file or spreadsheet and enables you to quickly add and edit data for a large number of products.

Before you begin preparing your CSV file it is recommended that you download open office and use that application to view and edit your CSV-spreadsheet. *Microsoft Excel is not recommended and may impact the reliability of your import process.

Common Question 1: How do I prevent Open Office from changing the first letter to lowercase in my CSV?

Select Tools > AutoCorrect Options and then the Options tab.

Near the top of the list, uncheck the [T] box next to "Capitalize first letter of every sentence".

Click OK at the bottom of the dialog to apply the change.

Common Question 2: When I open my file in a spreadsheet view?

First make sure that the end of your filename is .csv. If the end of your file is .txt, then change it to be .csv. Then use Open Office to open the document. It should open a pop up similar to the image below:

Importing Product Data into your LightSpeed Point of Sale:

It is recommended that you create a starter template to work from. You can download the sample template here or generate your own using the 'Export' function in LightSpeed Point of Sale.

When opening the sample .CSV in Open Office, your initial screen should look the example below:

Product Code:  This is the unique field for your product. No product should have the same product code.

Description: This is the web store product title that appears on your web store.

Photo: Leave this column blank. This column allows you to import images automatically that match the product code.