Simply link BeProfit to your Google Sheets account, and then your COGS will be updated and calculated automatically.
Connect your Google Sheet with BeProfit
Go to Settings ➡️ Costs ➡️ Product Costs.
Scroll down to the Product Costs table, click on the Sync with Google Sheets button on the right.
When a message pops up, click on Connect with Google.
When you get the permission message, click Allow.
If it’s the correct account, click Link Sheet. You can also use our empty template if needed.
Match the columns on your sheet which contain the SKU and COGS values, click Done.
You’re all set now, click Close.
Errors will be listed if there is a sync issue. Once you've corrected all errors in Google Sheets, click Resync.
BeProfit now syncs automatically with COGS added to your sheet! Happy calculating 😉
Frequently asked questions
Will Google Sheets update my COGS and orders retroactively?
Will Google Sheets update my COGS and orders retroactively?
The first time the Google sheet is connected to the Products Costs page it will update past and future orders. Any future change will only update future orders.
Can I enter the COGS value in a different currency?
Can I enter the COGS value in a different currency?
No, COGS amounts must be in the same currency as your shop with no currency, only numbers.
What do I need to do if I added new products to my shop?
What do I need to do if I added new products to my shop?
If you add new products to your shop, you will need to update the Google Sheet manually and add the product and its COGS.
How do I create a template with my current COGS and product cost?
How do I create a template with my current COGS and product cost?
Click on the Bulk Update button on the right.
Click on Download Now. A file with all your products and variants and their costs will be downloaded.
Copy or import the downloaded file into Google Sheets to create a template.
Why aren't the COGS I've entered in my Google Sheet being reflected in the order?
Why aren't the COGS I've entered in my Google Sheet being reflected in the order?
The COGS hierarchy could explain why you can't see COGS after adding them. Please check your hierarchy level according to the following list of descending hierarchy levels.
Bulk Update from the Orders page.
Manual edit on the Orders page.
COGS integration.
COGS profiles:
COGS profile with specific products selected.
COGS profile with all products selected.
Google Sheet sync.
Product Cost page manual update.