Data Export Service

Understanding the File Structure

The file is a single text document containing multiple, distinct sections. Each line belongs to a section, identified by its first character. Certain sections are summaries, while others provide corresponding detail, creating a hierarchical relationship.

Data Export File (SPOT_...TXT)
↓
Primary Data Sections

[ V ]   [ C ]   [ I ]   [ S ]   [ N ]   [ R ]   [ X ]

            ↓         ↓

            [ D ]        [ Q ]

Detail Sections

• Section Identifier: The first character of every line (V, C, I, etc.) tells you what kind of data the line contains.

• Header Row: The first data line within each section is a header row, identified by |00| as its second field. This row defines the columns for all subsequent data lines in that section.

• Delimiter: By default, fields are separated by a pipe (|). This can be configured to use commas instead.

V|00|Company|Store|VisitDate|DropoffVisits|DropoffPieces|DropoffOrders|PickupVisits|PickupPieces|PickupOrders|PromisedOrders|LateOrders
V|01|MyDryCleaner|0001|6/2/2025|2|3|3|1|3|3|15|0
C|00|Name|Company|Store|ID|Address1|Address2|City|State|Zip|Phone1|Phone2|Route|Stop|Status|SignupDate|FirstVisitDate|LastVisitDate|LastModifiedDate|EmailAddress|DisableMarketing|RewardsProgram|RewardsPoints|RewardsLevel|BirthDate|AccountNumber|ClientGUID|StoreGUID|BillingGroup|SignupOrigin|CCExpires|CCType|CCLast4|ReferralSource|ReferralDetail|SMSRouteReminders|CustomerType|APILastActivityDateTime|APILastActivityVersion|MarketingSource|FBStatus
C|01|Holme, Janet|MyDryCleaner|0001|DC7444||||||8807338764||||Enabled|6/2/2025 9:47:00 AM|||6/2/2025|poqenli@orpkhdgkakmjfinrvrfio.website|0||0|||DC7444|{1CCA4F09-FF0D-4B3D-AE79-E0A3AA96B025}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}|Standard|CC||||||Null|Individual|6/2/2025 10:04:00 AM|APIv1|Taco Bell|
C|01|Reward, 3|MyDryCleaner|0001|DC7445|||Draper|UT|84020|8015555555||||Enabled|6/2/2025|6/2/2025|6/2/2025|6/2/2025||0|Reward3|4.65000000000001||||{8A125943-48C9-4344-88D3-02761D491DCC}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}||S||||||Null|Individual|||Facebook|A
C|01|Jackson, Test|MyDryCleaner|0001|DC7446|1201 Richardson Dr||Richardson|TX|75080|2148642378||Hotel|18|Enabled|6/2/2025 3:24:59 PM|||6/2/2025|testjgrlsd@sdgfjil.com|0||0|||DC7446|{7E2110B1-D6E3-4898-B38E-EBF7FEBD6FBF}|{E333AE59-E486-4A1A-90C6-FDD6F22EEB85}|Standard|CC||||||True|Individual|6/2/2025 2:15:00 PM|APIv1||
I|00|Invoice|CustomerID|Company|Store|DepartmentGroup|CurrentStatus|Route|KioskPickup|ModifiedDate|PriceDelta|BasePriceDelta|UpchargeTotalDelta|AlterationTotalDelta|VoidTotalDelta|CouponTotalDelta|AdjustmentTotalDelta|DiscountTotalDelta|SubtotalDelta|EnviroTotalDelta|TaxTotalDelta|PieceCountDelta|WriteoffTotalDelta|Price|BasePrice|UpchargeTotal|AlterationTotal|VoidTotal|CouponTotal|AdjustmentTotal|DiscountTotal|Subtotal|EnviroTotal|TaxTotal|PieceCount|WriteoffTotal|DropoffDate|ReadyDate|PickupDate|VoidDate|WriteoffDate|PNPDate|PriceModifiedDate|PaidDate|PaidCash|PaidCheck|PaidCreditCard|PaidCashCredit|PaidAccount|PaidOther|TotalPaid|PiecesSold|OrdersSold|TaxPaid|EnviroPaid|CardType|DetailClerk|HotelName|DetailStore|AssembledStore|BagScan|SubscriptionCouponTotal|SubscriptionCouponTotalDelta|PickupClerk|LockerNumber|GlobalLockerNumber
I|01|06-000001|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:47:19 AM|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:47:00 AM||6/2/2025 11:48:00 AM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000001|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:47:48 AM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:47:00 AM||6/2/2025 11:48:00 AM|||||6/2/2025 11:47:48 AM|6.78|0.00|0.00|0.00|0.00|0.00|6.78|1|1|0.78|0.00||adm||0001||0|0.00|0.00|adm||
I|01|06-000002|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:48:31 AM|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:49:00 AM||6/2/2025 11:49:00 AM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000002|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:49:04 AM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|6.78|6.00|0.00|0.00|0.00|0.00|0.00|0.00|6.00|0.00|0.78|1|0.00|6/2/2025 11:49:00 AM||6/2/2025 11:49:00 AM|||||6/2/2025 11:49:04 AM|6.78|0.00|0.00|0.00|0.00|0.00|6.78|1|1|0.78|0.00||adm||0001||0|0.00|0.00|adm||
I|01|06-000003|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 11:50:47 AM|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|6/2/2025 11:51:00 AM||6/2/2025 1:31:00 PM||||||0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0|0.00|0.00||adm||0001||0|0.00|0.00|||
I|01|06-000003|DC7445|MyDryCleaner|0001|DryCleaning|Sold|Not Specified|0|6/2/2025 1:30:31 PM|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|0.00|5.65|6.00|0.00|0.00|0.00|-1.00|0.00|0.00|5.00|0.00|0.65|1|0.00|6/2/2025 11:51:00 AM||6/2/2025 1:31:00 PM|||||6/2/2025 1:30:31 PM|5.65|0.00|0.00|0.00|0.00|0.00|5.65|1|1|0.65|0.00||adm||0001||0|0.00|0.00|adm||
D|00|Invoice|InvoiceDate|Company|Store|ModifiedDate|Item#|HSL|Department|Category|Item|Quantity|PieceCount|Price|Brands
D|01|06-000001|6/2/2025|MyDryCleaner|0001|6/2/2025 11:47:47 AM|001||DryCleaning|Pants|Regular|1|1|6.00|
D|01|06-000002|6/2/2025|MyDryCleaner|0001|6/2/2025 11:49:00 AM|001||DryCleaning|Pants|Regular|1|1|6.00|
D|01|06-000003|6/2/2025|MyDryCleaner|0001|6/2/2025 1:30:28 PM|001||DryCleaning|Pants|Regular|1|1|6.00|
S|00|Company|Store|CouponDate|CouponCode|Description|Count|TotalValue
S|01|MyDryCleaner|0001|6/2/2025||$1 Off (1)|1|-1.00
Q|00|Company|Store|Invoice|InvoiceDate|CouponDate|CouponCode|Description|Value|Clerk
Q|01|MyDryCleaner|0001|06-000003|6/2/2025|6/2/2025||$1 Off (1)|-1.00|adm
N|00|Company|Store|InventoryDate|BeginningBalance|IncomingTotal|OutgoingTotal|WriteoffPNPTotal|EndingBalance
N|01|MyDryCleaner|0001|6/2/2025|719,546.72|17.00|17.00|0.00|719,546.72
N|01|MyDryCleaner|0002|6/2/2025|250.27|0.00|0.00|0.00|250.27
N|01|MyDryCleaner|0003|6/2/2025|349.91|0.00|0.00|0.00|349.91
N|01|MyDryCleaner|0004|6/2/2025|21.69|0.00|0.00|0.00|21.69
N|01|MyDryCleaner|0005|6/2/2025|37.59|0.00|0.00|0.00|37.59
N|01|MyDryCleaner|0006|6/2/2025|129.10|0.00|0.00|0.00|129.10
R|00|Company|Store|ReportingDate|OutgoingAR|CashCredits|InvoiceCredits|ManualCredits|ARPayments|CCAdjustments|PayinsPayouts|PendingCCPayments|UncollectedFunds|Cash|Checks|AMEX|VisaMCDiscover|OtherCC
R|01|MyDryCleaner|0001|6/2/2025|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|19.21|0.00|0.00|0.00|0.00
X|00|Company|Store|ReportingDate|MTDGrossTotal
X|01|MyDryCleaner|0001|06/02/2025|18.00

Section Breakdown

The following is a breakdown of each section and its purpose.

V - Visit Totals

A high-level summary of daily customer visit activity.

Headers:

VisitDate, DropoffVisits, DropoffPieces,PieckupVisits, PickupPieces

Example:

V|01|MyDryCleaner|0001|6/2/2025|2|3|3|1|3|3|15|0

On June 2, 2025, at store 01 of MyDryCleaner there were 2 drop-off visits resulting in 3 pieces dropped off across 3 new orders. There was also 1 pickup visit accounting for a total of 3 pieces picked up across 3 existing orders.

C - Customer Records

Contains details for customers added/modified that day, or for any customer with invoice activity in the file.

Headers:

Name, Company, Store, ID, Address1, City, State, Zip, Phone1, LastVisitDate, LastModifiedDate, EmailAddress, RewardsProgram, RewardsPoints, ClientGUID, etc.

Example:

C|01|Reward, 3|MyDryCleaner|0001|DC7445|...|LastVisitDate|6/2/2025|...

This line is for customer 'Reward, 3' (Customer ID: DC7445). This customer’s record is included because they have invoice activity in this export (see invoices starting with 06- below). Their LastVisitDate is Jun 2, 2025 confirming they had activity today.

I - Invoice Summary & D - Invoice Detail

These two sections work together. I shows events happening to an invoice (like creation and payment), while D shows the items on that invoice.

Headers:

Invoice, CustomerID, ModifiedDate, PriceDelta, TotalPaid

Example for invoice 06-000001:

// EVENT 1: INVOICE CREATION
I|01|06-000001|...|ModifiedDate|...11:47:19 AM|PriceDelta|6.78|...|TotalPaid|0.00|...

// EVENT 2: INVOICE PAYMENT
I|01|06-000001|...|ModifiedDate|...11:47:48 AM|PriceDelta|0.00|...|TotalPaid|6.78|...

// DETAIL: THE ITEM ON THE INVOICE
D|01|06-000001|...|Item|Regular|...|Price|6.00|

What this means:

1. At 11:47:19 AM, Invoice 06-00001 was created.

2. At 11:47:48 AM, the invoice was paid.

3. The D section shows what was on the invoice: one ‘Regular’ ‘Pants’ with a base price of $6.00, the additional $0.78 from the I record represents taxes or fees.

S - Specials (Coupons) & Q - Coupon Detail

Similar to invoices, S provides a daily summary of coupons, and Q provides the specific details of their use.

Headers:

CouponCode, Description, Count, TotalValue

// SUMMARY: A $1 a coupon was used today
S|01|MyDryCleaner|0001|...|Description|$1 Off (1)|Count|1|TotalValue|-1.00

// DETAIL: It was used on this specific invoice
Q|01|MyDryCleaner|0001|Invoice|06-000003|...|Description|$1 Off (1)|Value|-1.00|...

The S Record shows that for the entire day, a coupon described as $1 Off was used 1 time for a total value of 1.00.

The Q record links this usage to a specific transaction, showing the coupon was applied to invoice 06-000003

N - Inventory

This section is a financial reconciliation of inventory value for the day.

Headers:

InventoryDate, BeginningBalance, IncomingTotal, OutgoingTotal, EndingBalance

Example:

N|01|MyDryCleaner|0001|6/2/2025|719,546.72|17.00|17.00|0.00|719,546.72

For store 01 on 6/2/2025, the BeginningBalance was $719,546.72 with an IncomingTotal of $17.00 that was added today, and an OutgoingTotal of 17.00 was removed (picked up by customers). The EndingBalance remained the same at $719,546.72

R - Register/Cash Drawer

This section is a summary of the day's financial activity by tender type.

Headers:

ReportingDate, PayinsPayouts, Cash, Checks, AMEX, VisaMCDiscover

R|01|MyDryCleaner|0001|6/2/2025|...|Cash|19.21|Checks|0.00|AMEX|0.00|...

For store 01, the register activity for the day 6/2/2025 included $19.21 in Cash Transactions. Other tender types like Checks and AMEX had zero activity.

X - Month-to-Date (MTD) Totals

A simple, informational snapshot of gross sales for the month so far.

Headers:

ReportingDate, MTDGrossTotal

X|01|MyDryCleaner|0001|06/02/2025|18.00

As of the end of the day on June 2, 2025, the MTD gross sales total for store 01 is $18.00

The X Section

The X section total is a highly reliable estimate but is not guaranteed to be 100% auditable against the sum of all daily invoice (I) records. It is intended for at-a-glance operational awareness, not for precise financial reconciliation.