Catfish Reports

Catfish Reports

We currently offer a nightly feed that contains four standard reports.  These four reports are compressed and password protected in to a ZIP file called 'CATFISH-DAILY-REPORTS.7z'.  By request we can configure our background tasks to copy the report ZIP file to an FTP location of your choosing on a nightly basis. A few points to note:

  1. This ZIP file contains four reports, as follows: Catfish-CustomerReport.csv', 'Catfish-ProductReport.csv', 'Catfish-SalesReport_OrderLineDetail.csv' and 'Catfish-SalesReport_OrderSummary.csv' (columns detailed below).
  2. The reports are cumulative, that is they contain all data historically.

Reports Format

The four included reports Catfish-CustomerReport.csv', 'Catfish-ProductReport.csv', 'Catfish-SalesReport_OrderLineDetail.csv' and 'Catfish-SalesReport_OrderSummary.csv' are provided as CSV (Comma Separated Values) files which can be easily opened with any text editor, financial package or Microsoft Excel. The columns within each report are as follows:

SalesReport_OrderSummary

[StoreFrontName]
,[CustomerId]
,[OrderId]
,[PONumber]
,[NumberOfOrderLines]
,[ShippingMethod]
,[OrderTotal]
,[PrepayUsedValue]
,[OrderSubtotalInclTax]
,[OrderSubTotalDiscountInclTax]
,[OrderShippingInclTax]
,[CreatedOnUtc]
,[PrepayId]
,[BillingAddressFirstName]
,[BillingAddressLastName]
,[BillingAddressCompany]
,[BillingAddressLine1]
,[BillingAddressLine2]
,[BillingAddressCity]
,[BillingAddressCounty]
,[BillingAddressCountry]
,[BillingAddressPostCode]
,[ShippingAddressFirstName]
,[ShippingAddressLastName]
,[ShippingAddressCompany]
,[ShippingAddressLine1]
,[ShippingAddressLine2]
,[ShippingAddressCity]
,[ShippingAddressCounty]
,[ShippingAddressCountry]
,[ShippingAddressPostCode]

SalesReport_OrderLineDetail
[StoreFrontName]
,[CustomerId]
,[OrderId]
,[OrderLineId]
,[Sku]
,[Name]
,[ShortDescription]
,[OrderStatus]
,[OrderLineStatus]
,[ShippingMethod]
,[PaymentStatus]
,[UnitPriceInclTax]
,[PriceInclTax]
,[DiscountId]
,[DiscountName]
,[DiscountAmount]
,[OrderCreatedDate]
,[DispatchBy]

,[RecordCount]

,[PageCount]

CustomerReport
[StoreFrontName]
,[CustomerId]
,[FirstName]
,[LastName]
,[Email]
,[Gender]
,[DateOfBirth]
,[AddressFirstName]
,[AddressLastName]
,[AddressCompany]
,[AddressLine1]
,[AddressLine2]
,[AddressCity]
,[AddressCounty]
,[AddressCountry]
,[AddressPostCode]
,[DateOfRegistration]
,[LastLoggedInDate]

ProductReport
[StoreFrontName]
,[Id]
,[Name]
,[ShortDescription]

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk