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.
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.
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:
- Enter sku for the header name field in Jetti (or whatever you’ve entered for the column header in your spreadsheet)
- 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's sometimes so extra fields like separator that appear for the different field types, most of the time you can just leave these 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
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.
- In the Google Drive account, select the file and edit its Sharing Settings. In the window the pops up, copy the sharing link and set the sharing settings to allow Anyone with the link to view the document.
- You also need to publish the document under File > Publish to the Web so Jetti can access it.
- Back in Jetti, under the inventory feed settings add the document ID (e.g. the highlighted part of this example
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.