Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Instructions For Products Excel File

    Uploaded by

    Helcon Ehl Magos
    The document provides instructions for filling out an Excel file with product information sourced from various websites. Key steps include copying product details like brand, title, price and ASIN from Amazon product pages into columns; looking up estimated sales and profit data on JungleScout and Amazon's profit calculator; and finding similar product images on Alibaba to include URLs. The goal is to efficiently gather a range of relevant data about products in one centralized Excel file.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Instructions For Products Excel File

    Uploaded by

    Helcon Ehl Magos
    49 views4 pages
    The document provides instructions for filling out an Excel file with product information sourced from various websites. Key steps include copying product details like brand, title, price and ASIN from Amazon product pages into columns; looking up estimated sales and profit data on JungleScout and Amazon's profit calculator; and finding similar product images on Alibaba to include URLs. The goal is to efficiently gather a range of relevant data about products in one centralized Excel file.

    Original Description:

    exel

    Original Title

    Products Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for filling out an Excel file with product information sourced from various websites. Key steps include copying product details like brand, title, price and ASIN from Amazon product pages into columns; looking up estimated sales and profit data on JungleScout and Amazon's profit calculator; and finding similar product images on Alibaba to include URLs. The goal is to efficiently gather a range of relevant data about products in one centralized Excel file.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    49 views4 pages

    Instructions For Products Excel File

    Uploaded by

    Helcon Ehl Magos
    The document provides instructions for filling out an Excel file with product information sourced from various websites. Key steps include copying product details like brand, title, price and ASIN from Amazon product pages into columns; looking up estimated sales and profit data on JungleScout and Amazon's profit calculator; and finding similar product images on Alibaba to include URLs. The goal is to efficiently gather a range of relevant data about products in one centralized Excel file.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    Instructions for Products Excel File

    1.    Go to "Fill This Excel Tab/Workbook" - Copy and paste URL from column A in your browser
    2.    First line in blue is the Brand name. Copy brand name to Excel column B
    3.    Copy Product Title to column C
    4.    Copy price to column D (without $ sign)
    5.    Scroll down the product page and look for the ASIN code of the product. Enter it in to column E
    6.    Underneath the ASIN you will find the customer reviews, enter the number of review (in blue) into co
    7.    Look for Best Sellers Rank and enter the number into column H and enter the Main category (after t
    8.    Scroll down the page until you find shipping weight, copy shipping weight to column J
    9. Open the following link in your web browser https://www.junglescout.com/estimator/
    10. Choose the Main Category you entered in column I
    11. Enter into the Sales Rank dialog box the number you entered in column H. Press “Find Out Now”. C
    12. Open the following link in your web browser https://sellercentral.amazon.com/fba/profitabilitycalculator/index?lang=e
    13. Enter the ASIN you entered in column E into the dialog box and enter “Search” button
    14. Enter the price you entered in column D into Item price with Amazon Fulfillment Current (Second co
    15. Copy Net Profit of product into column L
    16. Copy Net Margin into column M
    17. Look at product title (column C), what do you think are the product main keywords? Maximum of 4 w
    18. Open in your browser the following link https://www.alibaba.com
    19. Search for your main keywords (column N)
    20. Look for the 2 products images which look very similar the product we analyzed. Open each image
    n your browser

    er it in to column E
    f review (in blue) into column F and the total star rating (a score out of 5) into column G
    he Main category (after the number) into column I

    Press “Find Out Now”. Copy the number you got to column K
    bilitycalculator/index?lang=en_US&ld=NSGoogle
    ch” button
    ment Current (Second column). Scroll down and press “Calculate”.

    words? Maximum of 4 words. Enter it into column N

    zed. Open each image in a new tab and copy each URL to column O and column P
    Link Brand name Title Price ($) ASIN Customer Reviews (Number)
    https://www.amazon.com/dp/B01J3GFA8S/
    Best ESTIMATED
    Sellers Main Shipping SALES PER Net Main Alibaba Alibaba
    Average Customer Reviews Score Rank Category Weight MONTH Net profit Margin Keyword URL 1 URL 2

    You might also like