Skip to Content

Sometimes the user re-orders identical articles in a web-shop. This use-case is not that important in a B2C-Scenario but probably more relevant in a B2B-Scenario.

Now, there is a small and easy solution to improve this for recurring orders. In addition this new feature also allows entering data outside of the online-shop.

It also enables B2B-Customers to collect orders from their employees and enables customers to reuse the list for recurring orders with changed quantities.

How does it works?

Activation of Item Upload in Web Channel Builder

First you have to activate the Order-Upload in the Web Channel Builder. This is just one checkbox in the module “salestransactions” (Section “Shopping Cart”).

With this setting the user will get an additional button in the shopping cart.

/wp-content/uploads/2012/12/item_uplaod_wcb_164872.png

Illustration I: Activation of the “Item Upload” functionality in the Web Channel Builder (Module “salestransactions”).

Upload Items to the Shopping Cart

In the shopping cart the additional button “Upload” is visible. Pressing this button will open an overlay-window to select a file for the upload.

This file must be a csv-file and must have the following structure:

  • Product ID
  • Product description
  • Quantity
  • Unit of measurement

/wp-content/uploads/2012/12/item_uplaod_164871.png

Illustration II: Option to upload the csv-file into the shopping cart.

With this structure the user can create his order-list. This list the user can use again and again. Rows without a positive quantity and a valid unit of measurement will get ignored for the upload. All items with a valid Product ID, a valid Quantity and a valid Unit of measurement will get uploaded to the shopping cart. The column “Product description” is not mandatory and will not get uploaded to the shopping cart. This column is only in the csv-file to help the employee working with this file.

For sure this upload can be done with an empty shopping cart but also with a filled shopping cart. It is possible to upload several files after each other and it is possible to upload the same file multiple times.

Items and quantities will just get added and the user can work with the shopping cart as usual. He can change quantities, remove items and add other products to the cart.

A typical use-case is that a company has such a list and asks the employees to check the stock for the relevant department and enters the products with a critical reorder point. The company can now easily create one order with many items hand has no cumbersome work typing in all products manually.

Additional Information

SAP Web Channel Experience Management – New 3.0 Release

SAP Web Channel Experience Management 3.0 Highlights (Presentation on Service Market Place)

SAP WCEM 3.0 Application Help: Shopping Cart

SAP WCEM 3.0 Learning Map

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

    1. Former Member
      Post author

      Hi Ingo,

      there are only 3 columns relevant for the upload

      • Product ID
      • Quantity
      • Unit of measurement

      the Product description is just to understand the list better but not relevant for the upload.

      Using chinese characters for this column should not harm but will not have an impact on the product description.

      Regarding the unit of measure you have to use the key.

      Best regards,

      Arno

      (0) 
  1. Former Member

    Hi Arno,

    Its a nice feature. But is there a out-of-the-box way a user can store his shoppingcart to a CSV. I could only download the order as XML-file.

    Best regards,

    Nikolaus 

    (0) 
    1. Former Member
      Post author

      Hi Nicolaus,

      thank you for your feedback. You are right, out of the box there is no CSV-Download for a later upload available in the Shopping Cart or within the Shopping Templates and also the Order Download has a different purpose.

      The XML File for the Order Download doesn’t have the structure you need for the Item Upload.

      For the item Upload the structure is very simple (just 4 columns).

      However we don’t provide a functionality to download the content of a Cart just as CSV-File in this simple structure and we also don’t have something like an export functionality from the “Shopping Templates”.

      Just to have a CSV-Template with the structure and some sample-data would be helpful. However we have not added this to our standard delivery as this is very project specific.

      BTW we also have a functionality which is strongly related to the CSV-Download. We call this feature “Shopping Templates”. We have implemented this to support regular buyers to (re)order things. Here you can collect all the items you order on a regular basis. You can use a shopping template to fill your cart.


      Best regards,

      Arno

      (0) 
  2. Former Member

    Hi Arno,

    This is exactly what I need to implement.  Can you help me on how to implement the upload order via excel.  We are using  5.0 version.  Is it feasible for it.

    Thank you

    Regards,

    Jaspreet Kaur

    (0) 
    1. Ingo Woesner

      Hi Jaspreet,

      this feature is part of SAP Web Channel Experience Management 3.0 (WCEM), not Internet Sales/E-Commerce 5.0.

      WCEM is the successor of Internet Sales.

      Best regards,

      Ingo

      (0) 
      1. Former Member

        That’s not what Google, Wikipedia, and Excel say…but I’m open to the idea that the term is being used incorrectly.  Maybe you can share, what is the best way for the WCEM website user to create a semicolon separated file? I did some searching and couldn’t find a straightforward way…

        (0) 
        1. Former Member
          Post author

          Hi Clint,

          I know this is not nice as Windows handles this only via central settings for region and language. The default “List separator” is specific for the different countries.

          For the US it is the comma, for all european countries it is the semicolon by default.

          As a comma sometimes is also part of a product title, or description we decided to use the semicolon.

          Best regards,

          Arno

          (0) 

Leave a Reply