Search found 117 matches

by batmike
Tue Feb 12, 2013 10:16 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DB repair- help!
Replies: 15
Views: 15397

Re: DB repair- help!

Well, our maintenance routines are working well and I have the anonymous users set to delete after 14 days (with affiliate association or not). So a couple months would certainly keep you safe too. I imagine that the large number of records could slow things down a bit. I know that with our search e...
by batmike
Wed Feb 06, 2013 1:50 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DB repair- help!
Replies: 15
Views: 15397

Re: DB repair- help!

Yes you could run any of them using the Query Analyzer. I would run the SELECT first by itself to see some of the data that will be affected, make sure it looks good and such. Then you can run each of the DELETE statements one at a time. And I suppose to cover myself, I would recommend making a back...
by batmike
Wed Feb 06, 2013 9:41 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DB repair- help!
Replies: 15
Views: 15397

Re: DB repair- help!

Rick, I have this code from a while back in another part of the forums here that you can run manually or set up as a SQL job to clean up the anonymous users and their associated details. The first block is just a SELECT statement so you can see how many users you'd actually be affecting by running t...
by batmike
Sun Dec 16, 2012 4:26 pm
Forum: AbleCommerce GOLD
Topic: FedEx
Replies: 4
Views: 5131

Re: FedEx

There's no recent information on it other than that the certification process with FedEx apparently isn't the easiest or most vendor-friendly process. Having said that, there is http://fedexacgold.codeplex.com which is the open source plugin for FedEx that works with Gold. I haven't actually tested ...
by batmike
Mon Sep 17, 2012 1:22 pm
Forum: AbleCommerce GOLD Data Exchange
Topic: Dataport issue with Gold
Replies: 14
Views: 23820

Re: Dataport issue with Gold

Any updates on the DataPort project progression? I'm working on migrating our 7.0.7 and definitely need the DataPort to go live on the Gold version.


Thanks!

Mike
by batmike
Wed Aug 22, 2012 11:41 am
Forum: Good Reference Posts
Topic: GEO IP support
Replies: 9
Views: 20600

Re: GEO IP support

I had an issue come up the other day and others using this may have seen the same thing. It seems that the site changed some of the table code so when trying to hover over to lookup the IP info, an error would be returned. To fix, I had to change line 33 in the /App_Code/GeoLocationHelper.cs from th...
by batmike
Wed Aug 22, 2012 7:33 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: UPC Codes and Amazon Feed
Replies: 16
Views: 12158

Re: UPC Codes and Amazon Feed

No, I started out using Joe Payne's feed builder, which I don't think is being sold anymore, but have modified the code too much for it to look like the original anymore. The Amazon and Google feeds are built around that, but obviously quite a bit more customized to deal with the variants and the sp...
by batmike
Mon Aug 20, 2012 7:22 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: UPC Codes and Amazon Feed
Replies: 16
Views: 12158

Re: UPC Codes and Amazon Feed

For our store, I repurposed the Cost of Goods Sold field that is available for each variant (every size/color combination, for example). By using that, I was able to export the data correctly for my variant based feeds - Google & Amazon in particular. The reports in AbleCommerce get screwed up becau...
by batmike
Tue Mar 27, 2012 4:11 pm
Forum: Feature Requests
Topic: Product Option Lists - Move to Top
Replies: 0
Views: 3182

Product Option Lists - Move to Top

It would be helpful, especially when working with an option list that has a lot of choices, to have a move to top, move to bottom or perhaps even a move up 10 or move down 10 (or something similar) to allow for quicker sorting of the option choices. Specifically for us, being able to sort the option...
by batmike
Tue Mar 27, 2012 8:58 am
Forum: Feature Requests
Topic: Specify Override Price at Option Level
Replies: 0
Views: 3107

Specify Override Price at Option Level

It would be really great to be able to set the modify/override setting at the Option Level - for example. We have Color, Size and Width options and those make up all the variants. If one color is put on clearance, I can change each variant to be the clearance price and mark them all override. If thi...
by batmike
Mon Jan 16, 2012 4:40 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Paypal Commercial Address
Replies: 8
Views: 7475

Re: Paypal Commercial Address

Has this been looked into at all? At this point we're still getting back commercial addresses from our PayPal transactions. This is also a problem because we get much better rate discounts from FedEx when using their Home Delivery method so we'd really like to get this figured out sooner ... Let us ...
by batmike
Wed Nov 23, 2011 11:07 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Don't forget to change the Time Zone Offset
Replies: 1
Views: 2130

Re: Don't forget to change the Time Zone Offset

I agree some kind of reminder or something similar would be helpful since the time changes on the weekend and I don't always remember the day after the change to shift the time on our site.

Of course, having it automatic would also be nice :)



-Mike
by batmike
Thu Oct 06, 2011 2:55 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: How do I secure a folder using SSL?
Replies: 4
Views: 3494

Re: How do I secure a folder using SSL?

Hi Joe, The rewriting is controlled by a file at /App_Data/ablecommerce.config. Open that up and then you will find a node called <securePages> Below that there is a node <directories> and a node <pages> ... if you add in the following under the <directories> node, it will force SSL for the SecureFo...
by batmike
Mon Jun 06, 2011 5:46 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Who has installed 7.0.7?
Replies: 27
Views: 17512

Re: Who has installed 7.0.7?

We've been using it successfully on our live site for about a month now. The PageHelper.cs issue was the big one and with that fixed, everything else works well on our site.
by batmike
Tue May 24, 2011 8:41 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Paypal Commercial Address
Replies: 8
Views: 7475

Re: Paypal Commercial Address

I agree that this needs to be looked into. We have been using PayPal for quite a while now and it is a great payment option for our customers but giving them a couple dollars off just for using PayPal (though nice), isn't really something we'd like to continue doing :) Any headway on this issue woul...
by batmike
Wed May 11, 2011 11:16 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Who has installed 7.0.7?
Replies: 27
Views: 17512

Re: Who has installed 7.0.7?

Logan,

In response to your question, I currently have a little over 160,000 records in the ac_PageViews table and I have the history set to maintain for 5 days and delete ... which isn't really that long but in any case, that should help you decide what to do with the patch optimization.

Thanks!
by batmike
Wed May 11, 2011 9:06 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Who has installed 7.0.7?
Replies: 27
Views: 17512

Re: Who has installed 7.0.7?

I as well have benefitted very much from having a great user community available here and a great amount of posts to search through ... which is where I often find most of my information. Additionally, I'm glad this particular issue was able to be fixed up and look forward to the patch to see how th...
by batmike
Thu May 05, 2011 1:06 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Who has installed 7.0.7?
Replies: 27
Views: 17512

Re: Who has installed 7.0.7?

I have installed 7.0.7 and after the last day having very slow performance I rechecked all the changes made between 7.0.6 and 7.0.7 - both the normal files and source code - and the thing that solved it for my install was removing the changed code that checks all associated categories in the /App_Co...
by batmike
Wed May 04, 2011 11:27 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: AbleCommerce 7.0.7 released
Replies: 19
Views: 16587

Re: AbleCommerce 7.0.7 released

I have a similar questions now that I've completed the upgrade to 7.0.7. I am getting numerous OutOfMemory exceptions along with SqlClient timeout errors. They seem occur once or twice every so often but then a couple hundred pile up every hour or two (or so). I'm wondering if there's something goin...
by batmike
Wed Apr 06, 2011 9:48 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Inventory Quantity Lock
Replies: 1
Views: 1962

Inventory Quantity Lock

I'm curious ... in the flow of product page to add to cart to checkout, when does an inventoried item become locked out and only available to that specific user. I'm wondering because we just did a promo on some half-price gift cards and sold out in a few minutes and I'm checking on this after the f...
by batmike
Thu Mar 17, 2011 5:57 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Goodbye VS 2008
Replies: 1
Views: 2016

Re: Goodbye VS 2008

This is great! Worked for me and I'm all converted now!
by batmike
Mon Sep 20, 2010 2:34 pm
Forum: Feature Requests
Topic: Flat Rate Shipping Fallback
Replies: 2
Views: 3660

Flat Rate Shipping Fallback

FedEx's system has been having a lot of outages lately and since that's our only shipping option, when they go down, we can't complete orders because the shipping options can't be selected. What would be great is to have an option that when the FedEx system times out or otherwise fails, a flat rate ...
by batmike
Wed Jun 02, 2010 7:04 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Sql.log
Replies: 2
Views: 2626

Re: Sql.log

If you have the source code (which is why this happened to me), make sure that the properties of the Visual Studio are set to build in release mode and not debug mode. If the project is built in debug mode, there is a condition in the code to generate the sql.log file to track problems. Once it's in...
by batmike
Thu May 13, 2010 10:55 am
Forum: Critique My AbleCommerce Shopping Cart Powered Site!
Topic: Store Redesign and new Navigation System
Replies: 2
Views: 10739

Re: Store Redesign and new Navigation System

Alex, It's an implementation of EasyAsk, which is a search/navigation software that we are using. It was something I worked on with their developers and we integrated it into AbleCommerce and it works very well. Not the cheapest of solutions, but they offered a perpetual license which is kind of nic...
by batmike
Tue May 11, 2010 6:59 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal stuck in "Authorization Pending" status...
Replies: 122
Views: 226403

Re: PayPal stuck in "Authorization Pending" status...

I went through your checkout process and with the paypal function that you have set where you choose paypal on the one page checkout, within AbleCommerce, the customer finishes the sale and then they must click on a button on the receipt page that says Pay Now with Paypal. Then they'll be transferre...