Community Forums

by **Wouterjan** » Sun Oct 16, 2011 11:24 am

Can you make one order on 1 row.
So when there are 20 orders i have 20 rows.

by **bingo** » Sun Oct 16, 2011 1:24 pm

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.

by **Wouterjan** » Sun Oct 16, 2011 1:59 pm

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?

by **bingo** » Sun Oct 16, 2011 2:05 pm

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.

by **rukhairy** » Mon Oct 31, 2011 6:24 am

Hi,

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

by **bingo** » Mon Oct 31, 2011 8:35 am

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?

by **phonepartsusa** » Tue Nov 01, 2011 8:52 pm

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

by **bingo** » Wed Nov 02, 2011 4:03 am

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

by **phonepartsusa** » Wed Nov 02, 2011 4:43 am

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.

by **bingo** » Wed Nov 02, 2011 1:05 pm

Yep,phonepartsusa,that's cool.

by **olstar** » Tue Nov 08, 2011 4:44 pm

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

by **bingo** » Tue Nov 08, 2011 4:58 pm

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

by **olstar** » Wed Nov 09, 2011 9:21 am

Sent!

by **Wouterjan** » Mon Nov 14, 2011 4:35 pm

Olstar is it fixt?

i got the same!

by **bingo** » Mon Nov 14, 2011 4:43 pm

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

by **olstar** » Mon Nov 28, 2011 4:04 pm

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!!

by **bingo** » Mon Nov 28, 2011 4:26 pm

Then,olstar,
What is your good ideal to sort this out in excel format?

Bingo

by **scanreg** » Mon Nov 28, 2011 4:42 pm

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

by **bingo** » Mon Nov 28, 2011 4:53 pm

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.