Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview


Multiexcerpt
hiddentrue
MultiExcerptNameFeature Overview

Allows your trade customers to create an order via upload one or more prepared CSV files or data copy and paste of product codes and quantities. Useful for large organisations with centralised ordering processes. Requests by different staff or departments in multiple csv files can be uploaded and will be submitted as one order.  

Order Import allows your customers to create an order via upload of a prepared CSV files or copy and paste of product code/quantity data. It reduces data entry for larger organisations that place orders centrally with your business. The purchasing officer or similar can upload one or more files with lists of product codes and quantities requested by multiple staff or departments. Or they can simply copy and paste this data into the textbox on the page. Both import methods will convert the data into the cart items of a single order.   


The imported data is validated and feedback to the user given.

Order Import - Commerce Vision


Panel

On this page:

Table of Contents


Allow multiple file upload?


Info

To enable multiple file selection, toggle ON Allow Multiple Files on the File Upload tab in the Order Import Widget. Data from all files will be uploaded to a single cart. (Multiple orders will not be created).


These steps are for your customers.

Step-by-step guide


Data preparation

.csv files with requested product details or flattext data for copy and pasting must be prepared.

    • CSV file: An order line is created from data in the first two columns. Use the first column for the Product Code (or APN), and the second, for Order Quantity. DO NOT include a header row.
       Order Import - CSV file sample
    • Flattext data: Data must be ordered this way: Product Code (or APN), Order Quantity

CSV file import method


To create a data import order from CSV files:

  1. When logged into the website, go to DashboardOrder Import.

  2. Click Select Files to browse to the saved .csv files, or drag and drop files from your local directory into the selection box.

    Tip

    If your file has upload data errors, upload will return an error message.

    Check your upload has a success message.



  3. Click Import Files

  4. Check the Import Log for data analysed, as well as any errors encountered (e.g., invalid product codes).


  5. Check imported items in the Shopping Cart.  


    Note

    If there were errors in your data and your cart is empty, you can ask us to update the default import behaviour setting. When the 'Order Import Skip Errors' flag is enabled the invalid lines will be ignored and the rest of the data will be imported.



  6. Proceed to checkout. 

  7. Repeat Steps 1-8 for subsequent orders as required. 


Data copy and paste method 

Instead of uploading .csv files, you can also enter or paste data (Product Code,Quantity) into the Data Import box. 

Example: CV200,5


Edit Order Import options

Settings for the Order Import template are in the Order Import Widget. 

  1. Go to ContentPages & TemplatesOrdersOrder Import Page.

  2. Click Edit.

  3. Find the Order Import Widget, then click Edit



  4. For a guide to settings, see: Order Import Widget.

Additional Information


Multiexcerpt
MultiExcerptNameAdditional Info
 --


Multiexcerpt
hiddentrue
MultiExcerptNameFeature Title

Order Import


Minimum Version Requirements


Multiexcerpt
MultiExcerptNameMinimum Version Requirements
**.**.**


Prerequisites


Multiexcerpt
MultiExcerptNamePre reqs

--


Self Configurable


Multiexcerpt
MultiExcerptNameSelf Configurable

Yes


Business Function


Multiexcerpt
MultiExcerptNameBusiness Function

Ordering Functions


BPD Only?


Multiexcerpt
MultiExcerptNameBPD Only

No


B2B/B2C/Both


Multiexcerpt
MultiExcerptNameB2B/B2C/Both

B2B


Third Party Costs


Multiexcerpt
MultiExcerptNameThird Party Costs

n/a



Related help

Content by Label
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("import","order") and type = "page" and space = "KB"
labelsimport order

Content by Label
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "widget" and space = "KB" and title ~ "'order import'"
labelsimport order