Table of Contents

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.
(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.
(Cecilia Do) Configure store payment at:
1. Group Payment Methods
2. Store default payment methods
3. Product
(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.
(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
(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
(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.
(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
(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
 Thank you for your interest! Please choose from the donation values described below Gold- $2500 Silver- $1000 Bronze- $500
(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
(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.
(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.
(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.
(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.
(Cecilia Do) It looks like uStore and uPay names are not required to be unique.
1. 20150825 Mathew Lindley: Correct.
(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.
(Cecilia Do) When a uStore's name is changed, the reports will display the new name, even for transaction data before the name change.
(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.
(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.
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:
(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.
(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.
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
(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.
(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.
(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.
(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.
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.
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.
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.
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]
20151207 CD: If do not have an image for a product, may consider using just a white square.
12 May 2016 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.
07 Jun 2016 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
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.
08 Jun 2016 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
(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

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.
(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
(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.
(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.
(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.
(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.
(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.
(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
(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.
(Cecilia Do) It looks like uStore and uPay names are not required to be unique.
1. 20150825 Mathew Lindley: Correct.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
(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.
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.
20151012 Mathew Lindley: The end user and school each receive an email saying payment failed on CC recurring failures.
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.
Email receipt signature block uses uPay site name by default. Can override by configuring "Payment Notification Signature Text" under "Miscellaneous" section
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.
(Cecilia Do) 11 May 2016 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.
(Cecilia Do) 07 Dec 2016 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 07 Dec 2016.
2. 07 Dec 2016 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”.
04 Dec 2020 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

...

(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
(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

(I-Rong Lin) Credit card transaction data is kept indefinitely (e.g. not purged or limited)
All reports are available via CSV
Marketplace reports
Query Dates
(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.03 Apr 2023 (Cecilia Do)
At our campus, we tie Marketplace transactions to the Payment Gateway credit card settlement. We get discrepancies when authorizations come in close to the settlement time. For example, we have our settlement scheduled for 10pm. When a person is making a payment right at 10pm, the transaction may go straight to settlement, instead of going into the next day's batch. This causes a reporting discrepancy.
Does TouchNet have recommendations / suggestions to handle this?
I am thinking that we can mitigate these timing discrepancies if we can schedule a window, say daily between 9:55pm - 10:05pm, of downtime, so people are unable to make submit a payment during this critical window. Is there a mechanism to schedule a window or recurring window of downtime for our Marketplace instance?
1. At this time the only way to schedule downtime in uStores is at Store Settings > Status Management. However that only allows to schedule from Enable to Disable status, or Disable to Enable Status, and wouild also require manual intervention on a store by store basis. uPay sites don't contain a Status Management scheduler similar to uStores and would require manual intervention on a site by site basis as well.
  The only other alternative would be to navigate to Marketplace Home, and in each table for uStores and uPay, on the header row, check the box in the far left next to the "Name" column. Then on the far right, select the Gear drop-down, and select "Disable Web". But that also would require manual intervention.
  Sorry that there aren't better alternatives at this time.

Reports

(I-Rong Lin) Credit card transaction data is kept indefinitely (e.g. not purged or limited)
All reports are available via CSV
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. 13 Jun 2016 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.
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).
07 Jun 2016 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
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.

...

(Cecilia Do) How do we know when settlement completes? Are we notified? Or does settlement always complete, say, within 1 hour?
1. 20150804 Mathew Lindley: Batch settlement completes on the same time every day, based on when you configure your Credit Card Merchant to settle its batch. Transactions flow from Marketplace to Payment Gateway upon fulfillment real-time.
2. 20150904 Cecilia Do: Configured batch settlement for 2AM (Central). The batch settlement time is 2:00:01AM.
  1. 30 Jun 2016 Each batch is submitted for settlement one at a time.
    1. Each batch holds up to 1,000 transactions - about 3 minutes to complete settlement transmission
    2. Settlement transmission duration
      1. 100 transactions - 15-20 seconds
      2. 300 transactions - 1 minute
      3. 1,000 transactions - 2.5-3 minutes
(Cecilia Do) And just to confirm, the “Batch time” parameter controls this. It is configured at the individual Payment Gateway Credit Card Merchant level. It is in military time, Central Time. If left at the default value “off” then settlement is manual.
1. 20150903 Mathew Lindley: Correct!
(Dianne Bean) Is there a cutoff for when a department can do a refund through MarketPlace? In other words, if I made a MarketPlace payment today (8/25) at a School of Medicine store, how long does the SOM have to refund me when I make a request before the transaction is no longer accessible to refund? 30 days? 90 days? 120 days? 6 mos?
1. 20150825 Mathew Lindley: We do not create a limit, we allow the schools to dictate that per store. The system will allow a refund at any time after purchase.
(Cecilia Do) How do debit card types show up in reports? For example, a debit card with the Visa credit card logo, does it show up as “VISA” or “Visa Debit” (Payment Gateway Business User Guide, p.210)
1. 20150806 Mathew Lindley: This shows up as Visa and will be listed as a Signature Debit payment rather than Credit Card in TPG reporting.
(I-Rong Lin) I understand uPay user receive post-back in real time for credit card authorization. For uStore, is it true “order confirmation” is equal to credit card authorization is completed successfully?
1. 20150807 Mathew Lindley: When you set up your Marketplace Merchants, it is configurable whether or not to authorize at order time for the uStores in that Marketplace Merchant. I always recommend turning this on as an Administrator. Otherwise the authorization would occur at batch closure.
2. (I-Rong Lin) I take the default is blank or no for uStore authorization at the time the client places an order.
  1. 20150807 Mathew Lindley: Yes, that is the default. This can be edited by Admins and Merchant Managers in the General Settings of each Marketplace Merchant.
(Cecilia Do) Is the fulfillment/auto-fulfillment date (in the Marketplace reports) the same as the authorization date (in the Payment Gateway reports)?
1. 20150811 Mathew Lindley: The authorization will either occur at order time or at batch closure time, depending on how your admins choose to set that in Marketplace. Also if an authorization passes 72 hours without fulfillment, the fulfillment will put a fresh authorization encumbrance on the card statement (to replace the one that fell off after 72 hours) prior to that day’s batch closure.
(I-Rong Lin) Theoretically if we set up our settlement time from 12 a.m. - 11:59:59 p.m., this will coincide with the date range of information in Revenue by Account Code report even if this report doesn't only list settled transactions, right?
1. 20150813 Mathew Lindley: It should be really close to that, yes. You may have one transaction end up being on one day or the other by a fraction of a second depending on the timing and the communication between marketplace and payment gateway but that should be rare.
(Cecilia Do) Carte Blanche
1. Card type in Payment Gateway reports: "CB"
2. 20150811 Mathew Lindley: No test Carte Blanche number in TouchNet TEST. No plans to add to PaySim.
3. 20150813: Per the MID setup conference call with Mathew Lindley, he said that Carte Blanche is folded into AmEx and there will be no processor on the backend to process Carte Blanche payments. Per discussion with Dianne afterwards, we will not allow Carte Blanche in Marketplace.
(Cecilia Do) We have settlement configured for 12am (2am Central). I have some test recurring payments and I’m seeing that the recurring payments are authorized around 12am, and they’re going straight into the settlement batch. Is this correct behavior? It should be the following day’s data, shouldn’t it? As a result, we’re seeing discrepancies between the Merchant Revenue and the Batch Settlement. For example, if you look at the batch details for 9/7’s batch, you’ll see this:
And here’s one from 9/10:
Can we change the time that recurring payments are fired off for authorization? Say if we can make them come in at 3:00 Central, then it would mitigate the discrepancies.
1. 20150917 Mathew Lindley: Recurring payment authorization times are not configurable. We fix a bug if it is determined that this is not working as expected but anything else would be an enhancement request.
  1. I confirmed with Product Development that the time it runs is not configurable. All payments are scheduled for midnight (00:00) and TMS recur runs payments that have a scheduled date that is less than its current run time. That is why the first time tmsrecur runs starting after midnight, payments for the current day start to be processed.
07 Jun 2016 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
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.
23 Mar 2018 Payment Gateway Failed Credit Card Batch
1. (Cecilia) In the Payment Gateway - Batch Settlement Report, we see 3 transactions authorized and all voided yesterday, leaving the batch with no authorized transactions totaling $0. I am thinking we can disregard this notice. Can you please confirm this is correct?
2. (TouchNet) You are correct. Since there were actual transactions and then successful voids, we are still going to attempt to close and process the batch since there are records present. However, since the net of the batch comes to $0 and all of the transactions were voids of each other, an error is generated with the processor since the batch is "empty".
15 Jun 2022 (Cecilia Do) We are exploring possibly changing the Payment Gateway credit card settlement schedule. Can we make this change on our own? Can you please advise on where this configuration is? Once the change is made, when does it take effect?
1. (TouchNet) Is your question in regards to the batch closure time? If so, the timing of the batch can be set on each Merchant here:
  Payment Gateway > Payment Processing Setup > Credit Card > Merchant Configuration > Select the Merchant > General Configuration > Batch time
  After changing the time, I believe a Restart of the Payment Module would need to happen. That can be found here:
  Payment Gateway > Payment Processing Setup > Credit Card > System > at the bottom is is "Restart Payment Module".
2. (Cecilia Do) When the "Restart Payment Module" is run, does this interrupt service? How long does the restart last?
  1. (TouchNet) The Restart Payment Module is instant and does not cause any down time at all.
3. (Cecilia Do) Say currently my batch close time is 12AM midnight, and I change it to 11PM for all my merchants, and run "Restart Payment Module." Will the new close time apply to all my current batches? In other words, if a merchant already had an open batch, will this batch close at the new 11PM cutoff?
  1. (TouchNet) As long as you change the time before that batch is run, it should take effect immediately.
03 Apr 2023 (Cecilia Do) When the "Restart Payment Module" is run, does this interrupt service? How long does the restart last?
1. (TouchNet) The Restart Payment Module is instant and does not cause any down time at all.
(Cecilia Do) Say currently my batch close time is 12AM midnight, and I change it to 11PM for all my merchants, and run "Restart Payment Module." Will the new close time apply to all my current batches? In other words, if a merchant already had an open batch, will this batch close at the new 11PM cutoff?(TouchNet) As long as you change the time before that batch is run, it should take effect immediately For the credit card settlement process in the Payment Gateway, is there a way to change the merchant settlement order/priority? For example, can we move "SLATE GRAD SIR" to be first before the "ARTS" settlement?
1. The batch settlement goes in order of the SubTransCode in Payment Processing Setup. This order is set by merchant creation time. So for example the first batch to processed was ARTS which is SubTransCode 0 the first merchant created. There is no way to change how the SubTransCodes are numbered as they are created as new merchants are created. The only way to prioritize a batch settling time would be to change the batch closure time to be before the other merchants. If prioritizing batches is something you would like to see in the further my suggestion would be to add an enhancement request in the Ideas portion of the client community. I will close this case on our end but please let me know if you have any further questions or concerns regarding this case.