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 VisionImage Modified


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).
Image Added


These steps are for your customers.

Step-by-step guide

To run an Order Import:

...


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 sampleImage Modified
    • 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 Dashboard Order Import.
    Image Modified
  2. Click Select Files

...

  1. to browse to

...

  1. the saved .csv

...

  1. files, or drag and drop

...

  1. files from your local directory into the selection box.

...



  1. Tip

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

    Check your upload has a success message.

    Image Added



  2. Click Import Files

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

  4. Check

...

  1. imported items

...

  1. in the Shopping Cart.  
    Image Modified

    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.
    Image Modified



  2. Proceed to checkout. 

  3. 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

Image Modified


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
    Image Added


  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