Is it Possible To Upload Historic Sales Data

darryl_ss

Hi,

Is it possible to upload historic sales and purchase records from our old software to Lightspeed via the API?

darryl_ss

Yes it is.

Heather

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

gregarican

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...

darryl_ss

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,

Leah

@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/