Airtable offers Vendors on the marketplace to easily import large volumes of product into the marketplace using a simple import process.
The Airtable applicable is pre-configured for each Marketplace with the appropriate Categories, Attributes and Fields to make importing your products easy.
When you log in to your Airtable account you will be presented with a Product Import Base that has been shared with you by your marketplace administrator. This file is pre-configured with all the information you need to import your product successfully into the marketplace.
Note that the name of the file for your marketplace may differ from the name below.
Step 1: Create a Duplicate of this base for your products
The first step is to create a Duplicate of this base for your own products. If not you will be editing a shared base that is visible to others.
Click on the little white arrow on the bottom of the tile and select "Duplicate Base" This will create a copy of the base and you can rename this as required, based on your business. e.g. "Acme Product Base for MyMarketplace"
The Product Import Base
The product import base sheet will look as follows and will have several sections
2) The Table Grid
3) Table tabs
As you are inputing data to be imported into the marketplace you only need to focus on the Spreadsheet View of the first tab - Vendor Data Input Grid. All other tables are simply for processing data and you do not need to make any changes. Please do not change any values in these tables as your import will fail if you do.
The first view selected by default is the "Vendor Data Input Grid" this is where you copy and enter any new product information that you wish to import into the marketplace.
Adding a new record
You can add a new record by simply typing into the next empty row (e.g. in Row 7 as per the image).
You can also simply copy and paste data from an existing excel spreadsheet where you have this product data available. Please note that some fields will only accept specific values, so you must select these values from the list or ensure you're pasting the correct value.
These fields are denoted by their design
In the screenshot below, the name field can take any value, but the product_online and Select Product Attributes field can only accept specific values.
To select a value, click on the [+] sign on the field
Then select a value
Note that if you are pasting values, as long as the value matches the selection options, the option will immediately be selected.
Every field in the table has descriptions associated to help guide you with relation to the fields purpose, and the data that must be input. To view the description, simply hover over the (i) icon.
Determining which products to add to your import sheet
Once all of your products have been added to the table, you can decide which products to add in your import sheet by simply clicking on the "Checkbox" on the "Add to Import Sheet" column.
Only the selected SKU's or records selected will display in the Product Import File for Download.
Saving the Import Sheet
1) Click on the "Product Import File for Download" view
2) Download the Product Import Sheet
This view will present the data that is ready to be imported to your marketplace. You can now save this data to a CSV file and upload it to the marketplace. To save the file click on the three dots (...) beside the View Name and select "Download CSV"
3) Download the Inventory allocation Sheet
IMPORTANT - please ensure that after every product import, where you've added new products to the marketplace, you must download and run the Inventory Allocation Sheet so that the product is assigned to the Vendor's Inventory.
Click on "Vendor Inventory Import File for Download"
To save the file click on the three dots (...) beside the View Name and select "Download CSV"
You are now ready to upload your files to the marketplace.