How can I import orders on Yakkyofy using an Excel or CSV file?

It is possible to import orders on the Yakkyofy’s dashboard using an Excel or CSV file.

To do that just visit the Orders> Dropshipping Tab and click on the “Import Orders” button on the left side of your screen:

At this point, you will see this page:

You can now click on CSV template, if you want to use a CSV file or click on xlsx template to use an Excel file:

Please always remember:

• not to change the first row (header) of the example file;
• the first row (header) will be removed automatically by our software.

At this point, you have to fill in the file with all your orders, and in the following paragraph, you can read in detail how to do that:

Notice that every row in the file is one SKU Variant, not one order. The system will automatically unify in the same order all the rows that have exactly the same order number and the same shipping details.

This is how you should fill every column in:

1. quantity: the number of pieces that you want to buy for a specific variant;
2. notes: you can write a note if you like (not required);
3. shipping name: your customer full name;
4. shipping address: the customer’s address (without commas or points);
5. shipping City: the customer’s address city name (extended);
6. shipping Province: the customer’s address province name (extended);
7. shipping zip code: the customer’s address zip code;
8. shipping country: the customer’s country name (extended);
9. shipping phone: the customer’s phone number;
10. shipping country code: the customer’s country name (shortcode);
11. shipping Province code: the customer’s address province name (shortcode);
12. SKU: the SKU of the variant you want to buy;
13. order number: you can insert the number that you prefer, normally we advise our customer to use a number that you can easily match with the orders on your store.

If you want to upload an order with more items inside, remember that the following fields must be identical:

1. shipping Name;
2. shipping address;
3. shipping City;
4. shipping Province;
5. shipping zip code;
6. shipping Country;
7. shipping phone;
8. shipping Country code;
9. shipping Province code;
10. order number;

After filling in the file with all your orders, just drag it on the Import Orders Tab, inside your Yakkyofy’s Dashboard.

A new window will appear with the recap of all your orders:

If everything is correct, just click the “Confirm Orders” button and the order will be uploaded and found in "Orders>Dropshipping":

If there is some mistake, click the “Cancel Orders” button, correct the file and import it again.

For any doubt or question, please do not hesitate to contact our customer care at info@yakkyofy.com