Change Lightspeed prices and tags

Sales & Inventory → Products → Prices changes Lightspeed prices and costs for as many items as you like in one go, so price increases don't mean editing items one by one. It needs the Retail add-on and Lightspeed connected.

Change prices

1. Find the items: type in Find items (name, System ID or UPC), or pick a Brand or Vendor, and click Find.
2. Each item shows its current Price, MSRP, Online, IMAP, MAP and Cost in Lightspeed, with a box under each for the new value. Margin shows the margin now and with the new price and cost. Leave a box empty to keep the current value.
3. For an item that belongs to a matrix, tick Matrix too to put the same values on the matrix.
4. Click Upload to Lightspeed.

Paste from a spreadsheet

If your price changes are already in Excel or Google Sheets, copy the rows and paste them under Paste from a spreadsheet, then click Fill in. The first column is the item's System ID (or UPC); the rest are new values. With a header row, columns named Price, MSRP, Online, IMAP, MAP and Cost are recognized in any order; without one, they're read in that order. Blank cells keep the current value. Items Lightspeed doesn't have are listed so you can fix them. Check the boxes, then click Upload to Lightspeed.

The upload

The upload opens on its own page. Items go to Lightspeed one at a time, about one a second, and keep going if you close the page. Each item shows its old and new values and Lightspeed's answer. If Lightspeed refuses an item, it says why, and the rest still go through. A new cost is also set on the item's default vendor, the way Lightspeed's own screens do.

Uploads lists every upload with how many items were saved and how many failed.

Shelf tags

Every item whose price changed goes on the Shelf tags list of each store that stocks it or reorders it. Pick the Shop to see that store's list, re-print the tags, and tick Done for each one. Done tags stay on the list for a day.

Item tags

Item tags sets Lightspeed tags on many items at once. Paste one item per line: its System ID (or UPC), then its tags separated by commas (a tab or a comma after the System ID both work). Choose Replace each item's tags or Add to each item's tags, then click Check. Items Lightspeed doesn't have, and tags it doesn't have yet, are listed. Add new tags in Lightspeed first, since only existing tags can be used. When everything checks out, click Upload tags. It runs like a price upload, with each item's new tags shown on the upload's page.