AbleCommerce Shopping Cart Software

And recalculate taxes as well if your customer is in WA state. since WA state charges tax on shipping.

I had this problem the other day. Recalculate works just fine.

I am using Web2Market's Report Wizard so I can do SQL inside of Ablecommerce.

That was a very nice query. It gave me info that I was looking for plus more.

Thanks,

-Charles

We are using Ablecommerce Gold. We are looking for a SQL query to show us the count of registered users from the European Union. I can do it a query for each country, but I can't figure how to do it for a group on countries. I need the number of users separated by country. This information would be ...

You are right, I never knew there was a TotalCharges and TotalPayments field.

I thought I was going to have to calculate those fields during the query so I could make it work. Thanks to you a few customers got their refunds that were due.

Prefect, that got me going in the right direction. I was able to find the orders that I need to give a refund to.

Send me your Paypal address and I will shoot you a gratitude of my appreciation.

50 bucks via Paypal for someone that can help me figure this out.

Must be SQL Code.

Fields needed:

Order Number, Order Date, and Negative Balance AMT

Hi There, Can anyone kindly help me figure out some SQL code to locate negative remaining balances in orders? We normally have negative balances when customers are due refunds because they either remove items from their order or downgraded their shipping. I need some SQL Code to help me locate the n...

OK thanks for the update.

Zendesk would be an awesome addition.

Dimi Goranov with Drundo Software Inc. developed an add on to work with CDN that looks interesting.

You can see his post here: viewtopic.php?f=25&t=17924&p=77605&hili ... gin#p77605

I am sure there is a way to decrypt, but if you just change the server name to the same as previous then you don't have to worry about all that. But if you need to do that a brief Google search pulls up lots of articles on how to do that. Here is another thing I found useful...when you are making th...

On your SQL server it might simplify things by changing the new server to the old name after you restore your databases. That way you don't have to mess around with your database configs.

The last time I checked UPS address verification was not able to validate missing apt numbers.

If you are willing to lay out some coin https://smartystreets.com/ has the best and most detailed API for address correction. Well worth the money in our opinion.

Thanks that works perfect.

How can I improve the appearance of the fly out category on the responsive theme using the CategoryMenu Control when in small screen mode?

OK, got it working with the code. Thanks

I've try putting in the <%@ Implements Interface="CommerceBuilder.UI.ISidebarControl" %> code in as well in 2 different files. The CategoryListEx file and in another custom sidebar control which does not use the code behind approach and both are not showing up in the layout control list. I would muc...

Here is the help section on the Responsive Design Theme (Just in case you have not yet seen it)

http://help.ablecommerce.com/mergedProj ... _theme.htm

Also, when you installs the demo it installs the Responsive Theme as default.

This is great news. Thanks for the update.

Thanks for the comment Mike. We are looking forward to seeing the release too. Can't wait to change my sig line.

-Charles

OK, those bullet points were from the ShipStation website. I went ahead and wrote them (ShipStation Support) the following message: Our shopping cart vendor, Able Commerce, has informed us that they will be integrating ShipStation with the next version. In your ad copy on your software you state, "P...

Got the R10 Announcement email as well and was surprised (In a good way) by a few things.

In one of the ShipStation bullet points it says:

"Powerful, customizable tools to automate some decision points."

What does that mean?

Also, is the WA State Tax Provider still included in R10?

Hoping to move to R10 once it is released, but I wanted to do some experiments using our negotiated rates. I guess I will wait for R10.