How to export the Suggestion dictionary

You can export your redirects to a CSV file to help with several tasks:

  • Creating a backup of your suggestion dictionary.
  • Moving your existing suggestion dictionary to a new Shopify store.
  • Editing your suggestion dictionary in bulk using a spreadsheet.

Any changes that you make to the suggestion dictionary in your suggestion dictionary CSV file appear in your Suggestion dictionary if you import your suggestion dictionary CSV file into the Boost Product Filter & Search admin. 

The easiest way to edit a suggestion term in your Suggestion dictionary is to use the Suggestion dictionary add/edit in your Boost Product Filter & Search admin.

Export your Suggestion dictionary

If you export up to one page of products (up to 50 products), then the CSV file is downloaded by your browser. If you export more than one page of products (51 or more products), then the CSV file is emailed to you. If you aren't the store owner, then the file is sent to the store owner's email as well.

Steps:

    1
    From your Boost Product Filter & Search admin, go to Search menu > Suggestion dictionary
    Note: If you want to export only some of your products, then you can filter your suggestion list to view and select specific products for export.
    2
    Click Export.
    3
    From the dialog box, choose the products you want to export:
    4
    Select which type of CSV file you want to export:
    • CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit your product CSV file.
    • Plain CSV file. Use this format if you plan to use a plain-text editor with your product CSV file.
    5
    Click Export products.
Caution: Sorting your CSV file in a spreadsheet program can cause product variants or image URLs to become disassociated. Importing a CSV file that has been sorted might overwrite your existing products with bad data, which cannot be recovered.

Access your product image files

If you move your products to a new website and plan to close your current store or delete some of its product listings, then you need to upload your product CSV file to your new store while your old store and its product listings remain viewable.

When you export your products, the images associated with each product are not included in the CSV file. If you import the products to a new store, then the product images are generated only if they remain viewable on a publicly accessible website.

To ensure that your product images remain accessible to you, leave your original store and its products intact until you finish the import process. This allows your new store to assign the correct product image to each listing.


Use a text editor to edit your Suggestion dictionary CSV file

If you don't have a spreadsheet program, then you can edit CSV files using a text editor. 

You should only use a text editor as a last resort. For example, use a text editor if there are formatting errors in your CSV file and you cannot open it in a spreadsheet program.

Most computers have text editors that can open CSV files. You can also use a program like Atom or Sublime Text to edit and debug your CSV file.

Note: A CSV file with UTF-8 encoding is the only file format that can be used to import to or export from Shopify.

To format your CSV file in a text editor:

  • Column headers must be separated by commas (for example, First Name,Last Name,Email,Company,Address1).
  • The list of tags must be wrapped in quotation marks (for example, "tag1,tag2,tag3").
  • Different records must be separated by line breaks.

Filter and export your suggestion list

You can use filters to organize your products list before exporting. If you need to change only some of your products, then you can add a filter. It could be easier to edit your products using a shortened CSV, rather than your entire product list. Here are the steps:

    1
    On the Products page in Shopify, add a filter using conditions that list only the necessary products.
    2
    Export your products list, and make sure that you select the option to export only the products matching your filter.

A CSV file containing only those products in your filtered list will export.

After you make any changes to your exported product CSV, you can import the edited CSV file back to Shopify.