Watch the video, or read the Blog Post below.
Planning to get your daily orders ready easily and without the hassle, but are not quite sure where and how to start? Well, let me say this now: your idea is definitely doable, and it doesn’t take a lot of brains to make it happen!
In this video, I am going to show you how you can easily process up to a thousand daily orders via bulk CSV dropshipping — I also have tons of pro tips for you in this blog, so stay tuned to find out what they are and how they can greatly and positively affect your system and your business!
Bulk CSV Dropshipping
When you are a startup business that is receiving quite a few orders per day, you normally wouldn’t have to do this bit (and we’ll discuss what you can do later on, too!). But if you start scaling up and receiving a hundred up to a thousand orders a day, manual purchasing will become a problem, an inconvenience, and eventually, a waste of you and your team’s time and efforts. Hi
Our goal for today is to be able to ease your purchasing process and create a more systematized method such that you and your team can focus on the more important aspects of your business.
If you are still new to the eCommerce business or are tired of having to pay monthly fees for individual features, then switch to CommerceHQ. This platform is an alternative to Shopify, and if I may say so myself, I find that it is actually the better platform, simply because it is more affordable than the latter. But more than that, CommerceHQ has everything you would ever need to kick start your online store.
CommerceHQ has got your eCommerce business’ back, with it offering:
- A comprehensive list of winning products for your dropshipping business;
- Post-sale upsells where you can offer additional products at discounted prices or bundle offers;
- A countdown timer for your sales and offers;
- A recent purchase notification for you to keep track of your customers’ purchasing activities;
- No transaction fees;
- Just one monthly price for all of its features; and of course, many more!
With CommerceHQ, your online business is assured to be enriched with every bit of feature you could possibly think of to give it a proper boost. And if you click on this link, you get a special offer for the ability to create up to 6 online stores for the price of 1! You definitely do not want to miss out on this deal, especially when you now know that CommerceHQ has everything from A to Z.
Editing Your CSV File
A Comma Separated Value (CSV) file is basically an Excel file for all your important data. Basically, everything bit of information your customer will provide will be conveniently organized and prepared for you — all you have to do is to tell your system how to do it. But of course, not all of the good bits will be coming from your buyers, as they, too, will need some sort of information back for them to actually start trusting your store and become more eager to secure another transaction with you (we’ll be getting into that later on).
The best virtual assistants come from the Philippines. Why, you might ask? Because Filipino VAs are efficient, professional and have very good work ethics. Best of all, they charge affordable and reasonable rates — you even get top-class outputs every time in return!
So let’s get into editing your CSV file right away. Go to All CSV Templates and setup a template name. If you are looking for a tried and tested template for your own website, you can use mine. This is the exact template that I have been using for my business since 2017 — and it hasn’t been edited since then!
My CSV template is set to “1 row per item” and consists of the following headings:
- Order date;
- Order number;
- Item name;
- Full name;
- Street number;
- Billing email;
- Phone number;
- Item cost;
- Shipping cost;
- Tracking number;
- Notes; and
- Store name.
Take that extra step to make sure your customers will provide a valid and active contact number for when shipping and stock issues take an unexpected turn. In fact, the suppliers might contact them themselves for a more effective communication process.
USA states have 5-digit zip codes, so when you see a cell under the Zip Code column that only has 4 digits, it is probably missing a “0” in front, and it isn’t showing up because of the column formatting.
To resolve this issue, remove the column format (or change to ”Normal Text”), add a “0” and make a quick Google search to verify the information in question.
The suppliers are only interested in the customer’s shipping details, and not their billing details. That means you can either omit the latter from your CSV template, or ensure that your customer will provide the correct shipping information to prevent any issues.
Exporting Your CSV File
To export your CSV file, on your CommerceHQ dashboard, go to Orders, and on the Orders dropdown menu, specify a date range (in our video, I’ve chosen my orders for “Yesterday”). Finally, on the Actions dropdown, click on CSV Export to download your file.
Have a master Sheets file for all your transactions for easy bookkeeping. And we’re not just talking about having a record for today’s orders; we’re talking about weekly, monthly, and yearly records! The only time you should get rid of these files is when you feel the information contained in them are no longer needed. I recommend having a record of all your transactions for the past 3 years or so. Of course, put them all on the Cloud!
Open your file, copy all of the details and paste it onto your master Sheets file. And now, we can finally start modifying our CSV file and readying it for our suppliers!
Preparing Your CSV File
In this section, we are going to edit the CSV file that you will send to your suppliers to be able to secure a successful transaction.
As you can see on the bottom part of the image above, I have 7 tabs for my master Sheets file:
- AFTERSHIP IMPORT;
- MANUAL, which is the tab for all our manual transactions (more on that below);
- July, August, and September, which are all of the transactions I’ve processed during said respective months;
- COG, which is for the cost of goods; and
- ALL-16, which is what we are going to edit.
If you are working with an international team, it is highly recommended that you put everything on the Cloud. That is, everything up to the tiniest bit of detail that your team would need to be able to perform their tasks well should be uploaded into a shared space for easy 24/7 access.
I myself use the Google Suite to share all the necessary data to my sales and customer support team. That way, when a customer contacts one of them, regardless of my availability, they can easily pull out any sort of order information and quickly cater to their needs.
What we’re actually going to do is to separate the products according to their respective suppliers and create a Sheets file for each and every one of them. As for those products that only have a few order requests, we shall put them into the MANUAL tab (more on this later).
So, how do you separate the products, then?
Use the following Google Sheets shortcuts to maximize efficiency:
- Command (for iOS) or CTRL (for Windows) + F, if you want to find a specific data on your Sheets file.
- Data > Filter, if you want to arrange items according to a specific criterion (you can turn this feature off by going to Data > Turn Off Filter).
- Search All Sheets if you or your customer support team has misplaced a specific information.
- =SUM(), to get the total amount you need to pay your suppliers (item and shipping costs).
When you’re done organizing orders based on their suppliers, do a quick skim of the information provided. You can ask yourself (or your VA) these questions:
- Did the customer provide their full name?
- Did they provide their complete SHIPPING address?
- Is the zip code correct?
- Did they provide a valid and active contact number?
Of course you would have a clear idea as to how much your products cost, but if you haven’t, it’s best to create a separate Sheets file (thus the COG tab) for this specific purpose. Determine the quantity ordered by your customers and fill in the details. Of course, multiply this factor by your item cost to determine the total item cost, which you will then put into the Sheets file.
Afterwards, you can proceed to determine the correct shipping cost, especially when you are operating an international eCommerce store, with people from different parts of the world coming and going to your website.
You can either do a quick Google search, or directly contact your suppliers as to how much they would charge for it.
You only have to pay shipping once when a customer orders more than one of the same product (or if they order multiple products from the same supplier). Thus, you have to cross out the shipping costs for the rest of their ordered products.
Use the =SUM() function of Google sheets to determine the total sum you would need to pay your suppliers. Take special note of this amount, as this would be the star of your email later on.
Paying Your Suppliers
When you hear back from your suppliers regarding payment (or you can actually reach out to them and say you are ready to pay for their goods), they will usually send an AliExpress link for the specific products you’ve ordered. Specify the number of goods you are to order, click Other Payment Methods then contact them again for the manual override of the total price (because, again, some of your customers might have ordered multiple products from the same supplier).
Save more and go for direct bank transfer when paying your suppliers. Most banks do not even charge service fees when you are to transfer funds to and from accounts from the same bank; otherwise, banks only charge 4 - 6% of the total amount to be transacted — compare that to PayPal’s and other platforms’ service charges and you’ll clearly see how much you can save!
Once you’ve computed for the total cost (which is the sum of the item and shipping costs), simply export your Sheets file into CSV, and attach it to an email to be sent to your supplier informing that you have a new batch of orders up and ready for them for processing.
After their confirmation (and any other possible instructions) and receipt of payment, you should get the CSV file back, with the Tracking Numbers column all filled up.
And that’s it; you’re ready to send out these numbers to their respective and rightful owners, and you’ve successfully processed a MAJOR PERCENTAGE of your orders for the day! Of course, we still need to process the transactions for products that have been ordered by a select few, and we shall do that through manual purchasing.
Yes, it is as simple and straightforward as it sounds. For manual purchasing, you only need to go the products’ respective AliExpress (or directly contact their suppliers) links, manually input your customer’s information and contact the suppliers to tell them that you are a dropshipping business, and that all sorts of communication in terms of the parcel should only be done between you and them (only you should have contact with your customer). Finally, setup a payment method wait for the confirmation email with the tracking number (and you already know what to do with this).
Do not hesitate to follow-up with your suppliers with regards to your customers’ respective tracking numbers. Do you remember that piece of information your customers will need? Yup, it’s the tracking numbers, and they are vital in building trust between you and your buyers. Thus, it is important for you to send these numbers back to them as soon as possible in order to avoid any further questions or negative feedback.
Normally, the tracking numbers should be sent back to you within the day of purchase, but if you feel the suppliers are running a little late in sending them, you can follow-up up to three times a day.
Yep, that’s it; we’re all done!
On a side note, we will discuss the AfterShip Import tab in another video, so you better stay tuned for its upcoming blog (we’ll post a link here when it is ready for you)!
Once all’s done and done, the next step is to update your master Sheets file, so that you and your team will know that there are no more orders left to be processed for the day. Your goal should be to have as few tabs as possible on your master Sheets file — the only ones that should remain are those for bookkeeping.
Let’s Wrap It Up!
We’ve just discussed in great detail how you can process up to a thousand orders via bulk CSV dropshipping — and yes, regardless of how lengthy this blog post is, don’t you find that it is actually quite easy? In fact, with proper training and guidance, even a VA could effortlessly handle this task and still have enough time for other tasks and recreation, even!
Before we end this post, I would like to invite you to my monthly membership group, The Pirate Club, where you can get everything you would need to build a successful online store. By joining in and becoming a pirate yourself, you gain access to the following:
- The Pirate Academy;
- The Pirate Product App;
- The Pirate Community; and loads more!
Intrigued? The Pirate Club is now open with an early-bird pricing plan, so be sure to grab this super affordable deal before it expires!
If you have any more questions about bulk CSV ordering, CommerceHQ, AfterShip or anything regarding this video, feel free to personally contact me via email at [email protected] You can also leave your comments and feedback below, and our team over at WagePirate will definitely get back to you with a response. For more reviews, news and updates, don't forget to subscribe to our YouTube channel!