AbleCommerce Shopping Cart Software

Sorry, I forgot the semi-colon at the end of the line of code I posted. I figured it probably used the same code to calculate the rates on first load and when the basket changes. I hadn't tried it before, but I tried the unchanged OPC page on my test server now, and when the page loaded, the shippin...

Disclaimer: I don't use OPC and I haven't tried this, it is just an educated guess. Using GOLD R12. In OPC.aspx.cs, after building the rateQuotes collection on line 508: ICollection<ShipRateQuote> rateQuotes = shippingCalculator.QuoteForShipment(shipment); add a line to sort rateQuotes from lowest t...

I haven't tried it in the template you are asking about, but some of the other templates use .ToString("G") after a date field. For example, the Customer Order Notification template has $order.OrderDate.ToString("G") , and the time in the generated email matches my store time. Perhaps that will work...

If it is the paging that causes the problem, I guess you could call LoadForCategory without the last 2 parameters (it is overloaded), then do your own sort, then use the page size and index to remove unwanted items from visibleNodes. However, if you do that, the more items in the category, the longe...

Oh, maybe it has to do with the paging? LoadForCategory determines which records to return based on the page size and page index, but it is ordering things using the Product OrderBy field, then counting where to start and how many to return in that order. I should have thought of that earlier, sorry...

Just as a troubleshooting step though, if you run the exact query you have on the web page but from Mgmt Studio, without the join to products, do the node IDs come back in the correct order?

Hmm, not sure what's going on then. If you run this query directly (outside of AbleCommerce): select CatalogNodeId from ac_CatalogNodes where CategoryID = 47 order by OrderBy --or whatever the category id is are the catalog node ID's in the order you expect? Remember, you will be getting catalog nod...

Not sure what would be involved, here's a thread with the same question regarding R10:
viewtopic.php?f=65&t=19077

That looks like a phishing email. I doubt paypal-notice.com is a real PayPal site. The grammar of the email looks a little suspicious too.

EDIT: Maybe it is legitimate after all. I don't use PayPal, so don't rely on my answer .

GOLD R11 and higher has a "Secure All Pages" check box at Admin/Store/Security/Default.

Make sure the query in your code is: select CatalogNodeId from ac_CatalogNodes where CategoryId = " + this.CategoryId + " order by OrderBy The select clause should select the CatalogNodeId field, and the order by clause should sort on the OrderBy field. Also, if multiple items in the category have t...

A Basket has a Shipments collection (each of type Shipment), and a Shipment has an Items collection (each of type BasketItem). Each BasketItem has a Shipment property. If you manipulate them, just make sure the item's Shipment property is set to the Shipment that actually has the item in its Items c...

In R12, there are two errors in the code that builds the javascript dateQP function in \Admin\Orders\OrderNotesManager.aspx.cs. These errors result in an invalid script, so the date fields are not filled in when you choose an item from the Date Quick Pick drop-down. Error # 1: Line 32 should be: str...

Short version: The Search bug can also be fixed by updating jquery-ui to the current version (1.12.1). However, I have not done systematic testing to see if that breaks anything else, and I have not tried updating all the .css files that come with jquey-ui and are located in AbleCommerce's Themes fo...

Did a little more digging, found a work-around for the search issue. There was a error message in the browser console: TypeError: r.getClientRects is not a function against file jquery-3.3.1.min.js. Googling that error eventually led me to the following. Download the jquery-migrate-3.0.1.min.js file...

I had been able to get it to work by downloading a new jquery-ui-i18n.min.js file and new jquery ui file. Interesting, I thought I tried that and had the same problem, but maybe I never tried that combo. As mentioned, it worked fine with the un-minimized new version of jquery-ui and the un-minimize...

My guess would be the Register Now button here
https://www.usps.com/business/web-tools ... elcome.htm
which leads to here
https://registration.shippingapis.com/

So after a little more testing, it looks like going through the jquery-ui-i18n.min.js file and removing all the calls to setDefaults fixes the issue. Everywhere there is something like this: ,e.datepicker.setDefaults(e.datepicker.regional.af) or this: ,e.datepicker.setDefaults(e.datepicker.regional[...

I'm not a javascript or jquery expert, but I did a little testing and research, and here is what I found: The issue with the simplified Chinese font appears to be a timing issue with the localizations for the jquery datepicker widget. There is a jquery-ui-i18n.min.js file in the scripts folder that ...

Thanks, that 'value of "0" is not of type "System.Int32"' led me to notice the mistake in the query I suggested. It should be "select CatalogNodeId ..." instead of "Select OrderBy ...".

Regarding writing your own query, it may work as long as you use a method that returns an IList<Product>; you can assign it to visibleNodes just like the standard code. There several ways to do it with NHibernate, including Native SQL, Criteria, HQL, QueryOver, and Linq. I say "may work" because the...

Is there a more detailed error message in the error log? (Help > Error Log in Admin, or [site root path]\App_Data\Logs\app.log on the server).

Not sure if this is the most elegant or "correct" way :), but perhaps something like: IList<int> catNodeOrder = NHibernateHelper.CreateSQLQuery("select CatalogNodeId from ac_CatalogNodes where CategoryId = " + this.CategoryId + " order by OrderBy").List<int>(); visibleNodes = visibleNodes.OrderBy(vn...

You may need to use stop IIS (in IIS Manager, select the server from the tree on the left, click Stop on the right), then make your change, then start IIS again (same as stop, but click Start on the right). Maybe post your proposed changed ProductTellAFriend.ascx here first, maybe we'll notice somet...

You can view errors by going to Help > Error Log in the Admin area, assuming you haven't already deleted the the errors from that same page. If you delete them from there, they are only deleted from the database, not the text log file. The text log file(s) are at [Site root]\App_Data\Logs on the ser...