Import / Export Shopify Orders with StoreRobo

StoreRobo Import Export Suite is a Shopify app designed to streamline store data management. This article details the process of importing and exporting Shopify Orders data.

Once you have the app on your store:

1. From the Shopify admin dashboard, go to Apps > StoreRobo > Home.

Under the Export section, choose an export template – The available export templates are:

• Shopify CSV
• Google Shopping Feed.

Click Proceed to move forward.

1. Under Select data, choose the data type as Orders.
2. Expand the selected data type.
3. Under Columns, choose specific data columns to export.
4. Additionally, to filter the data columns, click on Add new filter under Filters.
5. Set up the necessary filters.

8. If you plan to export the data to an FTP server, enable the Export file to FTP/SFTP option and set up a new FTP profile. If you already have an existing FTP/SFTP profile, select it. To know more about how to set up an FTP/SFTP server, refer to the article, Setting up an FTP/SFTP profile in StoreRobo.

9. Next, choose a separator/delimiter to separate your data inside the CSV file. To know more about delimiters, refer to, Uncovering Delimiters: Crucial Data Organization Techniques

10. To save your current configuration as a preset, ensuring you won’t need to reconfigure columns or filters next time for the same export, simply click on Save and key in a name for your preset under the Save preset section. To know more about presets, refer to Simplify Data Management with Shopify Import/Export Presets

11. You can choose to export the data immediately or schedule it for a future date.

Click on Export to begin the process. Alternatively, to schedule the Export, click on Schedule. For more information on scheduling your export, refer to the article Scheduling Shopify Import Export with StoreRobo.

Monitor the export progress until the status changes to Completed.

Once the Status changes to Completed, the export will be completed and you will be notified by email.

If you had chosen FTP/SFTP export, the data will be uploaded to the server. Otherwise, you can download it from here.

Once you have the app on your store:

1. From the Shopify admin dashboard, go to Apps > StoreRobo > Home.

2. Under the Import section, choose an import path. The supported import locations are:
   • Local storage – Upload the file directly to the app
   • URL – URL to a file that is hosted on the web
   • FTP/SFTP server – FTP URL to a file that is hosted on a FTP server
   • WooCommerce API – Import data directly from WooCommerce store.
3. Once you’ve chosen the import path, navigate to Choose Separator and select the delimiter or separator that corresponds to the one used in your CSV file. It’s important to ensure that the correct delimiter is selected, and you can verify this by using the preview feature.

4. Under Select data type, select Orders.
5. Click on Proceed (Upload for local storage).

Based on the selected file, the application will automatically identify the orders.

By checking the checkbox, the order item in the import file will be added to an existing order in the store if an order with the same name/ID already exists.

Click on import to begin the import process. Alternatively, to schedule the Export, click on Schedule. For more information on scheduling your import, refer to the article Scheduling Shopify Import Export with StoreRobo.

Monitor the export progress until the status changes to Completed.

On successful completion of the import process, you will be notified via email.