Effortlessly Import Products to Drop Shipping Zone
Effortlessly Import Products to Drop Shipping Zone
Table of Contents
- Getting Started
- 2.1 Requirements
- 2.2 Creating a dropship Zone Account
- 2.3 Using Microsoft Excel
- Selecting Products
- 3.1 Choosing Products with Free Shipping
- 3.2 Copying SKU Numbers
- Importing Products to Your Website
- 4.1 Accessing the Download Center
- 4.2 Uploading a Watermarked Photo (Optional)
- 4.3 Copying SKU Numbers for Import
- 4.4 Checking Import Status
- 4.5 Downloading the CV File
- Making Bulk Changes
- 5.1 Editing the Shopify CV File
- 5.2 Saving and Continuing
How to Import Products from Dropship Zone to an Excel Spreadsheet
In this article, we will guide you through the process of importing products from Dropship Zone into an Excel spreadsheet. This allows you to easily manage and edit product details, such as pricing, in a convenient and organized manner. We will provide step-by-step instructions and tips to ensure a smooth importing process.
Dropship Zone offers a wide range of products for dropshipping. By importing these products into an Excel spreadsheet, you can have better control over your inventory and easily make adjustments to product details.
2. Getting Started
Before you can start importing products, there are a few requirements you need to fulfill. Firstly, make sure you have Microsoft Excel installed on your computer. If you don't already have it, you can subscribe to Microsoft Office 365 for just nine dollars a month.
To access the Dropship Zone products, you need to have an active account. If you don't have one yet, we will guide you through the process of creating an account. Lastly, ensure you have a notepad or a word document open, as it will be essential for copying SKU numbers.
- Microsoft Excel subscription
- Dropship Zone account
- Notepad or word document
2.2 Creating a Dropship Zone Account
To create a Dropship Zone account, follow these simple steps:
- Visit the Dropship Zone website.
- Click on the signup or create account button.
- Fill in the required information and choose a secure password.
- Complete the verification process.
- Congratulations! You now have a Dropship Zone account.
2.3 Using Microsoft Excel
Ensure you have Microsoft Excel installed on your computer. If you don't have it, subscribe to Microsoft Office 365 for just nine dollars a month. Excel will be your tool for managing and editing product details.
3. Selecting Products
When selecting products to import, it is crucial to consider the shipping costs. To avoid complications and additional expenses, choose products with free shipping options only. Let's go through the process:
3.1 Choosing Products with Free Shipping
- Open Dropship Zone and search for the products you want to import.
- In the search results, focus on products with free shipping.
- Click on the product to view its details.
- Ensure the shipping cost is zero.
- Repeat this process for all the products you wish to import.
3.2 Copying SKU Numbers
Once you have selected the products, it's time to copy their SKU numbers. Follow these steps:
- Open a notepad or a word document.
- Locate the SKU number at the bottom of the product page.
- Copy the SKU number and paste it into the notepad or word document.
- Repeat this process for all the products you want to import.
4. Importing Products to Your Website
Now that you have the SKU numbers ready, let's proceed with importing the products to your website.
4.1 Accessing the Download Center
- Log in to your Dropship Zone account.
- Go to the "My Account" section.
- Click on the "Download Center" option on the left-hand side.
4.2 Uploading a Watermarked Photo (Optional)
In the Download Center, you have the option to upload a watermarked photo. This feature is optional and mainly used if you want to have a logo or branding on your product images. It is not necessary for the importing process.
4.3 Copying SKU Numbers for Import
In the Download Center, locate the section where you can see the SKU numbers. Copy the SKU numbers from the notepad or word document and paste them into the designated section.
4.4 Checking Import Status
After pasting the SKU numbers, you will receive a notification stating that your request has been submitted. To check the import status, click on the "My SKU" option.
4.5 Downloading the CV File
Once the import process is complete, you can download the CV file. Click on the "Download" button. The file will be a zipped folder containing the CV file and product photos.
5. Making Bulk Changes
To make bulk changes to the imported products, you need to edit the Shopify CV file. Follow these steps:
5.1 Editing the Shopify CV File
- Open the downloaded zip file and locate the Shopify CV file.
- Open the Shopify CV file using Microsoft Excel.
- Make the necessary adjustments, such as pricing or product descriptions, directly in the Excel file.
5.2 Saving and Continuing
Save the changes you made in the Excel file and continue with the importing process. In the next video, we will guide you through the steps to finalize the bulk changes.
Thank you for reading this article. We hope it helps you efficiently import products from Dropship Zone to an Excel spreadsheet.
- Discover the Easy Way to Start a T-Shirt Business with Printify and Shopify
- Master the Art of Shipping: Calculate Shipping Costs for Your Online Business
- Streamline Your Purchase Orders with Stocky by Shopify
- Expand Your Shopify Payments Worldwide with First Payment Solutions
- Master HotJar: The Ultimate Guide to Usability Testing
- Discover the Best Shopify Product Personalizer Apps of 2022!
- Discover Winning Dropshipping Products for Free
- Fix Google Merchant Center Disapproved Products
- Find the Best Shopify Shipping Apps: Reviewed, Rates, Discounts
- Create an Amazing Online Store Using Shopify