How to use the USS to STK COGS automation?

How to use the USS to STK COGS automation?

Hope you are doing well, we are happy to tell you that we have now added the USS-STK COGS add-on to your sheet (See below instructions how to use), thank you for your patience and trust. Kindly provide feedback if any.  And if we don’t receive any feedback within 3 business days, we will tag the issue as resolved and close this ticket. Thank you and have a good day ahead!



1. Download the reports from STK either update list or full list. 

Note that this will only work every 15 minutes since we don't want the STK website to have full of request, if you press several times under 15 minutes this will still downloads but the downloaded file is still the same. 




2. Double check the COGS final tab if the entries are okay. If now okay then press the STK COGS Upload above. 




3. Note that this items are matched per SKU, so if you have the same item on the buy sheet make sure that column C in the COGS final tab is matched with SKU Column on your Buy sheet. 

Hope this helps. Let me know if you further questions. Thanks

    • Related Articles

    • How to get Seller Token# from STK?

      How to get seller token in STK for the add-on. 1. Open your STK website and goto settings 2. On the pop-up click the USS Link Token and click the copy icon.
    • Skill Based Assessment for USS Applicants

      This is a Situational. Kindly answer the following questions based from the policy form for USS. 1. The Client sent a message to support team, he just recently purchased the USS sheet over the week and he has 4 remaining support calls. He heared that ...
    • Is it better to use my own SKUs than the USS- Custom SKUs?

      It is suggested to use the USS- Custom SKUs to monitor the sales made from the deals/purchases made by each VA. The sales made can be monitored at the VAPS sheet. 
    • How to Set-up the USS Sheet

      Objective: To make the ultimate sourcing sheet connected to seller central as well as create the triggers to automatically get the amazon fees. 1. Make sure the client is sharing the screen and opening the USS (This is because the owner of the sheet ...
    • How to use FastPack Prep Integration?

      See attached pdf