Skip to main content
All CollectionsUpload (Admin)
Import/Export Orders & Quotes
Import/Export Orders & Quotes

Streamline order management by importing details and mapping items with ease

Updated over 3 months ago

When you navigate to the "Order and Quotes" import/export section, you'll find two drop-down menus:

  • Orders and Quotes: Use this option to input details for orders and quotes.

  • Order and Quote Items: This option is for providing details about the items included in specific orders and quotes.

We recommend that you first upload the order and quote details, and then proceed to map the items to each order and quote. This sequence ensures a clear and organized import process, facilitating accurate data integration and reducing potential errors.

Import

Steps -

  1. Navigate to the Import/Export section from the left panel

  2. Click on "order and quotes"

  3. Then click on "Import"

  4. Select "order and quotes" from the dropdown list

  5. Download the template Excel

  6. Edit the Data Sheet tab on the Excel

  7. Save the Excel sheet

  8. Now, again click on "Import"

  9. Choose the edited Excel, and click on "Next"

  10. Select the column headers on the sheet

  11. Click on "Next"; you will need to map the template fields to the columns

  12. Again click on "Next," verify the data, make rectifications if required

  13. Click on "Submit "

  14. Now, select from "Add only," "Update," and "Add & Update"

  15. Click on "Confirm"

Order and quotes details will be uploaded on the platform. Similarly, add Order and Quotes Items on the platform.

Note - All the fields available on the template sheet are configurable; you can get in touch with the WizCommerce team to configure it.

Export

Steps:

  1. Navigate to the Import/Export section from the left panel

  2. Click on “Orders & Quotes”

  3. Then click on “Export”

  4. Choose the timeline from the dropdown (Today, Last week, Last Month, All Time, Custom)

  5. Click on “Export”

  6. Select the bell icon at the top right corner

  7. Download the excel file

The Orders & Quotes excel file is now downloaded to your system.

Did this answer your question?