I just started using for my Amazon store. We are a fairly large seller and Sellerboard looks like a great tool and we will be using it going forward. From our limited use we saw some things that should maybe be addressed. 1. On the batch / date costs - please set the dates to be in the following format "Dec 2, 2022 to Dec 15, 2022" To avoid confusion and annoyance with US vs European date formats. That format makes it simple and easily visible. 2. Money formats for the US have the $ sign before the number. $22 not 22$. Europeans have it the latter. Thanks and I look forward to using sellerboard!
@@jimmaynard3 Hello there! We're happy to inform you that our team carefully reviews all suggestions from our valued users. We prioritize them and add them to our queue, with the possibility of re-prioritization. For instance, we have already fixed the display of dollars, but the second question in this inquiry was not immediately implemented as it may affect other functions. However, rest assured that it has been taken into consideration for future updates. If you have any further inquiries or concerns, please don't hesitate to email us at support@sellerboard.com or chat with us on our website. We are always eager to assist and will respond as quickly as possible. Thank you for being a part of our community and for sharing your suggestions with us. We truly appreciate it!
In my opinion it would be better, easier and more precise if you simply made a product folder where every new purchase order from the supplier add the price and quantity. For example, I buy a product for $ 10 and buy 5 items, and when I have sold 2, I decide to reorder and order 10 to $ 9. In this way the software knows that the first 5 products were purchased for $ 10 and the second 10 to $ 9. Then calculate the profit for the first 5 orders at a price and from 6 onwards the other. Because with the remaining dates and batches you cannot be precise with pending orders, returns, damages etc ...
@@dapperblue6165 Sellerise has an option to configure COGS by inbound shipment and it looks great but unfortunately they are NA only at the moment. Did you find any others? I am still hunting for a scaleable solution.
Sellerise, has this feature and I love it. You simply select an FBA shipment and update the cost of any item in that shipment in seconds. SellerBoard made this so complicated. However, Sellerise comes with drawbacks as well. 1) It does not have ROI information at all, which is important to me. 2) You need to enter an ending date for your expenses. There is no "forever" option. For instance, you pay a monthly fee for being an Amazon Seller and when you enter this monthly expense, you need to enter an ending date, which doesn't make sense as you will be paying for this forever as long as you are in this business.
Will a FIFO implementation be introduced anytime soon? I find this very inconvenient compared to Inventory Lab's FIFO's system. In Inventory Lab, each replenishment that is sent in has its own row created automatically once the shipment is created by the seller in Seller Central and you can enter the cost for each individual replenishment, suppliers name, date purchsed, Purchased Qty, and the remaining Qty in that replenishment. This saves a significant amount of time and makes the system more automated with minimal manual data entry. I previously used Inventory Lab and recently switched to sellerboard for the much more wide array of feature available, but this feature is making me question if I should switch back to Inventory Lab. I would love to hear an update on if this COGs by period/batch system will be improved. Thank you!
I signed up for trial, and test imported my costs today. This is such a versatile tool! Now if only it could do prep/label/ship functions similar to inventory lab
Unfortunately, this is not how accounting works. Although, you have found a workaround to get the right figure at the end (sort of). Stock cost attribution is done on the basis of FIFO and LIFO system of stock accounting. Either one needs to be used based on the Accounting Standards (GAAP or IFRS) the user needs to implement in the country he/she is residing. I need you guys to improve this aspect as this requires change. Hire an accounting consultant for this aspect of your software.
Thanks for this video. Good to know how this is supposed to be done. Agree with Albert though - my stock movement is way too dynamic for me to know what the previous batch total is. I was hoping sellerboard would be able to count my stock down and apply the correct CoG.
Actually we do calculate the stock left from the previous batch automatically. I'm showing it here (apprximately): th-cam.com/video/KYmqlN1AXWk/w-d-xo.html The example in the demo is not optimal, it shows 0. But if you do it with your product, sellerboard will automatically enter the remaining FBA stock from the previous batch into the field "Old batch"
Hi guys, this would work well for private label products, but there is no way we can know the exact date stock becomes available for sale at Amazon if we use FBA. We could package 350 items, all different SKUs, to be shipped to Amazon on a specific date, and it could take between 2 and 14 days for it to get to Amazon, and then another few days for them to make it available in our inventory, and potentially another 1-15 days for some of the stock if it is in transfer to another fulfilment centre or European location (we are UK based). So having to use the date field for the date the stock is available to sell is impossible. We have 1000+ skus that we are buying all the time at different prices from different suppliers. It would be far more practical to do as others have said, and be able to upload invoice/purchase order information to the system with price we paid for x number of items, and then have it use that information FIFO, like others have suggested, or even averaged the price using existing stock levels with the new batch on it's way. Your method would work for people with hardly any SKUs who deal with large sets of orders wholesale or private label. We do all three.
Hi. I understand your concern, however you must not enter the exact date, when the new batch is available on amazon. You can enter the date, when it arrived in your country for example. On this day, the old and the new batches will be "averaged" to the new mixed price. As long as the amounts of items in the old and in the new batch are roughly correct, you're fine, the profit calculations will be accurate. It's your decision, when to start to "merge" the new batch with the old one and start to apply the new average price. If you do it earlier, you'll have more items left from the old batch and thus the effect of the new batch's price on the average will be lower and vice versa. But in the end, you're just "moving" the purchasing price difference back and forth a little by this decision (which does not affect the total profit in the long term).
Any plans to automatically calculate and apply cost based on FIFO? Current solution requires manual tracking of when the inventory at old cost is sold out, or to calculate how many units is left when new period starts. I have hundreds of MSKUs and I don't see how I can realistically manage my cost with solution described in the video. This requires a lot of manual work while in fact it could be done by the software. Maybe I am missing something? Please advise. Thank you.
Hi! I understand your point. FIFO is already on our roadmap. When you're adding a new batch, sellerboard will automatically read the FBA stock and enter this number into the "old batch" field (if you check the checkmark "Account for the remaining stock from the previous batch"). You have to enter the batch on the product level atm. The start of new period should not necessarily be in synch with the date when the old batch is sold out. Does this work for you? Or do you need some sort of bulk processing for multiple products at once? This is coming soon
@@sellerboard, thanks for your reply. I tried entering cost with and without "Account for remainder of stock from previous batch" checked, but it used incorrect numbers both times. Also, your tool displays batch dates 2 days prior to what I actually entered, e.g. instead of my December 3rd, it shows December 1st. It does not really matter to me now since I can't use your tool without it properly calculating COG, but I still wanted to bring this to your attention. Please let me know once you implement the automatic calculation of COG based on FIFO AND (!) add support for bulk upload supporting multiple products with multiple entries (periods) for each product.
@@albertf.4552 Bulk upload will be available within 1 week, it's already implemented. You can also change the numbers when you set the option "Account for remainder from previous batch". By default, sellerboard uses the FBA stock, but the field is editable, you can change it if needed. Why does this method not work for you exactly? The COG's calculated the way we do are 100% accurate too, there's just a small time shift comparing to FIFO. Both methods are legitimate (both are taught in the business administration classes).
@@sellerboard, what numbers can I change? How many were in stock on the start of a new batch? I have almost a thousand SKUs and I do restocking weekly. Can you imagine how much time should be spent to monitor the quantity in stock manually?
@@albertf.4552 OK, I understand. That you can't do through a flat file. So, if we add a possibility to account for remainders from previous batches and a quantity column (new batch) and a date into the COGS import template, would that be a solution?
Well, do we need to type the previous batch again? As far as I know, SB already checks the inventory level from Amazon via MWS and automatically put the inventory in this field. Please confirm, thanks.
In this field we show the stock balance we received from Amazon and (kept by us) as of the date you entered for that batch. But both this balance and the quantity in the new batch you can change to adjust the result if necessary at your discretion.
Hi, thank you very much for this video. Im currently in your free trial and am learning a lot. I was wondering if you have future plans to integrate with Inventory Lab? So when retail arbitrage sellers process a new shipment through Inventory Lab, the cost of goods will automatically upload into seller board.
@@sellerboard so basically I need to enter in the old batch only stock I have in prep-center if I am using one, FBA stock is already automatically added?
@@matjazlampret6152 You don't need to put your prep balances in there, because they have not yet arrived at Amazon and should not be included in the cost calculation. There you can specify how much of the old batch should be included in the weighted average cost calculation, as well as how much of the new batch should be included. In this case, the calculation mechanism serves only to automatically calculate the cost price for the new batch, the actual amount of goods is not important here.
You can upload your COGs in bulk via the Import button on the products page. Just click on the button, download the template, fill it out and upload it back. Please note that you do not have to use the template file offered by sellerboard. You can use the file exported from Seller Central or other external service (even Google sheets) and upload it to sellerboard. After this, you will be able to match the necessary columns with the ones required by sellerboard. Please note that in order to import this information in sellerboard ASIN and SKU need to be presented in sellerboard before. Also, your Excel file should contain 1 sheet only.
Hey, we do not keep such records, this task is in our to-do list. The thing is that even Amazon doesn't have such data - an order for 2 units can include a unit from a recent batch and a unit from a batch that arrived a year ago. Therefore, under such conditions, only COGS accounting by order dates is possible (with a possibility to adjust it backwards if needed).
On the Products page, you can find the import button in the lower left corner. After clicking it, you will see a pop-up window where you can download a template. Please open it and insert the product cost in the "Cost" column for each SKU, and the start date of the new period in the CostPeriodStartDate field (so you have as many rows for each SKU as you have periods.), after doing so, save it and upload it back to sellerboard.
A FIFO association between sales and cost batches would have been the right way to do it. This weighted average method of calculating the costs is not precise. In any case, if the software has access to sellercentral, it should already know the unsold inventory from the last batch - why then does the user need to input that manually?
Just signed up for the free trial and finding it very difficult to figure out cost of goods for previous sales. I could follow this tutorial if I was starting from a clean slate but having to figure out cogs retroactively is really complicated. Any suggestions?
Hello there! Just wanted to let you know that our process is actually quite simple. Each order is calculated based on the cost price set in the settings for the order date. If you need to analyze a specific example, please don't hesitate to reach out to us through our support chat on the site or by emailing us at support@sellerboard.com. We're always happy to help!
You can enter warehouse costs for FBM products through expenses or include them in the production cost. you can change the shipping cost (as well as the production cost) of a specific FBM order by clicking on the shipping/cost figure for that order in the dashboard, or you can do it as a file via the Import button on the Products page, then downloading the template (COGS and Shipping by order), then filling in the data in it and uploading it back to the sellerboard. Also, please watch our video about it: th-cam.com/video/9ztSkg6zFzI/w-d-xo.html
I do RA and most of my products aren't replenishable. Today I bought the same item from 3 different suppliers with 3 different prices. I would like to use the Purchase Orders to keep tracking data about orders/costs/suppliers/shipping, but when I did that the product COG is the last closed order. My trial will end soon but the lack of FIFO on SB will prevent me to replace Inventory Lab 😭
But in P&L I couldn’t see the breakdown of the COGS. It is critical to know what are my manufacturing costs and shipping costs. Please please add this feature
you run into a problem when you send in 2 batches+ of same item with different pricing & quantity, how do you keep track what inventory of which batch is left
@@Chandler890 There really is no such accounting at the moment (but it's not available on Amazon either). However, we have this feature in our “To-Do” list right now. Now you can either use a weighted average price for both batches, or you can adjust the start date of the period based on actual unit sales, for example, assuming that all of batch 1 is sold first, then all of batch 2, (although in reality this is not the case), and then retroactively changing the date for batch 2 to the next day the last unit of batch 1 is sold.
It is confusing, I just started doing RA, prices change everyday for one product using coupons or using rewards, so i dont understand how i can track the prices for one product which has different prices
You can use the weighted average cost option by entering a new batch with a new date each time and selecting this option ( can be found in the video). The final goal is to set the cost price for each day, so that the system can calculate for a specific order the cost price based on the cost price set for a specific day and market. As an option, you can sum up all your costs and quantity of items, for example, for a month outside sellerboard, calculate the average cost price and specify it for 1 month, so that you don't have to enter every day.
if COGS is (product cost + shipping cost from factory to amazon warehouse), then what about the amazon fees (Estimated fee per unit sold). Please help and explain. Thank you
Hey! We receive all fees directly from Amazon as well as compensation and advertising costs and show the actual data in the profit calculation by order, product or account. The user only needs to enter the cost of goods and indirect costs (if any).
Hi, as per video, the amount from the previous batch should be indicated by the user, but we took the chance and improved that. So nowadays, when creating a new batch, the amount from the old batch will be populated automatically. No need to remember anything related to previous batch!
We have 600+ ASINs in 10+ markets. Is it possible to use the batch method but upload using a flat file? I tried to add in the different batch prices for a product in each market and then export it but only 2 fields are then populated. 1. Cost period start date 2. Cost
There is also 'market' in the last column of the file. Thus you need to specify the product - the date of the period - the price - the market. And there are such lines for one product - as many as you need, for each period and market.
At the moment you can connect only your eBay account to sellerboard - click on "eBay" button on the settings page and follow the instructions. For Shopify we can offer sellerboard.io - profit analytics for Shopify sellers.
What way is recommended for 'daily' upload via template of COG once recieved a batch in different price ( I have ~100 ASINs , so manual update is not an option ;) ) : Example of data: Batch date ASIN Pcs Price 16.11.2022 ASIN A 100 44,07 30.11.2022 ASIN A 500 32,52 16.12.2022 ASIN A 100 40 26.12.2022 ASIN A 200 40 22.02.2023 ASIN A 200 41,99 22.02.2023 ASIN A 100 46,99
Has someone noticed that Sellerboads "Net Profit" calculations are WRONG when you consider the VAT (sales tax for the UK). Sellerbaod method of calculation "Net Profit" is (Sales Price - Amazon Fee (Incl VAT) - COGs (Excl VAT) - VAT on Sale Price = Net Profit). This is ABSOLUTELY wrong. You can't deduct "Amazon Fee (Incl VAT) and then also deduct "Full VAT" on the sale price. I am very surprised that no one has noticed it yet and yet this software is being purchased by others. I raised a support case, but after I gave evidences, they have stopped responding now.
Hello, we completely agree with you, in this particular situation, it is only fair that Amazon fees are exempt from VAT. Our team of developers is currently looking into this matter, and we will make sure to keep you updated once it is resolved. Thank you for your understanding and for bringing this to our attention. We apologize for any inconvenience this may have caused. Your patience is greatly appreciated!
In the bottom left corner, there's an "Import" button. Click it please, you'll be able to download a spreadsheet template. In the template, there's a column for a batch/period start date in case you'd like sellerboard to create a new period when uploading
@@jawadsimine There's an "x" at the right side of each row in the table with expenses. Feel free to drop us a quick message into the support chat in the bottom right corner of the screen, we'll help!
I just started using for my Amazon store. We are a fairly large seller and Sellerboard looks like a great tool and we will be using it going forward. From our limited use we saw some things that should maybe be addressed.
1. On the batch / date costs - please set the dates to be in the following format "Dec 2, 2022 to Dec 15, 2022" To avoid confusion and annoyance with US vs European date formats. That format makes it simple and easily visible.
2. Money formats for the US have the $ sign before the number. $22 not 22$. Europeans have it the latter.
Thanks and I look forward to using sellerboard!
Thank you so much for the feedback and your suggestions - they are already passed to our product team :)
@@sellerboard That's the standard response I get as a Sellerboard member and what happens? Nothing.
@@jimmaynard3 Hello there! We're happy to inform you that our team carefully reviews all suggestions from our valued users. We prioritize them and add them to our queue, with the possibility of re-prioritization. For instance, we have already fixed the display of dollars, but the second question in this inquiry was not immediately implemented as it may affect other functions. However, rest assured that it has been taken into consideration for future updates.
If you have any further inquiries or concerns, please don't hesitate to email us at support@sellerboard.com or chat with us on our website. We are always eager to assist and will respond as quickly as possible.
Thank you for being a part of our community and for sharing your suggestions with us. We truly appreciate it!
In my opinion it would be better, easier and more precise if you simply made a product folder where every new purchase order from the supplier add the price and quantity. For example, I buy a product for $ 10 and buy 5 items, and when I have sold 2, I decide to reorder and order 10 to $ 9. In this way the software knows that the first 5 products were purchased for $ 10 and the second 10 to $ 9. Then calculate the profit for the first 5 orders at a price and from 6 onwards the other. Because with the remaining dates and batches you cannot be precise with pending orders, returns, damages etc ...
THIS
Couldn't agree more
THIS IS WHAT I WANT! Anyone know a software that has this? thats connected to my seller central? thank you so much n have a great day!
@@dapperblue6165 Sellerise has an option to configure COGS by inbound shipment and it looks great but unfortunately they are NA only at the moment. Did you find any others? I am still hunting for a scaleable solution.
Sellerise, has this feature and I love it. You simply select an FBA shipment and update the cost of any item in that shipment in seconds. SellerBoard made this so complicated.
However, Sellerise comes with drawbacks as well.
1) It does not have ROI information at all, which is important to me.
2) You need to enter an ending date for your expenses. There is no "forever" option. For instance, you pay a monthly fee for being an Amazon Seller and when you enter this monthly expense, you need to enter an ending date, which doesn't make sense as you will be paying for this forever as long as you are in this business.
Will a FIFO implementation be introduced anytime soon? I find this very inconvenient compared to Inventory Lab's FIFO's system. In Inventory Lab, each replenishment that is sent in has its own row created automatically once the shipment is created by the seller in Seller Central and you can enter the cost for each individual replenishment, suppliers name, date purchsed, Purchased Qty, and the remaining Qty in that replenishment.
This saves a significant amount of time and makes the system more automated with minimal manual data entry. I previously used Inventory Lab and recently switched to sellerboard for the much more wide array of feature available, but this feature is making me question if I should switch back to Inventory Lab. I would love to hear an update on if this COGs by period/batch system will be improved. Thank you!
Agree with this as a new user! The FIFO is key to accurate margins. Please let us know if this will be implemented anytime soon.
I signed up for trial, and test imported my costs today. This is such a versatile tool! Now if only it could do prep/label/ship functions similar to inventory lab
Unfortunately, this is not how accounting works. Although, you have found a workaround to get the right figure at the end (sort of). Stock cost attribution is done on the basis of FIFO and LIFO system of stock accounting. Either one needs to be used based on the Accounting Standards (GAAP or IFRS) the user needs to implement in the country he/she is residing. I need you guys to improve this aspect as this requires change. Hire an accounting consultant for this aspect of your software.
thats true
Thanks for this video. Good to know how this is supposed to be done. Agree with Albert though - my stock movement is way too dynamic for me to know what the previous batch total is. I was hoping sellerboard would be able to count my stock down and apply the correct CoG.
Actually we do calculate the stock left from the previous batch automatically. I'm showing it here (apprximately):
th-cam.com/video/KYmqlN1AXWk/w-d-xo.html
The example in the demo is not optimal, it shows 0. But if you do it with your product, sellerboard will automatically enter the remaining FBA stock from the previous batch into the field "Old batch"
Hi guys, this would work well for private label products, but there is no way we can know the exact date stock becomes available for sale at Amazon if we use FBA. We could package 350 items, all different SKUs, to be shipped to Amazon on a specific date, and it could take between 2 and 14 days for it to get to Amazon, and then another few days for them to make it available in our inventory, and potentially another 1-15 days for some of the stock if it is in transfer to another fulfilment centre or European location (we are UK based). So having to use the date field for the date the stock is available to sell is impossible. We have 1000+ skus that we are buying all the time at different prices from different suppliers. It would be far more practical to do as others have said, and be able to upload invoice/purchase order information to the system with price we paid for x number of items, and then have it use that information FIFO, like others have suggested, or even averaged the price using existing stock levels with the new batch on it's way. Your method would work for people with hardly any SKUs who deal with large sets of orders wholesale or private label. We do all three.
Hi. I understand your concern, however you must not enter the exact date, when the new batch is available on amazon. You can enter the date, when it arrived in your country for example. On this day, the old and the new batches will be "averaged" to the new mixed price. As long as the amounts of items in the old and in the new batch are roughly correct, you're fine, the profit calculations will be accurate. It's your decision, when to start to "merge" the new batch with the old one and start to apply the new average price. If you do it earlier, you'll have more items left from the old batch and thus the effect of the new batch's price on the average will be lower and vice versa. But in the end, you're just "moving" the purchasing price difference back and forth a little by this decision (which does not affect the total profit in the long term).
Any plans to automatically calculate and apply cost based on FIFO? Current solution requires manual tracking of when the inventory at old cost is sold out, or to calculate how many units is left when new period starts. I have hundreds of MSKUs and I don't see how I can realistically manage my cost with solution described in the video. This requires a lot of manual work while in fact it could be done by the software. Maybe I am missing something? Please advise. Thank you.
Hi! I understand your point. FIFO is already on our roadmap.
When you're adding a new batch, sellerboard will automatically read the FBA stock and enter this number into the "old batch" field (if you check the checkmark "Account for the remaining stock from the previous batch"). You have to enter the batch on the product level atm. The start of new period should not necessarily be in synch with the date when the old batch is sold out. Does this work for you? Or do you need some sort of bulk processing for multiple products at once? This is coming soon
@@sellerboard, thanks for your reply. I tried entering cost with and without "Account for remainder of stock from previous batch" checked, but it used incorrect numbers both times.
Also, your tool displays batch dates 2 days prior to what I actually entered, e.g. instead of my December 3rd, it shows December 1st. It does not really matter to me now since I can't use your tool without it properly calculating COG, but I still wanted to bring this to your attention.
Please let me know once you implement the automatic calculation of COG based on FIFO AND (!) add support for bulk upload supporting multiple products with multiple entries (periods) for each product.
@@albertf.4552
Bulk upload will be available within 1 week, it's already implemented.
You can also change the numbers when you set the option "Account for remainder from previous batch". By default, sellerboard uses the FBA stock, but the field is editable, you can change it if needed.
Why does this method not work for you exactly? The COG's calculated the way we do are 100% accurate too, there's just a small time shift comparing to FIFO. Both methods are legitimate (both are taught in the business administration classes).
@@sellerboard, what numbers can I change? How many were in stock on the start of a new batch? I have almost a thousand SKUs and I do restocking weekly. Can you imagine how much time should be spent to monitor the quantity in stock manually?
@@albertf.4552 OK, I understand. That you can't do through a flat file. So, if we add a possibility to account for remainders from previous batches and a quantity column (new batch) and a date into the COGS import template, would that be a solution?
Well, do we need to type the previous batch again? As far as I know, SB already checks the inventory level from Amazon via MWS and automatically put the inventory in this field. Please confirm, thanks.
In this field we show the stock balance we received from Amazon and (kept by us) as of the date you entered for that batch. But both this balance and the quantity in the new batch you can change to adjust the result if necessary at your discretion.
Is there anyway to automatically import COGS from Inventory Lab?
At the moment we don't have this feature. But you can import all the COGS from Excel.
Thanks for video. Just one question, Cost (net) column refers to Product Landing Cost (product cost + shipment cost)?
Correct
@@sellerboard do you enter shipment cost (shipping to fba) if it was an amazon partnered shipment?
Hi, thank you very much for this video. Im currently in your free trial and am learning a lot. I was wondering if you have future plans to integrate with Inventory Lab? So when retail arbitrage sellers process a new shipment through Inventory Lab, the cost of goods will automatically upload into seller board.
Is it planned to pulled the remaining „old“ stock value from the stock tab, so you don’t have to enter it manually?
The "old" batch stock is automatically pulled from amazon (FBA stock)
@@sellerboard so basically I need to enter in the old batch only stock I have in prep-center if I am using one, FBA stock is already automatically added?
@@matjazlampret6152 You don't need to put your prep balances in there, because they have not yet arrived at Amazon and should not be included in the cost calculation. There you can specify how much of the old batch should be included in the weighted average cost calculation, as well as how much of the new batch should be included. In this case, the calculation mechanism serves only to automatically calculate the cost price for the new batch, the actual amount of goods is not important here.
How do I import all the cogs from excel? I’ve been selling since last march so have a lot to import and have several excel documents.
You can upload your COGs in bulk via the Import button on the products page. Just click on the button, download the template, fill it out and upload it back. Please note that you do not have to use the template file offered by sellerboard. You can use the file exported from Seller Central or other external service (even Google sheets) and upload it to sellerboard. After this, you will be able to match the necessary columns with the ones required by sellerboard. Please note that in order to import this information in sellerboard ASIN and SKU need to be presented in sellerboard before. Also, your Excel file should contain 1 sheet only.
Hey guys! Where can I find how many units I have left for each batch in order to get a more accurate COGS?
Hey, we do not keep such records, this task is in our to-do list. The thing is that even Amazon doesn't have such data - an order for 2 units can include a unit from a recent batch and a unit from a batch that arrived a year ago. Therefore, under such conditions, only COGS accounting by order dates is possible (with a possibility to adjust it backwards if needed).
Hi, thanks for the tutorial, can I import the COGs by period? Or is it just possible overwriting the previous COGs?
On the Products page, you can find the import button in the lower left corner.
After clicking it, you will see a pop-up window where you can download a template.
Please open it and insert the product cost in the "Cost" column for each SKU, and the start date of the new period in the CostPeriodStartDate field (so you have as many rows for each SKU as you have periods.), after doing so, save it and upload it back to sellerboard.
@@sellerboard Is there a video of how to do this?? Im having a hard time figuring how to put costs in because my cogs varies order to order.
@@charlesmclellan4676 Please write us an email and our support team will help you with that. The email is support@sellerboard.com
A FIFO association between sales and cost batches would have been the right way to do it. This weighted average method of calculating the costs is not precise. In any case, if the software has access to sellercentral, it should already know the unsold inventory from the last batch - why then does the user need to input that manually?
Thanks for your comment! It's on our to-do list, we plan to release it within a couple of months.
Just signed up for the free trial and finding it very difficult to figure out cost of goods for previous sales. I could follow this tutorial if I was starting from a clean slate but having to figure out cogs retroactively is really complicated. Any suggestions?
Hello there! Just wanted to let you know that our process is actually quite simple. Each order is calculated based on the cost price set in the settings for the order date. If you need to analyze a specific example, please don't hesitate to reach out to us through our support chat on the site or by emailing us at support@sellerboard.com. We're always happy to help!
Hi There, do we have to add shipping cost that we create from amazon seller account or seller board automatically picks up the shipping cost?
Do you mean the FBA inbound shipping costs? These will be picked up automatically by sellerboard
possible to add warehouse and shipping cost by order if it's an FBM product?
You can enter warehouse costs for FBM products through expenses or include them in the production cost. you can change the shipping cost (as well as the production cost) of a specific FBM order by clicking on the shipping/cost figure for that order in the dashboard, or you can do it as a file via the Import button on the Products page, then downloading the template (COGS and Shipping by order), then filling in the data in it and uploading it back to the sellerboard.
Also, please watch our video about it: th-cam.com/video/9ztSkg6zFzI/w-d-xo.html
I do RA and most of my products aren't replenishable.
Today I bought the same item from 3 different suppliers with 3 different prices. I would like to use the Purchase Orders to keep tracking data about orders/costs/suppliers/shipping, but when I did that the product COG is the last closed order.
My trial will end soon but the lack of FIFO on SB will prevent me to replace Inventory Lab 😭
Sorry to hear that!
We are constantly improving our tools, hope you'll be back to us soon!
But in P&L I couldn’t see the breakdown of the COGS. It is critical to know what are my manufacturing costs and shipping costs. Please please add this feature
Yes, you can see the breakdown. Please, contact our support team via support@sellerboard.com, they will help you with this.
you run into a problem when you send in 2 batches+ of same item with different pricing & quantity, how do you keep track what inventory of which batch is left
this is confusing so after it sells the units from all the old batch, the price should account for only new batch?
@@Chandler890 There really is no such accounting at the moment (but it's not available on Amazon either). However, we have this feature in our “To-Do” list right now.
Now you can either use a weighted average price for both batches, or you can adjust the start date of the period based on actual unit sales, for example, assuming that all of batch 1 is sold first, then all of batch 2, (although in reality this is not the case), and then retroactively changing the date for batch 2 to the next day the last unit of batch 1 is sold.
I am unable to access data from 2018 after choosing that date range. How much of my previous data can I access on Sellerboard?
Hello! It's 2 years max from today (Amazon's limit).
It is confusing, I just started doing RA, prices change everyday for one product using coupons or using rewards, so i dont understand how i can track the prices for one product which has different prices
You can use the weighted average cost option by entering a new batch with a new date each time and selecting this option ( can be found in the video). The final goal is to set the cost price for each day, so that the system can calculate for a specific order the cost price based on the cost price set for a specific day and market. As an option, you can sum up all your costs and quantity of items, for example, for a month outside sellerboard, calculate the average cost price and specify it for 1 month, so that you don't have to enter every day.
if COGS is (product cost + shipping cost from factory to amazon warehouse), then what about the amazon fees (Estimated fee per unit sold). Please help and explain. Thank you
Hey! We receive all fees directly from Amazon as well as compensation and advertising costs and show the actual data in the profit calculation by order, product or account. The user only needs to enter the cost of goods and indirect costs (if any).
Hi, is there a way to know how much I have left in the previous batch? As I don't remember.
Hi, as per video, the amount from the previous batch should be indicated by the user, but we took the chance and improved that. So nowadays, when creating a new batch, the amount from the old batch will be populated automatically. No need to remember anything related to previous batch!
Thank you!
We have 600+ ASINs in 10+ markets. Is it possible to use the batch method but upload using a flat file?
I tried to add in the different batch prices for a product in each market and then export it but only 2 fields are then populated. 1. Cost period start date 2. Cost
There is also 'market' in the last column of the file. Thus you need to specify the product - the date of the period - the price - the market. And there are such lines for one product - as many as you need, for each period and market.
How do I connect Shopify and other channels to Sellerboard?
At the moment you can connect only your eBay account to sellerboard - click on "eBay" button on the settings page and follow the instructions. For Shopify we can offer sellerboard.io - profit analytics for Shopify sellers.
What way is recommended for 'daily' upload via template of COG once recieved a batch in different price ( I have ~100 ASINs , so manual update is not an option ;) ) :
Example of data:
Batch date ASIN Pcs Price
16.11.2022 ASIN A 100 44,07
30.11.2022 ASIN A 500 32,52
16.12.2022 ASIN A 100 40
26.12.2022 ASIN A 200 40
22.02.2023 ASIN A 200 41,99
22.02.2023 ASIN A 100 46,99
Please watch our video about it: th-cam.com/video/KYmqlN1AXWk/w-d-xo.html
Has someone noticed that Sellerboads "Net Profit" calculations are WRONG when you consider the VAT (sales tax for the UK). Sellerbaod method of calculation "Net Profit" is (Sales Price - Amazon Fee (Incl VAT) - COGs (Excl VAT) - VAT on Sale Price = Net Profit). This is ABSOLUTELY wrong. You can't deduct "Amazon Fee (Incl VAT) and then also deduct "Full VAT" on the sale price. I am very surprised that no one has noticed it yet and yet this software is being purchased by others. I raised a support case, but after I gave evidences, they have stopped responding now.
Hello, we completely agree with you, in this particular situation, it is only fair that Amazon fees are exempt from VAT. Our team of developers is currently looking into this matter, and we will make sure to keep you updated once it is resolved. Thank you for your understanding and for bringing this to our attention. We apologize for any inconvenience this may have caused. Your patience is greatly appreciated!
How to upload all the costs in one file instead of going one by one?
In the bottom left corner, there's an "Import" button. Click it please, you'll be able to download a spreadsheet template. In the template, there's a column for a batch/period start date in case you'd like sellerboard to create a new period when uploading
How to delete or update incorrect expenses which are uploaded through flat file?
Manually one by one. If you have too many, write to the support chat please, we'll offer a solution.
Where exactly can i remove the cost one by one? I have explored it completely but couldn't find anyplace to remove them
@@jawadsimine There's an "x" at the right side of each row in the table with expenses. Feel free to drop us a quick message into the support chat in the bottom right corner of the screen, we'll help!
Would be easier to base it off different SKU's - no need for messing around with dates
Thank you for your suggestion!