Skip to main content

Vendor integration - Google Sheets (URL)

Filipa
Filipa
  • Updated

Introduction

In this article, we describe how to integrate with a vendor using Google Sheets (URL). Your vendor can use Google Sheets to sync products.

Creating your inventory feed

❗️You can use our template to create your vendor's product catalog. Read the section MAPPING VALUES CORRECTLY below if you want to import a custom file.

Format Guidelines:

  1. The data in the spreadsheet should be in tabular columns, each with a header and the values below.

  2. Choose Sheet tab.

  3. Onport cannot import sheets that do not list data in this tabular format.

  4. Not all columns have to be imported as well. Those can be left blank. 

Data formats

It's fine to use formatting if you want (e.g. make the column headers bold or highlight out-of-stock items in red). However, you need to ensure the numeric data is correctly formatted.

❗️Important: When adding inventory quantities, they should be a whole number and not contain any text (e.g. 1 not 1 in stock). Decimal numbers (e.g. 10.00 will just be rounded to the nearest whole number). Price, sale price, cost price - Should be a number and not contain any text (e.g. 9.99 not 9.99 EUR). Headers are also case-sensitive.

Connecting to Google Drive

Video tutorial: How to share data from a Google Sheet

Once you've created your Google Spreadsheet and mapped the columns to Onport, you then need to add the URL of the document in the feed settings. Onport will then check the document for updates every hour (larger feeds might take longer). You can also manually trigger an import if needed by fetching the feed.

  1. You'll need to publish the document you want to share under File > Publish to the Web so Onport can access it.

  2. After that, click on the top right "Share" button and choose the option “Anyone on the internet with this link can view”:

    Captura_de_ecra__2021-09-22__a_s_09.48.52.png

  3. Copy the URL of the document from the top bar. Do not copy the sharing URL.

  4. Back in Onport, under the inventory feed settings add the document link.

  5. Save the settings. Your feed should then be imported within the hour. If you need it quicker than that, click Feed Items on the top right and then click Fetch. Follow the steps on the pop-up - you'll be notified by email once your import is complete or you can access it at the bottom left section of the app, under Exports:

Mapping the inventory feed

Once you've set up your spreadsheet, you need to map the data. Under the Mappings section in the feed settings. There are four options:

Update inventory only

Select if you have two columns, sku and qty. The spelling and casing of these should match exactly.

Update inventory and prices only

Select if you have three columns, Price(retail_price, cost_price, compare_at_price), sku and qty. The spelling and casing of these should match exactly. For price, you need to have at least one of the price options but can also have additional ones. 

Product data for publishing

Select if you want to use our preset mapping for product publishing. You can use this file as a template.

Custom mapping

Use this when you want to use your own column titles or want to add additional fields. For example, if you had a column that stored the sku.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk