After adding a manual sales channel and linking your listing SKUs to a master SKU, you can start importing your orders into the channel.

To import orders manually, follow the procedure below.

1. Open the Orders Module.
2. Click the Import/Export dropdown menu, then select Import Orders.

3. In the Manual Order Import window, click Configure.

4. In the Order Import Settings window, click + New Settings.

5. In the New Import Settings window, give your settings a title in the Settings Name field. A descriptive name would be best, e.g. Import_All_Fields, or September 2020 Settings.

6. Select the file format from the CSV and Text options, select the structure, and the date format.

7. Add and/or organize the Data Fields you'd like to use. Ensure that every Data Field has a corresponding Column Name that you'll be able to recognize in your Import File. To reorder Data Fields, drag and drop them.

Some Data Fields are required both in the Configuration and in the actual import file.

  • Customer Name
  • Address
  • City, State, Zip
  • Phone Number
  • Order Number

8. If you want to make column headers required, make sure to check the Include column headers box.

9. Once you're satisfied with your configurations, click Save to close the Import Settings window.

10. Back in the Order Import Settings window, the new settings are now added to your Settings list. Click Close to close the Order Import Settings window and go back to the Manual Order Import window.

11. Now you'll need to create either a CSV or Text file according to the file format you chose in your configuration settings, and input your orders to import in the exact column format that matches your configuration settings as well. Any deviation to the file format will cause the import to have issues, including if you do/don't include the row headers. These issues could be caused by having more columns than your configuration settings have Data Fields, or putting a Date input in a column that was configured for an amount of money (like Amount Paid). Make sure to double-check that any date text is in the exact format matching your configurations and that all required fields are filled in. Make sure your file is saved as the right file format.

⚠️ Note: The Row Headers & configuration settings are case-sensitive.

12. Back in the Manual Order Import window, click the Import Settings dropdown menu and select the settings you just created. Set the Manual Sales Channel to the correct channel. Then click the Select button and choose the CSV or Text file from your computer to import. Click Continue to start uploading the file into Skubana.

Skubana will then start processing the import file. The speed with which the process runs and completes depend on the number of manual orders to be imported into Skubana. If an Error Log is generated, ensure that the rows with issues detected are addressed. If there is a general error that the file could not be uploaded, there is likely an issue with the number and order of columns in your file not matching the Configuration Settings exactly, or the presence or lack thereof of Headers, or the file format itself is incorrect. Double-check your settings and file until an Error Log is produced and notifies you that your import was completely successful.

Did this answer your question?