Lightspeed Retail: After the integration
FollowHow 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.
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.
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.
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).
-
In Lightspeed, export the sales history to find the returned products
-
Go to History in Lightspeed.
-
Filter down the history based on the relevant Date and Register.
-
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.
-
-
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).
-
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 | |
Website | Website |
Fax Number | Fax |
Mobile Number | Mobile |
Stock on Hand
Unleashed | Lightspeed |
---|---|
Available Quantity | Current Stock |