Page 2 of 4

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Sun Oct 16, 2011 7:24 pm
by Wouterjan
Can you make one order on 1 row.
So when there are 20 orders i have 20 rows.

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Sun Oct 16, 2011 9:24 pm
by bingo
Wouterjan wrote:Can you make one order on 1 row.
So when there are 20 orders i have 20 rows.
Hi,no.
The export rule: Base on product model.
One product model one row.
If base on order,then product model and product quanlity will be hard to find or see.

For example.a buyer buy a 30,b 20,
there will be two ways to export:
One:
... product model,product quantity ...
... a,b ,30,20

Two:
... product model/product quantity ...
... a/30,b/20

You understand?
None of them is good to find what you have sold in export orders.

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Sun Oct 16, 2011 9:59 pm
by Wouterjan
I understand.
But for my administration i just need easy overview of all the orders, and order totals. And not nesseserie wish products they orderd. Is that possible to make?

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Sun Oct 16, 2011 10:05 pm
by bingo
Wouterjan wrote:I understand.
But for my administration i just need easy overview of all the orders, and order totals. And not nesseserie wish products they orderd. Is that possible to make?
Do you mean that in the backoffice, you can see the product model and quantity in a row,not in the export excel?
If so,then it can.
But in the export excel file,it can not.

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Mon Oct 31, 2011 2:24 pm
by rukhairy
Hi,

Set defaut order status's comment doesn't work for me, any idea why?

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Mon Oct 31, 2011 4:35 pm
by bingo
hi,rukhairy,
did you modify mysql table "order_status",Add one more field named "comment"to table order_stutas.
Please recheck you had completed the steps to install the order manager.
PS.which version of opencart you used?
Any error code appear when set default order status's comment?

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Wed Nov 02, 2011 4:52 am
by phonepartsusa
I purcahsed the item, but am stock at the MYSQL stage

What is the exact procedure for inserting a new field in the mysql. I am using PHPmyAdmin.


Thank you

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Wed Nov 02, 2011 12:03 pm
by bingo
Hi,phonepartsusa,
read the installation guide,I had worte the example.
If you still don't know how to modify,please tell me the PHPmyAdmin website and username and password.
I will do it for you.

You can send me personal message.
When I modify mysql,you can reset your username or password.

Bingo

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Wed Nov 02, 2011 12:43 pm
by phonepartsusa
I think i figured it out.

I ran

Code: Select all

ALTER TABLE `oc_order_status` ADD `comment` text COLLATE utf8_bin NOT NULL
as a query.

Re: [RELEASED] Order Manager - Bulk update orders

Posted: Wed Nov 02, 2011 9:05 pm
by bingo
Yep,phonepartsusa,that's cool.

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Wed Nov 09, 2011 12:44 am
by olstar
Dude, awesome mod!

A lot of my orders appear like 3 or 4 times in a row though...

Any thoughts?

Latest version of OC and your mod

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Wed Nov 09, 2011 12:58 am
by bingo
Hi,olstar,
please send the the excel and let me see.
I did not get you mean that "3 or 4 times in a row though"

My email:
yuyamu@hotmail.com

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Wed Nov 09, 2011 5:21 pm
by olstar
Sent!

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 15, 2011 12:35 am
by Wouterjan
Olstar is it fixt?

i got the same!

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 15, 2011 12:43 am
by bingo
It is not the problem.
The order share the same information like order id,invoice id,shipping information,billing information and others.
While the product parts,like product name,product model,product quantity,they are different.
It is the best way to export into the excel.
Coz excel is column * row format.
The product parts need to be in each row,the same column.

Bingo

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 29, 2011 12:04 am
by olstar
I appreciate that, but i think for this mod to be used more you HAVE to sort this out!

Not fixed no guys... something to do with 1 row per product...

Not ideal though is it!! :(

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 29, 2011 12:26 am
by bingo
Then,olstar,
What is your good ideal to sort this out in excel format?

Bingo

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 29, 2011 12:42 am
by scanreg
olstar wrote:A lot of my orders appear like 3 or 4 times in a row though...
This happens in the 2.1 demo too

Click the Order ID filter to show all the "1" order IDs

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Tue Nov 29, 2011 12:53 am
by bingo
scanreg wrote:
olstar wrote:A lot of my orders appear like 3 or 4 times in a row though...
This happens in the 2.1 demo too

Click the Order ID filter to show all the "1" order IDs
bingo wrote:It is not the problem.
The order share the same information like order id,invoice id,shipping information,billing information and others.
While the product parts,like product name,product model,product quantity,they are different.
It is the best way to export into the excel.
Coz excel is column * row format.
The product parts need to be in each row,the same column.

Bingo
Please read this.
But we can change the look of order manager,will release in next version.

Re: [RELEASED] Order Manager - Bulk update export orders

Posted: Thu Dec 01, 2011 9:28 pm
by bingo
Order Manager had been updated to v1.3 & v2.2(01/12/2011)
Fix Print Invoice and list view.

Bingo