Post by Wouterjan » Sun Oct 16, 2011 7:24 pm

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

1.5.0


Active Member

Posts

Joined
Sat Jun 04, 2011 9:46 pm

Post by bingo » Sun Oct 16, 2011 9: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.
Last edited by bingo on Sun Oct 16, 2011 10:05 pm, edited 1 time in total.

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by Wouterjan » Sun Oct 16, 2011 9: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?

1.5.0


Active Member

Posts

Joined
Sat Jun 04, 2011 9:46 pm

Post by bingo » Sun Oct 16, 2011 10: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.

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by rukhairy » Mon Oct 31, 2011 2:24 pm

Hi,

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

Newbie

Posts

Joined
Tue Jun 07, 2011 1:21 am

Post by bingo » Mon Oct 31, 2011 4:35 pm

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?

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by phonepartsusa » Wed Nov 02, 2011 4:52 am

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

New member

Posts

Joined
Thu Jul 28, 2011 9:42 am

Post by bingo » Wed Nov 02, 2011 12:03 pm

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

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by phonepartsusa » Wed Nov 02, 2011 12:43 pm

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.

New member

Posts

Joined
Thu Jul 28, 2011 9:42 am

Post by bingo » Wed Nov 02, 2011 9:05 pm

Yep,phonepartsusa,that's cool.

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by olstar » Wed Nov 09, 2011 12:44 am

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

Professional UK Based eCommerce - Our Free Opencart Mods - Our Premium Opencart Mods
Kashflow Integration


User avatar
New member

Posts

Joined
Tue Jul 05, 2011 3:53 pm


Post by bingo » Wed Nov 09, 2011 12:58 am

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

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


User avatar
New member

Posts

Joined
Tue Jul 05, 2011 3:53 pm


Post by Wouterjan » Tue Nov 15, 2011 12:35 am

Olstar is it fixt?

i got the same!

1.5.0


Active Member

Posts

Joined
Sat Jun 04, 2011 9:46 pm

Post by bingo » Tue Nov 15, 2011 12:43 am

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

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by olstar » Tue Nov 29, 2011 12:04 am

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

Professional UK Based eCommerce - Our Free Opencart Mods - Our Premium Opencart Mods
Kashflow Integration


User avatar
New member

Posts

Joined
Tue Jul 05, 2011 3:53 pm


Post by bingo » Tue Nov 29, 2011 12:26 am

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

Bingo

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by scanreg » Tue Nov 29, 2011 12:42 am

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

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by bingo » Tue Nov 29, 2011 12:53 am

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.

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by bingo » Thu Dec 01, 2011 9:28 pm

Order Manager had been updated to v1.3 & v2.2(01/12/2011)
Fix Print Invoice and list view.

Bingo

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am

Who is online

Users browsing this forum: tiendung4 and 6 guests