HomeHome Product Discus... Product Discus...SmithCartSmithCartManage CustomersManage Customers
Previous
 
Next
New Post
2/12/2011 8:25 PM
 

DNN 5.6.1
Cart 3.8.0

How do you remove customers under "Manage Customers"? Had testers create profiles and now need to purge this list for a clean start.

 
New Post
2/12/2011 8:56 PM
 

This feature is currently not supported, but I will add it to our feature request list, if you would like to sponsor this enhancement email sales@smith-consulting.com.

Thanks,

Christian

 
New Post
2/12/2011 9:25 PM
 

Sorry, I will not sponsor this. It is my opinion that this should be done voluntarily by you, the developer. I hope you will add this soon. One would think that this feature should obviously be part of the shopping cart. Am I making a mistake with this cart?

 
New Post
2/13/2011 8:28 PM
 

On the manage orders screen there is a delete button where you can delete the order, which essentially deletes the customer because a customer is never created in the cart without a corosponding order, but if you want to clear out your entire customer table, you can do one of the following SQL statments:

delete * from Smith_Customer


or


truncate table Smith_Customer



Thanks,

Christian

 
New Post
2/15/2011 5:49 AM
 

I will say that the "Manage Customers" screen is, pretty much, useless.

You can't actually edit anything, hitting "Select" next to a customer just takes you to the list of orders.

Just my opinion.

 
New Post
2/16/2011 9:24 PM
 

I agree with "gbaughma".

However, the "Truncate SQL Statement" worked.

Thank you.

 
New Post
2/17/2011 8:49 AM
 

All the customer information is editable on the manage order detail screen. The manage customer screen lists all the customers and allows sorting and filtering to locate and drill into an order. Customers are only added to the database when an order is created so a customer record always corresponds to an order and there is a delete button on the manage orders screen. Adding a delete button on the customer screen would allow deleting only custmer records would orphan orders and payment history records. As you pointed out there are situations where you need to clear out your test data before you go live and as Christian pointed out you can always issue a truncate or delete sql command to clear your table. We will look into adding a delete button on the customer screen in addition to the delete button that already exists on the manage orders screen but we need to do more analysis to make sure it makes sense and that referential integrity in the database is maintained.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
12/5/2011 9:06 AM
 

The one thing that SmithCart seems to lack is just that... validation.   There should be no reason that there would be orphaned records.  The answer is to add validation and not allow a user to delete a customer that has order details.  

The way you programmed this we will always have orphaned records when your remove the customers order details ... the customers. 

 
New Post
12/5/2011 3:13 PM
 

Craig,
You are correct, adding a delete button on the manage customer screen is doable if the proper validation is written. If you delete a customer with no orders associated with it then allow delete customer. If however there are say 10 orders associated with a particular customer and you delete the customer logically all 10 orders should be deleted as well this is the reason it wasnt added to prevent unintended orders from being deleted accidentally. If we added a delete customer button and there are 10 orders associated with the customer would you want the delete button to delete all 10 orders as well or only allow deleting a customer if no orders are associated?
 


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
12/7/2011 1:46 PM
 

Hi Scott,

I would throw a popup alert telling the user something like this:

"This customer cannot be deleted becuase the customer has existing orders.  To delete the customer delete the orders first."

 

If the customer can be deleted I would popup something like this:

"Are you sure you want to delete customer 'xyz'?"

 

Craig

 

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartManage CustomersManage Customers