How to use import and export function

This function allows users to quickly add data to your product feed from multiple formats such as CSV files or Google Sheets. A subset of products can be exported, such as ones with missing GTINs, then re-imported once the data is complete.

Navigate to the left hand side menu and to Products

Screenshot 2024-02-13 at 5.24.12 pm

Once the Products screen, both the Import and Export function is found towards the top right hand corner of the page.

Screenshot 2024-02-13 at 5.46.45 pm

Exporting product data

Exporting your product data is useful in a number of situations. For example, you can:

  • Make a backup of your optimizations
  • Share data with someone else

To export your product data:

  1. Edit the columns the Products screen so that it shows the fields you want to export.
  2. Optionally, apply filters by clicking Add Filters.
  3. Click Export.

Your browser will automatically open a new tab with a Google Sheet containing your exported data.

Importing product data

You can import product data from a variety of sources, including Google Sheets, CSV files and others. This is useful if you want to:

  • Integrate information other systems
  • Re-apply exported (and edited) data

To import your product data:

  1. Navigate to the Products screen.
  2. Click Import.
  3. Choose the type of file you wish to import from:
    1. File: any type of file you want to upload, including comma separated (.csv), tab separated (.tsv or .txt) or XML. You can also upload zipped versions of any of these file formats.
    2. URL: if your file is available at a URL you can enter the URL here.
    3. Google Sheet: if your data is available in a Google Sheet (e.g. because you exported it from FeedOps) you can import directly from the sheet. You will be asked to authorise access to the sheet, and then you will need to select which tab to fetch the data from.
    4. Google Content API: if your data is already present in Google Merchant Center, you can import it into FeedOps directly using Google's Content API. You will be asked to authorise access using the account you use to log in to Google Merchant Center.
    5. Microsoft Content API: similarly if your data is already in Microsoft Merchant Center, you can import using Microsoft's Content API.
  4. Once you have selected the source, you will need to choose which fields you want to import.
    1. For each field, select the FeedOps Field from the dropdown list, the choose which column you wish to use as the source for that field.
    2. Your product data must have a column containing the Item ID for each product, as this is what is used to connect your imported data with the data already in FeedOps.
  5. If you want to import your data to all channels, check the box next to Save to these channels
  6. Save your data:
    1. Click Save to apply your changes to the feed immediately.
    2. Click Save As Suggestions to save the data for you to review later.