Search found 247 matches
- Tue Mar 14, 2017 5:39 am
- Forum: AbleCommerce GOLD
- Topic: Messed up database
- Replies: 2
- Views: 4609
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.
- Mon Feb 27, 2017 11:15 am
- Forum: AbleCommerce GOLD
- Topic: Live License Message
- Replies: 1
- Views: 3036
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.
- 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: 5225
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
- Tue Mar 10, 2015 6:23 am
- Forum: AbleCommerce GOLD
- Topic: Adding Custom Fields For Customer
- Replies: 2
- Views: 2393
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",...
- Mon Dec 15, 2014 1:30 pm
- Forum: AbleCommerce GOLD
- Topic: Sorting Invoice Order Items
- Replies: 5
- Views: 3880
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...
- Thu Oct 31, 2013 10:38 am
- Forum: AbleCommerce GOLD
- Topic: Extra paragraph tags in webpage content
- Replies: 2
- Views: 2620
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/...
- Thu Aug 29, 2013 11:03 am
- Forum: AbleCommerce GOLD
- Topic: Error Message Index was outside the bounds of the array.
- Replies: 11
- Views: 8182
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 ....
- Tue Aug 20, 2013 9:17 am
- Forum: AbleCommerce GOLD
- Topic: Mobile Subdirectory
- Replies: 5
- Views: 4264
Re: Mobile Subdirectory
It's in the CommerceBuilder\Utility\UrlHelper.cs file of the Able source.
- 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: 50888
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...
- 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: 50888
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...
- 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: 50888
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...
- 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: 50888
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...
- Mon Mar 25, 2013 10:17 am
- Forum: AbleCommerce GOLD
- Topic: ProductImage Main Image Click
- Replies: 6
- Views: 4757
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; }
- Fri Mar 08, 2013 4:20 pm
- Forum: AbleCommerce GOLD
- Topic: Get Credit Card Auth Information out of an Order object
- Replies: 1
- Views: 2550
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...
- 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: 51670
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...
- 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: 51670
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?
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?
- 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: 51670
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 ...
- 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: 51670
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...
- Tue Feb 26, 2013 4:24 pm
- Forum: Feature Requests
- Topic: Default selection in the product options
- Replies: 8
- Views: 19930
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...
- 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: 13537
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...
- 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: 6220
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...
- Fri Dec 07, 2012 4:16 pm
- Forum: AbleCommerce GOLD
- Topic: Product price line-through
- Replies: 2
- Views: 3585
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.
- 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: 7018
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...
- 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: 7018
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.
- 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: 4694
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...