Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
If I try and import an order that has a deleted product, I get the following error:
Erros: System.Collections.Specialized.StringConnection.
Is there any way around this? Unfortuantely I have a number of orders with deleted products and I dont' want to have to manually edit each order. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
|
|
|
|
|
|
|
Rank: Member
Joined: 9/19/2010(UTC)
Posts: 104
|
I'm new to BV, but if I had to choose between deleting a product, category, or anything that's been associated to other data, I would mark it as inactive instead. That way your historical reports remain intact. Obviously that's a little too late for you now though! |
Best regards, Shan Plourde www.pahsah.com+1 (416) 628-1280 -------------------------------- |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
The problem with BV is you mark it inactive, it can still be found in doing a search or found from a customer's past order or organic search links. So then to prevent people from having to order the item, you have to mark it as having inventory but out of stock and not available to backorder. So then the product clutters up your low inventory email. It's not a well-thought through process I'm afraid. |
|
|
|
|
|
|
Rank: Member
Joined: 9/19/2010(UTC)
Posts: 104
|
Making products inactive with my version of the cart, 5.74, seems to hide the product on the public portion of the site. It doesn't show up in category browsing, searching doesn't find it, and the product detail page errors out if I refresh it after making the product inactive. Maybe it was a bug that was fixed in the version that I'm using. |
Best regards, Shan Plourde www.pahsah.com+1 (416) 628-1280 -------------------------------- |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Have you tried a link from a customer's past order screen? Or an organic Google link to the product page? Yes, the store hides it from anyone looking for it, but if the links is available (in a customer's past order history or stored in google), then it can be found. |
|
|
|
|
|
|
Rank: Member
Joined: 9/19/2010(UTC)
Posts: 104
|
With BVC 5.74 I can't view the product detail page once the product is inactive. I think that it makes sense to allow a customer to continue to see a product in their past order history. Does it just show the product in their order history but not allow them to navigate to the details page? If so I think that's reasonable, versus removing it from their history, unless it is actually allowing them to add the item to their cart and buy it.
Re Google, there's not much you can do with cached Google pages, except request them to refresh their page cache faster I believe (Google Webmaster Tools I think). |
Best regards, Shan Plourde www.pahsah.com+1 (416) 628-1280 -------------------------------- |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Customers can add the item to a shopping cart -- once they do and try to checkout, they are told the item is no longer available because you have to set it track inventory and then set it so they can't backorder, hence it is added to and clutters the low stock email even though it is inactive. |
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
hey joe, does setting it to "Remove From Store" still include the product in the low stock report? |
|
|
|
|
|
|
Rank: Member
Joined: 9/20/2006(UTC)
Posts: 92
|
Joe, Why not just add some code to the product page that checks whether the product has been set to inactive and if so redirects the customer to another page? [code] Dim p As Catalog.Product = Catalog.InternalProduct.FindByBvin(id) If Not p.Status = Catalog.ProductStatus.Active Then 'do something or redirect somewhere Response.Redirect("some url") End If [color=gray> <HR] [/color] Wallace Miller -- Narrowpath Design
Providing installation, custom development, and design services for BVC5 sites 24/7 tech support and consultation service available for BVSoftware E-Commerce 760.728.8679 (phone) [email protected]
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Matt - yes it does -- still cluttered up email.
Thanks Wallace -- my issue is not with the store and directly customers to another page -- my issue is being able to import those orders into Quickbooks that contain deleted items. |
|
|
|
|
|
|
Rank: Member
Joined: 9/19/2010(UTC)
Posts: 104
|
do you have a full error stack trace? |
Best regards, Shan Plourde www.pahsah.com+1 (416) 628-1280 -------------------------------- |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I can view the QuickConnector error log |
|
|
|
|
|
|
Rank: Member
Joined: 9/19/2010(UTC)
Posts: 104
|
Any other details you're getting other than the error message "System.Collections.Specialized.StringConnection"? I.e. a more technical kind of stack trace, or something in the BV error audit logs? |
Best regards, Shan Plourde www.pahsah.com+1 (416) 628-1280 -------------------------------- |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
This is the error I get:
Exception!
Server was unable to process request. ---> There was an error generating the XML document. ---> Object reference not set to an instance of an object.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Connector.BVC5WebServices.WebServices3.Orders_Order_FindByBvin(AuthenticationToken& token, String bvin)
at Connector.ExportWorker.GetBVC5Order(String orderNumber)
at Connector.ExportWorker.StartExporting()
###################################################
Problem Orders:
51256
51200
51210
51214
51217
51218
51220
24
10/6/2010 10:41:29 AM - Errors in Last Export
Error: Error while saving order 51256 No valid userID was returned!
Error: Error while saving order 51200 No valid userID was returned!
Error: Error while saving order 51210 No valid userID was returned!
Error: Error while saving order 51214 No valid userID was returned!
Error: Error while saving order 51217 No valid userID was returned!
Error: Error while saving order 51218 No valid userID was returned!
Error: Error while saving order 51220 No valid userID was returned!
Error: Server was unable to process request. ---> There was an error generating the XML document. ---> Object reference not set to an instance of an object. |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.