Search found 151 matches

by efficiondave
Thu Aug 30, 2018 4:18 am
Forum: AbleCommerce GOLD
Topic: Display warning for certain products
Replies: 1
Views: 3135

Display warning for certain products

For California Prop 65, we need to display a warning for certain products. I'm looking for an easy way to pick the products and display the warning. Product Templates have a great system for associating the template to specific products so I created a new product template and associated the products...
by efficiondave
Fri Jan 26, 2018 4:05 am
Forum: AbleCommerce GOLD
Topic: Variant Sku Search
Replies: 25
Views: 44478

Re: Variant Sku Search

We found the same thing as Joe and it was a real issue for us as we were trying to do a syncronization with a clients SAGE MAS 100 system for pricing and inventory and the Variant data wasn't there to sync to. I know we found a way to force it to write the the DB but would have to dig around a bit t...
by efficiondave
Wed Jan 24, 2018 8:22 am
Forum: AbleCommerce GOLD
Topic: Variant Sku Search
Replies: 25
Views: 44478

Re: Variant Sku Search

Any update on this?
by efficiondave
Wed Jan 24, 2018 7:38 am
Forum: AbleCommerce GOLD
Topic: R12 search slow when many Product.SearchKeyword values
Replies: 2
Views: 5838

Re: R12 search slow when many Product.SearchKeyword values

I also need a solution that allows keyword search to include all skus. It's surprising to me this isn't already handled.
by efficiondave
Thu Jun 29, 2017 8:15 am
Forum: AbleCommerce GOLD
Topic: CategoryDropDownList ignores the level setting
Replies: 10
Views: 13300

Re: CategoryDropDownList ignores the level setting

Sorry, haven't upgraded to R12 yet so I don't know.
by efficiondave
Mon Apr 24, 2017 4:01 am
Forum: AbleCommerce GOLD
Topic: Lost Encryption Key
Replies: 5
Views: 7228

Re: Lost Encryption Key

Good point.
by efficiondave
Mon Apr 24, 2017 3:02 am
Forum: AbleCommerce GOLD
Topic: Lost Encryption Key
Replies: 5
Views: 7228

Re: Lost Encryption Key

Yeah, I had found that thread and added a MachineKey after the fact. We managed to get things set back up (Shipping and PayPal were broken) and running. And now I have the encryption key backed up to a few places.
by efficiondave
Fri Apr 14, 2017 10:49 am
Forum: AbleCommerce GOLD
Topic: Lost Encryption Key
Replies: 5
Views: 7228

Lost Encryption Key

I changed out the hardware (Processor, MB, Ram) on my server and that seems to have caused me to lose the Encryption key so I can't retrieve CC info and UPS shipping is broken. I haven't been able to find the Key.bin backup file for the site. I believe I do have the Random text string I used to gene...
by efficiondave
Thu Sep 01, 2016 4:56 am
Forum: AbleCommerce GOLD
Topic: Blocking odd bots from Search.aspx and Category.aspx
Replies: 8
Views: 24879

Re: Blocking odd bots from Search.aspx and Category.aspx

Yesterday I noticed my server had overly high utilization (sustained 90%+ CPU) and in running the queries I specified above I saw BingBot and Yandex were running lots of odd queries against Search.aspx. I looked in robots.txt and saw that search.aspx was blocked but not Search.aspx (capital S). I ad...
by efficiondave
Wed Dec 02, 2015 5:03 am
Forum: AbleCommerce GOLD
Topic: Multi-language support
Replies: 6
Views: 6548

Re: Multi-language support

Is there a target date or release for which you expect to have support complete?
by efficiondave
Mon Nov 30, 2015 1:13 pm
Forum: AbleCommerce GOLD
Topic: Multi-language support
Replies: 6
Views: 6548

Multi-language support

My client wants to add support for multiple languages to the site. I've searched around and I'm not seeing any current information on this for AbleCommerce. Has anyone successfully implemented multiple languages for a single site? What are the options?
by efficiondave
Fri Nov 20, 2015 7:01 am
Forum: AbleCommerce GOLD
Topic: Blocking odd bots from Search.aspx and Category.aspx
Replies: 8
Views: 24879

Re: Blocking odd bots from Search.aspx and Category.aspx

Thanks Joe. 57,000 anonymous users created yesterday. Ugh.

How did you block the bot with IIS?
by efficiondave
Thu Nov 19, 2015 5:52 pm
Forum: AbleCommerce GOLD
Topic: Blocking odd bots from Search.aspx and Category.aspx
Replies: 8
Views: 24879

Re: Blocking odd bots from Search.aspx and Category.aspx

I should also note you should probably only worry about dealing with unknown bots logging 10,000 plus hits in a day. The main offender that forced me to look into this logged 40,000 page views in a 3 hour period and that caused my server to crawl.
by efficiondave
Thu Nov 19, 2015 5:24 pm
Forum: AbleCommerce GOLD
Topic: Blocking odd bots from Search.aspx and Category.aspx
Replies: 8
Views: 24879

Re: Blocking odd bots from Search.aspx and Category.aspx

I've been looking into this a bit and the following seem to work: If you are having intermittent performance issues, you'll want to look at your ac_PageViews table. It records all pages that have been served with the ActivityTime, IP, UserAgent, UriQuery and more. If you are current having issues, r...
by efficiondave
Thu Nov 19, 2015 1:14 pm
Forum: AbleCommerce GOLD
Topic: Site Maxing out server
Replies: 3
Views: 3564

Re: Site Maxing out server

I created a new Thread for addressing the issue of bot blocking: viewtopic.php?f=65&t=18610
by efficiondave
Thu Nov 19, 2015 1:13 pm
Forum: AbleCommerce GOLD
Topic: Blocking odd bots from Search.aspx and Category.aspx
Replies: 8
Views: 24879

Blocking odd bots from Search.aspx and Category.aspx

In tracking down a serious performance issue that resulted from highly aggressive bots, I noticed the majority of pageviews come from odd bots that are nailing the search.aspx and category.aspx pages with all sorts of weird queries. Are there recommended AbleCommerce best practices for the Robots.tx...
by efficiondave
Thu Nov 19, 2015 1:00 pm
Forum: AbleCommerce GOLD
Topic: Site Maxing out server
Replies: 3
Views: 3564

Re: Site Maxing out server

Running some SQL queries against the ac_PageViews table helped shed some light... SELECT top 100 * from ac_PageViews ORDER BY ActivityDate DESC the majority of the hits came from two sources and all within milliseconds: UserAgent: AppEngine-Google; (+http://code.google.com/appengine; appid: s~skawa-...
by efficiondave
Thu Nov 19, 2015 12:36 pm
Forum: AbleCommerce GOLD
Topic: Site Maxing out server
Replies: 3
Views: 3564

Re: Site Maxing out server

Also, Google Analytics shows 979 pageviews today. The AbleCommerce Page View report shows over 11,000 views in the last hour.
by efficiondave
Thu Nov 19, 2015 12:34 pm
Forum: AbleCommerce GOLD
Topic: Site Maxing out server
Replies: 3
Views: 3564

Site Maxing out server

There's something weird going on today. One of my AbleCommerce sites is maxing out my server. This is a site I've hosted for at least 7 years without issue. It is currently running AbleCommerce Gold R10 and has been with no changes for a couple months. A huge number of calls to SQL Server are occurr...
by efficiondave
Fri May 29, 2015 11:39 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal Express - No Order Confirmation Emails
Replies: 3
Views: 7681

Re: PayPal Express - No Order Confirmation Emails

Is this a known issue or does it work properly for standard installs? Is this something I have access to the code for? I'm at a loss for how I can fix this without buying the CommerceBuilder source.
by efficiondave
Tue Apr 28, 2015 1:51 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal Express - No Order Confirmation Emails
Replies: 3
Views: 7681

PayPal Express - No Order Confirmation Emails

When users use PayPal Express to pay, they are not getting an Order Confirmation email. Is there a reason for this? Is there a fix?
by efficiondave
Wed Apr 08, 2015 7:23 am
Forum: Good Reference Posts
Topic: ContactUs Control (7.0.8 Gold)
Replies: 10
Views: 21031

Re: ContactUs Control (7.0.8 Gold)

you should really use a HoneyPot field instead of CAPTCHA. Much more user friendly and more effective for now.
https://www.dexmedia.com/blog/honeypot-technique/
by efficiondave
Tue Apr 07, 2015 1:53 pm
Forum: Good Reference Posts
Topic: ContactUs Control (7.0.8 Gold)
Replies: 10
Views: 21031

Re: ContactUs Control (7.0.8 Gold)

You should update the wiki page on this with the new code:
http://wiki.ablecommerce.com/index.php/ ... Us_Control

I wasted time updating the old code from the wiki prior to finding this.