Skip to main content

In short

Drop your buy sheet on Your buy sheet, then click Match costs. A buy sheet is the file where you wrote down what you paid. SourceDock fills in the cost of each product. Nothing is saved yet. Your file waits until you press Import on the last step. Say your sheet says you bought 20 blenders on May 1 at $8.00 each, and Amazon received 20 on May 12. May 12 is 11 days after May 1, so the row fills that box. Each unit costs $8.00, and the screen says “Every product has a buy cost”. No sheet? Click I don’t have a buy sheet. Your products come in with no cost. In Purchases they show as Cost needed, and you can add the cost later. Watch it: Your first day.

More details

The title says what SourceDock found, like “SourceDock found 120 products in 35 shipments”. A list shows each product with Shipments and Received.Match costs stays off until you add a file. If SourceDock can’t find the columns it needs, it shows them so you can pick. Skip for now leaves setup, and Back returns to the import step.
A box is one Amazon shipment of one product.
  1. Rows go oldest first. A row with a date and a number of units fills the earliest boxes Amazon received on that day or up to 60 days later, until its units run out.
  2. A dated row with no number of units prices one whole box that step 1 didn’t reach, the one closest in date.
  3. Units still empty take the units step 1 didn’t use, oldest row first, even past 60 days.
  4. Units still empty after that get the product’s average cost across all its rows. A row with no date, or no number of units, only feeds this average.
If you change your files after Match costs, it says Your files changed. Press Match costs to match them again.
The screen says how it went, like “48 of 64 products got a buy cost” and “16 products have no buy cost”. When the missing months are clear, a line names them, like “Upload sheets for Jul–Aug 2025 to cover them.”To add more sheets, click Back, drop them in, and click Match costs again. Or click Review.
SourceDock can ask about a year your sheets miss, like “Do you have a buy sheet from 2025?” with “Upload your 2025 buy sheet”. A card shows for two or more empty months with products to price, or one month with 5 or more.Only an uploaded sheet clears a card. The cards never stop you from moving on.
SourceDock takes .csv and .xlsx files.
  • Up to 20 files. Extra ones are left out.
  • This file has more than 100,000 rows. Split it into smaller files and upload each one.
  • This file is bigger than 10 MB. Delete the columns you do not need, save the file, and try again.
  • These files are bigger than 10 MB all together. Remove a file, or delete the columns you do not need and save the file again.
  • Too many uploads in one minute. Please wait a minute, then try again.
Excel can turn long numbers into short ones like 8.41E+11. The page tells you when it finds these. It says Excel changed your UPCs into numbers like 8.41E+11. Set that column to Text and export again.Order numbers can get shortened the same way. SourceDock leaves those out, and the costs still come in.
Amazon only keeps shipment records for 18 months. Older products aren’t imported. You can add them by hand to track them.If your list is cut short, it says You have a lot of products. SourceDock can only show part of them here, so Import is off. Wait a moment and open this page again.