APCO Oil — Sync Dashboard

📊 Last Sync Summary

Invoices Inserted

—

CC Records

—

Skipped / Errors

—

Last Run

Never

Run Sync

Sync Data — Invoices + credit cards.
Sync Prices — Rack prices and optional email/SMS notifications.

SYNC DATE

Send email/SMS price notifications with Sync Prices

📄 Upload Invoice CSV

Upload a CSV file to sync invoices into tblinvoice, tblinvoiceline, and tblinvoicelinedetails.

Marathon Invoice Sync

📂

Drop CSV here or click to browse

DATE

Sunoco Invoice Sync

📂

Drop CSV here or click to browse

DATE

ℹ️ Expected CSV Columns


          InvoiceNumber, InvoiceDate, InvoiceTotal, CustomerNumber, ShipTo, BL,

          Terminal, Shipper, TaxPrepaid, GCode, GasSpecification, PercentDiscount,

          DraftDay, GLabel, AmtPerItem, Quantity, PricePerGallon, FedTax, FedPerItem,

          StateTax, StateDiscount, CollectionAllowance, ProtectionFee, StateTaxTotal, StateTaxQty, Eth,

          UnitPrice_LineDet1 … UnitPrice_LineDet8 (optional)

💳 Upload Credit Card CSV

Syncs into tblcreditcard. Duplicate records (same company + payDate + batch) are replaced automatically.

MarathonCC Sync

📂

Drop CSV here

PAY DATE

SunocoCC Sync

📂

Drop CSV here

PAY DATE

ClarkCC Sync

📂

Drop CSV here

PAY DATE

ℹ️ Expected CSV Columns


          CustomerNumber, Batch, Amount, Net, Date, PayDate

⛽ Upload Price CSV

Syncs into tblraq. Products: REG/E, ULSD, ULT3/E. Enable email to notify customers via spGetCustomerPrices.

MarathonPrice Sync

📂

Drop CSV here

DATE

NOTIFY EMAIL

SunocoPrice Sync

📂

Drop CSV here

DATE

NOTIFY EMAIL

ℹ️ Expected CSV Columns


          raqProduct (REG/E | ULSD | ULT3/E), raqPrice, raqBranded (0 or 1)

📋 Sync Logs

Loading logs...