Search found 19 matches

by jhollender
Tue Feb 09, 2016 9:04 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Need help setting up PayPal BillingAgreements
Replies: 0
Views: 8960

Need help setting up PayPal BillingAgreements

We need to be able to capture a sale through PayPal and if the customer makes a change to their order, we need to be able to charge them for the modifications. PayPal said they offer this ability with BillingAgreements that can be added into the cart's code for the PayPal Express checkout through th...
by jhollender
Tue Jan 26, 2016 11:12 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Urgent: An item with the same key has already been added
Replies: 1
Views: 8707

Urgent: An item with the same key has already been added

I really need some help. Our site just started randomly getting some errors over the previous weekend. The error is being generated from random pages on the site, and of course, there is hardly any information to go on. Here's the error: System.ArgumentException: An item with the same key has alread...
by jhollender
Wed Apr 01, 2015 2:45 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help me with some database questions
Replies: 6
Views: 8694

Re: Please help me with some database questions

In case you are curious which tables contain the most data, you can run this script on the DB. I'm surprised that you still have a 6.6 GB data file. That is a lot! create table #TableSize ( Name varchar(255), [rows] int, reserved varchar(255), data varchar(255), index_size varchar(255), unused varc...
by jhollender
Wed Apr 01, 2015 10:02 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help me with some database questions
Replies: 6
Views: 8694

Re: Please help me with some database questions

I had already gone over that page before. We are using AbleCommerce 7.0.7. The Anonymous User Maintenance is only set to 3 days right now: Anonymous User Count: 359880 Oldest Record: 3 days @ 3/29/2015 2:01:15 AM Affiliate Anonymous User Count: 0 Oldest Record: n/a There aren't currently any logs fo...
by jhollender
Wed Apr 01, 2015 8:11 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help me with some database questions
Replies: 6
Views: 8694

Please help me with some database questions

First of all, let me say that I am not a DBA. I've worked with MySQL databases a bit in the past, but I'm new to MS SQL. I inherited this database, and it was never set up properly. The issue that I'm running into has to do with database size and backups. After doing a little research, our database ...
by jhollender
Mon Nov 03, 2014 1:48 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Need help fixing bad data condition for database maintenance
Replies: 2
Views: 5557

Need help fixing bad data condition for database maintenance

Hi, I just noticed this error in our AC error log over the weekend: The DELETE statement conflicted with the REFERENCE constraint "ac_Addresses_ac_BasketShipments_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_BasketShipments", column 'AddressId'. The statement has been termin...
by jhollender
Tue Oct 14, 2014 8:30 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Re: Please help with this TypeInitializationException error

We probably get about 150,000+ pageviews per day on average. Any idea what else I could look into for the random SQL errors?
by jhollender
Tue Oct 14, 2014 8:01 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Re: Please help with this TypeInitializationException error

We are definitely getting tons of anonymous users in a 3 day window. When does Ablecommerce create them? Is a user created on every visit? We are not getting any of the maintenance errors in our logs, so I don't think it is a user constraint issue. I have the maintenance window set to 3 days, delete...
by jhollender
Fri Oct 10, 2014 8:11 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Re: Please help with this TypeInitializationException error

I know this is a painfully long document, but it might help - http://help.ablecommerce.com/upgrades/ac7_aspnet/tech_bulletins/anonymous_user_maintenance.htm There were some maintenance issues in older version of 7.0.x that may have carried over to the 7.0.7 version. I've narrowed the anonymous user...
by jhollender
Wed Oct 08, 2014 2:03 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Re: Please help with this TypeInitializationException error

Actually, I just checked the database and it shows 969885 anonymous users (with the oldest being 15 days old). It is already set to delete older than 15 days. That seems a bit crazy. Any ideas?
by jhollender
Wed Oct 08, 2014 1:49 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Re: Please help with this TypeInitializationException error

SQL Server 2008 R2 is run on a separate server (Windows Server 2012 R2). The error happens at random times, so it is hard to track down. We are running AC 7.0.7 and it looks like there are 74,482 users in AC. I'll run some maintenance to delete users older than 15 or 30 days.
by jhollender
Wed Oct 08, 2014 8:16 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Please help with this TypeInitializationException error
Replies: 11
Views: 10307

Please help with this TypeInitializationException error

Hi, I'm having some problems with some random errors in AbleCommerce. I cannot pinpoint what is causing the problem - there is no problem connecting to the SQL server. The error happens randomly. Any help or ideas would be greatly appreciated: System.Web.HttpUnhandledException: Exception of type 'Sy...
by jhollender
Thu Apr 10, 2014 9:36 am
Forum: AbleCommerce GOLD
Topic: FEEDBACK WANTED:Is a filtered (Faceted) search available?
Replies: 26
Views: 22207

FEEDBACK WANTED:Is a filtered (Faceted) search available?

Does anyone know of a way to add a filtered search to a store? I'm looking for something similar to: http://www.rei.com/c/hiking-backpacks where you can select categories, features, colors, etc. to filter your search. Once selected, each "filter" should also be able to be cleared. This seems like a ...
by jhollender
Mon Apr 07, 2014 1:07 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Variants explained
Replies: 31
Views: 40238

Re: Variants explained

If I remember correctly, Janice ran into a problem with copying products that had variants with price changes. There was a Able bug in her version that dropped the price modifiers when copying the product in the admin. Mike at Able suggested re-usable kits which I had done in Able 5, but they weren...
by jhollender
Thu Apr 03, 2014 3:01 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Variants explained
Replies: 31
Views: 40238

Re: Variants explained

From months of trying to get it to work, variants do not work when trying to have people customize a product and have it dynamically change the price. The best way to do it is to create kits, so also you can use these same features on multiple products and when it comes time to change the price you...
by jhollender
Thu Apr 03, 2014 11:28 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Variants explained
Replies: 31
Views: 40238

Re: Variants explained

Yeah, I just don't think that AC will be able to handle millions, if not billions, of possible combinations of choices.
by jhollender
Thu Apr 03, 2014 10:46 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Variants explained
Replies: 31
Views: 40238

Re: Variants explained

Variants seem like the best route for us to use because each option is not a product in itself. How would you recommend that we set this up? Your configuration is quite complex. Variants will be able to do the trick for you. But configuring each product for the various acceptable and unacceptable c...
by jhollender
Thu Apr 03, 2014 10:36 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Is there a Web Service for AC product data?
Replies: 0
Views: 3663

Is there a Web Service for AC product data?

If we have a product set up in AC with variants, is there some type of Web Service or API that can be called from an external page to get that product data?
by jhollender
Thu Apr 03, 2014 10:21 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Variants explained
Replies: 31
Views: 40238

Re: Variants explained

My company has been using AbleCommerce for awhile, but we are looking into restructuring the way that we have some things done and I could really use some feedback. We sell some highly customizable products, so here is one of our more complex scenarios: We offer a Custom Guitar Body builder product ...