Versions Compared

Version Old Version 145 New Version 146
Changes made by

Cecilia Do

Cecilia Do

Saved on

Key

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

Table of Contents

...

  1. UCI's TEST TouchNet Operation Center URL: https://test.secure.touchnet.net:8443/centraltest

    Warning

    Bookmark the original "clean" URL. Always use this URL, as the URL with all the parameters appended will stop working as time passes, since it includes a dynamic parameter that facilitates single-sign-on.


  2. Realm: C21570

  3. Usernames are prefixed with realm (e.g. C21570.doct)

  4. Use Firefox or IE.
    1. TouchNet Operation Center is not officially supported on Chrome. Has known issues running on Chrome
    2. Note that the browser restriction is only for the Operation Center
    3. Per Mathew Lindley, the mall/store/payment pages work on all browsers
  5. (Cecilia Do) 200230207: Configure time zone in local user profile

    1. To set the time zone for how data is displayed in the uCommerce, please follow these steps:

      1. Log into uCommerce > in the upper right, click your name > Then select "Edit Profile"

      2. Once that page comes up, set the time zone to desired settings. > Then click "Save"

    2. CD: This impacts the Payment Gateway reports. Marketplace reports already reflect Pacific time, regardless of profile Time Zone setting

TouchNet Users Guide

You can access TouchNet User Guides here: https://drive.google.com/open?id=1M0tH7DAR6DfPaLozfcTOt4J2dpwQn7Kb . This requires a UCI account.

The documentation includes:

  1. Marketplace Users Guide - guide for both uStore and uPay
  2. uStores Layout

TouchNet Users Guide

You can access TouchNet User Guides here: https://drive.google.com/open?id=1M0tH7DAR6DfPaLozfcTOt4J2dpwQn7Kb . This requires a UCI account.

The documentation includes:

  1. Marketplace Users Guide - guide for both uStore and uPay
  2. uStores Layout Guide - specific layout guide for uStores
  3. uPay Technical Guide - specific guide for uPay

...

  1. How do I view my store?

    1. You can view your store by going to “Marketplace Home” at the top of your left hand bar. Look for your store under the “Stores” section, and there is a “View Store” link towards the right.

  2. (Cecilia Do) Is there only one shopping mall for our Marketplace account? Or can we freely create however many malls we need and include whichever stores in each mall?
    1. 20150825 Mathew Lindley: Each customer had one mall. To have a separate mall you would need to purchase a separate instance of Marketplace.
  3. (Cecilia Do) Configure store payment at:
    1. Group Payment Methods
    2. Store default payment methods
    3. Product

  4. (Cecilia Do) Configure shipping:

    1. Must always create a shipping class

    2. Even no shipping for store, must still create a shipping class a "None" option.

  5. (Cecilia Do) Configure tax:

    1. Use "default tax rate"
    2. Store => Store Settings
      1. Turn on "Use Tax Service"
      2. Select "California" option
    3. Can configure tax on the shipping
    4. Can configure tax per product

  6. (John Romine) How do I set the units for each item? For example, a product is a "box of 12 widgets" which costs $5. It's sold as $5/bx. The website only shows the $5 price, and doesn't indicate the units, which could be confusing for the buyer as to whether she's purchasing one unit or one box of 12. 

    1. 20150818 Mathew Lindley: On this I would use the short/long description to notify the customer that one box contains 12 widgets
  7. (John Romine) How can I sell fractional quantities.  For example, I sell jelly beans for $8/lb. Our smallest quantity sold is 1/4 lb, but we will sell any increment of that amount (e.g., 3-3/4 lbs).
    1. 20150818 Mathew Lindley: There isn’t any really good way to do this in uStores. Again you could notify the customer in the descriptions that 1 unit =.25 lbs at $2/unit. Or you could even make the product as a donation product type and let the customer enter their price rather than having to choose a number of units, then simply say that the customer can enter as much money as they would like to pay and the rate is $8/lb.
  8. (John Romine) How do I differentiate price by customer type. For example, we offer a student price, a staff price, a faculty price and an outside (public) price. This is different from offering per-item variable pricing/discount, since each customer can only purchase items of the correct type (no mixing selections) and the income goes into different accounts. 
    1. 20150818 Mathew Lindley: Since I-Rong has request an LDAP connection to make a private uStore, I would have a private student faculty and staff store, then also a public store that offer the same items. A more manual approach would be to have one store with one product for sale, then use modifiers to ask if the customer is a student, faculty, staff or n/a. collect name and credentials students and faculty/staff and manually validate this against reports. Whether one or the other is more feasible would depend on volume of transaction
  9. (John Romine) For donation items, how do I add description next to the various donation amounts, for example: Gold $2500, Silver $1000, Bronze $500? 

    1. 20150818 Mathew Lindley: I would use the short/long product descriptions to describe the various donations amounts for example:

      Code Block
      <p><b>Thank you for your interest! Please choose from the donation values described below</b></p>
<p>Gold-      $2500</p>
<p>Silver-    $1000</p>
<p>Bronze-    $500</p>


  10. (John Romine) How do I have a multi-line input field, for example the lettering to be printed on a shirt is three lines long. Can I have a single text area input or do I need to have three single-line input fields?
    1. 20150818 Mathew Lindley: It would be best to have three single line input fields limited in their characters to the limit offered on the t-shirts
  11. (John Romine) For a job fair, companies who purchase our "Gold" package are allowed to bring an unlimited number of representatives. We need to collect the names of each representative so we can print badges for them. How do I add a text input field where the representatives names can be entered with an 'Add More' button where the customer can add as many additional input fields as needed.
    1. 20150818 Mathew Lindley: uStores can’t do the ‘add more’ option. Depending on the largest possible amount of attendees anticipated, you could have as many optional text fields for ‘Attendee 1, Attendee 2, 3, 4, etc… and the customer could fill out as many as needed then leave the rest blank.
  12. (John Romine) When we sell conference registrations, we want to optionally sell parking passes. The customer can buy as many parking passes as she wants, but only if she is buying a conference registration item. How do I set this up?
    1. 20150818 Mathew Lindley: Offer these items only as additional items at checkout. This will still allow the customer to purchase as many as they would like.
  13. (John Romine) How do I associate the "additional items" with their primary item? For example, if you pay for a conference registration, an additional item might be a conference t-shirt. The t-shirt purchase is only available to conference attendees. I tried adding an "additional item", but it shows up at checkout regardless of what items are in your cart (i.e., whether or not the conference registration was purchased).
    1. 20150923 Mathew Lindley: That is correct.  In this case the parent product would need to have it's own store to exclusive sell the child product.
  14. (Cecilia Do) Can you delete a uStore/uPay as long as it hasn’t taken payments yet? And once a payment is taken, the store/site can only be disabled, not deleted? 
    1. 20150825 Mathew Lindley: Correct.
  15. (Cecilia Do) It looks like uStore and uPay names are not required to be unique.
    1. 20150825 Mathew Lindley: Correct.
  16. (Cecilia Do) When a store is no longer used, we can only disable it? And it will forever show up on the Revenue by Merchant reports with 0 amounts?
    1. 20150825 Mathew Lindley: Correct, although it will only show up with zero depending on how far you search back. If you haven’t used the store or site you can delete it.

  17. (Cecilia Do) When a uStore's name is changed, the reports will display the new name, even for transaction data before the name change.

  18. (Linda Snyder) 20150918 CD: Select "No" for Perform General Ledger Updates. That feature does not work for us since we do not have Banner or PeopleSoft.

  19. (Cecilia Do on behalf of Chris Wong) A department is requesting to confirm with you that the store and product templates is a feature that will be rolled out this year. By templates, we mean that there is a store skeleton that we can copy/clone to make another store. The same concept applies to cloning products.
    1. 20150917 Mathew Lindley: We have no plans to published pre-formatted templates, we are actually looking rather at cloning. We have no set date for store cloning, the answer right now I get is “maybe in the future”. On the other hand, product cloning is scheduled to roll out in late October. In a sense, being able to clone a product allows you to create your own templates rather than relying on TouchNet to create the template you want, so I think this should be very helpful to our schools.

      -Note: The TouchNet can do product clone in the same store since 20161123. However, it is not possible to clone products across the stores.
  20. How to clone product in a Store?
    First go to your Store and then select the Product on the left menu-bar. After that, select the corresponding product to clone as shown in the picture below:

  21. (Cecilia Do on behalf of Linda Snyder) I understand that TouchNet has monthly maintenance. Are we able to request for uninterrupted service during our peak payment period? For example, the period 2-3 weeks where students make an SIR (Student Intent to Register) payment is critical. Can we request for uninterrupted service during those weeks?
    1. 20150916 Michelle Sullivan: You are correct, we do have monthly maintenance that occur on Wednesday. Unfortunately it is a datacenter-wide activity and we cannot pull certain schools from this. I apologize for any inconvenience this may cause.
  22. (Dianne Bean) 20150928 Mathew Lindley: Adding new merchants / uStores / uPay sites does NOT require any kind of restart. As soon as they are created, they will show up.

  23. How to view reversals (voids/refunds) in reports

    1. Marketplace Reports » Stores » <store name> » By Product

      1. Input date range

      2. Product drilldown will list out individual transaction and refund lines

  24. (John Romine) 20150922: I'm having some problems with TouchNet Marketplace on the Chrome browser. This is with Chrome version 45.0.2454.99 on Windows 7 but I have encountered the same issue under ChromeOS. Both these operations work correctly under Firefox 38.

    1. In the Engineering Store, under FABWorks, attempting to add a product to the cart results in the product not being added, and a message saying You have no items in your cart. 

    2. In the admin interface, in Engineering Store General Settings, attempting to change any setting does not work. The selected form control is simply reset and loses focus.  For example, trying to change Store Home Page Layout results in the select box immediately closing without allowing a selection change. 

    3. (John Romine) 20150923: Yes, I was able to verify that you have fixed the problems both with adding items to the cart, and with making changes in the the admin interface (in the TEST store). This was tested with Chrome 45.0.2454.99 on Windows 7, and also with Chrome 45.0.2454.86 (64 bit) on ChromeOS.
  25. (Cecilia Do) Regarding going live. 20150930 Mathew Lindley (in red)
    1. For uStore, there is a preview mode that allows us to see the stores look-and-feel without it being accessible by customers?  Correct
    2. Is there a way to test to the point of authorization and viewing reports? I’m guessing the store needs to be enabled, and the department can use their own real card to make an authorization, view the reports, and do a same-day reversal.

      1. That is also correct. Since you are launching, it is fairly safe to enable the store to make some test runs since none of your students will know how to get to the stores until you start making the store URLs available.

  26. (Linda Snyder) The “Site Email Address” item in “General Settings” of the Miscellaneous page…. Is this for administrator announcements/alerts?  Or is this for users to submit queries?

    1. Used as the contact e-mail address on e-mail confirmation messages to the customer. In addition, warning messages for posting URL failures, GL update failures, and recurring payment failures are sent to this e-mail address.

  27. (Cecilia Do) For the “Registered Users” functionality in Marketplace, are these accounts on the Marketplace level? Or is it for each individual store? For example, when I register and create an account on uStore A, can I use this same account in uStore B? In the mall?
    1. 20151009 Mathew Lindley: Registered Users are system wide. 
    2. 20151009 Mathew Lindley: That means any store where Peter the Anteater can gain access and where you are allowing Registered users to log in (in your Single Stores settings) that Peter would be able to use his saved payment methods and shipping address. Register Users really don’t have so much to do with access as they do with saved information for return shopping.
  28. Department notification for product sold?
    1. 20151012 Mathew Lindley: There are two ways to do this which offers different granularity:
      1. A store manager can opt to receive emails on all products by going to "Edit My Profile" on the left hand menu.
      2. At the product configuration level, can add email addresses for "Product Notification". Can be configured for each option combination (e.g. stock number)
        1. Department emails do not contain modifiers, but customer emails do.
  29. 20151012 Mathew Lindley: The end user and school each receive an email saying payment failed on CC recurring failures.
    1. 20151012 Cecilia Do: In this case, department may want to cancel the future recurring transactions and contact the customer to make a new recurring payment.
  30. 20151012: Regarding collecting checks/alternative payment methods besides credit cards:
    1. Offer $0 products that collect the customer information, and instruct customers to submit alternative payment.
    2. Can have product options for each type of payment and different prices.
  31. 20151105 CD: Single store URL

    1. http://[server]/[context]/web/store_main.jsp?STOREID=[ID#][&SINGLESTORE=true]

    2. https://test.secure.touchnet.net:8443/C21570test_ustores/web/store_main.jsp?STOREID=[ID#][&SINGLESTORE=true]
  32. 20151207 CD: If do not have an image for a product, may consider using just a white square.
     
  33.  Promotional codes for packages do not work.
    Per Lindsay Carroll's email to Rhett Lowe from Education: Unfortunately, the current functionality of promotion codes doesn’t allow promo codes to be set up on packages, only individual products. They are currently working on a case with another University that has the same concerns but a resolution date is indefinite. Their only advice to me was to submit an enhancement request to increase the functionality of promotion codes. I will do this today, however, if and when this gets resolved is unknown. 
  34.  Product fulfillment
    1. Authorization & settlement
      1. Credit card is authorized at order time
      2. If order is fulfilled within 72 hours, the authorization is still active and the transaction will be submitted to the credit card batch for settlement
      3. If order is not fulfilled within 72 hours, the authorization will be automatically reversed/cancelled
        1. Upon fulfillment, the credit card will be authorized again, and if successful, will be submitted to the credit card batch for settlement
    2. There are no partial fulfillments (e.g. have 5 products, ship 3 products, and later ship the remaining 2). Entire shipment is sent, or the quantity can be decreased.
    3. Marketplace revenue reports are based off the fulfillment date for products requiring manual fulfillment

    4. Fulfilled order transactions will be submitted for the day's credit card batch for settlement

      Tip

       Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.


  35.  Free shipping if order amount exceeds X - Work arounds
    1. Staff reverse shipping charges same day
      1. For manual fulfillment, can reverse after fulfillment
        1. Authorization amount will be adjusted
        2. Settlement ill be for the adjusted amount only
        3. Department assessed expense on adjusted amount
      2. If next business day or after, then reversal will be a separate refund line item
        1. Multiple line items will be seen on customer card account
        2. Department assessed expense on each item
    2. Unique promo code
      1. Call department to retrieve
    3. Create shipping class for free shipping
      1. No validation on amount
      2. Honor system with customers
  36. (Chris Wong) how to set up variable pricing for a product
    1. set the product type as Donation 
    2. check ‘User entered amount’ in the Donation amount section

uPay

Tip

uPay test page: https://test.secure.touchnet.net:8443/C21570test_upay/ext_site_test.jsp

uPay posting URL: https://test.secure.touchnet.net:8443/C21570test_upay/web/index.jsp

  1. uPay posting URL
    1. Location that department storefront will initiate request post and redirect
    2. (Sean Lee) 20150807 Mathew Lindley: The uPay posting URL is where you post the parameters and the user redirect occurs in that single operation. There is an example posting in the uPay Technical Guide. This is the only method of posting to a uPay site.
  2. (Sean Lee) Department postback
    1. Send TouchNet the IPs and ports to allow postbacks through the TouchNet firewall
    2. (Rich Martucci) So when we are ready to move to the production server we will need to send you the ssl certificate .cer renamed as .txt for that server too correct?
      1. 20151014 Adam Stambaugh: More than likely. If wildcards are used than it may not be needed but to be on the safe side sending in the cert is the best bet.
    3. 20160226 Cecilia Do: For troubleshooting the postback, go here
  3. (Sean Lee) I have noted two additional postback parameters with corresponding value in postback result: __VIEWSTATE and __VIEWSTATEGENERATOR.  What are these values for and is there a way that we can exclude them in postback? 
    1. 20150818 Mathew Lindley: The two parameters are not part of TMS.  If they are being posted to the posting URL, it is because they are being passed to TMS on entry.  The school needs to change their application to not pass them.
  4. (Sean Lee) VALIDATION_KEY
    1. Alphanumeric plus special characters
    2. Sample: hX0r0Huchc9gv+ReALWrkQ
    3. 20150817 Sean Lee: Now I know that we cannot have hyphen as part of validation key.  I have tried to include hyphen in ExtTransId and TouchNet complains.
  5. (Sean Lee) The other question I have is related to validation key.  I have setup HousingTest uPay site with a validation key.  Let’s say my campus web application is not configured or is configured with incorrect validation key for posting.  TouchNet will redirect user to this page (see attachment),  and stay on that page if user clicked the “Please click here to return” button.  Is there a way that we can configure this scenario in uPay setting with an external URL similar to the way we configure for success/error/cancel page?
    1. 20150818 Mathew Lindley: The ‘Please click here to return’ button is not configurable.  It returns the user back to the location they were sent from.
  6. (Sean Lee) What is the maximum field length return by uPay postback for the following fields:

    VALIDATION_KEY
    tpg_trans_id
    CREDIT_ACCT_CODE
    CREDIT_ACCT_AMT
    CREDIT_ACCT_CODE_2
    CREDIT_ACCT_AMT_2 

    All of them have field type ALPHANUMERIC and FIELD LENGTH Unlimited.  What is the maximum “possible” return value for unlimited length?  We want to limit the field length but at same time try to prevent truncation to occur.  This is especially important for tpg_trans_id and CREDIT_ACCT_CODE/CREDIT_ACCT_CODE_2. 

    1. 20150821 Mathew Lindley: 
      1. The maximum length allowed to be entered into the Op Center when creating an accounting code is 50.  So their maximum length is defined by what they use for accounting codes.
      2. Validation key is not passed back to the posting url, but it is calculated and passed by the school, so they should be able to see the length, but I believe that it is 24.
      3. tpg_trans_id is defined by payment gateway, but I believe for credit cards the format is always year, month, day and 6 numbers for a total of 14.  Ach is just a one up number, so that can grow over time.

  7. (Cecilia Do) Can you confirm what will happen when we transmit an invalid account code (CREDIT_ACCT_CODE) in uPay?

    1. We're seeing:

      1. uPay session is successful. Customer can make payment.

      2. Transaction shows up in:
        1. uPay reports 
        2. Payment Gateway reports
      3. Transaction does not show up in Marketplace Accounting Code report
      4. The transaction shows up under GL Exception
        1. We can correct the Accounting Code and mark it as complete
        2. After which transaction will show up in Marketplace Accounting Code report under the newly selected Account Code

    2. 20150820 Mathew Lindley: We have confirmed that yes, payments are taken and completed before attempting to send to G/L.  If an exception occurs, payments are not reversed, G/L error notifications are sent.

  8. (Cecilia Do) 20150825 Mathew Lindley (in red)

    1. For the uPay payment reversals (same day VOID and subsequent refunds), will a postback be sent? No
    2. Is this the “Post data when payment is cancelled:” parameter under “Posting Settings”? Post data when payment is cancelled controls whether we post back to you when the customer hits the cancel button
    3. If a transaction had multiple partial refunds, will a postback be transmitted for each one with the appropriate refunded amount? No
    4. And what about recurring payments? Will a postback be sent out for each payment that is processed on the scheduled payment date? Yes
  9. (Cecilia Do) Can you delete a uStore/uPay as long as it hasn’t taken payments yet? And once a payment is taken, the store/site can only be disabled, not deleted? 
    1. 20150825 Mathew Lindley: Correct.
  10. (Cecilia Do) It looks like uStore and uPay names are not required to be unique.
    1. 20150825 Mathew Lindley: Correct.
  11. (Cecilia Do) When a store is no longer used, we can only disable it? And it will forever show up on the Revenue by Merchant reports with 0 amounts?
    1. 20150825 Mathew Lindley: Correct, although it will only show up with zero depending on how far you search back. If you haven’t used the store or site you can delete it.
    2. They will stay there for reporting. We do allow the deletion of uStore products though.

  12. (Cecilia Do) When a uPay site's name is changed, the reports will display the new name, even for transaction data before the name change.

  13. (Sean Lee) Does uPay support postback encryption?  I am a bit concerned on postback security and wondering if it has any methods to encrypt the postback string.
    1. 20150908 Mathew Lindley: I’m not aware of any post back encryption, although it should be noted that we would never receive a post or send a post back that contains payment data; that information is entered on the uPay pages and is only saved within our datacenter at that point.
  14. (Cecilia Do on behalf of Linda Snyder) I understand that TouchNet has monthly maintenance. Are we able to request for uninterrupted service during our peak payment period? For example, the period 2-3 weeks where students make an SIR (Student Intent to Register) payment is critical. Can we request for uninterrupted service during those weeks?
    1. 20150916 Michelle Sullivan: You are correct, we do have monthly maintenance that occur on Wednesday. Unfortunately it is a datacenter-wide activity and we cannot pull certain schools from this. I apologize for any inconvenience this may cause.
  15. (Sean Lee) It occurs to me that I need some ways to verify user’s identity for those that visit success page, cancel page, and error page via uPay redirect.  Is there a way that we can append parameters (e.g., campus identifier, tpg_trans_id, user-defined parameters, etc.) from post string at the end of redirect URL so the referred page can parse and verify?
    1. 20150917 Mathew Lindley: Posted parameters are not added to the Success Link.  If they want the posted parameters passed back to them, they need to use a posting url. UPAY_SITE_ID and EXT_TRANS_ID are added to the success url unless they have turn this off in the Payment Settings page with the “Transaction ID Settings - Show External Transaction Id in URL” setting.
  16. (Markus Quon) With the UPAY_SITE_ID and EXT_TRANS_ID, we are able to identify the record (person) being redirected, however, there is no trust that the redirect URL was tampered with because it lacks trust/validation information.  Is there a way to include one more item such as the VALIDATION_KEY which the external user would not know, but TouchNet does know (Cecilia: this is comparable to the session id key in our current world).
    1. 20150917 Mathew Lindley: This is not possible in our current environment.
    2. (Markus Quon) I'm a bit concerned about the lack of the VALIDATION_KEY as part of the redirect process.  There's a big disconnect that breaks trust and actually would open the door for someone to brute force if a uPay client blindly trust the EXT_TRANS_ID to continue to process assuming they still are handling the same “customer.” Our only saving grace for the UX is that we are able to check for our session and if it exists correlate that with the EXT_TRANS_ID to validate if we have the same user; and in all other cases force reauthentication.
  17. (Dianne Bean) 20150928 Mathew Lindley: Adding new merchants / uStores / uPay sites does NOT require any kind of restart. As soon as they are created, they will show up.

  18. (Cecilia Do) Regarding going live. For uPay, there’s no preview mode, right? If a department wants to test to the point of authorization, postback, and viewing reports, do we enable the uPay site, go through the local storefront, make a payment with a personal card, check for the postback, view the reports, and do a same-day reversal?

    1. 20150930 Mathew Lindley: That would be the best way to test it front-to-back. You can also use the TEST uPay page to simply test transactions without involving the posting application.

  19. (Linda Snyder) The “Site Email Address” item in “General Settings” of the Miscellaneous page…. Is this for administrator announcements/alerts?  Or is this for users to submit queries?

    1. Used as the contact e-mail address on e-mail confirmation messages to the customer. In addition, warning messages for posting URL failures, GL update failures, and recurring payment failures are sent to this e-mail address.

  20. How to view reversals (voids/refunds) in reports

    1. Marketplace Reports » uPay Sites » <uPay name>
      1. » Revenue
        1. Input date range.
        2. Lists out individual transaction and refund lines.
      2. » By Product
        1. Input date range.
        2. Product drilldown will list out individual transaction and refund lines.
  21. 20151012 Mathew Lindley: The end user and school each receive an email saying payment failed on CC recurring failures.
  22. Department notification for transactions processed?
    1. 20151013 Mathew Lindley: A uPay site manager can opt to receive emails by going to "Edit My Profile" on the left hand menu.
  23. Email receipt signature block uses uPay site name by default. Can override by configuring "Payment Notification Signature Text" under "Miscellaneous" section
  24. User's browser might show insecure red lock icon in the https URL in uPay site.
    1. The SSL certificate for secure.touchnet.net, is certainly valid and secure.  This warning is most only being seen by certain older operating systems (generally MAC) and internet browsers that are having issues recognizing new SSL certificates.  Therefore, if those users can visit the site in Safari and permanently trust the root certificate as shown in the attached image, it should resolve future warnings in Safari and Chrome as well.
       
  25. (Cecilia Do)  Per TouchNet Customer Care, there is no way to repost a postback if it is not in the posting exceptions list. The department will need to perform manual updates.
  26. (Cecilia Do)  For passing parameters to your uPay site, can we define our own fields for input? Do these self-defined fields come back to us in the postback? Can we pass over fields not defined in the Technical Guide? Say I pass over fields called student_id = '12345678' and term_code = 'F2017'. Will I get these value pairs in the postback so my web system can further process this data? Or does uPay only accept the parameters defined in the uPay Technical Guide?
    1. Yes, allowed! Cecilia confirmed on TEST environment .
    2.  TouchNet Customer Care: You can pass any parameter you like, we will pass them back to the posting url. Take a look at section 10.4 of the Marketplace Users guide. or the uPay Technical Guide Section 1.0  “uPay will accept any parameters that you pass and in turn pass the parameters back to your campus web application after the transaction is processed”.
  27.  VALIDATION_KEY details: https://secure.touchnet.com/help/tms/79/default.htm#Marketplace%20User%20Guide/Creating_a_VALIDATION_KE.htm
    1. Encode value before putting onto uPay test page: https://test.secure.touchnet.net:8443/C21570test_upay/ext_site_test.jsp

...

  1. Line break

    Code Block
    languagexml
    <br>


  2. Color 

    Code Block
    languagexml
    <font color="red">Hello, this is red.</font>


Miscellaneous

Configuration

  1. (Cecilia Do) 20230207: Configure time zone in local user profile

    1. To set the time zone for how data is displayed in the uCommerce, please follow these steps:

      1. Log into uCommerce > in the upper right, click your name > Then select "Edit Profile"

      2. Once that page comes up, set the time zone to desired settings. > Then click "Save"

      3. The setting to change the time zone for reports in your user profile will be on an individual basis for each user.
        It will not have any effect on realm C21570.

    2. CD: This impacts the Payment Gateway reports. Marketplace reports already reflect Pacific time, regardless of profile Time Zone setting
  2. (Cecilia Do) 20230216: What does the Time Zone under Administration > System Configuration > Default Localization Settings control? [ Does this ] impact the whole “realm” C21570?
    1. Do not change the settings in Administration unless necessary. They control a lot of internal processes.

Reports

  1. (I-Rong Lin) Credit card transaction data is kept indefinitely (e.g. not purged or limited)
  2. All reports are available via CSV
  3. Marketplace reports

    1. Query Dates

      1. (Cecilia Do) For the query date parameters, is the “From” date starting at the beginning of the day? And the “To” date is the end of the day? For example, if I entered 8/4/15 for both, the criteria would be 8/4/15 12:00:00.000AM through 8/4/15 11:59:59.999PM. 
        1. 20150806 Mathew Lindley: Correct
      2. (Cecilia Do) Is this Central Time? (which is ok because the transaction dates are Central Time anyways?) 
        1. 20150806 Mathew Lindley: Correct

    2. Dates

      1. 20150804 Mathew Lindley: If the transaction is auto-fulfill, the report is based on activity for that transaction. If the transaction is not auto-fulfill, the report is based on the fulfillment date (which works, because we wouldn’t send the transaction to the batch until fulfillment either way).

    3. Revenue by Accounting Code Report
      1. (Cecilia Do) How do voids (or same day reversals) look in this report? Are they two separate line items with a positive amount and a negative amount with two separate timestamps? Or is it one line that was originally a positive amount, and then gets zeroed out? (relates to #3-b below)
        1. 20150806 Mathew Lindley: The report will show the total for each accounting code but you can also view the report in detail which will show all the transactions that make up the totals
        2. Cecilia Do: Authorization comes in as one credit line. Same day reversal comes in as a debit line. If the void comes in the second day, then the first day will have the credit, the second day will have a debit.
      2. (I-Rong Lin) Does Revenue by Accounting Code report only contain settled transactions? 
        1. 20150806 Mathew Lindley: No, It contains all completed transactions in Marketplace, including transactions which may not have yet settled for their daily batch. Cecilia and I discussed this as well and I would recommend comparing the Batch Detail Report to the Revenue by Accounting Detail Report, using the first and last transactions from the Batch report to define the list of Accounting updates for that batch. Very slow in all likelihood but the only way to ensure accurate manual GL updates using these reports.
      3. (Cecilia Do) Suppose we configured our batches to close for settlement at 5PM daily (which we do in our current system). Then I run a report for 8/4/15.
        1. Will it include the settled transactions that were auto-fulfilled/fulfilled from 8/4 12AM through 8/4 5PM, and the not-yet-settled transactions auto-fulfilled/fulfilled from 8/4 5PM through 8/4 11:59PM? 
          1. 20150806 Mathew Lindley: Correct, but if you compare to batch detail as described above you can sort this out.
        2. How will the data look if an authorization goes in on 8/4 6PM, and then on 8/5 8AM I void it? 
          1. 20150806 Mathew Lindley: You will see both transactions in the accounting code report, neither of the transactions will show in the batch detail report

      4. (Cecilia Do) Settlement cutoff is 5PM. $100 authorization for account code MISC at 6PM last night. Same transaction was voided 8AM this morning.

        1. When I pull a report for yesterday, the accounting code report (summary) will show

          1. MISC - $100 - credit?

        2. When I pull a report for today, the accounting code report (summary) will show 

          1. MISC - $100 - debit?

        3. When I pull a report for yesterday through today, the accounting code report (summary) will not show MISC, since it netted out to $0?

      5. (Cecilia Do) We found that the Revenue by Accounting Code Detail Report CSV is missing the fulfillment date column.
        1. 20150813 Mathew Lindley: Product Development says this is not intended and is a bug. I am entering a ticket to get this fixed.
      6. (Cecilia Do) The Accounting Code report is pulled by fulfillment date.
        1. If there was a GL Exception say yesterday, and the exception was not processed until today, the Accounting Codes amounts are still tied to the original date: yesterday, e.g. they will not show up on today's date, the date you marked the exception as complete.
    4. (Cecilia Do) 20150825 Mathew Lindley (in red): For the Revenue by Merchant:
      1. How do recurring payments show up? I’m guessing they show up on the date that a payment is scheduled to be made? Yeah, this is only revenue in a timeframe, without projected recurrences factored in.
      2. This report will show a summary including same-day reversals and refunds? I don’t think so but just to be sure I would recommend doing it, that should be easy to test.
        1. 20150828 Cecilia Do: Reversal, same-day or not, is a new line with a negative amount. The summary amount totals the net as expected.
    5. How do we view a list of products and all the modifiers?
      1. 20151012 Mathew Lindley: Go to Marketplace Reports » Stores » <Store> » By Product. 
        1. Drill-down to specific product.
          1. Displays transactions with all modifiers
        2. Option to "Export to CSV". Can pick-and-choose modifiers to export.
    6.  For the "By Stock No." report, it does differ from the Totals report for the same store because the totals includes the taxes, whereas By Stock No. does not. The By Product, By Stock No., and By Product Type all reference the same amount.
  4. Payment Gateway reports
    1. (I-Rong Lin) Batch Settlement report is broken down by MID
    2. The Credit Card Type Usage Report is based off the batch settlement time.


    3. (I-Rong Lin) One batch per MID?
      1. 20150806 Mathew Lindley: No, you can send multiple batches to a single MID (with each have their own reports).
  5.  Product fulfillment
    1. Marketplace revenue reports are based off the fulfillment date for products requiring manual fulfillment

    2. Fulfilled order transactions will be submitted for the day's credit card batch for settlement

      Tip

       Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.


...