Flow template · Export data

Export Lightspeed Retail (R-Series) Serialized Items

Start with a blank template to fetch and export Lightspeed Retail (R-Series) Serialized Items. Add filters and choose the fields you want to export.

Get started Back to templates

Month-to-monthHuman setup helpNo surprise usage bills

01The result

What this template is ready to do.

Template outcomeFlow starting point

Build your own export by adding filters and selecting the fields you need. You can run the flow manually or schedule it to run automatically.

Uses: Lsr Serialized
Definition: 4 dashboard stages
Run control: Manual or scheduled

How this template runs

The dashboard definition, from trigger to finished export.

Every stage below comes directly from this template in the Slynk dashboard.

01
trigger
Run automatically or manually
Run this flow automatically on a schedule or manually from the dashboard.
02
fetch
Fetch Serialized Items
The flow will fetch Serialized Items from your Lightspeed Retail (R-Series) account, ready for filtering.
03
filter
Filter Serialized Items
Choose which Serialized Items this flow applies to and add as many filters as you need.
04
action
Export Serialized Items
Choose the fields you want to export and add as many columns as you need.

A good fit when

A recurring data delivery needs to be reliable.

You need lsr serialized outside the POS regularly.
The recipient needs selected, renamed or joined fields rather than a basic export.
The result should run manually or arrive on a dependable schedule.

Product: Flow
What it does: Export data
POS platform: Lightspeed Series R
Uses: Lsr Serialized
Starting point: Build your own

Customisation catalogue

Start here. Make it fit the business.

This is the list of triggers, filters and export columns available for this exact template. Learn how customisation works.

2 available

Choose what starts the workflow

Triggers are the events that start this template. Use a dependable schedule or keep control with a manual run.

Scheduler

Run automatically at a specific time or interval: monthly, weekly, daily or hourly.

Trigger

Manual run

Start the template from the dashboard for testing or whenever it is needed on demand.

Trigger

341 available

Fields you can filter on

Use one or more conditions to target only the records that matter. Related POS information is available without building a separate integration.

Find a field

Browse all 341 fields by POS data group.

Other POS data341 fields

Lsr customer contact address address 1via Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address address 2via Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address cityvia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address countryvia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address country codevia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address statevia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address state codevia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact address zipvia Lsr customers contact › Lsr customer contacts addresses › Lsr customer contact addresses contact address

Lsr customer contact email addressvia Lsr customers contact › Lsr customer contacts emails › Lsr customer contact emails contact email

Lsr customer contact email use typevia Lsr customers contact › Lsr customer contacts emails › Lsr customer contact emails contact email

Lsr customer contact phone numbervia Lsr customers contact › Lsr customer contacts phones › Lsr customer contact phones contact phone

Lsr customer contact phone use typevia Lsr customers contact › Lsr customer contacts phones › Lsr customer contact phones contact phone

Lsr customer contact website URLvia Lsr customers contact › Lsr customer contacts websites › Lsr customer contact websites contact website

Lsr customer contacts contact IDvia Lsr customers contact

Lsr customer contacts no emailvia Lsr customers contact

Lsr customer contacts no mailvia Lsr customers contact

Lsr customer contacts no phonevia Lsr customers contact

Lsr customer contacts time stampvia Lsr customers contact

Lsr customer types customer type ID

Lsr customer types discount ID

Lsr customer types name

Lsr customer types tax category ID

Lsr customers archived

Lsr customers company

Lsr customers company registration number

Lsr customers contact ID

Lsr customers create time

Lsr customers credit account ID

Lsr customers customer ID

Lsr customers customer type ID

Lsr customers discount ID

Lsr customers dob

Lsr customers first name

Lsr customers last name

Lsr customers tax category ID

Lsr customers time stamp

Lsr customers title

Lsr customers vat number

Lsr item attribute sets archivedvia Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets archived

Lsr item attribute sets attribute name 1via Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets attribute name 1

Lsr item attribute sets attribute name 2via Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets attribute name 2

Lsr item attribute sets attribute name 3via Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets attribute name 3

Lsr item attribute sets item attribute set IDvia Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets item attribute set ID

Lsr item attribute sets namevia Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets name

Lsr item attribute sets systemvia Lsr items item attributes › Lsr item attributes item attribute set

Lsr item attribute sets system

Lsr item attributes attribute 1via Lsr items item attributes

Lsr item attributes attribute 2via Lsr items item attributes

Lsr item attributes attribute 3via Lsr items item attributes

Lsr item attributes item attribute set IDvia Lsr items item attributes

Lsr item categories category IDvia Lsr items category

Lsr item categories category ID

Lsr item categories create timevia Lsr items category

Lsr item categories create time

Lsr item categories full path namevia Lsr items category

Lsr item categories full path name

Lsr item categories left nodevia Lsr items category

Lsr item categories left node

Lsr item categories namevia Lsr items category

Lsr item categories name

Lsr item categories node depthvia Lsr items category

Lsr item categories node depth

Lsr item categories parent IDvia Lsr items category

Lsr item categories parent ID

Lsr item categories right nodevia Lsr items category

Lsr item categories right node

Lsr item categories time stampvia Lsr items category

Lsr item categories time stamp

Lsr item component assembly item IDvia Lsr items item components › Lsr item components wrapper item component

Lsr item component component groupvia Lsr items item components › Lsr item components wrapper item component

Lsr item component component item IDvia Lsr items item components › Lsr item components wrapper item component

Lsr item component item component IDvia Lsr items item components › Lsr item components wrapper item component

Lsr item component quantityvia Lsr items item components › Lsr item components wrapper item component

Lsr item manufacturers create timevia Lsr items manufacturer

Lsr item manufacturers create time

Lsr item manufacturers manufacturer IDvia Lsr items manufacturer

Lsr item manufacturers manufacturer ID

Lsr item manufacturers namevia Lsr items manufacturer

Lsr item manufacturers name

Lsr item manufacturers time stampvia Lsr items manufacturer

Lsr item manufacturers time stamp

Lsr item matrices archived

Lsr item matrices category ID

Lsr item matrices default cost

Lsr item matrices default vendor ID

Lsr item matrices department ID

Lsr item matrices description

Lsr item matrices item attribute set ID

Lsr item matrices item matrix ID

Lsr item matrices item type

Lsr item matrices manufacturer ID

Lsr item matrices model year

Lsr item matrices season ID

Lsr item matrices serialized

Lsr item matrices tax

Lsr item matrices tax class ID

Lsr item matrices time stamp

Lsr item notes is publicvia Lsr customers note

Lsr item notes is publicvia Lsr items note

Lsr item notes notevia Lsr customers note

Lsr item notes notevia Lsr items note

Lsr item notes time stampvia Lsr customers note

Lsr item notes time stampvia Lsr items note

Lsr item price amountvia Lsr items prices › Lsr item prices item price

Lsr item price amountvia Lsr item matrices prices › Lsr item prices item price

Lsr item price use typevia Lsr items prices › Lsr item prices item price

Lsr item price use typevia Lsr item matrices prices › Lsr item prices item price

Lsr item price use type IDvia Lsr items prices › Lsr item prices item price

Lsr item price use type IDvia Lsr item matrices prices › Lsr item prices item price

Lsr item shop average costvia Lsr items item shops › Lsr item shops item shop

Lsr item shop backordervia Lsr items item shops › Lsr item shops item shop

Lsr item shop component backordervia Lsr items item shops › Lsr item shops item shop

Lsr item shop component qohvia Lsr items item shops › Lsr item shops item shop

Lsr item shop item IDvia Lsr items item shops › Lsr item shops item shop

Lsr item shop item shop IDvia Lsr items item shops › Lsr item shops item shop

Lsr item shop last received costvia Lsr items item shops › Lsr item shops item shop

Lsr item shop last received lot IDvia Lsr items item shops › Lsr item shops item shop

Lsr item shop next fifo lot costvia Lsr items item shops › Lsr item shops item shop

Lsr item shop next fifo lot IDvia Lsr items item shops › Lsr item shops item shop

Lsr item shop on layawayvia Lsr items item shops › Lsr item shops item shop

Lsr item shop on special ordervia Lsr items item shops › Lsr item shops item shop

Lsr item shop on transfer invia Lsr items item shops › Lsr item shops item shop

Lsr item shop on transfer outvia Lsr items item shops › Lsr item shops item shop

Lsr item shop on workordervia Lsr items item shops › Lsr item shops item shop

Lsr item shop qohvia Lsr items item shops › Lsr item shops item shop

Lsr item shop reorder levelvia Lsr items item shops › Lsr item shops item shop

Lsr item shop reorder pointvia Lsr items item shops › Lsr item shops item shop

Lsr item shop sellablevia Lsr items item shops › Lsr item shops item shop

Lsr item shop shop IDvia Lsr items item shops › Lsr item shops item shop

Lsr item shop time stampvia Lsr items item shops › Lsr item shops item shop

Lsr item shop total value avg costvia Lsr items item shops › Lsr item shops item shop

Lsr item shop total value fifovia Lsr items item shops › Lsr item shops item shop

Lsr item shop total value negative inventoryvia Lsr items item shops › Lsr item shops item shop

Lsr item vendor num costvia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr item vendor num item IDvia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr item vendor num item vendor num IDvia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr item vendor num time stampvia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr item vendor num valuevia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr item vendor num vendor IDvia Lsr items item vendor nums › Lsr item vendor nums item vendor num

Lsr items archived

Lsr items avg cost

Lsr items category ID

Lsr items create time

Lsr items custom SKU

Lsr items default cost

Lsr items default vendor ID

Lsr items department ID

Lsr items description

Lsr items discountable

Lsr items ean

Lsr items item ID

Lsr items item matrix ID

Lsr items item type

Lsr items manufacturer ID

Lsr items manufacturer SKU

Lsr items model year

Lsr items publish to ecom

Lsr items season ID

Lsr items serialized

Lsr items system SKU

Lsr items tax

Lsr items tax class ID

Lsr items time stamp

Lsr items upc

Lsr price levels archived

Lsr price levels can be archived

Lsr price levels name

Lsr price levels price level ID

Lsr price levels type

Lsr sale embedded line avg costvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc line discountvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc subtotalvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc tax 1via Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc tax 2via Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc totalvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line calc transaction discountvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line create timevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line customer IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line discount amountvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line discount IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line discount percentvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line displayable subtotalvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line displayable unit pricevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line employee IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line fifo costvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line is layawayvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line is special ordervia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line is workordervia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line item fee IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line item IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line line typevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line normal unit pricevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line note IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line parent sale line IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line sale IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line sale line IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line shop IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line taxvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line tax 1 ratevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line tax 2 ratevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line tax category IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line tax class IDvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line time stampvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line unit pricevia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded line unit quantityvia Lsr sales sale lines › Lsr sale embedded lines sale line

Lsr sale embedded payment amountvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment archivedvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment cash rounding deltavia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment cc charge IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment create timevia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment credit account IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment employee IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment payment IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment payment type IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment ref payment IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment register IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment remote referencevia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment sale IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment sale payment IDvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale embedded payment tip amountvia Lsr sales sale payments › Lsr sale embedded payments sale payment

Lsr sale line notes is publicvia Lsr sale lines note

Lsr sale line notes is publicvia Lsr sales sale lines › Lsr sale embedded lines sale line › Lsr sale embedded line note

Lsr sale line notes notevia Lsr sale lines note

Lsr sale line notes notevia Lsr sales sale lines › Lsr sale embedded lines sale line › Lsr sale embedded line note

Lsr sale line notes note IDvia Lsr sale lines note

Lsr sale line notes note IDvia Lsr sales sale lines › Lsr sale embedded lines sale line › Lsr sale embedded line note

Lsr sale line notes time stampvia Lsr sale lines note

Lsr sale line notes time stampvia Lsr sales sale lines › Lsr sale embedded lines sale line › Lsr sale embedded line note

Lsr sale lines avg cost

Lsr sale lines calc line discount

Lsr sale lines calc subtotal

Lsr sale lines calc tax 1

Lsr sale lines calc tax 2

Lsr sale lines calc total

Lsr sale lines calc transaction discount

Lsr sale lines create time

Lsr sale lines customer ID

Lsr sale lines discount amount

Lsr sale lines discount ID

Lsr sale lines discount percent

Lsr sale lines displayable subtotal

Lsr sale lines displayable unit price

Lsr sale lines employee ID

Lsr sale lines fifo cost

Lsr sale lines is layaway

Lsr sale lines is special order

Lsr sale lines is workorder

Lsr sale lines item fee ID

Lsr sale lines item ID

Lsr sale lines line type

Lsr sale lines normal unit price

Lsr sale lines note ID

Lsr sale lines parent sale line ID

Lsr sale lines sale ID

Lsr sale lines sale line ID

Lsr sale lines shop ID

Lsr sale lines tax

Lsr sale lines tax 1 rate

Lsr sale lines tax 2 rate

Lsr sale lines tax category ID

Lsr sale lines tax class ID

Lsr sale lines time stamp

Lsr sale lines unit price

Lsr sale lines unit quantity

Lsr sales archived

Lsr sales balance

Lsr sales calc avg cost

Lsr sales calc discount

Lsr sales calc fIFO cost

Lsr sales calc non taxable

Lsr sales calc payments

Lsr sales calc subtotal

Lsr sales calc tax 1

Lsr sales calc tax 2

Lsr sales calc taxable

Lsr sales calc tips

Lsr sales calc total

Lsr sales cash rounded balance

Lsr sales cash rounded total

Lsr sales cash rounding delta

Lsr sales change

Lsr sales complete time

Lsr sales completed

Lsr sales create time

Lsr sales customer ID

Lsr sales discount ID

Lsr sales discount percent

Lsr sales displayable total

Lsr sales employee ID

Lsr sales enable promotions

Lsr sales quote ID

Lsr sales reference number

Lsr sales reference number source

Lsr sales register ID

Lsr sales sale ID

Lsr sales ship to ID

Lsr sales shop ID

Lsr sales tax 1 rate

Lsr sales tax 2 rate

Lsr sales tax category ID

Lsr sales time stamp

Lsr sales tip employee ID

Lsr sales tip enabled

Lsr sales total

Lsr sales total due

Lsr sales updatetime

Lsr sales voided

Lsr seasons name

Lsr seasons season ID

Lsr serialized color name

Lsr serialized customer ID

Lsr serialized description

Lsr serialized item ID

Lsr serialized sale line ID

Lsr serialized serial

Lsr serialized serialized ID

Lsr serialized size name

Lsr serialized time stamp

Lsr tax classes name

Lsr tax classes tax class ID

Lsr tax classes time stamp

Lsr vendor purchasing currency codevia Lsr vendors purchasing currency

Lsr vendor purchasing currency ratevia Lsr vendors purchasing currency

Lsr vendor purchasing currency symbolvia Lsr vendors purchasing currency

Lsr vendors account number

Lsr vendors archived

Lsr vendors b 2b seller uID

Lsr vendors name

Lsr vendors price level

Lsr vendors share sell through

Lsr vendors time stamp

Lsr vendors update cost

Lsr vendors update description

Lsr vendors update price

Lsr vendors vendor ID

342 available

Columns you can export

Select the POS fields that should appear in the output, then rename, order and format the columns for the destination.

Find a field

Browse all 342 fields by POS data group.

Other POS data342 fields