Skip to main content
All CollectionsHow to Use the Google Import Feature in SellerVue
How to Use the Google Import Feature in SellerVue
How to Use the Google Import Feature in SellerVue

Learn how to use the google import feature to import working sheets from Google into SellerVue

Ava Maddox avatar
Written by Ava Maddox
Updated over 6 months ago

The Google Import Feature in SellerVue streamlines the process of importing working sheets from Google Sheets into the SellerVue platform. This guide will walk you through the steps required to successfully import your data, ensuring you use the correct formatting and follow best practices.

Step-by-Step Guide to Import Working Sheets from Google Sheets into SellerVue

Step 1: Access the Template

To start, you'll need to use the provided template designed for compatibility with SellerVue. Click on the link below to open the template in Google Sheets:

Step 2: Make a Copy of the Template

Since the template is view-only, you need to make your own copy to edit it:

1. Open the template.

2. Go to `File` in the menu.

3. Select `Make a copy`.

4. Save the copy to your preferred Google Drive location.

Step 3: Customize Your Copy

Now that you have your own editable copy of the template, you can input your specific data. Ensure that you follow these guidelines for the `Cost Type` column:

- SHIPPING

- FACTORY_INVOICE

- CUSTOMS_AND_DUTIES

- INSPECTIONS

- LOCAL_FREIGHT

- PHOTOGRAPHY

- DESIGNER_FEES

- PRODUCT_SAMPLES

- PRODUCT_TESTING

- STORAGE

- INSURANCE

- BANK_FEES

- OTHER

IMPORTANT: Ensure the text is entered exactly as shown to avoid import errors.

Step 4: Import Your Data into SellerVue

Once you have completed your Google Sheet with all necessary data and correct formatting, follow these steps to import it into SellerVue:

1. **Copy the URL of Your Google Sheet:**

- Open your customized Google Sheet.

- Click on the address bar and copy the URL.

2. **Paste the URL into SellerVue:**

- Log in to your SellerVue account.

- Navigate to the import section where you can input Google Sheets URLs.

- Paste the copied URL into the provided field.

3. **Initiate the Import:**

- Follow any additional prompts to complete the import process.

- SellerVue will process the data and integrate it into your system.

Tips for a Smooth Import

- **Double-check Your Data:** Ensure that all required fields are filled and formatted correctly.

- **Consistent Cost Types:** Use the exact text for the `Cost Type` column to prevent mismatches or errors.

- **Test Small Batches:** If importing a large dataset, consider testing a smaller batch first to confirm everything is set up correctly.

By following these steps and tips, you can efficiently import your working sheets from Google Sheets into SellerVue, saving time and ensuring accuracy in your data management processes.

Did this answer your question?