Home > Docs > StoreRobo - Shopify Product Import Export App > SR Product Import Export for Shopify – Troubleshooting Guide

SR Product Import Export for Shopify – Troubleshooting Guide

Last updated on July 15, 2024

SR Product Import Export is an advanced product import/export tool to migrate, update and manage product data for Shopify stores. However, even the most robust tools can encounter unexpected hitches that interrupt the app’s seamless performance momentarily. This is a comprehensive troubleshooting guide to help you address and resolve common import-export-related issues.

This case can occur under the scenario of importing data via WooCommerce API. Both the consumer key and secret credentials will be correct but the connection won’t be established successfully.

Solution
  1. From the WordPress admin panel, navigate to Settings > Permalinks.
  2. Select the Permalink structure as the Post name.
  3. Save the changes.
  4. Once the permalinks are updated, establish the connection.

This error mainly occurs due to 2 reasons.

Case 1: Wrong FTP credentials

Entering any of these credentials wrongly can cause failed FTP connection:

  • FTP server host/IP
  • FTP username
  • FTP password
  • FTP port number
 Solution

To upload an FTP file without failure:

  1. Double-check the FTP credentials before establishment.
  2. Ensure the exact import path is entered.
  3. This will avoid connection not successful scenarios and will upload the FTP file successfully.
  4. You can also check the credential’s integrity in FTP client applications, such as: FileZilla. On successful connection, the folder path will be listed under Remote site as shown below:
Server connection successful in FileZilla
Server connection successful in FileZilla
Case2: Connection refused by the server

In certain scenarios, all the FTP credentials will be correct, yet the connection will still fail. This situation occurs because of restrictions or blocks imposed by the hosting providers on the server side.

  • In this case, FTP connection will be unsuccessful in client application like FileZilla.
  • The blocking or restrictions are usually from hosting providers. The restrictions can occur due to blacklisting of IP address or due to restrictions on country codes.
 Solution
  1. Reach out to the hosting provider and inquire about the cause of the restriction.
  2. Also, activities such as whitelisting of IP can avoid this error and result in successful FTP connection.

Overview

When importing smart collections into Shopify using StoreRobo Import Export Suite by WebToffee, you might encounter an Invalid rules details error. This error typically occurs due to incorrect or incomplete data in the rules section of your CSV file.

When does the error occur?

The error occurs if:

  • Mandatory columns are missing: Ensure that columns like Rule: Product Column, Rule: Relation, and Rule: Condition are correctly populated.
  • Invalid data entries: Entries in the rules section don’t match the expected values. For example, using a non-supported relation type or an empty condition value.

Solution

  1. Verify required columns:
    • Ensure the presence of Rule: Product Column, Rule: Relation, and Rule: Condition.
    • Populate the Must match column correctly with values like all conditions or any condition.
  2. Check Data Validity:
    • Ensure that Rule: Product Column contains valid values (e.g., Title, Vendor, Tag).
    • Verify that Rule: Relation includes valid relations (e.g., Equals, Contains).
    • Ensure Rule: Condition is not empty and contains valid values relevant to the selected product column.
  3. Validate CSV Format:
    • Ensure the uploaded file is in CSV format.
    • Use the sample CSV files provided to cross-check your file.

Example

If importing a smart collection to include products where the tag is “Plants”:

  • Must match = all conditions
  • Rule: Product Column = Tag
  • Rule: Relation = Equals
  • Rule: Condition = Plants

Your issue is not on the list..?

If you continue to experience difficulties, feel free to contact our support team. Provide them with the error details to receive additional help and guidance.