Search found 247 matches

by david-ebt
Tue Mar 14, 2017 5:39 am
Forum: AbleCommerce GOLD
Topic: Messed up database
Replies: 2
Views: 4511

Re: Messed up database

I've seen this issue under other circumstances and clearing the cookies on the browser (or try private/incognito mode) has gotten me back in.
by david-ebt
Mon Feb 27, 2017 11:15 am
Forum: AbleCommerce GOLD
Topic: Live License Message
Replies: 1
Views: 2977

Re: Live License Message

Go to your Admin/Store/Security/Licensing.aspx page and make sure the registered domain matches your domain and that you're not running in DEMO MODE.
by david-ebt
Thu Feb 02, 2017 3:58 am
Forum: AbleCommerce GOLD
Topic: SQL Query to bring up Counts for Users in the European Union
Replies: 3
Views: 5081

Re: SQL Query to bring up Counts for Users in the European Union

If you're working directly in SQL, you can this query:

Code: Select all

select c.Name, COUNT(*) as NumUsers
from ac_Users u
join ac_Addresses a on u.UserId = a.UserId and a.IsBilling = 1
join ac_Countries c on a.CountryCode = c.CountryCode
where u.IsApproved = 1 and u.IsAnonymous = 0
group by c.Name
by david-ebt
Tue Mar 10, 2015 6:23 am
Forum: AbleCommerce GOLD
Topic: Adding Custom Fields For Customer
Replies: 2
Views: 2328

Re: Adding Custom Fields For Customer

You can also use the ac_UserSettings table. It can store FieldName and FieldValue pairs of data for users. You use string ValueToGet = AbleContext.Current.User.Settings.GetValueByKey("FieldToGet") to get the value for a user. And you use AbleContext.Current.User.Settings.SetValueByKey("FieldToSave",...
by david-ebt
Mon Dec 15, 2014 1:30 pm
Forum: AbleCommerce GOLD
Topic: Sorting Invoice Order Items
Replies: 5
Views: 3806

Re: Sorting Invoice Order Items

Austin, If you have the source, you can make a copy of the OrderItemComparer.cs file and put it into your App_Code folder. Give it a new name and change the name of the class to something unique like MyOrderItemComparer. Then you can use that class in the ViewOrder.aspx.cs to use your sort instead o...
by david-ebt
Thu Oct 31, 2013 10:38 am
Forum: AbleCommerce GOLD
Topic: Extra paragraph tags in webpage content
Replies: 2
Views: 2557

Extra paragraph tags in webpage content

The built-in editor for editing the content on a webpage is adding some extra paragraph tags. If I put this into the webpage content in HTML mode: <!-------------- Some special instructions -------------------> <!-------------------------- BANNERS --------------------------------> <img src="/Assets/...
by david-ebt
Thu Aug 29, 2013 11:03 am
Forum: AbleCommerce GOLD
Topic: Error Message Index was outside the bounds of the array.
Replies: 11
Views: 8103

Re: Error Message Index was outside the bounds of the array.

We're seeing the same issue with some 7.0.7 and 7.0.6 sites but only if the site uses Custom URLs. If the site does not use Custom URLs we don't see these messages. And the error messages have nothing to do with a Custom URLs. I've seen them for the default.aspx, a category page and a product page ....
by david-ebt
Tue Aug 20, 2013 9:17 am
Forum: AbleCommerce GOLD
Topic: Mobile Subdirectory
Replies: 5
Views: 4189

Re: Mobile Subdirectory

It's in the CommerceBuilder\Utility\UrlHelper.cs file of the Able source.
by david-ebt
Mon Jul 29, 2013 2:14 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: USPS and ABLE don't agree
Replies: 29
Views: 47102

Re: USPS and ABLE don't agree

A customer will only see Military or DPO if their address is an APO/FPO/DPO address. If you enter in APO as the state and 09002 as the zip that should give you a Priority Mail Express result. The rate on the USPS site for that is $35.90. They'll also only see 1-Day or 2-Day or 3-Day if USPS offers t...
by david-ebt
Mon Jul 29, 2013 1:04 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: USPS and ABLE don't agree
Replies: 29
Views: 47102

Re: USPS and ABLE don't agree

It does not cost $16.10 to ship from zip code 95030 TO zip code 95031. It is returning the most expensive service only for 1 lb packaging going from and to the same town. If you go to the USPS online calculator, it will return a cost of $16.05 for shipping a 1lb package from 95030 to 95031 via Prio...
by david-ebt
Mon Jul 29, 2013 12:39 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: USPS and ABLE don't agree
Replies: 29
Views: 47102

Re: USPS and ABLE don't agree

I can ONLY get 1 method to show in the shopping cart, and that is Priority 1-day, I've entered all varients from Express, 1, 2, 3, APO and DPO (dont even know what that is). How do I get the other methods to show? I've tested shipping to various locations including California, Alaska.. only the one...
by david-ebt
Mon Jul 29, 2013 12:38 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: USPS and ABLE don't agree
Replies: 29
Views: 47102

Re: USPS and ABLE don't agree

One option you have to fix this is when you name the shipping method. You have the ability to set the name of the Shipping Methods as you enter them. So the service can called Priority Mail 1-Day but you can name it Priority Mail and strip the transit time off yourself. This will mean you have six m...
by david-ebt
Mon Mar 25, 2013 10:17 am
Forum: AbleCommerce GOLD
Topic: ProductImage Main Image Click
Replies: 6
Views: 4660

Re: ProductImage Main Image Click

If you add this to your styles.css file it will change the mouse to a pointer when the user hovers over the main product image.

Code: Select all

div.productImageArea div.mainImage img.productImage:hover { cursor:pointer; }
by david-ebt
Fri Mar 08, 2013 4:20 pm
Forum: AbleCommerce GOLD
Topic: Get Credit Card Auth Information out of an Order object
Replies: 1
Views: 2474

Re: Get Credit Card Auth Information out of an Order object

In 7.0.7, the CheckoutResponse only has the OrderId and OrderNumber. You'll need to use OrderDataSource to get the actual order. The reference information you're looking for is in the payment records associated with the order. If you're using 7.0.7, here's a snippet of code that pulls the transactio...
by david-ebt
Wed Mar 06, 2013 9:18 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: HELP- unsuccessfully moving to new server
Replies: 26
Views: 51113

Re: HELP- unsuccessfully moving to new server

Rick, That's good news! The file size of the database file won't shrink by itself. The database file is like a separate file system. Inside the MDF there is now extra space that the database will use to hold new records. If you run a search on Google for "sql shrink database" you'll see how to shrin...
by david-ebt
Tue Mar 05, 2013 6:34 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: HELP- unsuccessfully moving to new server
Replies: 26
Views: 51113

Re: HELP- unsuccessfully moving to new server

What user owns the AC tables? Are they "dbo" or some other user?

Can you run any query against the database? Like "select top 1 * from ac_Categories"?

Your screen indicates SSMS is in debug mode. Can you do a simple F5 execute instead of an ALT-F5 debug?
by david-ebt
Mon Mar 04, 2013 2:48 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: HELP- unsuccessfully moving to new server
Replies: 26
Views: 51113

Re: HELP- unsuccessfully moving to new server

What happens when you just run the inner select: select top 100 u.UserId, o.OrderId from ac_users u left join ac_Baskets b on u.UserId = b.UserId left join ac_orders o on u.UserId = o.UserId left join ac_Wishlists w on u.UserId = w.UserId where u.IsAnonymous = 1 and o.OrderId is null and b.BasketId ...
by david-ebt
Mon Mar 04, 2013 11:36 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: HELP- unsuccessfully moving to new server
Replies: 26
Views: 51113

Re: HELP- unsuccessfully moving to new server

Rick, Do you have QUERY access to the database? If so, you can run this query. Make sure you have a good backup first. Also check the LastActivityDate to make sure you're okay deleting users before the first of the year. begin tran delete dd from ac_users dd join ( select top 100 u.UserId, o.OrderId...
by david-ebt
Tue Feb 26, 2013 4:24 pm
Forum: Feature Requests
Topic: Default selection in the product options
Replies: 8
Views: 17025

Re: Default selection in the product options

In GOLD there is a function in the BuyProductDialog.ascx.cs that builds the options choice - GetOptionChoices. By default this function adds the option header text as the first item. We commented out that code to always default to the first option. protected List<OptionChoiceItem> GetOptionChoices(O...
by david-ebt
Wed Feb 20, 2013 10:18 am
Forum: 7.0 Store UI: Layout, Design, Look and Feel
Topic: is there a way to list products by the date they were added
Replies: 3
Views: 11079

Re: is there a way to list products by the date they were added

Sorry, my mistake. That sort option won't work on the CategoryGridPage. The only valid sort options are based on the group by in the ProductDataSource.NarrowSearch query: ProductId, Name, Sku, Price, MSRP, CostOfGoods, Weight, Length, Width, Height, IsFeatured, FTS.RANK, OrderBy, Manufacturer Sortin...
by david-ebt
Mon Dec 17, 2012 9:12 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: How to get Category Name in SQL for Product?
Replies: 3
Views: 6028

Re: How to get Category Name in SQL for Product?

Try this query: SELECT p.[Name] ,p.[Price] ,p.[MSRP] ,m.[Name] as 'Manufacturer' ,p.[Sku] ,p.[ImageUrl] ,p.[Description] ,p.[VisibilityId] ,c.[Name] as 'Category' FROM [ac_Products] p left JOIN ac_Manufacturers m ON p.ManufacturerId = m.ManufacturerId left JOIN ac_CatalogNodes cn ON cn.CatalogNodeId...
by david-ebt
Fri Dec 07, 2012 4:16 pm
Forum: AbleCommerce GOLD
Topic: Product price line-through
Replies: 2
Views: 3507

Re: Product price line-through

It looks like the current GOLD templates don't have CSS styles associated with those values. You'll have to modify the ConLib\BuyProductDialog and ConLib\Utility\ProductPrice controls to add CSS styles.
by david-ebt
Fri Dec 07, 2012 1:35 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: How to use Custom URL option
Replies: 8
Views: 6834

Re: How to use Custom URL option

You should be okay. Take a look at the source code for both the Pxxx page and the custom URL page. They should both have a canonical meta tag in the HEAD and the meta tag URL should be the same for both URLs. I think it will end up being the custom URL. This canonical tag tells the search engines th...
by david-ebt
Fri Dec 07, 2012 12:47 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: How to use Custom URL option
Replies: 8
Views: 6834

Re: How to use Custom URL option

I believe the old URLs with the Pxxx and Cxxx will continue to work with your custom URLs. I'd suggest you add a custom URL to one of your products and then try the Google link just to make sure.
by david-ebt
Wed Dec 05, 2012 2:50 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Google Adwords conversion tracking Not working.
Replies: 3
Views: 4627

Re: Google Adwords conversion tracking Not working.

This is what we're using for the GoogleCheckoutWidget control: GoogleCheckoutWidget.ascx <%@ Control Language="C#" AutoEventWireup="true" CodeFile="GoogleCheckoutWidget.ascx.cs" Inherits="ConLib_GoogleAnalyticsWidget" EnableViewState="false" %> <%-- <conlib> <summary>Widget for Google Analytics Trac...