Is it Possible To Upload Historic Sales Data

in Development
Hi,
Is it possible to upload historic sales and purchase records from our old software to Lightspeed via the API?
Hi,
Is it possible to upload historic sales and purchase records from our old software to Lightspeed via the API?
5 comments
Yes it is.
Hi @darryl_ss,
It seems you've answered your own question! I will add though, that we also have a partner who can migrate data from another POS system to Lightspeed Retail if you (or anyone reading this) needs.
Have a great day,
Heather
I'd check to see if the transaction timestamps are hard-coded to be as of the import time and not the historical transaction time. That's something that stopped us short a few years ago...
Hi @gregarican & @Heather,
Our current sales data looks like this:
{
"shopID": "1",
"registerID": "1",
"employeeID": "1",
"completed": "true",
"referenceNumber": "10001000150",
"refernceNumberSource": "Opsuite",
"completeTime": "6/4/2017",
"TransactionQtySold": "2",
"TransactionTax": "2.82",
"TransactionTotalSales": "19.76",
"ItemSku": "380010",
"ItemDescription": "CRAFTSMAN'S KNIFE HVK",
"Supplier": "Casstrom Limited",
"Department": "KNIVES",
"Category": "FIXED BLADE",
"Price": "8.95",
"Cost": "2.63",
"QtySold": "1",
"Tax": "1.49",
"TotalSales": "10.44",
"BinLocation": "Z5"
},
{
"shopID": "1",
"registerID": "1",
"employeeID": "1",
"completed": "true",
"referenceNumber": "10001000150",
"refernceNumberSource": "Opsuite",
"completeTime": "6/4/2017",
"TransactionQtySold": "2",
"TransactionTax": "2.82",
"TransactionTotalSales": "19.76",
"ItemSku": "JRY-BIOSA",
"ItemDescription": "BISLEY SILICONE OIL AEROSOL",
"Supplier": "John Rothery (Wholesale)Co Ltd",
"Department": "CHEMICAL & CLEANING",
"Category": "OILS & GREASES",
"Price": "7.99",
"Cost": "3.67",
"QtySold": "1",
"Tax": "1.33",
"TotalSales": "9.32",
"BinLocation": "D"
},
An object for each item in a sale.
How would I need to format these objects to post to the sale API?
Thanks,
@darryl_ss Information on the format of data that can be sent to the sale endpoint can be found in our documentation here: https://developers.lightspeedhq.com/retail/endpoints/Sale/
Lightspeed HQ