✨ Join our new Affiliate Program!

📊 Google Sheets Export And CSV Import

These features are only available with the Boutique plan.

To get started, install the Dotb Google Sheets add-on on your Google account. This add-on lets you import Dotb export files into Google Sheets and edit the data.

Export your Vinted listings to Google Sheets

You can only export items that are already saved in Dotb. First, make sure your items are saved, then use the Load Backup button to select the listings you want to export.

Watch this short demo to see how to export listings from your Vinted dressing and import them into Google Sheets using the Dotb add-on:

Import listings from a CSV file

You can also import listings into Dotb using a CSV file. The file must follow the same format as the Dotb export.

Check out this public Google Sheet for a sample export file.

Watch this quick demo to learn how to download a CSV file from Google Sheets and import it into Dotb:

About the Vinted fields

  • id: Not required when importing; serves as a reference to the original listing ID
  • title: String, up to 100 characters
  • description: String, up to 2000 characters
  • brand_id: Integer of the brand ID. When importing, it can be left empty if the brand field is filled—it will automatically set the brand_id
  • brand: String, brand name. When importing, if brand_id is filled, it will automatically set the brand
  • color1_id: Integer of the color Vinted ID (check the colors sheet)
  • color2_id: Integer of the color Vinted ID (check the colors sheet)
  • isbn: String, only used for books. Accepts both ISBN-10 and ISBN-13
  • is_unisex: Values: 0 or 1
  • catalog_id: Integer of the catalog Vinted ID (check the catalogs_hash sheet)
  • size_id: Integer (check the size_groups_by_catalog_id sheet)
  • status_id: Integer of the status Vinted ID (check the statuses sheet)
  • package_size_id: Integer (check the package_sizes_per_catalog_id sheet)
  • item_attributes: JSON string of materials and other attributes (check the catalog_attributes_per_catalog_id sheet for more info)
  • video_game_rating_id: Special field for video games (check the video_game_ratings sheet)
  • measurement_length: Number in cm
  • measurement_width: Number in cm
  • price: Number
  • currency: String, 3-letter currency code (e.g., EUR, PLN). Refer to your Vinted export for the correct code
  • photo_1 to photo_20: String URL of the photo. Note that the photo must be a publicly accessible URL. Google Drive does not work.

I recommend using Dropbox.

When you create a public link in Dropbox, you first get something like this:

// Public URL generated by Dropbox (preview link)
https://www.dropbox.com/scl/fi/nrhayhlc3v0oqhbj0wlsj/IMG_1999.jpeg?rlkey=dd3b535ajfzdbjy5xnjzq66mh&st=wa20fqiw&dl=0

This link shows the Dropbox preview page, not the raw image.

You can convert it with this formula in Google Sheets:

=SUBSTITUTE(A1,"www.dropbox.com","dl.dropboxusercontent.com")

So the working direct URL becomes:

https://dl.dropboxusercontent.com/scl/fi/nrhayhlc3v0oqhbj0wlsj/IMG_1999.jpeg?rlkey=dd3b535ajfzdbjy5xnjzq66mh&st=wa20fqiw&dl=0

About the Dotb fields

When importing a CSV file into Dotb, there are some extra fields that can be added directly to the Dotb save if you tick the “Save to Dotb after import” option.

Those fields are:

  • sku: Your custom SKU identifier
  • restock_enabled: Values: TRUE or FALSE (defaults to FALSE if left empty)
  • restock_quantity: Integer number. -1 means unlimited. Note that if you have a stock of 5, you should set the restock_quantity to 4, as this is the number of items that will be restocked when an item is sold
  • location: Used for inventory tracking. Can be any text
  • messages_enabled: Values: TRUE or FALSE (defaults to TRUE if left empty). This boolean indicates if you want to send messages to likes on this specific item
  • accept_offers_enabled: Values: TRUE or FALSE (defaults to FALSE if left empty). This boolean indicates if you want to accept offers automatically on this specific item
  • minimum_offer_price: Number. The minimum price for offers when accept_offers_enabled is TRUE
  • counter_offer_price: Number. The counter offer price for offers when receiving an offer below minimum_offer_price
  • purchase_price: Number. The price you paid for the item, used for profit calculation later

Import listings from a Shopify CSV file

Dotb also supports importing listings directly from a Shopify CSV file.

Watch this quick demo to learn how to download a CSV file from Shopify and import it into Dotb:

📨 Inbox Panel