Overview
General overview of the Lightspeed Parts Exporter (LPE)
In the simplest terms, the Lightspeed Parts Exporter (LPE) is a microservice that pulls, processes, and merges parts and accessories from multiple Lightspeed accounts. The result is a CSV available for download at any time that can be uploaded to ARI to control e-commerce inventory.
This project is part of a wider project to have a unified parts and accessories e-commerce storefront using ARI as the website provider. Internally, ARI has records for thousands of parts from many different manufacturers. The LPE microservice pulls the manufacturer code and part number (among other things) from Lightspeed and puts it into a format that ARI can use. ARI then uses their database of parts to match up what's in the output file and makes those parts available for customers to purchase.
CSV File Download
The most up-to-date parts file will always be available for download at the same link. Simply click the link, and your browser will download the CSV file automatically to your device.
CSV Parts File Download: https://oz-dev-cdn.sfo2.digitaloceanspaces.com/lightspeed-parts-exports/powersports-parts.csv
If something doesn't look quite right with the file, you can always download the the debug file that contains a lot more information and explanation for each part:
LPE Process Overview
To keep the output CSV file as up-to-date as is feasible, the LPE microservice runs several times in a day.
LPE Schedule: Every hour, on the hour, from 7 AM to 7 PM, MST
(The process itself runs a few minutes before, so that the file is consistently updated by the top of the hour)
Every time the Lightspeed Parts Exporter runs, it follows the same steps:
Query the Lightspeed API for every part/accessory each dealership has that has one or more units of inventory available.
Merge any duplicate parts that exist at multiple dealerships.
If there is a duplicate part, the amount of available inventory for each is combined and the higher of the two prices is used in the final output.
Remove any parts from unsupported manufacturers.
Based on the manufacturer code, assign each part as either
OEMorAFTERMARKETand adjust the part number accordingly.Create the CSV file for ARI and the debug CSV file.
Upload the CSV files to the file server and make them available for download.
Guides
Now that you've got a good idea of the overview of the microservice, you can follow the guides and deeper explanations below:
Fundamentals: Dive a little deeper
Learn the fundamentals of LPE to get a deeper understanding of how it works:
Last updated