Live webinar · 16 September 2026 · 11:30 AM CT: From Chat to Order: The WhatsApp Sales Agent for SAP Business One Save my Seat
appse ai reads each Lightspeed XRetail stock change, maps the outlet to its Shopify location through Airtable, and sets the quantity for that location.
Apps used in this template
About this template
A multi-store retailer does not have one stock figure, it has one per outlet, and Shopify wants them per location too. Keeping those aligned by hand means someone knows which till maps to which fulfilment site and updates the right one, which is why most retailers fall back on a nightly total and oversell the last unit. This template pushes each stock change to the location it actually belongs to.
Key benefits
Inside the flow
appse ai runs this workflow from a Lightspeed XRetail stock change through validation, outlet identification, and Airtable location mapping to a per-location quantity set in Shopify.
appse ai starts when product stock is updated in Lightspeed XRetail, whether the movement came from a sale, a transfer, or a consignment adjustment at any outlet. Every location's stock movements enter the same process rather than only the ones someone remembers to report.
appse ai passes the incoming payload through a filter that checks the stock delta is plausible before anything downstream runs. An obviously wrong adjustment is stopped here rather than being published to the storefront and corrected afterwards.
appse ai searches Lightspeed XRetail records to establish which physical outlet the stock change belongs to. Without this the quantity could be applied to the wrong site, which is the failure that makes multi-location sync worse than no sync.
In parallel, appse ai retrieves the Lightspeed XRetail product and its inventory levels by product ID, then locates the corresponding product in Shopify. The quantity that gets published is the live figure, not the delta that triggered the run.
appse ai queries the Airtable mapping table to translate the Lightspeed XRetail outlet into its matching Shopify location. Keeping that matrix in Airtable means opening a new store is a row your team adds, not a change to the workflow.
appse ai merges the product, location, and inventory results into one payload, activates the inventory location in Shopify, then sets the available quantity for that location. The storefront shows what is on that shelf, so shoppers are not sold the last unit twice.
Publish each outlet's real stock position to its matching Shopify location as movements happen, rather than as a nightly total.
01
Shopify availability follows the shelf, so the last unit is not sold twice while a batch file waits.
02
Each Shopify location receives the quantity from its own Lightspeed XRetail outlet rather than a blended figure.
03
Opening or closing a store is a row in the Airtable table, not a change to the workflow.
04
Stock movements publish as they happen instead of waiting for an end-of-day upload.
05
The validation filter holds back implausible deltas before they reach the storefront.
06
The quantity written to Shopify is read from Lightspeed XRetail at run time, so drift does not accumulate.
07
Sales, transfers, and consignment adjustments all enter the same process.
08
Adding outlets adds mapping rows rather than reconciliation work.
01
Shopify availability follows the shelf, so the last unit is not sold twice while a batch file waits.
02
Each Shopify location receives the quantity from its own Lightspeed XRetail outlet rather than a blended figure.
03
Opening or closing a store is a row in the Airtable table, not a change to the workflow.
04
Stock movements publish as they happen instead of waiting for an end-of-day upload.
05
The validation filter holds back implausible deltas before they reach the storefront.
06
The quantity written to Shopify is read from Lightspeed XRetail at run time, so drift does not accumulate.
07
Sales, transfers, and consignment adjustments all enter the same process.
08
Adding outlets adds mapping rows rather than reconciliation work.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Customize this workflow to match your own outlet mapping table, validation rule, and Shopify location structure.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.
SOC 2
SAP Certified Partner
ISO/IEC 27001
GDPR
