What's your name? We'll personalise your dashboard so it feels like home.
🎯
Set your yearly investment target below
Track how your spending compares to your goal for the year.
£0
Spent 2026
→
£0
Target
£0
Remaining
0%
Complete
£0 spent£0 target
Set yearly target:2026
Showing:
Total Invested
£0.00
0 products
🏭 Warehouse (e.g. Prep Centre / Home)
0
£0
🚚 Shipped to Amazon (e.g. products shipped out from you)
0
£0
⏳ Awaiting Stock (e.g. purchased stock not delivered yet)
0
£0
⚠️
Stock needs attention
Recent Products
Date
Image
ASIN
Product
Units
Buy
Sell
Invested
Est. Profit
ROI
Status
Units by Location
Stock across pipeline
Capital by Location
£ invested at each stage
Monthly Spend vs Target
How your purchasing tracks across the year
📊
Google Sheets Sync
Paste your public Google Sheet link to auto-import products. Make sure sharing is set to Anyone with the link → Viewer.
Date
Image
ASIN
Product
Units
Buy/unit
Sell
FBA Fee
Invested
Profit
ROI
Location
Days
⚠️ Alert
Supplier
Actions
📖
Setup Guide
Everything you need to get your MyBuyTool up and running
1
Open your sourcing tool on Desktop & Go to Sheets Setup
Open your sourcing tool on your desktop browser. On the main page, look for the Sheets option in the menu and click Setup to begin connecting your Google Sheet.
💡 Tip: Make sure you are logged into your sourcing tool before starting. The Sheets option is in the top navigation bar.
2
Connect Your Google Account & Create a New Sheet
If your Google account is not already connected, click Connect Google Account and follow the login steps. Once connected, press New Sheet to create a fresh Google Sheet that your sourcing tool will export your data into.
💡 Tip: Use the same Google account you want the sheet saved to. You only need to connect it once — your sourcing tool will remember it.
3
Rename Your Sheet & Set Field Mappings
On the left side, rename your sheet to something meaningful like "My Buy Sheet" — this name will appear inside your sourcing tool every time you open an ASIN, so make it easy to recognise.
On the right side, set your Field Mappings exactly as shown in the picture below. This tells your sourcing tool which data to export into which column of your Google Sheet — getting this right means the CRM will pull all the correct information when you sync.
💡 Tip: The field mappings must match exactly as shown — if a column is missing or named differently, the CRM sync may not pick up the data correctly.
✅ Important: Once you have set the field mappings, scroll to the bottom of the page and press "Test Write Header" — this creates the sheet and adds all the column headers. You must do this before the sheet will work!
4
Scroll to the Top & Go to My Account → Settings
Once you have finished setting up your sheet, scroll back to the top of the page. Click on My Account in the top navigation and then select Settings from the dropdown menu.
💡 Tip: Settings is where you configure how your sourcing tool behaves when you analyse products — this is where you link everything together.
5
Enable Google Sheets & Pin It to the Top
In Settings, scroll until you find Google Sheets and toggle it to enabled.
Then find the icon on the left side and drag it to the top of the list — this pins your Buy Sheet so it always appears at the top of your sourcing tool every time you open an ASIN, making it quick and easy to log products without scrolling.
💡 Tip: Dragging it to the top saves you time — you won't have to scroll down to find your sheet every time you want to log a product.
6
Log a Purchase with One Click
As shown in the picture, as soon as you open any product page in your sourcing tool, your Buy Sheet will now appear at the top of your sourcing tool — ready to use instantly.
To log a purchase, simply click the button and it will export the product data straight into your Google Sheet automatically.
❓ FAQ — How to Log a Purchase Correctly
1
Enter your COG (Cost of Goods)
Before logging, make sure you have entered your Cost of Goods (COG) — this is the price you are paying per unit from your supplier. it uses this to calculate your profit and ROI.
2
Enter the Quantity
Scroll down in your tool to where it says Quantity and input the total number of units you are buying for this purchase order.
3
Click the Export Button
Once COG and Quantity are filled in, click the export button on your Buy Sheet at the top of your sourcing tool. The product will be added as a new row in your Google Sheet instantly.
⚠️ Remember: You must enter both the COG and Quantity before pressing the export button — otherwise the data in your sheet (and CRM) will be incomplete or incorrect.
7
Go Back to Sheets Settings & Open Your Google Sheet
Go back to Sheets → Settings in your sourcing tool. You will see your sheet listed — press the Open button next to it. This will open your Google Sheet in the browser so you can make it publicly accessible for the CRM sync.
8
Share Your Sheet — Set to Anyone with the Link
Inside your Google Sheet, click the Share button in the top right corner.
You will see it says Restricted by default — click on it and change it to "Anyone with the link". Make sure the permission is set to Viewer. Then press Copy link.
⚠️ Important: This step is required for the CRM to be able to read your sheet. Without it, the sync will fail. Your sheet data is still safe — it is read-only for anyone with the link.
9
Paste the Link into the CRM & Press Sync
Head over to the Inventory tab in this MyBuyTool. You will see the Google Sheets Sync bar at the top — paste your copied link into the field and press 🔄 Sync Now. Your products will be imported instantly!
✅ Done! Once synced, all your your sourcing tool purchases will appear in the inventory table below.
10
Manage Everything in the CRM — Not Google Sheets
Your Google Sheet is just the data source — all your day-to-day management happens here in the MyBuyTool.
Need to change a product's location? Move it from Awaiting Stock → Warehouse → Shipped to Amazon? Edit units? Add notes? Do all of that directly in the Inventory tab using the dropdowns and Edit button on each row.
Your changes will be preserved even when you sync again from Google Sheets.
💡 Remember: Google Sheets = where purchases are logged via your sourcing tool. MyBuyTool = where you manage, track and analyse everything.
✅
You're All Set! Sync to Your CRM
Every time you log a purchase in your sourcing tool it will appear in your Google Sheet. Come back to this CRM, go to the Inventory tab, paste your Google Sheet link and press 🔄 Sync Now — or use the 🔄 Sync Google Sheet button on the Dashboard for a quick update anytime.
🚀 Pro tip: Bookmark this CRM page and sync it at the start of each day to keep your purchasing data up to date!