Hi there,
I had made a single test purchase (purchasing just one item), when i open "export orders" i get five lines of order entry each with different prices, the price of the order (free shipping) was £10 however the other four lines (which contain identical info apart from price) had shown the folling prices:
line 2 £7.60
line 3 12.60
line 4 194.50
line 5 10.00
i have attached a screen shot which shows replication of this error through multiple purchases
In the export orders screen, did you choose the Hierarchical format or the flat format?
(The top one is hierarchical and the bottom one is a flat format)
Christian
Hi Christian
Our backoffice are unable to use the hierarchical format as it does not comply with their work ethic. We had the flat format built so that an order is placed on a single line which also contained the client details. I have attached a flat format which i exported. As an example, if you look at the first line you will notice that even though a single item was purchased; the file shows the order item multiple times with different order total (also the quantity and cost are the wrong way round i.e. quantity row is referencing price and cost row is referencing quantity(in this insatnce the first order at the top was an item costing £10 and zero shipping cost)).
Programming is looking into this now, thanks for reporting it!
Thanks,
The export orders issue has been fixed and will be available in the next cart release 4.22. Thanks
could you please advise when cart release 4.22 will be available?
4.22 will be released on March 15th, or if you need it sooner, it was just the fix was just stored procedure so just run the following stored procedure from SQL managemetn studio:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[dnn_Smith_SA_ListExportOrders]
@PortalId int
AS
select distinct o.orderid,o.orderdate,o.status,convert(varchar,o.taxtotal) as taxtotal,o.shipmethod,o.shipdate,o.trackingnumber,
convert(varchar,o.shippingtotal) as shippingtotal,convert(varchar,o.handlingcharge) as handlingcharge,
convert(varchar,o.discount) as discount, o.affiliateid,o.specialinstructions,
c.customerid,c.firstname,c.lastname,c.email,c.Address1,c.address2,c.City,c.state,c.country,
c.zip,c.homephone,c.workphone,c.companyname,
min(od.productid) as productid, min(od.productsku) as productsku, min(od.ProductName) as productname,
ph.billingaddress,ph.billingzip,ph.acctno,ph.exproute,convert(varchar,ph.amount) as amount,ph.transid,
ph.payhistid,ph.authcode,ph.notes,ph.status as paystatus,ph.billingname,ph.billingcity,ph.billingstate,ph.billingcountry
from dnn_smith_storeorders o
inner join dnn_smith_customer c on
o.customerid = c.customerid
left outer join dnn_smith_storeorderdetails od on
o.orderid = od.orderid
inner join dnn_smith_payhist ph on
o.payhistid = ph.payhistid
where o.portalid = @PortalId
group by c.customerid,c.firstname,c.lastname,c.email,c.Address1,c.address2,c.City,c.state,c.country,
c.zip,c.homephone,c.workphone,c.companyname,o.orderid,o.orderdate,o.status,o.taxtotal,o.shipmethod,o.shipdate,o.trackingnumber,o.specialinstructions,
o.shippingtotal,o.handlingcharge,o.discount,o.affiliateid,ph.billingaddress,ph.billingzip,ph.acctno,ph.exproute,ph.amount,ph.transid,
ph.payhistid,ph.authcode,ph.notes,ph.status,ph.billingname,ph.billingcity,ph.billingstate,ph.billingcountry
order by o.orderid desc
Make sure that if your using an object quilifier you change it before running this stored procedure!