export sales by agent

[Gareth Wanklin]

I am looking at being able to export to excel via a sql query my moto sales with details of who took the order.

Has anyone been able to achieve this or know whether it is possible?

[Mike Hughes]

It shouldn't be too difficult as long as the agent info is stored with the order.

If you're familiar with excel then you should be able to do it using the excel database query tool / wizard.

Mike

[Gareth Wanklin]

Thanks Mike.

That was what i was hoping to do but is very reliant on whether that data is linked in the tables.

Would be interested to hear if anyone has been able to achieve this.

[miketait]

Here's some SQL that lists Offline (MOTO) orders, user name & date/time (MM/DD/YYYY date format !)

SELECT Order.[Order Number], OrderHistory.sUserName, OrderHistory.sDate
FROM ([Order] INNER JOIN OrderHistory ON Order.[Order Sequence Number] = OrderHistory.nOrderID) INNER JOIN SetupInfo ON Order.[Order Number] LIKE SetupInfo.sData & "*"
WHERE (((SetupInfo.sName)="Offline Order Number Prefix") AND OrderHistory.sAction = "Order Created");


Hope that's some help
Mike

[Jan]

Hi Gareth,

If you decide not to go the SQL route, you can use our order processing tools to do this. They are fully configurable, so you can define any export format you like. Either of these would do it :

Multichannel Order Processing :
http://www.1stoporders.co.uk/

Sellerdeck Order Processing :
http://www.mole-end.biz/acatalog/Mul...r-Actinic.html

You would need to have the Agent information available in the order details.

Regards,