Can you make one order on 1 row.
So when there are 20 orders i have 20 rows.
Hi,no.Wouterjan wrote:Can you make one order on 1 row.
So when there are 20 orders i have 20 rows.
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.
Do you mean that in the backoffice, you can see the product model and quantity in a row,not in the export excel?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?
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.
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?
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.
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
What is the exact procedure for inserting a new field in the mysql. I am using PHPmyAdmin.
Thank you
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
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.
I think i figured it out.
I ran
as a query.
I ran
Code: Select all
ALTER TABLE `oc_order_status` ADD `comment` text COLLATE utf8_bin NOT NULLYep,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.
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
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
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
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.
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
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.
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!!
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
Then,olstar,
What is your good ideal to sort this out in excel format?
Bingo
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.
scanreg wrote:This happens in the 2.1 demo tooolstar wrote:A lot of my orders appear like 3 or 4 times in a row though...
Click the Order ID filter to show all the "1" order IDs
Please read this.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
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.
Order Manager had been updated to v1.3 & v2.2(01/12/2011)
Fix Print Invoice and list view.
Bingo
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.
Who is online
Users browsing this forum: No registered users and 75 guests
