Search found 4912 matches

by mazhar
Mon Apr 18, 2016 1:00 am
Forum: AbleCommerce GOLD
Topic: Return or Refund
Replies: 25
Views: 44167

Re: Return or Refund

I'm working on upgrading my site and I just noticed something that could be related... AbleCommerceGold-GoldR11-b8643-SRC.zip\IntegratedProviders\AuthorizeNetCIM\AnetApiSchema.designer.cs // Generated by Xsd2Code. Version 3.4.0.37595 UpgradeGold-R11b8643-R11SR1b8858-SRC.zip\IntegratedProviders\Auth...
by mazhar
Mon Apr 18, 2016 12:55 am
Forum: AbleCommerce GOLD
Topic: Where is the microdata for availability
Replies: 3
Views: 3528

Re: Where is the microdata for availability

I think it was discussed here before it made into R11 SR1 viewtopic.php?f=65&t=18372 along with some customization tips.
by mazhar
Mon Apr 18, 2016 12:49 am
Forum: AbleCommerce GOLD
Topic: Unexpected row count errors (R5)
Replies: 2
Views: 12328

Re: Unexpected row count errors (R5)

It seems like it happens when it tries to delete something which is already deleted from database. Not sure about how to trigger this scenario though. Is thee any custom code in place which maybe removing basket items before this system routine or maybe directly from database without involving Nhibe...
by mazhar
Thu Apr 14, 2016 2:12 am
Forum: AbleCommerce GOLD
Topic: Sorting Order Items List
Replies: 1
Views: 3463

Re: Sorting Order Items List

You will have to replace following code products.Sort(new OrderItemComparer()); with products.Sort("Sku", CommerceBuilder.Common.SortDirection.ASC); Also if you are using Web Application version then in order make these changes work you will need to build the website project. If you are using Websit...
by mazhar
Thu Apr 14, 2016 1:52 am
Forum: AbleCommerce GOLD
Topic: Error installing AbleCommerceGold-GoldR11SR1-b8858-WAP
Replies: 4
Views: 5143

Re: Error installing AbleCommerceGold-GoldR11SR1-b8858-WAP

Make sure under App_Data folder you have a file called database.config. Before any successful install its content should be <connectionStrings> <add name="AbleCommerce" connectionString="CONNECTIONSTRING" providerName="System.Data.SqlClient" /> </connectionStrings> Now try to install from /install/d...
by mazhar
Wed Mar 30, 2016 11:51 pm
Forum: AbleCommerce GOLD
Topic: AC suddenly sending template e-mail to customer
Replies: 19
Views: 17171

Re: AC suddenly sending template e-mail to customer

After deleting the templates have you noticed any errors in error log? If there was any potential code sending those mails it could be failing and dumping errors in log. If you found any related error entry then this could be helpful and may provide hint about code location.
by mazhar
Wed Mar 30, 2016 4:25 am
Forum: AbleCommerce GOLD
Topic: AC suddenly sending template e-mail to customer
Replies: 19
Views: 17171

Re: AC suddenly sending template e-mail to customer

Do you have anything customization which maybe related to this? Any custom recurring event implemented for something? By default six hours is maintenance interval but we don't send Emails during maintenance. Is it possible to see what was the order against which customer received Emails? Maybe inspe...
by mazhar
Wed Mar 30, 2016 3:52 am
Forum: AbleCommerce GOLD
Topic: AC suddenly sending template e-mail to customer
Replies: 19
Views: 17171

Re: AC suddenly sending template e-mail to customer

Which version of ablecommerce that website is running?
by mazhar
Wed Mar 30, 2016 3:42 am
Forum: AbleCommerce GOLD
Topic: What happened to ProductVolumeDiscounts?
Replies: 4
Views: 3914

Re: What happened to ProductVolumeDiscounts?

ProductVolumeDiscount is no longer needed in Gold since Nhibernate can take care of this by itself. This object was used to create a join between a product and discount. This is now being taken care by Nhibernate mappings. This makes code cleaner and meaningful since it abstracts the implementation....
by mazhar
Sun Mar 20, 2016 11:54 pm
Forum: AbleCommerce GOLD
Topic: Error on upgrading from Gold R10 to 11
Replies: 5
Views: 4968

Re: Error on upgrading from Gold R10 to 11

It seems like some of your order has missing shipping details. If you run following query on your database it will tell you about order items pointing to invalid order shipments. SELECT OI.OrderItemId, OI.OrderId, OI.Name, OI.OrderShipmentId FROM ac_OrderItems AS OI LEFT OUTER JOIN ac_OrderShipments...
by mazhar
Mon Mar 14, 2016 1:45 am
Forum: AbleCommerce GOLD
Topic: R11 how to merge anonymous basket into registered basket
Replies: 3
Views: 3156

Re: R11 how to merge anonymous basket into registered basket

Yes something like that. This copy thing can also be tried in front end codes before calling migrate. Just copy over the basket items to new user's basket before calling migrate.
by mazhar
Mon Mar 14, 2016 12:37 am
Forum: AbleCommerce GOLD
Topic: R11 how to merge anonymous basket into registered basket
Replies: 3
Views: 3156

Re: R11 how to merge anonymous basket into registered basket

You should try to extend BasketService and override its Transfer method. There you can ensure to copy over the basket items instead of deleting target items.
by mazhar
Mon Mar 14, 2016 12:17 am
Forum: AbleCommerce GOLD
Topic: Treeview for gold?
Replies: 24
Views: 21624

Re: Treeview for gold?

Do you notice any errors in Administration -> Help -> Error Log page while you play with control on product page? Does it happen for all products or products under a certain category?
by mazhar
Thu Mar 10, 2016 3:55 am
Forum: AbleCommerce GOLD
Topic: Gold R10 Sales By Product report timeout
Replies: 15
Views: 16307

Re: Gold R10 Sales By Product report timeout

The new updated version in R11 still will not load without timing out. How much data you have ? In our tests the improvements made significant difference over huge data set of 20K orders. We also removed the default binding allowing merchant to choose the desired time span first before automaticall...
by mazhar
Wed Mar 09, 2016 1:07 am
Forum: AbleCommerce GOLD
Topic: R11 unusual Page Async Postback in error log
Replies: 3
Views: 3494

Re: R11 unusual Page Async Postback in error log

Is it still happening? Error details doesn't seem much helpful. I wonder if there are more details in App_Data/logs/app.log file.
by mazhar
Wed Mar 09, 2016 1:02 am
Forum: AbleCommerce GOLD
Topic: Subscription start date
Replies: 4
Views: 3863

Re: Subscription start date

For this you will have to use a JOIN query. Subscription is created against an order item which belong to an order. Following query will get you all subscriptions with related order date SELECT S.SubscriptionId, O.OrderDate FROM ac_Subscriptions AS S INNER JOIN ac_OrderItems AS OI ON S.OrderItemId =...
by mazhar
Wed Mar 09, 2016 12:55 am
Forum: AbleCommerce GOLD
Topic: Reports showing wrong date on orders.
Replies: 2
Views: 2779

Re: Reports showing wrong date on orders.

Go to Administration > Configure > Store > General and see what is configured for store's Time Zone Offset. In database we keep it without offset (UTC) format so if you want reports to be same as database then choose UTC as time zone offset.
by mazhar
Wed Mar 09, 2016 12:51 am
Forum: AbleCommerce GOLD
Topic: Change One Page Checkout to not default delivery address
Replies: 3
Views: 3457

Re: Change One Page Checkout to not default delivery address

Edit Website/Checkout/OPC.aspx.cs file and locate following code. UseBillingAsShippingAddress.Checked = (shipment.Address.Id == _user.PrimaryAddress.Id); and update it like UseBillingAsShippingAddress.Checked = false; //(shipment.Address.Id == _user.PrimaryAddress.Id); Save the changes and try again...
by mazhar
Wed Mar 02, 2016 5:56 am
Forum: AbleCommerce GOLD
Topic: Subscription start date
Replies: 4
Views: 3863

Re: Subscription start date

How about using Order Date of subscription?
by mazhar
Tue Mar 01, 2016 8:21 am
Forum: AbleCommerce GOLD
Topic: Horizontal Category Menu
Replies: 2
Views: 2727

Re: Horizontal Category Menu

It seems like you are looking for this viewtopic.php?f=65&t=18421

Demo of both horizontal and slide menu can be seen here http://www.goinginstyle.com/
by mazhar
Tue Feb 23, 2016 9:24 am
Forum: AbleCommerce GOLD
Topic: Integrating Google Search API to AC Gold
Replies: 4
Views: 4161

Re: Integrating Google Search API to AC Gold

What website URL you used in Google Account? ntwonline.com or debug.ntwonline.com ? It seems like debug.ntwonline.com is not indexed by Google so that may be the reason its not able to find any results. If this is the case then try using ntwonline.com in Google account while configuring your Google ...
by mazhar
Tue Feb 23, 2016 4:25 am
Forum: AbleCommerce GOLD
Topic: Connecting ac_OrderItems and ac_Categories via SQL query
Replies: 2
Views: 2927

Re: Connecting ac_OrderItems and ac_Categories via SQL query

As Jay suggested you can use ac_CatalogNodes table to find the categories. Following simple query will get you the categories a product belongs too. DECLARE @productId int = 33 SELECT CategoryId,Name FROM ac_Categories WHERE CategoryId IN ( SELECT CategoryId FROM ac_CatalogNodes WHERE CatalogNodeId ...
by mazhar
Tue Feb 23, 2016 3:27 am
Forum: AbleCommerce GOLD
Topic: R10 issue with adding to cart after adding from More Items
Replies: 4
Views: 3803

Re: R10 issue with adding to cart after adding from More Items

This seems to be happening due back button, browser cache and how ASP.NET handles post backs in javascript. It seems like it happened to other people too as being discussed here http://weblog.west-wind.com/posts/2007/May/22/doPostBack-and-the-Back-Button The simplest fix in our case should be to cle...
by mazhar
Mon Feb 22, 2016 4:16 am
Forum: AbleCommerce GOLD
Topic: What happens when you reboot your EMAIL server?
Replies: 6
Views: 4755

Re: What happens when you reboot your EMAIL server?

JYI in Gold we implemented event handler is replaceable service. This means one can provide custom handling for ablecommerce events. For example you can create a some suitable data structure to create a queue of messages as events are triggered and data is passed. A separate service may process the ...
by mazhar
Mon Feb 22, 2016 4:11 am
Forum: AbleCommerce GOLD
Topic: How to change SQL timeout for nHibernate?
Replies: 3
Views: 3152

Re: How to change SQL timeout for nHibernate?

try adding timeout property with suitable value in App_Data/nhibernate.config file. <property name="command_timeout">120</property> Not sure if you enabled intelisense support for nhibernate mappings and configurations. If you have intelisense enabled it will show you all possible property names. I ...