Is there a way to enter bulk data into the Sandbox?

Hi Good Folks,

I hope you’re doing well. I’m here seeking some suggestions.

We’re building a system that requires testing bulk data from our Sandbox. I understand we use the application to enter data. However, that is not enough for us and need to upload synthetic data and timestamps for testing purposes. Is there a way to do so?

I’m also trying to access the Sandbox data using the API provided. Can anyone suggest how to retrieve orders? I’d highly appreciate it if anyone kindly share some sample codes.

Thanks in advance.

Best regards,

Niaz

:wave: At this time a set of bulk data isn’t currently available unless you seed the data in sandbox.

Also to retrieve orders in Sandbox you will use either SearchOrders or RetrieveOrder with the Orders API. :slightly_smiling_face:

Hi Bryan,

Thank you for your quick reply. We have the data but don’t know how to push it into the Sandbox. We’re currently using the app provided by Square but the problem is we want to test our system with a large dataset spanning over a long period (at least 12 months). With the app, first we cannot add large data and second it will take 12 months to have data with 12-months timestamp.

I’d appreciate if you give us a documentation showing (of course, if available) how to add bulk data without having to go through the app.

Best regards,

Niaz

Hi Niaz,

Currently with sandbox there isn’t a way to import large datasets that span multiple month. Sandbox doesn’t have a way to backfill data so you can test applications across multiple month without seeding the data over several months. We’re constantly working to improve our features based on feedback like this, so I’ll be sure to share your request to the API product team. :slightly_smiling_face:

Hi Bryan,

It would be really great if you let your API development team know about this feature. Importing a large dataset spanning multiple months into the Sandbox is the key to test our app.

Will it be possible for the API dev team to upload a large dataset into our Sandbox if we give them it in csv format?

Cheers,

Niaz

Unfortunately, backdating data isn’t currently available with our sandbox. I’ll be sure to share your request to the product team. :slightly_smiling_face:

Hi Bryan,

Thanks for sharing our request with the product team. I hope in a future release, we get that support. Meanwhile, I was wondering, do you have any test sandbox that can feed us data for performing a stress testing on our system?

Best regards,

Niaz

Unfortunately, do don’t have a sandbox that could feed you data for stress testing. You could build tests that would make large amounts of API calls to our sandbox. Then you could consume the data for testing. :slightly_smiling_face:

Start the wizard. From Setup, enter Data Import Wizard in the Quick Find box, then select Data,Import Wizard,Choose the data that you want to import,Map your data fields to Salesforce data fields,Review and start your import,Check import status.

My CC Pay

:wave: I’m happy to help, but I’m not sure I fully understand your question. Whenever you have a moment, please reply with a little more information describing your technical issue or question. :slightly_smiling_face:

I just found this response while looking for a way to get my production data into my sandbox. Is “seed(ing) the data in sandbox” something supported by a square developer tool?

:wave: At this time we don’t have a tool that would seed data for your sandbox account other than creating catalog objects with our Order Ahead Sample app. You will need to seed the account yourself or build scripts to do it for you. We’re constantly working to improve our features based on feedback like this, so I’ll be sure to share your request to the API product team. :slightly_smiling_face: