Search our Help.

Lightspeed Retail: After the integration

Follow

How it will work

Once the integration is completed:

  • You will no longer need to manage stock through Lightspeed. Instead, you will receive your stock through Unleashed.
  • All stock reports should only be run in Unleashed.
As soon as the integration is performed, it creates a discount product. The discount is used as a sale where there is a discount line, it uses this Lightspeed discount product.

How Lightspeed and Unleashed will work together

The following processes are examples that demonstrate how Lightspeed works with Unleashed after the integration is completed.

Example process 1

  • You receipt in a purchase order in Unleashed.
  • Unleashed updates the quantities in Lightspeed for the products receipted.

Example process 2

  • You sell a product in Lightspeed.
  • A copy of the sales order is pulled into Unleashed.
  • Unleashed attempts to automatically complete the sale –or– if there is not enough stock, the sale is given the status ‘Parked’, and allocates stock to that sale.
  • Sales orders will be brought into the warehouse automatically, from the mapping that was configured during the setup process.

Viewing the Connection log

The Connection Log provides a list of every single action that has occurred during the integration process. For example, you can use the log screen to determine any issues that might occur during the integration process. This could include a validation error, or any other possible faults. You can use the Connection Log page to determine what the actual fault is, and then plan to fix accordingly. The logs only keep the last 7 days of activity.

Viewing in log levels

You can select the log level that you need to view for analysis. 

  • ERROR: Displays error type logs.
  • INFO: Displays general log information, such as products details being transferred.
  • ALL: Displays all log levels.

Using your accounting provider with Unleashed & Lightspeed

This diagram demonstrates how the three systems work together when fully integrated.

 

Artboard 1.png

 

Pricing cannot be sent to the tax inclusive field in Lightspeed, it is only sent to the tax exclusive field. This means that you need to set up all your retail pricing in Unleashed as tax exclusive.

How accounting providers work with Unleashed

If you are using an accounting provider, consider the following:

  • Unleashed will not send the invoice for a Lightspeed sale to your accounting provider. Otherwise, this would duplicate the process.
  • Unleashed sends the sales journal for the transaction to your accounting provider. This is adjusting your stock levels.
Sales between Unleashed and Lightspeed may differ by a small amount, however; this should not affect your reconciliation as Lightspeed sends both the Sales and the Payment to the accounting provider.

Close Lightspeed registers each day

In order for someone to be confident that all the information in the three systems are up-to-date, you must close all the registers that you are using by the end of each business day.

Returns & Credits

In Lightspeed, returns and credits are handled by entering negative lines on a sale . This does not work the same way as Unleashed, so the sale cannot be imported (Unleashed has a separate module for Returns and Credits).

How to handle your returns and credits

The best way to handle your returns and credits is to do a manual adjustment in Unleashed for the stock returned in Lightspeed (on a regular basis i.e. daily).

  1. In Lightspeed, export the sales history to find the returned products

    1. Go to History in Lightspeed.

    2. Filter down the history based on the relevant Date and Register.

    3. Click Export CSV at the top right. Note that Lightspeed can only export a sales report if there are less than 1000 records in a day.

  2. With the exported file, filter the rows using the Quantity column (you want the products with a negative quantity as these are your Returns/Credits).

  3. Enter a stock adjustment in Unleashed to add back these negative quantities for each product.

Field validation mappings

The following is a list of field validations that need to be mapped during the Lightspeed integration. All available information has been gathered to ensure you have the easiest integration possible.

Products

 Unleashed Lightspeed
Product Code Product Handle (Lightspeed strips out any space)
Stock Keeping Unit (SKU**)
Product Description Product Name + Vend Variant Name (Vend > UNL) (only updates if there are no variant/s)
Product Group Type
(note: one-way sync from Unleashed to Lightspeed only)
*Barcode

Product Handle (Only applies in product creation)

Notes Notes
Default Purchase Price Supply Price (only applies in product creation)
Default Sell Price Retail Price (excluding tax)

*This is optional and dependent on the barcode. To establish this synchronization, please contact Unleashed Support.

**There are different SKU types in Lightspeed (Custom, EAN, ISBN, ITF, JAN, UPC). Unleashed currently maps Product Code to “CUSTOM”. Products can have many SKUs of the same type.

  • Unleashed only overrides the first product code of Custom Type, if there isn’t any custom type product code we create one.
  • Unleashed will only update or create a new product code in Vend and will not update the SKU.
  • We Update the product code if there’s a custom type on an existing product; if there is none, Unleashed will create a new custom type for the product. If there's an existing product code in Vend that we want to update the value into - this will throw a duplicate SKU error. 

 Customers

Unleashed Lightspeed
Customer Code Customer Code
Customer Name Customer Name
Postal Postal
Street Address / PO Box Street
Town/City City
Postal Code Physical postcode
First Name Contact Name (First Name)
Last Name Contact Name (Last Name)
Email Address Email
Website Website
Fax Number Fax
Mobile Number Mobile

 

Stock on Hand

Unleashed Lightspeed
Available Quantity Current Stock
Was this article helpful?
0 out of 0 found this helpful