You have forgot something Ross, some people like joking around.
So until now, I have fifteen test orders.
So when I am looking for a real order, it’s crappy !
But one thing that’s important is that delete orders should be manage carefully. I don’t know if Magento invoices are good enough to be electronic invoices here. (Argentina) where the number in the invoice should be exact as the number when you create the invoice in Magento.
If they work and people can print it, then I am good. If I need to sync them, I am a little screwed...until I find how to do it.
And you should be able to suspend the account for “irregularities” for X amount of days, sending the customer the comment.
---------------------
SORRY TO USE CAP HERE BUT YOU SHOULD READ THIS (MAGENTO CREW TOO)
I don’t know where is the members of Magento. I still love their piece of software so much...but really..you need to participate in the forum more. There are so many good features requested, so many comments. I know you are probably busy working on better features (backorders, gift certificate and downloadable content my priorities) but we need some answers.
I just hope the paid support is a little better…
(Don’t intend to start a war..just some people could answer. Even a “We are working in this thing, so we don’t have much time”...but at least show up!)
I don’t know where is the members of Magento. I still love their piece of software so much...but really..you need to participate in the forum more.
Name (total forum posts)
blizzard182 (17)
Moshe (1771)
RoyRubin (865)
Michael (621)
adimagento (539)
YoavKutner (474)
You see that the Varien team has a lot of participation on the forum!
Well, I am sorry, but I don’t see how comparing my number of posts has something to do with anything. I could have posted 17 extra modules for Magento and I would be more useful than anyone who has 2000 posts with nothing important to say.
Ok, so I am new here. I registered not long ago if you saw that too. Moving on…
What I am saying is that in the past few weeks that I was registered, I saw a couple of nice posts, important ones...and no answer for them.
Of course, this is free, I shouldn’t be complanning but guess what...I am. Because this is not any other feature. This one and a couple of other ones are LEGALLY important.
There is christmas approaching. There is going to be a lot of projects going around. And if I can do what I want with Magento, I will need to look around. That’s something I don’t want to do.
All I want (And if you look around there are a lot of people saying “where is the Magento people") is just a little heads up. You know, an announcement would be nice. Just to know what are they doing and so on.
These forums are not that much crowded, and at least the most accesed threads should be follow by the Magento crew.
Magento is unlikely to help for free when their entire business model revolves around paid support. In the beginning they were here a lot (to grow the community), but now the project has taken off. No need to provide free support anymore.
Magento is unlikely to help for free when their entire business model revolves around paid support. In the beginning they were here a lot (to grow the community), but now the project has taken off. No need to provide free support anymore.
These are basic functions that should be included with every store.
Like if an order has been completed by accident, there is no way to change the status as well?
And canceling an order would be fine with most folks if Magento didn’t include it in the stats or sales reports.
We really need this option as well. Sometimes we will have a customer call to cancel an order or change an order and we can’t go into the database every time this happens to make these changes.
We really need this option as well. Sometimes we will have a customer call to cancel an order or change an order and we can’t go into the database every time this happens to make these changes.
You should be able to cancel an order or make a refund (credit memo) at any time except the case when order has been already invoiced, shipped and refunded. Doesn’t it work for you ?
Magento is unlikely to help for free when their entire business model revolves around paid support. In the beginning they were here a lot (to grow the community), but now the project has taken off. No need to provide free support anymore.
True. But I am not asking for free support. I am just asking how they think about it. If they start saying. ..
“Ok, we now don’t do anymore things for free”. Fair enough, let’s bring the paid support (It’s a business after all)
We really need this option as well. Sometimes we will have a customer call to cancel an order or change an order and we can’t go into the database every time this happens to make these changes.
You should be able to cancel an order or make a refund (credit memo) at any time except the case when order has been already invoiced, shipped and refunded. Doesn’t it work for you ?
Thanks for your reply Michael, and I am shocked that a team member has finally replied to this issue . But the problem still remains, and it is a very serious problem. We have “live” test orders that need to be fully and completely deleted, along with PayPal transactions that went bad and other orders that didn’t fully complete due to one problem or the other. We have a separate “mirror” installation that we use for testing, and we fully understand the need for this and have no problem with it (except that it means double the work every time we make a change or upgrade). But we still found a need to perform live tests, the client requires it and in our case the bank requires it. Every other ecommerce application that I work with provides the basic means to delete an order. We and obviously many many others need this feature (look how many pages are in this thread) and in my opinion, the inability to delete orders shouldn’t be built into Magento’s business rules.
With Magento not dealing with this problem, again in my opinion people are going to [have to] do whatever means necessary to delete orders, and that could mean comprimising their data integrity.
Please can you provide us with an update on the issue? Is it on the roadmap, will it be considered, is it out of the question, do we need someone to provide this as an extension instead ...
Like I said before, deleting orders might be a legal problem. Sometimes you are asked to store every order you basically had. That’s why I think is even better to have three separated databases.
1) For archived orders
2) For test orders, orders that went bad, joke orders, etc.
3) The actual database in use for the system.
That will keep the main database clean.
I don’t mind a simple button to ‘archive order’ and ‘move order to test database’ but it will become a problem since I don’t think MySQL is designed to handle large databases.
Also, the ability to use either SQL Express or DB2 would be awesome (Both have free versions) I work with IBM products so, DB2 would be my choice.
I just used the SQL code mention in this thread and it worked ok for me.
Aftet running the SQL I notice that tables sales_order_tax, sales_flat_quote_payment and sales_flat_quote_shipping_rate have some records left that seams related to the test orders I had before.
Is it safe to truncate these tables as well?
Also “Reports / Shopping Cart / Product in Cart” shows a few hundred results although I see no records listed. Strange…
I looked again to the tables and it seams this number is equal to the number of records in the following tables: cataloginventory_stock_item, catalog_product_entity and catalog_product_website.
. But the problem still remains, and it is a very serious problem. We have “live” test orders that need to be fully and completely deleted, along with PayPal transactions that went bad and other orders that didn’t fully complete due to one problem or the other. We have a separate “mirror” installation that we use for testing, and we fully understand the need for this and have no problem with it (except that it means double the work every time we make a change or upgrade). But we still found a need to perform live tests, the client requires it and in our case the bank requires it. Every other ecommerce application that I work with provides the basic means to delete an order. We and obviously many many others need this feature (look how many pages are in this thread) and in my opinion, the inability to delete orders shouldn’t be built into Magento’s business rules.
Sales: Call 877.832.5289 (N America)|310.295.4144 (International)
