Is it Possible To Upload Historic Sales Data

darryl_ssdarryl_ss Member Posts: 11

Hi,

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

5 comments

  • darryl_ssdarryl_ss Member Posts: 11

    Yes it is.

  • HeatherHeather Administrator, Lightspeed Staff Posts: 95 moderator
    edited February 7

    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

    Lightspeed
  • gregaricangregarican Member Posts: 383 

    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_ssdarryl_ss Member Posts: 11

    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,

  • LeahLeah Moderator, Lightspeed Staff Posts: 170 moderator

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

    API Support
    Lightspeed HQ
Sign In or Register to comment.