Search found 482 matches

by Mike718NY
Sat Dec 15, 2012 6:18 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: How to get Category Name in SQL for Product?
Replies: 3
Views: 6089

How to get Category Name in SQL for Product?

Is there a way to join some tables to get the Category Name? I was able to get the Manufacture name, but I can't see how to join the Category Table. SELECT [ac_Products].[Name] ,[Price] ,[MSRP] ,ac_Manufacturers.Name as 'Manufacturer' ,[Sku] ,[ImageUrl] ,[Description] ,[VisibilityId] FROM [super-v_s...
by Mike718NY
Tue Dec 04, 2012 3:55 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Data Port not working
Replies: 0
Views: 3402

Data Port not working

I'm running version 7.6.248 on Windows 7 64 bit.

When I try to export the Products I get this error:

Image
by Mike718NY
Mon Dec 03, 2012 4:14 pm
Forum: 7.0 DataPort
Topic: Version mismatch error for dataport
Replies: 3
Views: 11229

Re: Version mismatch error for dataport

I got it work by running version 7.6.248 as a pervious post suggested.

But now I get the "Could not Deserialize" error when I try to export Product data.

I there anyway to fix this?
by Mike718NY
Sat Dec 01, 2012 4:54 pm
Forum: 7.0 DataPort
Topic: error: could not deserialize
Replies: 1
Views: 7498

Re: error: could not deserialize

I just got this problem now too.

Anyone know how to fix this? thanks
by Mike718NY
Fri Nov 30, 2012 7:19 pm
Forum: 7.0 DataPort
Topic: Version mismatch error for dataport
Replies: 3
Views: 11229

Version mismatch error for dataport

Got this error when running dataport :

Version mismatch. You are running dataport 7.7.254.0 and we have detected an older version
of CommerceBuilder.DataClient.Api.dll in Bin folder.

I have :
VERSION: 7.0
BUILD: 10152

Should I install a different dataport? thanks
by Mike718NY
Thu Nov 29, 2012 9:29 pm
Forum: 7.0 DataPort
Topic: Does DataPort work on Windows 7 64 bit
Replies: 5
Views: 13289

Re: Does DataPort work on Windows 7 64 bit

thanks . .. I remember doing that for some other program about a year a ago.

I really hate Windows 7 with all this "idiot proof" bs.

It's your computer, . . but it won't let you do anything.
by Mike718NY
Thu Nov 29, 2012 7:19 pm
Forum: 7.0 DataPort
Topic: Does DataPort work on Windows 7 64 bit
Replies: 5
Views: 13289

Re: Does DataPort work on Windows 7 64 bit

Thanks, but there is no "Run as Administrator" option for this when I r-click.

When I run it I get : "Ableccommerce dataport has stopped working".
by Mike718NY
Thu Nov 29, 2012 6:18 pm
Forum: 7.0 DataPort
Topic: Does DataPort work on Windows 7 64 bit
Replies: 5
Views: 13289

Does DataPort work on Windows 7 64 bit

Can the data port run Window 7 64 bit?
by Mike718NY
Wed Mar 21, 2012 9:06 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Add meta tags to Manufacturer pages
Replies: 1
Views: 2239

Add meta tags to Manufacturer pages

I'm thinking it's not possible,
but can I add Meta tags to Manufacturer pages?
by Mike718NY
Mon Jun 06, 2011 8:22 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Prohibited Items (Google Checkout and PayPal)
Replies: 6
Views: 4542

Re: Prohibited Items (Google Checkout and PayPal)

thanks. . but will this take PayPal out the "Payment Method" options on the Checkout page? Is "PayPal Express" the one where the user is taken directly to paypal without having to enter their billing/shipping address at the store? I think I'm using the regular paypal where the user fills out billing...
by Mike718NY
Wed Jun 01, 2011 2:38 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Prohibited Items (Google Checkout and PayPal)
Replies: 6
Views: 4542

Re: Prohibited Items (Google Checkout and PayPal)

jmestep wrote:We handled it on one site by making the Paypal payment method not visible if the basket contained a product was checked to not display for Google checkout.
Good idea. But exactly how did you do this? Do you need the source code to do this?
by Mike718NY
Wed Aug 18, 2010 2:07 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Can't get into Order Manager - going to error page
Replies: 4
Views: 3496

Re: Can't get into Order Manager - going to error page

I didnt' touch the code, it just started happening.
This happened to 3 orders. Whatever it was, it stopped now.
Maybe it was something authorize.net or paypal did.
I don't know.
by Mike718NY
Tue Aug 17, 2010 12:01 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Can't get into Order Manager - going to error page
Replies: 4
Views: 3496

Re: Can't get into Order Manager - going to error page

This is happening because some orders are being placed with
no payment information - the Payment section is blank.
If I add a dummy payment, the Orders screen works again.

Is this a problem related to Authorize or PayPal?
No payment information is being recorded so I can't tell the type of payment.
by Mike718NY
Tue Aug 17, 2010 10:35 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Can't get into Order Manager - going to error page
Replies: 4
Views: 3496

Re: Can't get into Order Manager - going to error page

>> at CommerceBuilder.Common.SortableCollection`1.get_Item(Int32 index)
>> at Admin_Orders_Default.GetPaymentStatus(Object dataItem)

Could this field be a problem in the Orders table:

[PaymentStatusId]
by Mike718NY
Tue Aug 17, 2010 9:37 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Can't get into Order Manager - going to error page
Replies: 4
Views: 3496

Can't get into Order Manager - going to error page

When I click on Orders in the Dashboard, I get kicked out and taken to the error page. Catalog works ok. Here is the error I found on the server logs: Event message: An unhandled exception has occurred. Exception information: Exception type: ArgumentOutOfRangeException Exception message: Index was o...
by Mike718NY
Thu Aug 05, 2010 3:22 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Is there a way in the admin side to see all products at once
Replies: 5
Views: 3607

Re: Is there a way in the admin side to see all products at once

I want sort this list by Vendor. I tried this but it still sorts it by Product Name: <cb:SortedGridView ID="ProductsGrid" ... <Columns> <asp:TemplateField HeaderText="Vendor" SortExpression="VendorId"> <ItemTemplate> <asp:Label ID="Vendor" runat="server" Text='<%# Eval("Vendor.Name") %>'></asp:Label...
by Mike718NY
Thu Aug 05, 2010 11:09 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Want to display all Products with groupings
Replies: 1
Views: 2078

Want to display all Products with groupings

Are there any sql queries out there to display all the products in the database, grouped by Category, Vendor, etc.? SELECT [Name] ,[Price] ,[ManufacturerId] ,[Sku] ,[ModelNumber] ,VisibilityId] FROM ac_Products but would need joins to other tables. Has anyone have already written these queries?
by Mike718NY
Wed Aug 04, 2010 11:42 am
Forum: Good Reference Posts
Topic: Email Alert to the registered users with Abandoned Baskets
Replies: 30
Views: 66145

Re: Email Alert to the registered users with Abandoned Baskets

Thanks a million Mary!
And Aimee & Greg for your version, which I used.
This looks really good.

Did you consider putting a coupon code in the email, for maybe 5 or 10 percent off?
by Mike718NY
Fri Jul 16, 2010 11:20 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Sudden PayPal issue
Replies: 7
Views: 4291

Re: Sudden PayPal issue

>> PayPal instructs us not to store the image locally and refer to it. They require integrators >> to link to it on their site. Yeah, but what happens when they decide to take the image off their server or whatever they did the other night, causing the Reciept page to have no PayPal button the custo...
by Mike718NY
Thu Jul 15, 2010 7:19 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal button on Receipt page gone !!!
Replies: 7
Views: 4784

Re: PayPal button on Receipt page gone !!!

Ok, the button is back . . . swine PayPal . . :x

But how do I change the button to an image on my server?
I still can't find where that button image is generated.
I want to replace it.
by Mike718NY
Wed Jul 14, 2010 10:28 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal button on Receipt page gone !!!
Replies: 7
Views: 4784

Re: PayPal button on Receipt page gone !!!

this is the image that should show :

http://images.paypal.com/images/x-click-but6.gif

and this is the image path I got from viewing the source on Receipt page:

https://www.paypal.com/images/x-click-but6.gif

which is not showing up.
by Mike718NY
Wed Jul 14, 2010 10:23 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal button on Receipt page gone !!!
Replies: 7
Views: 4784

Re: PayPal button on Receipt page gone !!!

But Mike, this is happening on the 2 websites that I work on.
I'm hoping PayPal is going to put those images back on before morning :?
by Mike718NY
Wed Jul 14, 2010 9:29 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal button on Receipt page gone !!!
Replies: 7
Views: 4784

Re: PayPal button on Receipt page gone !!!

The only place I can see where the image is coming from is: \ConLib\Utility\PayPalPayNowButton.ascx.cs Control payNowButton = provider.GetPayNowButton(paymentItem.Order, paymentItem.PaymentId); if (payNowButton != null) phPayNow.Controls.Add(payNowButton); but the "GetPayNowButton" method code is no...
by Mike718NY
Wed Jul 14, 2010 9:08 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: PayPal button on Receipt page gone !!!
Replies: 7
Views: 4784

PayPal button on Receipt page gone !!!

Seems PayPal has taken the image "Click here to pay PayPal" down (the one on the Receipt page) https://www.paypal.com/images/x-click-but6.gif I can't find where this is located in the code. I see this in the Receipt page: Register Src="~/ConLib/Utility/PayPalPayNowButton.ascx" TagName="PayPalPayNowB...