# Is there a way to enter bulk data into the Sandbox? **URL:** \ **Category:** Questions\ **Tags:** orders-api\ **Created:** [October 26, 2021, 8:20pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065 "2021-10-26T20:20:24Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Niaz](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@Niaz](https://developer.squareup.com/forums/u/Niaz)\ **Post date:** [October 26, 2021, 8:20pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/1 "2021-10-26T20:20:24Z")
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 ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [October 26, 2021, 9:54pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/2 "2021-10-26T21:54:51Z")
👋 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](https://developer.squareup.com/reference/square/orders-api/search-orders) or [RetrieveOrder](https://developer.squareup.com/reference/square/orders-api/retrieve-order) with the Orders API. 🙂 ---
**Author:** ![Niaz](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@Niaz](https://developer.squareup.com/forums/u/Niaz)\ **Post date:** [October 27, 2021, 8:57am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/3 "2021-10-27T08:57:44Z")
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 ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [October 27, 2021, 4:22pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/4 "2021-10-27T16:22:12Z")
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. 🙂 ---
**Author:** ![Niaz](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@Niaz](https://developer.squareup.com/forums/u/Niaz)\ **Post date:** [October 28, 2021, 10:49am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/5 "2021-10-28T10:49:38Z")
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 ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [October 28, 2021, 3:59pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/6 "2021-10-28T15:59:10Z")
Unfortunately, backdating data isn’t currently available with our sandbox. I’ll be sure to share your request to the product team. 🙂 ---
**Author:** ![Niaz](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@Niaz](https://developer.squareup.com/forums/u/Niaz)\ **Post date:** [November 8, 2021, 9:39am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/7 "2021-11-08T09:39:03Z")
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 ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [November 8, 2021, 4:53pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/8 "2021-11-08T16:53:11Z")
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. 🙂 ---
**Author:** ![Krystina](https://avatars.discourse-cdn.com/v4/letter/k/53a042/32.png) [@Krystina](https://developer.squareup.com/forums/u/Krystina)\ **Post date:** [November 26, 2021, 9:05am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/9 "2021-11-26T09:05:16Z")
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](https://www.myccpay.net/) ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [November 29, 2021, 4:46pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/10 "2021-11-29T16:46:25Z")
👋 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. 🙂 ---
**Author:** ![chris](https://avatars.discourse-cdn.com/v4/letter/c/958977/32.png) [@chris](https://developer.squareup.com/forums/u/chris)\ **Post date:** [February 1, 2022, 11:53pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/11 "2022-02-01T23:53:58Z")
> [@Bryan-Square](#): > > unless you seed the data in sandbox 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? ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [February 2, 2022, 12:28am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/12 "2022-02-02T00:28:25Z")
👋 At this time we don’t have a tool that would seed data for your sandbox account other than [creating catalog objects](https://developer.squareup.com/docs/orders-api/quick-start/step-3) 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. 🙂 ---
**Author:** ![rishavgoenka](https://avatars.discourse-cdn.com/v4/letter/r/74df32/32.png) [@rishavgoenka](https://developer.squareup.com/forums/u/rishavgoenka)\ **Post date:** [August 25, 2023, 11:09am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/13 "2023-08-25T11:09:41Z")
Hi Bryan. I have data in my production environment and I am creating a new Sandbox environment. I need the catalog data of my production environment in the Sandbox. I tried fetching the data using the api and then doing batch upsert catalog but that returned an error category: ‘INVALID\_REQUEST\_ERROR’, code: ‘INVALID\_VALUE’, detail: ‘Object of type MODIFIER\_LIST does not exist: ID=“23W3JLCW2EHLF5CD3K5M73A5”’ Any idea how I can resolve this or any other way I can upload the data to Sandbox environment. ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [August 25, 2023, 4:52pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/14 "2023-08-25T16:52:56Z")
The error your getting is cause the modifier list value your passing in doesn’t exist in sandbox. If your importing from production to Sandbox it may be best if you export the `.CSV` file and import the Catalog in sandbox. With the Item Import Tool, easily add new items to your library using an Excel (.xlsx) or CSV template. To get started with Item Import Tool, follow the steps below: 1. Visit **Items** in your [online Square Dashboard](https://squareup.com/dashboard/items/library). 2. Click **Actions** \> **Import Library**. 3. Select **Modify Item Library** to add new items and update existing items, or **Replace Item Library** to delete all existing items and replace them with your uploaded items. 4. Click **Next** \> Click **Download your item library** to download your current inventory Excel (.xlsx) or .CSV report **Export**. Select between Excel (recommended) or CSV. 5. Open the file saved to your computer in a spreadsheet program. 6. Fill in the template columns with your item information. When editing the template, keep the following tips in mind: - Don’t change any of the information in the Item ID column or delete empty columns. - Leaving the category field blank will leave the item as Uncategorized. - New categories will be created for any new values identified in the Category column. - Leaving the price field blank will create a variable priced item. - Leaving the modifier field blank will default the modifier to off. Place a “Y” in the appropriate Modifier Set column if you’d like a specific modifier applied to an item. 1. Save the edited file to your computer. 2. Drag and drop the file into the upload area or click **select it from your computer** \> **Upload**. 3. Review your changes and click **Confirm** to upload your new item library. 🙂 ---
**Author:** ![rishavgoenka](https://avatars.discourse-cdn.com/v4/letter/r/74df32/32.png) [@rishavgoenka](https://developer.squareup.com/forums/u/rishavgoenka)\ **Post date:** [August 27, 2023, 7:53am UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/15 "2023-08-27T07:53:52Z")
Hi Bryan. This is one way but if I wanted to use the apis then what method should I follow. From your earlier response I gather that I have to create some modifier list as well. Could you walk me through the process. ---
**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\ **Post date:** [August 28, 2023, 4:46pm UTC](https://developer.squareup.com/forums/t/is-there-a-way-to-enter-bulk-data-into-the-sandbox/4065/16 "2023-08-28T16:46:01Z")
Yeah, you’ll need to create the modifiers and lists prior to adding them to the items on creation. Once you have all the modifiers and lists created you’ll then be able to create the catalog objects with the generated IDs for the modifiers. 🙂