How to Set-up the USS 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 should be the one to create triggers).

Here are the purpose of the triggers. 

myfunction - This trigger is use to automatically get amazon fees in Amazon website for the product - will run every 15 minutes but if the product has been already updated within the day, this will be skipped. 

resetTokens - This trigger is used for the importing of import sales and import restock that will run everyday from 12 midnight to 1 AM.

generateRestockReportsAccessTokens - This trigger is used for the importing of import restock, this will ask for a token on Amazon that will serve as the gate pass of the data. This will run from 1AM-2AM everyday. 

generateSalesReportsAccessTokens  - This trigger is used for the importing of import sales, this will ask for a token on Amazon that will serve as the gate pass of the data. This will run from 1AM-2AM everyday. 

generateSalesFile - This is also used in downloading the import sales file in Amazon and saving to the cloud then importing it to the sheet. This will run every 15 mins but if the file is already updated today this will be skip.

generateRestockFile - This is also used in downloading the import restock file in Amazon and saving to the cloud then importing it to the sheet. This will run every 15 mins but if the file is already updated today this will be skip.

3. Connect the USS to Seller Central by following this PDF: https://drive.google.com/file/d/1nxl2fp4S9Z65BZngMe6-zgTHkvmB3JeH/view?usp=sharing
4. After that set-up is now okay. 

    • Related Articles

    • Listings Loader Sheet

      A listing loader is a tool that allows you to sell products that are already listed in the market place catalogue. It is through matching the products from your catalogue with corresponding products that sellers have already sold in Amazon.  The best ...

    • 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 ...

    • VAPS Sheet

      The VAPS sheet is used to monitor the actual sales, profit, and ROI for the whole business as well as per VA. On the left, it shows the sales on 31 rolling days. While on the right, it shows all the deals from the Sales Report you imported from ...

    • 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 ...

    • 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.