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.
Process: 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.
How it will workOnce the integration is completed:
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.
Process: 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
Example process 2
Viewing the Connection logThe 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 levelsYou can select the log level that you need to view for analysis.
How accounting providers work with UnleashedIf you are using an accounting provider, consider the following:
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 dayIn 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 & CreditsIn Lightspeed, returns and credits are handled by entering negative lines on a sale (see image). 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 creditsThe 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).
For more information on how to filter in Excel, click here.
Field validation mappingsThe 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.
|