Clear a sandbox database of all orders & items

mikesitmikesit Member Posts: 36

How do we get a sandbox DB cleared (orders & items only, NOT settings)?

We've been developing on this sandbox for a few years now and the DB is full of old archived Orders & Items.

We are running into the issue where querying an Order by RefNum="Q37010" AND completed=false AND archived=false. (URL: https://api.lightspeedapp.com/API/Account/XXXXXX/Order?refNum=Q37010&archived=false&complete=false&load_relations=[%22OrderLines%22,%22Note%22,%22Vendor%22,%22Shop%22,%22CustomFieldValues%22])

This query is returning the archived Order; with the above query we do not expect this result, we expect that Order to NOT Exist.

So, this question is "Who do we speak with to get the sandbox cleared of Archived Orders & Items?

Regards,

Rock

Answers

  • Ali_MasoumieAli_Masoumie Moderator, Lightspeed Staff Posts: 340 moderator

    Hello Rock,

    It is not possible for us to delete archived orders and items. You could create a new demo shop and have us extend it so you have a new test account, but before we do that, can you send me your accountID so that I can have a closer look at your query.

  • mikesitmikesit Member Posts: 36

    Hey Ali,

    I sent you a PM with account ID.

    Rock

  • mikesitmikesit Member Posts: 36

    Ali,

    Do have any info for us on this?

    The PM you sent me does not address the problem.

    Are you still looking at it?


    Thanks

    Rock

  • Ali_MasoumieAli_Masoumie Moderator, Lightspeed Staff Posts: 340 moderator

    Hi Rock,

    Please check your PM.

  • mikesitmikesit Member Posts: 36

    Ali,


    Are you there?

    I've been waiting 10 days for a reply to the last PM.

Sign In or Register to comment.