Dropship

Vendor integration - Google Drive

Integrate live vendor inventory feeds from Google drive to keep track everything in real time.

Last updated July 2nd, 2020

Creating your inventory feed

Jetti can import inventory feeds from spreadsheets in Google Drive. If you're creating a new document to import, you'll first need to create the columns and populate the data. If you're working with an existing vendor file, please also read this section and it details our required format for the spreadsheets.

The data in the spreadsheet should be in tabular columns, each with a header and the values below. Jetti cannot import across different sheets (coming soon) or import sheets which do not list data in this tabular format.

You can add any column headers you like. Also, not all the columns have to be imported. For example, you can add a "notes" column to record any additional information (e.g. perhaps the color or size of the item) that won't be imported into Jetti.

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.

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)

Mapping the inventory feed

Once you've set your spreadsheet up, you then need to map the data. Under the Mappings section in the feed settings. There are three 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, sku and qty. The spelling and casing of these should match exactly.

Custom mapping

Use this when you want to use your own column titles or want to add additional fields (e.g. the product name or image). For example, if you had a column which stored the SKU:

  1. Enter sku for the header name field in Jetti (or whatever you’ve entered for the column header in your spreadsheet)
  2. Select sku from the dropdown and click Add inventory feed field.

You'll then need to repeat for any other columns. You only need to map the columns for which you want to sync data. There are sometimes additional fields such as separator that appear for the different field types, you can leave this blank.

Note: The order of the columns does not matter when creating the mappings. For example, if you have a sku column it doesn't matter whether it's the first, 2nd or last column in the spreadsheet. However, the spelling and case is important and needs to match exactly.

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 Jetti, you then need to add the URL of the document in the feed settings. Jetti will then check the document for updates every hour (larger feed might take longer). You can also manually trigger an import if needed.

  1. You need to publish the document you want to share under File > Publish to the Web so Jetti can access it.
  2. Then, copy the URL of the document from the top bar. Do not copy the sharing URL.
  3. Back in Jetti, under the inventory feed settings add the document ID (e.g. the highlighted part of this example https://docs.google.com/spreadsheets/d/abcd1234abcd1234abcd1234)

Save the settings. Your feed should then be imported within the hour. If you needed it quicker than that, click through on Feed items and then click on the Fetch. Follow the steps on the popup - you'll be notified by email once your import is complete.

Step 1

Mapping Values

When mapping values, you need to have the Name, qty, and SKU.

Important: qty needs to be written that way, with lower case. If you write quantity or Qty, it won't work.

FAQs

How to map values correctly in CSV or Google Sheets?

When mapping values, you need to have the Name, qty, and sku.

Important: qty needs to be written that way, with lower case. If you write quantity or Qty, it won't work.

Read more about mapping values correctly here.

Last updated July 2nd, 2020

How do I integrate with my Wix vendor?

You can pull in inventory from your Wix vendors using either a CSV, or Google Drive sheet. The sheet needs to include columns with Sku and qty as headers.

Last updated July 2nd, 2020

Back to Dropship