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:
Google Sheets Template
https://docs.google.com/spreadsheets/d/1XGBaqy6MA0GF_IMrVJMJ1fKsOL0lnRz63r98nA59lAs/edit#gid=0
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.