Sales columns match Shopify Analytics; label cost is attributed to the day the order was placed.
ShipStation shipping costs
Label costs sync from ShipStation every morning and are matched to Shopify orders by order ID. To fill a gap by hand, export shipments from ShipStation as CSV and drop the file here. CSV rows match by order number, and labels already saved won't double count.
Orders
Shopify · product sales · Pacific time
Product sales
–
Loading product sales…
By category, vendor and model
Net sales = gross sales − discounts − returns. Margin is on sales with a product cost recorded. Last year is the same dates a year earlier.
Cost watch
Daily check of product costs, run each morning.
Cost changes
Every variant's cost is compared with the day before. Click Correction or Real change to override how a row is treated.
Warehouse · stock set aside to send to Amazon
Prep center
Loading the prep center…
Amazon Outgoing
prep center → FBA / AWD
On The List
to re-order → a draft or booking order
Incoming shipments
what's coming, by expected arrival — line up Amazon shipments ahead of it
Stock
Activity
acenrally.com · sales from Shopify, costed at Just Tennis cost
Ace n Rally
–
Loading Ace n Rally sales…
Products with no Just Tennis match
Their sales have no cost. Give them the same SKU (or barcode) as the Just Tennis product in Shopify; the next sync matches them.
Amazon FBA + AWD · units at Amazon, costed through your Shopify products
Amazon inventory
Loading FBA inventory…
Inventory at cost by vendor
Click a vendor to filter the list below.
By Amazon listing
Est. fees = referral fee % × price + FBA fee per unit, from each SKU's own sales in the last 180 days (or 15% and the typical FBA fee for its size when it hasn't sold). Profit = price − fees − cost. Storage fees aren't included.
Shopify + Amazon inventory at cost · edit Shopify product costs, biggest sellers first
Inventory value
Sales in
–
Loading products and sales…
Totals
Costs by product
Type a new unit cost and press Enter to move down. Saved costs are written to Shopify within about a minute.
Shopify · orders sold without a product cost
Shopify cost mapping
–
Loading orders…
Items without a cost
Type the cost of one unit. Enter moves to the next box. When you enter a cost, other empty rows with the same item fill in too.
Operations · what needs doing
Alerts
Loading alerts…
Amazon FBM · ships from Shopify stock
FBM orders → Shopify stock
Loading FBM orders…
Shipped — confirm each order
"Take out of Shopify" lowers Shopify's available stock by the units shown, about a minute later. "Don't take out" just records the decision.
FBM listings Shopify has in stock, by ASIN
"Send" sets the listing's quantity on Amazon to the number in the box (prefilled with what the FBM location's stock covers, or 0 when Amazon holds the ASIN at FBA or AWD). It shows on Amazon within a few minutes.Merchant-fulfilled listings mapped to a Shopify product with stock at the FBM location.
Amazon · fees & profit by posted date, Pacific time
Amazon sales & profit
–
Loading Amazon data…
Orders from Amazon
Loading…
By purchase date, Pacific time, straight from Amazon (US, Mexico, Canada), synced every hour. Mexico and Canada are converted to dollars. Cancelled orders and multi-channel orders aren't counted. Fees and profit below come from Amazon's payments (the same numbers as the Transaction report), every hour.
Daily product sales vs. profit
Product salesProfit after fees & product cost
Loading…
By day
Product cost only counts for mapped listings. Refunds don't credit product cost back.
Pick the Shopify vendor for each Amazon listing. Changing a vendor saves it. Confirm the guesses in bulk once a page looks right.
Approve a guess to save it as the listing's cost source (same as the Amazon mapping tab). Deny shows the next guess. Keys: A approve · D deny · N no match · ↓/↑ move. Guesses only use the listing's vendor from step 1.
Vendor orders · create the PO, then add its invoices
Purchase orders
Loading purchase orders…
Vendor invoices are uploaded on the Invoices tab; each one goes onto its PO here (by the PO # on it).
Vendor invoices · upload here, each goes onto its purchase order
Invoices
Loading invoices…
Drop an invoice PDF anywhere on this page. It's read, matched to the vendor's open PO with the same PO # (or you pick the PO), and opens here for checking, payment and QuickBooks. Receiving is done on the PO.