In short
Your buy sheet is the spreadsheet where you kept what you bought and what you paid. SourceDock reads it and fills in your costs. Say your sheet has a row: 6 blenders, $30 each, bought March 3. SourceDock finds the blender, and gives $30 to the shipments Amazon got from March 3 to May 2. To add costs any time, go to Import from Amazon and click Upload buy sheets. Or on Purchases, click Cost needed, then Add costs from your file. Watch it: Your first day.More details
How SourceDock reads your buy sheet
How SourceDock reads your buy sheet
- SourceDock finds the product by its ASIN, then SKU, then UPC, then its name.
- SourceDock never stops to ask about your rows. If it can’t find a cost column, or an ASIN, SKU, or UPC column, it asks you to pick them.
- A row with a date fills the shipments Amazon got on or after that day, within 60 days. For the blender row, that’s shipments from March 3 to May 2.
- A sheet with no dates is read without them, so those products show as missing a cost.
- If a row has a unit cost and a total that don’t match, SourceDock uses the total.
- A pack row it can’t be sure about gets the average cost of that product’s other rows.
- A row with no price, like a blank cost cell, prices nothing. If that product still needs a cost on Purchases, its row says “Your buy sheet lists this product without a cost.” under Add cost. Add the price to your sheet and upload it again, or type the cost.
- If your sheets miss a whole year, it asks, like Do you have a buy sheet from 2025? Upload one, or click I don’t have one.
Add costs later
Add costs later
Products still missing a cost? Upload more buy sheets any time. On Import from Amazon, click Upload buy sheets. Or on Purchases, click Cost needed, then Add costs from your file.The upload has four steps: Upload, Match, Review, and Done. Match is SourceDock reading your sheets after you click Match files, so it has no step of its own below.Click Cancel to leave at any step. Nothing from an upload you didn’t finish is kept.
1
Upload
Drop your sheets on Drop your buy sheets here. A line says which months your sheets don’t cover yet, like “Months your sheets don’t cover yet: Nov – Dec 2024”. Click Match files.
2
Review
It lists the products that still have no buy cost, with their units and months. Under that is every purchase this import gives a cost. Each row has the product’s picture, name and ASIN, its units, the buy cost found, a green check with Has a buy cost now, and where the cost came from. The lists scroll inside the step, and the button stays in its own bar under them. If your sheet has orders Amazon doesn’t know about yet, it says so, like “Import will also add 2 purchases you ordered from your sheet.” Click the button, like “Import 368 costs”. Nothing is saved before you click it.
3
Done
It says how many costs were saved, like “368 costs saved”, and which months are still missing. If some products are in Amazon shipments you haven’t imported yet, click Show shipments. View purchases is at the bottom right. Upload more sheets sits beside it only while a purchase still has no buy cost.