Search found 482 matches

by Mike718NY
Sun Mar 21, 2010 4:45 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: 7.0.4 Database Access Layer
Replies: 3
Views: 2642

Re: 7.0.4 Database Access Layer

I've used this and it works great: http://forums.ablecommerce.com/viewtopic.php?f=47&t=12056 I added a field to the Products table and used this DAL to access/modify the field I used with the above: string query = string.Empty; if (chk_Engraving.Checked) { query = "UPDATE ac_Products SET Engraving =...
by Mike718NY
Tue Mar 09, 2010 6:36 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Advanced search errors when enabling Full Text search
Replies: 8
Views: 3864

Re: Advanced search errors when enabling Full Text search

Eric, do you ever get the FTS Catalog back?

I unchecked "Enable Full Text Searching" to try the other search, and now
I went to check it again to enable it and it won't stay checked.
And the Catalog is missing in SQL Server too. ??

Does the Catalag need to be recreated?
by Mike718NY
Tue Mar 09, 2010 3:28 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Seach Results Sorted by Relevance
Replies: 16
Views: 9849

Re: Seach Results Sorted by Relevance

Thanks Rob, I'll try it out.
I wish I could just use my SQL (from an above post) but I don't have the full source code.
That SQL works perfectly for every search.
by Mike718NY
Tue Mar 09, 2010 2:40 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Seach Results Sorted by Relevance
Replies: 16
Views: 9849

Re: Seach Results Sorted by Relevance

I turned off Full Text Search to see if the other search is any better. Not really. Inconsistent results. If I search "Boat Plaque" I get all 4 items. If I search "Boat Plaques" I get no results. A properly configured Full Text Search would return 4 items in both cases, . . as it just did when I tri...
by Mike718NY
Mon Mar 08, 2010 1:54 pm
Forum: Good Reference Posts
Topic: Email Alert to the registered users with Abandoned Baskets
Replies: 30
Views: 71296

Re: Email Alert to the registered users with Abandoned Baskets

Has anyone made a good email body for this?

I'm trying to display the cart items (Qty, Name, Price) but not having any luck.

If anyone could post what they have that would be great. :)
by Mike718NY
Sun Mar 07, 2010 12:51 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Email Server Configuration not working
Replies: 2
Views: 1939

Re: Email Server Configuration not working

I am configuring AbleCommerce on my local machine before going live, . .
That is why: you have to have the application on the actual server for the email to work.
It's not going to work on the local machine.
by Mike718NY
Fri Mar 05, 2010 5:14 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Advanced search errors when enabling Full Text search
Replies: 8
Views: 3864

Re: Advanced search errors when enabling Full Text search

Does turning on full text search automatically generate a catalog? Does it do this immediately or at specific intervals? (ie, is it done during maintenance?) I would think the catalog was created when the database was installed. Good question about the maintenance. I still don't know how or when th...
by Mike718NY
Fri Mar 05, 2010 2:30 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Advanced search errors when enabling Full Text search
Replies: 8
Views: 3864

Re: Advanced search errors when enabling Full Text search

Try going into sql server and rebuilding the catalog.
by Mike718NY
Thu Feb 25, 2010 7:37 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Where is Product -> Category relationship stored in database
Replies: 4
Views: 2866

Re: Where is Product -> Category relationship stored in database

I'm trying to do the same thing.
Can I steal this SQL off someone :wink:
by Mike718NY
Thu Feb 25, 2010 11:46 am
Forum: Critique My AbleCommerce Shopping Cart Powered Site!
Topic: Store Migrated to Able 7
Replies: 4
Views: 17400

Re: Store Migrated to Able 7

jmestep wrote:I moved the javascript to the bottom of the page for SEO purposes and it still works fine.
What file did you put the JavaScript in?

I'm looking to add this menu : http://htmldog.com/articles/suckerfish/ ... s/example/
and it has 12 lives of javascript that I'm not sure where to put.
by Mike718NY
Wed Feb 24, 2010 4:21 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Change order status after checkout
Replies: 4
Views: 2222

Re: Change order status after checkout

Thanks. That's easy. I keep looking for the difficult way to do things :?
by Mike718NY
Wed Feb 24, 2010 4:19 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Abandoned Baskets shopping cart items
Replies: 3
Views: 2109

Re: Abandoned Baskets shopping cart items

You have to make it, read: http://forums.ablecommerce.com/viewtopic.php?f=47&t=8817 But I still haven't been able to put together a decent body for the email. I want to list each product with quanity and price. But the "$basket.Items" just spits it out as one long string of all the products. There m...
by Mike718NY
Tue Feb 23, 2010 8:20 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Change order status after checkout
Replies: 4
Views: 2222

Re: Change order status after checkout

>> I need to change the entire order status to "On Backorder."

How are you doing that? Did you add a custom field?
by Mike718NY
Mon Feb 22, 2010 3:43 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Abandoned Baskets shopping cart items
Replies: 3
Views: 2109

Abandoned Baskets shopping cart items

For the email for Abandoned Baskets, If I use: "$basket.Items" it give this: Item:Confirmation Caption Frame Quantity:1 Price:25.9500 Weight:0 Item:St. Rita Visor Clip Quantity:1 Price:9.9500 Weight:0 ............ Is there a way to show the name, quantity, and price, . . and not show weight, one lin...
by Mike718NY
Thu Feb 18, 2010 11:10 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Seach Results Sorted by Relevance
Replies: 16
Views: 9849

Re: Seach Results Sorted by Relevance

Here is one of many examples of customers leaving the site because they can't find what they want. Below, the customer searched for "chalice pins", going through 21 pages. They left the site because they gave up looking. Can't blame them. There are 2 products for "chalice pins" and the SQL form the ...
by Mike718NY
Wed Feb 17, 2010 12:46 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Enter Key not working for Search
Replies: 6
Views: 3071

Re: Enter Key not working for Search

The Search works on FireFox. I found one difference: FireFox view source: onclick="if(Page_ClientValidate('Search')){window.location='/Search.aspx? IE8: onclick="if(Page_ClientValidate('Search')){window.location='/DCP3/Search.aspx? The Search page is in the root folder and this seems to be the probl...
by Mike718NY
Tue Feb 16, 2010 11:47 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Seach Results Sorted by Relevance
Replies: 16
Views: 9849

Re: Seach Results Sorted by Relevance

Can anyone give me an update on the progress of this?
The search does not give the results it should if 2 or more
search words are entered.
And when the customer can't find exactly what they are looking for,
they will leave the website. This is happening a lot from looking at the logs.
by Mike718NY
Tue Feb 16, 2010 9:20 am
Forum: Critique My AbleCommerce Shopping Cart Powered Site!
Topic: Store Migrated to Able 7
Replies: 4
Views: 17400

Re: Store Migrated to Able 7

Fantasic job.
How did you get that Title tag to the top?
I'm looking for a top menu you like that. Is it SEO safe?
by Mike718NY
Tue Feb 16, 2010 8:42 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Enter Key not working for Search
Replies: 6
Views: 3071

Re: Enter Key not working for Search

Anyboby know anything about JavaScript?
That seems to be the problem but I'm not javascript master.
by Mike718NY
Mon Feb 15, 2010 2:51 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Enter Key not working for Search
Replies: 6
Views: 3071

Re: Enter Key not working for Search

The ID in the Source is: id="ctl00_wpm_HomePage_ctl00_SearchButton"

But a break point in the code is showing:
document.getElementById('ctl00$wpm$HomePage$ctl00$SearchButton')

are the Question marks the problem and should be replaced by underscores?
by Mike718NY
Mon Feb 15, 2010 2:45 pm
Forum: 7.0 Store UI: Layout, Design, Look and Feel
Topic: Pottery Theme - Display problems
Replies: 17
Views: 10976

Re: Pottery Theme - Display problems

App_Themes\AbleCommerce\style.css has setting for the page's width.
It's probably a Cell Padding setting(s).
by Mike718NY
Mon Feb 15, 2010 10:35 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Enter Key not working for Search
Replies: 6
Views: 3071

Re: Enter Key not working for Search

The button in the code is "<asp:Button ID="SearchButton" runat="server" Text="GO!" .... Should I change it to a ASP Link Button instead? Here is the Source code from Default.aspx : <input type="submit" name="ctl00$wpm$HomePage$ctl00$SearchButton" value="GO!" onclick= "if(Page_ClientValidate('Search'...