StoreRobo Import Export Suite is a Shopify app designed to streamline store data management. In this guide, we’ll walk you through the seamless import or export of your Shopify product data.
Export Products
Once you have the app on your store:
- Go to Apps > StoreRobo > Home from the Shopify admin dashboard.
Step 1: Choose Template
Under the Export section, choose an export template – The available export templates are:
- Shopify CSV
- Google Shopping Feed.
Click Proceed to move forward.
Step 2: Select data to export
- Under Select data, choose the data type as Products.
- Expand the selected data type.
- Under Columns, choose specific data columns to export.
- Additionally, to filter the data columns, click on Add new filter under Filters.
- Set up the necessary filters.
- 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.
- To save your current configuration as a preset and ensure you won’t need to reconfigure columns or filters next time for the same export, click Save and key in a name for your preset under the Save preset section.
- You can choose to export the data immediately or schedule it for a future date.
Step 3: Export
Click on Export to begin the process. Alternatively, click on Schedule to schedule the Export. 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 from In progress 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.
Import products
Once you have the app on your store:
- Go to Apps > StoreRobo > Home from the Shopify admin dashboard.
Step 1: Choose import file
- 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.
- Once you’ve chosen the import path, navigate to Choose Separator and select the delimiter or separator corresponding 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. For more information on delimiters, refer to Uncovering Delimiters: Crucial Data Organization Techniques.
- Under Select data type, select Orders.
- Click on Proceed (Upload for local storage).
Step 2: Select import template and filters
Select a template
Based on the uploaded file, the import template will be automatically detected among Shopify CSV, WooCommerce CSV, and Custom CSV.
If the selection is wrong, select the import template from the drop-down. The available options include:
- Shopify CSV
- WooCommerce CSV
- Custom CSV
Filter data
You can filter products from being imported based on the product status. Under the Product Status dropdown, choose the product status on which the products will be imported.
The three available options are:
- Active: Import active products only.
- Draft: Import drafted products only.
- Archived: Import archived products only.
Select options
Here, you have different options for importing products to your Shopify stores.
- Ignore ID
- Update If products exist in the store
- Skip import of new products
- Publish New product
Additionally, save the current selections as a preset under Save preset. Then click on Save and provide the preset name.
If the Import template is chosen as Custom CSV, the mapping screen shown below will appear.
Shopify uses specific terms for its data fields, while your source file (like a CSV) might use different names for the same information. Mapping tells Shopify which column in your file corresponds to the data it needs, like Product Title or Variant Price. This ensures your data gets imported into the correct fields within Shopify.
After choosing the required options, click on Import to import the products. You can also schedule the import.
Step 3: Import
Click on import to begin the import 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.
Clicking on the Import button in the previous step will initiate the import process in the store. The import duration will depend on the number of products getting imported.
After the import is finished, the Status will change to Completed. Click on the Log button to download the product import log.
The fields in the import screen are similar to the export screen.
- Job ID – The ID for the product import action.
- Identified – Total number of products identified in your store.
- Skipped – Number of products skipped from being imported. (Only visible if you selected any product filters or choose to skip products from being imported)
- Started At – The start date and time information.
- Status: The status of the import process.
- Imported – Number of products imported.
- Failed – Number of failed products from importing. (if any)
- Ended At – The end date and time information.
