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

StoreRobo Import Export Suite – Troubleshooting Guide

Last updated on December 20, 2024

StoreRobo Import Export Suite 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

Overview

When you import products into your Shopify store, Metafields are also imported. However, the Metafields may not be visible on the storefront due to the following reasons:

  1. Case 1: The product data in the import file is missing Metafield columns or the columns are not named correctly.
  2. Case 2: The Metafields are imported but remain unstructured because Metafield definitions are missing.

Solution

Case 1: Missing Metafield Columns in the Import File

  • Issue: The Metafields are not imported because they are not included in the CSV file or are incorrectly formatted.
  • Fix:
    • Check your CSV file before importing to ensure all desired Metafields are included and formatted correctly.
    • Ensure each Metafield has a valid type and meta tag to define it as a Metafield.
    • Re-import the product data with the corrected Metafields.
Metafield validation
Metafield validation

Case 2

  • Issue: Even if Metafields are imported, they will remain unstructured if Metafield definitions are missing, making them invisible in the store.
  • FIx: Follow the given steps to structure you imported Metafield data.
  1. Open the Shopify Admin and navigate to Settings > Custom Data.
  2. Select the data type (e.g., Products, Variants) where the Metafields need to be added.
Shopify settings - Custom data
Shopify settings – Custom data
  1. To view the unstructured Metafields, click on View unstructured Metafields.
View unstructured data
View unstructured data
  1. A list of all unstructured Metafields will appear. Locate the Metafields you want to make visible and click Add definition next to each one.
Add new definition
Add new definition
  1. Fill in the Metafield definition details, including:
    • Name: A meaningful name for the Metafield.
    • Description: Optional, but recommended for clarity.
    • Type: Select the appropriate type for the Metafield (e.g., text, number, URL).
  2. Save the settings to create a structured definition for the Metafield.
Fill in the Metafield definition details
Fill in the Metafield definition details

After adding the necessary Metafield definitions, the previously unstructured Metafields will become structured. They will now appear on product pages and be usable in themes or storefront features.

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.