Importing orders on Yakkyofy’s dashboard using an Excel or CSV file is a simple and efficient way to manage your eCommerce operations, especially for those dealing with international shipping logistics.
To begin, visit the Orders > Dropshipping tab on your Yakkyofy dashboard. Then, click on the “Import Orders” button located on the left side of your screen.
At this point, you will be directed to a page where you can select your preferred file format. If you want to use a CSV file, click on the "CSV template" button, or choose the "xlsx template" if you prefer an Excel file.
Please always remember:
- Do not change the first row (header) of the template file. The software will automatically remove this header during the import process.
Next, fill in the file with all your orders. Detailed instructions on how to do this are provided below:
Note that each row in the file corresponds to one SKU variant, not an entire order. Yakkyofy’s system will automatically combine all rows that share the same order number and shipping details into a single order.
Here is how you should fill in each column:
- Quantity: Enter the number of units you want to purchase for a specific variant.
- Notes: Add any notes if necessary (this field is optional).
- Shipping Name: Input your customer's full name.
- Shipping Address: Enter the customer's address (avoid using commas or periods).
- Shipping City: Provide the full city name for the customer’s address.
- Shipping Province: Enter the full name of the customer’s province.
- Shipping Zip Code: Provide the postal code of the customer’s address.
- Shipping Country: Enter the full name of the customer’s country.
- Shipping Phone: Input the customer’s phone number.
- Shipping Country Code: Use the shortcode for the customer’s country.
- Shipping Province Code: Use the shortcode for the customer’s province.
- SKU: Enter the SKU of the variant you want to purchase.
- Order Number: Choose a unique order number that you can easily match with the orders in your store
If you are uploading an order with multiple items, ensure that the following fields are identical across all items:
- Shipping Name
- Shipping Address
- Shipping City
- Shipping Province
- Shipping Zip Code
- Shipping Country
- Shipping Phone
- Shipping Country Code
- Shipping Province Code
- Order Number
After completing the file with all your orders, simply drag and drop it into the Import Orders tab on your Yakkyofy dashboard.
A new window will appear, summarizing all your orders.
If everything is correct, click the “Confirm Orders” button to upload your orders. You can then find them in the Orders > Dropshipping section.
If there is any error, click the “Cancel Orders” button, correct the file, and re-import it.
For any questions or doubts, don’t hesitate to contact our customer care team at info@yakkyofy.com.