Search found 42 matches

by ksolito
Tue Dec 29, 2009 10:20 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Error log loading up with shipping errors
Replies: 0
Views: 1618

Error log loading up with shipping errors

We are getting many Warn level errors showing up in the Error Log. "Error obtaining rate quote for shipping method 'USPS Priority Mail International'. Object reference not set to an instance of an object." Seem to occur for all shipping methods. Shipping is applied to some orders received by admin, ...
by ksolito
Mon Dec 21, 2009 1:01 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Custom report - question about Product, Inventory Tracking
Replies: 2
Views: 1926

Re: Custom report - question about Product, Inventory Tracking

Thanks Mazhar, Now another question related to the report. In this report, I need to show Product Name, SKU, Stock, and the Variant Name, SKU, and Stock. In the database the Variant Names values are all NULL and my attempt to include them using Products->Options->OptionChoices resulted in a complete...
by ksolito
Fri Dec 18, 2009 1:43 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Custom report - question about Product, Inventory Tracking
Replies: 2
Views: 1926

Custom report - question about Product, Inventory Tracking

I am writing a custom report and I need to filter on the Product Inventory Tracking state.

I assmue this is the InventoryModeId field in the Products table. Where can I find the definintions for the InventoryModeId values?
by ksolito
Thu Nov 12, 2009 12:01 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Possible hack attempt - advice to determine when it happened
Replies: 2
Views: 1812

Re: Possible hack attempt - advice to determine when it happened

Mazhar,

Thank you. I will bookmark this for future reference. I just go called by the store owner and it turns out is was operator error by his staff.

Your query is still a useful diagnostic.
by ksolito
Thu Nov 12, 2009 9:49 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Possible hack attempt - advice to determine when it happened
Replies: 2
Views: 1812

Possible hack attempt - advice to determine when it happened

Just got a call from the store owner. Two empty product categories were somehow added to the store. There's nothing unusual in the audit log except that one employee who is off today was recorded as having logged on early this AM. We haven't been able to determine if he added the categories or not. ...
by ksolito
Tue Nov 10, 2009 4:34 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Docs/tutorials for writing custom reports
Replies: 5
Views: 3089

Re: Docs/tutorials for writing custom reports

mazhar, I viewed the sample on wiki but I am still unclear on how to retreive and process the sql query return. I have something like this: CommerceBuilder.Data.Database database = Token.Instance.Database; string sql = ("<my really comprehensive inventory query that is tested and debugged in SQL Mgm...
by ksolito
Tue Nov 03, 2009 12:36 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: modifying Top Sellers to exclude some items
Replies: 0
Views: 1501

modifying Top Sellers to exclude some items

We need to exclude a specific product from the Top Sellers box, ConLib:PopularProductsDialog, and would also like to limit it to products sold with in the last 30 days. We have some products that are basically sold in bulk and skew the Top Sellers content. I assume the exclusion can be filtered in P...
by ksolito
Fri Oct 09, 2009 7:20 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Bulk Print not working after update to 7.0.3
Replies: 17
Views: 6642

Re: Bulk Print not working after update to 7.0.3

The bulk invoice printing is working for me on IE8 but not if using FF 3.5.3 and Chrome 3.0.195. They are not page breaking whether printing to an HP Laserjet or Acrobat PDF.
by ksolito
Thu Oct 08, 2009 6:52 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: error log "Error in user maintenance"
Replies: 18
Views: 26295

Re: error log "Error in user maintenance"

Logan, I ran your script from two posts above (Tue Sep 22, 2009 5:56 pm) and got the following error: Msg 156, Level 15, State 1, Line 11 Incorrect syntax near the keyword 'SET'. System is: PLATFORM: ASP.NET VERSION: 7.0.3 BUILD: 12458 MSSQL v2000 AC SCHEMA v2000 This problem has been remained unres...
by ksolito
Thu Sep 17, 2009 3:41 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Preferred tools/setup/etc for AC 7 .net development?
Replies: 3
Views: 2295

Preferred tools/setup/etc for AC 7 .net development?

I am going to be doing enough customization to my customers AC 7 web store to invest the time for a more efficient development suite. Currently I'm just coding using the text editor and FTP from Dreamweaver CS3 and I need a better tool set. While I've been away from it for about two years, I have lo...
by ksolito
Wed Aug 19, 2009 5:04 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: need to reference low stock level value in code
Replies: 5
Views: 2870

Re: need to reference low stock level value in code

Mazhar, That document doesn't work. It displays the index but clicking any idex item displays: The address is not valid Most likely causes: There might be a typing error in the address. If you clicked on a link, it may be out of date. What you can try: Retype the address. Go back to the previous pag...
by ksolito
Tue Aug 18, 2009 3:13 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: need to reference low stock level value in code
Replies: 5
Views: 2870

need to reference low stock level value in code

I took a guess that InStockWarningLevel was part of the InventoryManagerData class but apparently it's not. I'm not using Visual Studio so no IntelliSense available. I downloaded the class library doc metioned in this thread, http://forums.ablecommerce.com/viewtopic.php?f=45&t=7559&p=31738&hilit=cla...
by ksolito
Thu Aug 13, 2009 11:26 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: error log "Error in user maintenance"
Replies: 18
Views: 26295

Re: error log "Error in user maintenance"

Showing as SQL Server 8.0.2055 so SQL Server 2000.
by ksolito
Thu Aug 13, 2009 6:43 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: error log "Error in user maintenance"
Replies: 18
Views: 26295

Re: error log "Error in user maintenance"

v7.0.3, just upgraded from 7.0.2.
by ksolito
Wed Aug 12, 2009 12:29 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: error log "Error in user maintenance"
Replies: 18
Views: 26295

error log "Error in user maintenance"

We're getting about a dozen of these a day in the error log: Severity: Error Message: Error in user maintenance Debug Data: DELETE statement conflicted with COLUMN REFERENCE constraint 'ac_Users_ac_Orders_FK1'. The conflict occurred in database 'shoote1_abc01', table 'ac_Orders', column 'UserId'. Th...
by ksolito
Wed Aug 12, 2009 6:59 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Canceled order not restoring inventory count
Replies: 1
Views: 1438

Canceled order not restoring inventory count

V7.0.3 When an order is canceled, the inventory count for the items in the order is not restored. I tested by making an order for 2 items knowing the inventory count for each. I placed an order and changed status to Processing and the inventory counts were correctly decremented. When the order was c...
by ksolito
Wed Aug 12, 2009 6:43 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Bulk Print not working after update to 7.0.3
Replies: 17
Views: 6642

Re: Bulk Print not working after update to 7.0.3

The problem occurs using Internet Explorer 7.0.5730.13, Firefox 3.0.13, and Chrome 2.0.172.39 and from each, printing to a LaserJet P1006, Acrobate Pro 8.1.6, and Windows XPS Document Writer.
by ksolito
Tue Aug 11, 2009 9:15 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: simple search ignores keywork, returns all products
Replies: 2
Views: 1865

Re: simple search ignores keywork, returns all products

Found it. I added this: [[ConLib:CategorySearchSidebar Visible="false"]] since we don't want the CategorySeachSidebar.

Thanks.
by ksolito
Tue Aug 11, 2009 8:23 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: simple search ignores keywork, returns all products
Replies: 2
Views: 1865

simple search ignores keywork, returns all products

Problem existed in v7.0.2 and remains in 7.0.3. We display but the simple search entry field and button and a link to Advanced Search on the header bar. The advanced search works fine but the simple search returns all items in the store regardless of the value (if any at all) entered. I read some ot...
by ksolito
Tue Aug 11, 2009 5:35 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Bulk Print not working after update to 7.0.3
Replies: 17
Views: 6642

Re: Bulk Print not working after update to 7.0.3

I am working on chuckdvc's web store. He is correct that the bulk invoice function is not applying page breaks. His admin theme is unmodified AbleCommerce. I diffed both AbleCommerce and AbleCommerceAdmin templates, 7.0.2 and 7.0.3 and they are identical. I did reload both to the server but the prin...
by ksolito
Thu Aug 06, 2009 4:16 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Customer view previous order, CS0246, 'Smtpclient' not found
Replies: 1
Views: 1408

Customer view previous order, CS0246, 'Smtpclient' not found

If a customer logs in and tries to view previous orders from their account, the following error is displayed. [[ConLib:MyOrderPage]] h:\hshome\shooters\shootersconnectionstore.com\ConLib\MyOrderPage.ascx.cs(393): error CS0246: The type or namespace name 'SmtpClient' could not be found (are you missi...
by ksolito
Thu Aug 06, 2009 11:33 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Just upgraded from 7.0.2 to 7.0.3 - shows IP, not URL
Replies: 1
Views: 1488

Just upgraded from 7.0.2 to 7.0.3 - shows IP, not URL

I just completed (almost anyway) upgrading from 7.0.2 to 7.0.3 and applied all hotfixes to date. When viewing the store, my browser's address bar is showing the IP addess, not the website's domain name. What did I do wrong and what do I need to fix it? There's a security certificate error too, thoug...
by ksolito
Fri Jun 19, 2009 12:35 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: ALL instances: Ship to Residence/Business default Residence
Replies: 3
Views: 2392

ALL instances: Ship to Residence/Business default Residence

Store owner would like all instances where ship to type can be business or residence to default to residence. I found the places below and all were either already set to default to residence or were changed to do so. 1) During checkout on *//Checkout/Default.aspx, if the 'Ship to a different address...